SELECT id, photo, pub_texte, target, web, width, height, niveau3, google_ad FROM Promo WHERE Repertoire_No = #attributes.Repertoire_No# AND (Actif='1' OR Actif='3') AND niveau2='Pub06' AND Date_debut <= #CreateODBCDate(now())# AND Date_fin >= #CreateODBCDate(now())# ORDER BY tri