SELECT Id,Actif,Photo,Pub13,Pub_texte,Option2,Target,Web FROM Promo WHERE Repertoire_No = #Repertoire_No# AND (Actif='1' OR Actif='3') AND Option2='Pub01' AND NOT Categorie_No=555555 ORDER BY Id