select * from `ao_anunturi` a join `ao_categorii` b on b.`idcat` = a.`sitecatid` join `ao_zone` c on (c.`idzona`= a.`localitateid` and c.`idgrup`= a.`grupid`) where `filialaid` = '3445' and `online_site`='1' and `sters`='0' and `online` = '2' and `idanunt` IN(4408430,4417936,4433141,4448759,4448762,4448763,4466624,4511632,4515447,4547921,4557107,4584017,4595920,4618937,11121529,55518175,55525539,55539831,55541574,55552247,55561333,55571261,55584830,55589321,55593858,55608515,55719269,55760493,55772067,55772196,55772858,55801889,55803382,55806502,55807917,55816029,55834394,55835425,55835810,303216330,303220761,315450273,315456889,315483755,315485764,315526100) and c.`zona` = 'petresti'Aristocrat Imobiliare Corbeanca - Schimburi Petresti