SELECT Publications.Id, Publications.Entree, Publications.Volume, Publications.Numero, Publications.Extrait,Publications.Description, Publications.Categorie_No, Publications.Titre, Publications.Titre2, Publications.niveau4, Publications.Sequence_No, Publications.Photo, Publications.Photo_mini, Publications.Photo_large,Publications.Photo_texte, Publications.Web, Publications.niveau, Publications.Repertoire_No,Publications.Langue, Fiches.Repertoire FROM Publications, Fiches WHERE Fiches.Repertoire_No=Publications.Repertoire_No AND Publications.Id IN (SELECT MAX(Id) FROM Publications WHERE Langue LIKE '%fr%' AND Publications.Repertoire_No=1151936421 AND niveau='2' AND Actif='3' GROUP BY Repertoire_No) ORDER BY Publications.niveau5 desc,Publications.Tri desc,Publications.Entree desc,Publications.Id desc,Publications.Titre2; SELECT Publications.Id, Publications.Description, Publications.Extrait, Publications.Categorie_No, Publications.Titre, Publications.Titre2, Publications.niveau4, Publications.Sequence_No, Publications.Photo_mini, Publications.Photo_texte, Publications.Web, Publications.niveau, Publications.Repertoire_No,Publications.entree,Publications.secteur, Fiches.Repertoire FROM Publications, Fiches WHERE Fiches.Repertoire_No=Publications.Repertoire_No AND Publications.Entree >= #CreateODBCDate("#DateAdd("d","-90","#now()#")#")# AND Publications.Id IN (SELECT MAX(Id) FROM Publications WHERE Langue LIKE '%fr%' AND niveau='2' AND (niveau3='journal' OR niveau4='journal') AND NOT (Repertoire_No=1151936421 OR Repertoire_No=2137989472 or Repertoire_No=1876894553 OR Repertoire_No=-985720755 OR Repertoire_No=1429373326 OR Repertoire_No=-2075855162 OR Repertoire_No=1994755490 OR Repertoire_No=-781623363 OR Repertoire_No=-1264624508) AND Actif='3' GROUP BY Repertoire_No) ORDER BY Publications.Entree desc, Publications.Tri desc, Publications.Id desc,Publications.Titre2;

À la une

#Titre#

#Replace("#Left("#Description#",150)#","#chr(13)##chr(10)#"," ","ALL")#... la suite »
#Titre2#

Vous devez installer Flash® et activer Javascript pour profiter des fonctions multimédia de ce site.

En manchette