SELECT Publications.Id, Publications.Extrait, Publications.Description, Publications.Categorie_No, Publications.Titre, Publications.Titre2, Publications.Date,Publications.niveau3, Publications.Sequence_No, Publications.Photo_mini, Publications.Photo_texte, Publications.niveau, Publications.Repertoire_No, Fiches.Web FROM Publications, Fiches WHERE Fiches.Repertoire_No=Publications.Repertoire_No AND Publications.Id IN (SELECT MAX(Id) FROM Publications WHERE #PreserveSingleQuotes(LieuQuery)#Langue LIKE '%fr%' AND niveau='2' AND Actif='3' AND NOT (Categorie_No=999980 OR Categorie_No=999981 OR Categorie_No=999982 OR Categorie_No=999983 OR Categorie_No=999993 OR Categorie_No=999996 OR Categorie_No=999998 OR Categorie_No=999979) AND DB_Source=#attributes.Repertoire_No# AND Entree <= #CreateODBCDate("#now()#")# GROUP BY Repertoire_No) ORDER BY Publications.Id desc

Publications du réseau
	#REReplace("#Titre#", "<[^>]*>", "", "ALL")#