SELECT Fiches.Web as webpath,Publications.Photo_mini,Publications.photo,Publications.photo1,Publications.Id,Publications.Photo_texte,Publications.Titre,Publications.Volume,Publications.Numero,Publications.Description,Publications.extrait,Publications.Divers1,Publications.width,Publications.height,Publications.transition,Publications.attachement,Publications.flickr
FROM Publications LEFT JOIN Fiches ON Publications.Repertoire_No = Fiches.Repertoire_No
WHERE Publications.Actif='3' AND Publications.Langue = '#attributes.Langue#' AND Publications.niveau='2' AND Publications.Categorie_No=999993 AND Publications.Entree <= #CreateODBCDate("#now()#")#
ORDER BY Publications.entree desc,Publications.Titre