SELECT Bienvenue,Option3 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,Entree desc,Id desc,Titre2; SELECT Publications.Id, Publications.Extrait, Publications.Description, Publications.Categorie_No, Publications.Titre, Publications.Titre2, Publications.Date,Publications.Option4, Publications.Sequence_No, Publications.Photo_mini, Publications.Photo_texte, Publications.Option, Publications.Repertoire_No, Publications.Source,Fiches.Web,Publications.Web as JournalWeb 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 Secteur LIKE '%#attributes.Secteur#' AND (Option='2' OR Option='3') AND Categorie_No=999998 AND (Actif='1' or Actif='3') GROUP BY Repertoire_No) ORDER BY Publications.Entree desc, Publications.Tri desc, Publications.Id desc,Publications.Titre2;

L'actualité

#replace(GetJournalListe.Titre,"#chr(13)##chr(10)#","
","all")#

]*>", "", "ALL")#" BORDER=0 ALIGN="RIGHT" WIDTH="70" HSPACE="3" VSPACE="3">
#GetJournalListe.Source##GetJournalListe.Source#,
#GetJournalListe.Date#

#REReplace("#GetJournalListe.Extrait#", "<[^>]*>", "", "ALL")#
#REReplace("#Temp#", "<[^>]*>", "", "ALL")#
SuiteSuite