SELECT id, photo, pub_texte, target, web, width, height, niveau3, google_ad FROM Promo WHERE Repertoire_No =-1818626519 AND (Actif='1' OR Actif='3') AND niveau2='Pub00' AND Date_debut <= #CreateODBCDate(now())# AND Date_fin >= #CreateODBCDate(now())# ORDER BY Id
SELECT Id,repertoire_no,niveau,titre,titre2,actif,attachement,target,description,extrait,niveau1,niveau2,niveau3,niveau5,web,bouton_off,bouton_on,photo,photo_mini,photo_texte,classement,entree,modification,intranet_statut FROM Sections WHERE #PreserveSingleQuotes(QryMenuactif)##PreserveSingleQuotes(EntreeQuery)##PreserveSingleQuotes(ExpirationQuery)#Repertoire_No=-1818626519 and niveau1 = 'menu1' ORDER BY Niveau1,Tri, Titre
