select
p.id_apart as ID,
a.rooms_q,
a.id_type,
t.name as type_name,
a.id_region,
r.name as region_name,
a.lcd,
a.id_infosource,
i.name as infosource_name,
a.id_ex,
y.name as exclusive,
a.deleted
from phones p
left join apart a on (a.id = p.id_apart)
left join types t on (t.id = a.id_type)
left join regions r on (r.id = a.id_region)
left join infosource i on (i.id = a.id_infosource)
left join infosource y on (y.id = a.id_ex)
where (p.tel = :tel or p.tel = :tel2)
UNION
select
p.id_off,
o.rooms_q,
o.id_type,
t.name as type_name,
o.id_region,
r.name as region_name,
o.lcd,
o.id_infosource,
i.name as infosource_name,
o.id_ex,
y.name as exclusive,
o.deleted
from phones p
left join offices o on (o.id = p.id_off)
left join types t on (t.id = o.id_type)
left join regions r on (r.id = o.id_region)
left join infosource i on (i.id = o.id_infosource)
left join infosource y on (y.id = o.id_ex)
where (p.tel = :tel or p.tel = :tel2)
UNION
select
m.id,
null,
m.id_type,
t.name as type_name,
null,
'ПОСРЕДНИК',
null,
null,
null,
null,
null,
m.deleted
from phones p
left join mediators m on (m.id = p.id_mediator)
left join types t on (t.id = m.id_type)
where (p.tel = :tel or p.tel = :tel2)
|