SELECT Fiches.titre as publisource,Fiches.societe as societesource,Publications.Id, Publications.Titre, Publications.Titre2, Publications.clic
FROM Publications LEFT JOIN Fiches ON Publications.Repertoire_No = Fiches.Repertoire_No
WHERE Publications.Langue LIKE '%fr%'#PreserveSingleQuotes(QrySecteur)# AND (Publications.niveau='2' OR Publications.niveau='3') AND Publications.niveau3='journal' AND Publications.Actif='3' AND Publications.Entree <= #CreateODBCDate("#now()#")# AND Publications.DB_Source='1151936421'
ORDER BY Publications.clic desc, Publications.Titre;