SELECT ID,jardin,surfHabitation,surfTerrain,code,source,vendrelouer,SUSP,prix,cacherprix,commune,codepostal,chambre,chambresup,garage,garagesup,carport,titre,typelib,`type`,datecrea,photo1,peb,nouveaute,IDresidence,etatgral,faireOffre,video,virtuel FROM 056_biens WHERE IDresidence='3933566' AND vendrelouer='V' AND source!='10230' AND SUSP!='PREPA' ORDER BY nouveaute DESC, `datecrea` DESC LIMIT -12, 12