Services aux abonnés

SELECT Publications.Id, Publications.Actif, Publications.Entree, Publications.Volume, Publications.Numero, Publications.Description, Publications.Categorie_No, Publications.Titre, Publications.Titre2, Publications.Auteur, Publications.Option4, Publications.Sequence_No, Publications.Photo_mini, Publications.Photo_texte, Publications.Web, Publications.Option, Publications.Repertoire_No, Publications.Langue, Publications.Attachement,Fiches.Repertoire FROM Publications,Fiches WHERE Publications.Repertoire_No=1876894553 AND Publications.Langue LIKE '%fr%' AND NOT (Publications.Classement='Caricature' OR Publications.Classement='Jeux de la Francophonie') AND (Publications.Option='2' OR Publications.Option='3') AND (Publications.Actif='1' OR Publications.Actif='3' OR Publications.Actif='5') AND (Publications.Option3='journal' OR Publications.Option4='journal') ORDER BY Publications.Id desc;

News Services
Date
Title
Author
Intranet
#LSDateFormat("#Entree#","d/mm/yy")# #Titre# #Auteur#
File Attachment
SELECT Publications.Id, Publications.Actif, Publications.Entree, Publications.Volume, Publications.Numero, Publications.Description, Publications.Categorie_No, Publications.Titre, Publications.Titre2, Publications.Auteur, Publications.Option4, Publications.Sequence_No, Publications.Photo_mini, Publications.Photo_texte, Publications.Web, Publications.Option, Publications.Repertoire_No,Publications.Classement,Publications.Langue, Publications.Attachement,Fiches.Repertoire FROM Publications, Fiches WHERE Publications.Repertoire_No=1876894553 AND Publications.Langue LIKE '%fr%' AND Publications.Classement='Jeux de la Francophonie' AND (Publications.Option='2' OR Publications.Option='3') AND (Publications.Actif='1' OR Publications.Actif='3' OR Publications.Actif='5') AND (Publications.Option3='journal' OR Publications.Option4='journal') ORDER BY Publications.Id desc;

Jeux de la Francophonie
Date
Title
Author
Intranet
#LSDateFormat("#Entree#","d/mm/yy")# #Titre# #Auteur#
File Attachment
SELECT Publications.Id, Publications.Actif, Publications.Entree, Publications.Volume, Publications.Numero, Publications.Description, Publications.Categorie_No, Publications.Titre, Publications.Titre2, Publications.Auteur, Publications.Option4, Publications.Sequence_No, Publications.Photo_mini, Publications.Photo_texte, Publications.Web, Publications.Option, Publications.Repertoire_No,Publications.Classement,Publications.Langue, Publications.Attachement,Fiches.Repertoire FROM Publications, Fiches WHERE Publications.Repertoire_No=1876894553 AND Publications.Langue LIKE '%fr%' AND Publications.Classement='Caricature' AND (Publications.Option='2' OR Publications.Option='3') AND (Publications.Actif='1' OR Publications.Actif='3' OR Publications.Actif='5') AND (Publications.Option3='journal' OR Publications.Option4='journal') ORDER BY Publications.Id desc;

Caricature
Date
Title
Author
Intranet
#LSDateFormat("#Entree#","d/mm/yy")# #Titre# #Auteur#
File Attachment
SELECT Publications.Id, Publications.Actif, Publications.Entree, Publications.Description, Publications.Categorie_No, Publications.Titre, Publications.Titre2, Publications.Editeur, Publications.Option4, Publications.Sequence_No, Publications.Photo_mini, Publications.Photo_texte, Publications.Web, Publications.Option, Publications.Repertoire_No, Publications.Attachement, Fiches.Repertoire FROM Publications, Fiches WHERE Publications.DB_Source='1151936421' AND Publications.Langue LIKE '%fr%' AND NOT Publications.Classement='Caricature' AND (Publications.Option='2' OR Publications.Option='3') AND (Publications.Actif='1' OR Publications.Actif='3' OR Publications.Actif='5') AND (Publications.Option3='journal' OR Publications.Option4='journal') ORDER BY Publications.Id desc;

Journaux de l'APF
Date
Title
Publisher
Intranet
#LSDateFormat("#Entree#","d/mm/yy")# #Titre# #Editeur#
File Attachment