SELECT Tpepole.email, tkizor.alacha, tkizor.saif, Tsiman.siman, Tpepolesiman.saif as saifid,sendit,Tpepole.id as pepoleid, Tsiman.id as simanid,Tpepolesiman.id FROM ((Tpepolesiman LEFT JOIN tkizor ON (Tpepolesiman.simanid = tkizor.simanid) AND (Tpepolesiman.saif = tkizor.saifid)) LEFT JOIN Tpepole ON Tpepolesiman.pepoleid = Tpepole.id) LEFT JOIN Tsiman ON Tpepolesiman.simanid = Tsiman.id WHERE Tpepolesiman.sendit=1 and Tpepole.sendme = true and Tpepole.senddate < date() ORDER BY Tpepolesiman.id