SELECT Publications.Id, Publications.Extrait, Publications.Description, Publications.Categorie_No, Publications.Titre, Publications.Titre2, Publications.Date,Publications.niveau4, Publications.Sequence_No, Publications.Photo_mini, Publications.Photo_texte, Publications.niveau, Publications.Repertoire_No, Publications.partenaireid,Publications.entree,Fiches.Web FROM Publications, Fiches WHERE Fiches.Repertoire_No=Publications.Repertoire_No AND Publications.Id IN (SELECT MAX(Id) FROM Publications WHERE #PreserveSingleQuotes(LieuQuery)#Langue LIKE '%fr%' AND (Secteur LIKE '%#attributes.Secteur#%' OR Classement LIKE '%Culture%' OR Classement LIKE 'Arts visuels%' OR Classement LIKE 'Cinéma%' OR Classement LIKE 'Histoire%' OR Classement LIKE 'Livre%' OR Classement LIKE 'Musique%' OR Classement LIKE 'Médias%' OR Classement LIKE 'Patrimoine%' OR Classement LIKE 'Théâtre%' OR metakeys LIKE '%Culture%' OR metakeys LIKE 'Arts visuels%' OR metakeys LIKE 'Cinéma%' OR metakeys LIKE 'Histoire%' OR metakeys LIKE 'Livre%' OR metakeys LIKE 'Musique%' OR metakeys LIKE 'Médias%' OR metakeys LIKE 'Patrimoine%' OR metakeys LIKE 'Théâtre%') AND (niveau='2' OR niveau='3') AND Categorie_No=999998 AND (repertoire_no='1151936421' or DB_Source='1151936421' or DB_Source='2137988666') AND Actif='3' AND Entree <= #CreateODBCDate("#now()#")# GROUP BY Repertoire_No) ORDER BY Publications.Entree desc, Publications.Tri desc, Publications.Id desc,Publications.Titre2;
Arts et culture

Fils RSSFils RSS | Archives
SELECT Publications.Id, Publications.Extrait, Publications.Description, Publications.Categorie_No, Publications.Titre, Publications.Titre2, Publications.Date,Publications.niveau4, Publications.Sequence_No, Publications.Photo_mini, Publications.Photo_texte, Publications.niveau, Publications.Repertoire_No, Publications.partenaireid, Publications.entree, Fiches.Web FROM Publications, Fiches WHERE Fiches.Repertoire_No=Publications.Repertoire_No and #PreserveSingleQuotes(LieuQuery)#Publications.Langue LIKE '%fr%' AND Publications.Classement LIKE 'Découverte littéraire' AND (Publications.niveau='2' OR Publications.niveau='3') AND (Publications.niveau3='journal' OR Publications.niveau4='journal') AND (Publications.Actif='1' or Publications.Actif='3') AND Publications.Entree <= #CreateODBCDate("#now()#")# and Publications.Repertoire_No=1151936421 ORDER BY Publications.Entree desc, Publications.Tri desc, Publications.Id desc,Publications.Titre2;

Découverte littéraire

Chroniques disques