SELECT Fiches.Web as webpath,Publications.Id,Publications.Titre,Publications.Photo,Publications.Photo_mini,Publications.Photo_texte,Publications.Description,Publications.Extrait,Publications.Web,Publications.niveau2,Publications.niveau
FROM Publications LEFT JOIN Fiches ON Publications.Repertoire_No = Fiches.Repertoire_No
WHERE Publications.DB_source=2137985646 AND Publications.Categorie_No=999998 AND Publications.Actif='3' AND Publications.Entree <= #CreateODBCDate("#now()#")#
ORDER BY Publications.Entree,Publications.Tri,Publications.Id desc,Publications.Titre