SELECT Bienvenue,niveau3 FROM Fiches WHERE Repertoire_No = #attributes.Repertoire_No# SELECT Titre2 FROM Publications WHERE Id=#attributes.Sequence_No##attributes.Id# AND Repertoire_No=#attributes.Repertoire_No# ORDER BY Tri desc,Id desc,Titre2; SELECT Id,Date,Volume,Numero,Titre2,Sequence_No,Classement,Titre,Photo,Photo_texte, Auteur,Editeur,Ville,Attachement,Attachement_texte,Divers1_t,Divers2_t,Divers3_t,Divers4_t, Divers5_t,Divers6_t,Divers7_t,Divers8_t,Divers9_t,Divers10_t,Suggestion,Auteur2, Edition,Source,Format,Nomb_page,Cout,Code,ISBN,ISSN,Url1,Url2,Url3,Url4,Url5, Url6,Url7,Url8,Url9,Url10,Description,Web,Extrait,Niveau2 FROM Publications WHERE #PreserveSingleQuotes(ActifQuery)##PresseQuery#niveau='#attributes.niveau#' AND Repertoire_No=#attributes.Repertoire_No# AND Categorie_No=999983 ORDER BY Tri desc,Entree desc,Id desc,Titre2; SELECT Classement,Id,Sequence_No,Photo_mini,Titre,Extrait,Description,Attachement FROM Publications WHERE #PreserveSingleQuotes(ActifQuery)#Sequence_No=#attributes.Sequence_No##Var.Presse.Id# AND Repertoire_No=#attributes.Repertoire_No# AND Niveau='3' ORDER BY Classement,Tri desc,Entree desc,Titre Volume #replace (Volume,chr(10),"
","all")# Numéro #replace (Numero,chr(10),"
","all")#