SELECT Id, Secteur, Province, Domaine, Keywords, Periode FROM RevPress WHERE IdIndividu=#Session.IdIndividu# AND Repertoire_No=#attributes.Repertoire_No# ORDER BY Id desc; SELECT SousMembre FROM Autorisation_Intranet WHERE IdIndividu = #Session.IdIndividu# SELECT Publications.Id, Publications.Entree, Publications.Volume, Publications.Numero, Publications.Description, Publications.Categorie_No, Publications.Titre, Publications.Titre2, Publications.Sequence_No, Publications.Photo_mini, Publications.Photo_texte, Publications.Web, Publications.niveau, Publications.Repertoire_No,Publications.Langue FROM Publications WHERE Publications.Id IN (SELECT MAX(Id) FROM Publications WHERE Publications.Repertoire_No=1151936421 AND Publications.Langue='fr' AND Publications.niveau='2' AND (Publications.niveau3='journal' OR Publications.niveau4='journal') AND Publications.Actif IN ('1','3','5')) SELECT Publications.Id, Publications.Photo_mini, Publications.Photo, Publications.Photo_texte, Fiches.Repertoire FROM Publications, Fiches WHERE Publications.Repertoire_No=Fiches.Repertoire_No AND Publications.Id IN (SELECT MAX(Id) FROM Publications WHERE Publications.Repertoire_No = 1429373326 AND (Publications.niveau3='journal' OR Publications.niveau4='journal') AND Publications.Actif IN ('1','3','5')) SELECT Publications.Id, Publications.Description, Publications.Categorie_No, Publications.Titre, Publications.Titre2, Publications.Sequence_No, Publications.Photo_mini, Publications.Photo_texte, Publications.Web, Publications.niveau, Publications.Repertoire_No, Fiches.Repertoire FROM Publications, Fiches WHERE Fiches.Repertoire_No=Publications.Repertoire_No AND NOT Fiches.Categorie_No IN (847582460,-709160916) AND Publications.Id IN (SELECT MAX(Id) FROM Publications WHERE Langue='fr' AND niveau='2' AND DB_Source='1151936421' AND Repertoire_No IN (#attributes.SousMembre#) AND (Publications.niveau3='journal' OR Publications.niveau4='journal') AND Publications.Actif IN ('1','3','5') GROUP BY Repertoire_No) ORDER BY Publications.Id desc;

#Titre2# #Titre# #Replace("#Left("#Description#",350)#","#chr(13)##chr(10)#"," ","ALL")#...
#Titre2# #Titre# #Replace("#Left("#Output.Description#",175)#","#chr(13)##chr(10)#"," ","ALL")#...