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_mini, Publications.Photo_texte, Publications.Web, Publications.niveau, Publications.Repertoire_No,Publications.Langue,
Fiches.Repertoire
FROM Publications, Fiches
WHERE Fiches.DB_Source=Publications.DB_Source AND Publications.Id IN (SELECT MAX(Id)
FROM Publications
WHERE Langue LIKE '%fr%' AND Publications.Repertoire_No=#attributes.Repertoire_No# AND niveau='2' AND Actif='3'
GROUP BY Repertoire_No)
ORDER BY Publications.Tri desc,Publications.Entree desc,Publications.Id 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
ORDER BY Publications.Tri desc,Publications.Entree desc,Publications.Id desc;
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,
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 niveau='2' AND DB_Source='#GetBaseInfo.DB_Source#' AND (niveau3='journal' OR niveau4='journal') AND Actif='3'
GROUP BY Repertoire_No)
ORDER BY Publications.Tri desc,Publications.Entree desc,Publications.Id desc,Publications.Titre2;
#Titre2#
#Titre#
#Replace("#Left("#Description#",600)#","#chr(13)##chr(10)#"," ","ALL")#...
|
|
[#GetBaseInfo.DB_Source#]
#Titre2#
#Titre#
#Replace("#Left("#Output.Extrait#",225)#","#chr(13)##chr(10)#"," ","ALL")#...
#Replace("#Left("#Output.Description#",225)#","#chr(13)##chr(10)#"," ","ALL")#...
|