SELECT Fiches.Web as webpath,Fiches.titre as publisource,Fiches.societe as societesource,Publications.Photo_large,Publications.Photo,Publications.Photo_mini,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,Publications.repertoire_no,Publications.clic
FROM Publications LEFT JOIN Fiches ON Publications.Repertoire_No = Fiches.Repertoire_No
WHERE Publications.niveau='2' AND Publications.Categorie_No=999993 AND Publications.actif='3'
ORDER BY Publications.entree desc,Publications.Titre