select *
from zaiavlenie z join chelovek ch on (z.id = ch.id_zayavlenie)
left join suda s on (z.id_suda = s.id_s)
left join dokument dok on (ch.id = dok.id_chelovek)
left join adresa ad on (ad.id_chelovek = ch.id and ad.propiska_fakt =
'ПРОПИСКА')
left join adresa ad2 on (ad.id_chelovek = ch.id and ad.propiska_fakt =
'ФАКТИЧЕСКИЙ')
where z.nomer_zaiavlenia = '262222222222222222222'-- Сергей Смирнов.
