SELECT Photo_mini,Photo_texte,Titre2,Date,Volume,Numero,Id,Titre,Entree,classement,actif,niveau2,attachement,attachement_poid,attachement_texte FROM Publications WHERE #PreserveSingleQuotes(ActifQuery)#Repertoire_No=#Repertoire_No# AND niveau='2' AND Categorie_No=999996 AND Entree <= #CreateODBCDate("#now()#")# ORDER BY #attributes.tri# SELECT Id,Sequence_No,Titre FROM Publications WHERE #PreserveSingleQuotes(ActifQuery)#Repertoire_No=#Repertoire_No# AND niveau='3' AND Sequence_No IN (SELECT Id FROM Publications WHERE Repertoire_No=#Repertoire_No# AND niveau='2' AND #PreserveSingleQuotes(ActifQuery)#Categorie_No=999996) AND Entree <= #CreateODBCDate("#now()#")# ORDER BY #attributes.triarticle#