SELECT Fiches.titre as publisource,Fiches.societe as societesource,Fiches.Web as websource, Publications.Id, Publications.Extrait, Publications.Description, Publications.Categorie_No, Publications.Titre, Publications.Titre2, Publications.Date,Publications.niveau4, Publications.Sequence_No, Publications.Photo_mini, Publications.Photo_large, Publications.Photo, Publications.Photo_texte, Publications.niveau, Publications.Repertoire_No,Publications.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' OR niveau='3') AND niveau3='journal' AND Actif='3' AND Entree <= #CreateODBCDate("#now()#")# AND Entree >= #CreateODBCDate("#DateAdd("d","-30","#now()#")#")# and not (repertoire_no='2137984530' or repertoire_no='2137987730' or repertoire_no='1551677169') AND TITRE IS NOT NULL GROUP BY Repertoire_No) ORDER BY Publications.Entree desc, Publications.Tri, Publications.Id desc,Publications.Titre2;

L'actualité