BiTel

 `

SELECT a.title as "Договор", b.pod+0 as "Подъезд", b.flat+0 as "Квартира", c.val as "ФИО", d.summa1+d.summa2-d.summa3-d.summa4 as "Баланс", f.title as "Тариф" FROM contract as a
left join contract_parameter_type_2 as b on (a.id=b.cid)
left join contract_parameter_type_1 as c on (a.id=c.cid and c.pid=1)
left join contract_balance as d on (a.id=d.cid and d.yy=2011 and d.mm=10)
left join contract_tariff as e on (a.id=e.cid and e.date2 is null)
left join tariff_plan as f on (e.tpid=f.id)
where b.address like "%Горького%д. 7%,%"
order by flat +0