SELECT Publications.Id, Publications.Entree, Publications.Volume, Publications.Numero, Publications.Description, Publications.Categorie_No, Publications.Titre, Publications.Titre2, Publications.Option4,
Publications.Sequence_No, Publications.Photo_mini, Publications.Photo_texte, Publications.Web, Publications.Option, Publications.Repertoire_No,Publications.Langue,
Fiches.Repertoire
FROM Publications, Fiches
WHERE Fiches.Repertoire_No=Publications.Repertoire_No
AND Publications.Id IN (SELECT Id
FROM Publications
WHERE Langue LIKE '%fr%' AND Publications.Repertoire_No=1876894553 AND Publications.Option='2' AND Publications.Actif='3') AND (Publications.Option3='journal' OR Publications.Option4='journal')
ORDER BY Publications.Entree desc, Publications.Tri desc, Publications.Titre2;
SELECT Publications.Photo_mini, Publications.Photo, Publications.Photo_texte, Fiches.Repertoire
FROM Publications, Fiches
WHERE Fiches.Repertoire_No=Publications.Repertoire_No AND Publications.Repertoire_No = 1429373326 AND (Publications.Option3='journal' OR Publications.Option4='journal')
ORDER BY Publications.Id desc;
SELECT Publications.Id, Publications.Description, Publications.Categorie_No, Publications.Titre, Publications.Titre2, Publications.Option4,
Publications.Sequence_No, Publications.Photo_mini, Publications.Photo_texte, Publications.Web, Publications.Option, Publications.Repertoire_No,
Fiches.Repertoire,Fiches.Categorie_No
FROM Publications, Fiches
WHERE Fiches.Repertoire_No=Publications.Repertoire_No AND NOT Fiches.Categorie_No IN (847582460,-709160916)
AND Publications.Id IN (SELECT MAX(Id)
FROM Publications
WHERE Langue LIKE '%fr%' AND Option='2' AND DB_Source='1151936421' AND (Publications.Option3='journal' OR Publications.Option4='journal') AND Actif='3'
GROUP BY Repertoire_No)
ORDER BY Publications.Id desc,Publications.Titre2;
