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.Langue LIKE '%fr%' AND Publications.Classement ILIKE '%Jeux linguistiques%' AND Publications.repertoire_no='1151936421' AND (Publications.niveau='2' OR Publications.niveau='3') AND Publications.niveau3='journal' AND Publications.Actif='3' AND Publications.Entree <= #CreateODBCDate("#now()#")# ORDER BY Publications.Entree desc, Publications.Tri desc, Publications.Id desc,Publications.Titre2;

Fils RSSFils RSS | Archives