SELECT Id, Photo, Pub_texte, Target, Web, Width, Height, niveau3 FROM Promo WHERE Repertoire_No = 1151936421 AND (Actif='1' OR Actif='3') AND niveau2='Pub06' AND NOT Categorie_No=555555 AND Date_debut <= #CreateODBCDate(now())# AND Date_fin >= #CreateODBCDate(now())# ORDER BY Id