BiTel

 SELECT contract.title, ccpt.address, cp.comment,  cp.summa, cp.dt, cpt.title,user.name FROM contract_payment as cp
    left join contract_payment_types as cpt
   on cpt.id=cp.pt
   left join user
   on cp.uid = user.id
   left join contract
   on contract.id=cp.cid
   left join contract_parameter_type_2 as ccpt
   on contract.id = ccpt.cid
        where cp.dt > 2009-01-01 and cp.dt < 2009-10-01