SELECT Id, Photo, Pub_texte, Target, Web, Width, Height, niveau3 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,Id desc;