SELECT Id, Photo, Pub_texte, Target, Web, Width, Height, niveau3 FROM Promo WHERE Repertoire_No = 1151936421 AND (Actif='1' OR Actif='3') AND niveau2='Pub00' AND Date_debut <= #CreateODBCDate(now())# AND Date_fin >= #CreateODBCDate(now())# AND NOT (Photo is NULL AND google_ad IS NULL) ORDER BY tri