SELECT Id, Photo, Pub_texte, Target, Web, Width, Height, niveau3 FROM Promo WHERE Repertoire_No = #attributes.Repertoire_No# AND niveau2='Pub03' AND Date_debut <= #CreateODBCDate(now())# AND Date_fin >= #CreateODBCDate(now())# ORDER BY Id