SELECT sections_pages.id, sections_pages.web,sections_pages.date, sections_pages.description, sections_pages.extrait, sections_pages.categorie_no, sections_pages.titre, sections_pages.titre2, sections_pages.sequence_no, sections_pages.niveau, sections_pages.nature,sections_pages.modification, sections_pages.niveau3, sections_pages.repertoire_no, sections_pages.db_source, sections_pages.auteur, fiches.web as webpath, fiches.societe, fiches.nom, fiches.prenom FROM sections_pages LEFT JOIN Fiches ON Fiches.Repertoire_No = sections_pages.Repertoire_No WHERE #PreserveSingleQuotes(ActifQuery)##PreserveSingleQuotes(DBQuery)##PreserveSingleQuotes(GlobalQuery)##PreserveSingleQuotes(LieuQuery)##PreserveSingleQuotes(SecteurQuery)#sections_pages.Langue LIKE '%en%'#PreserveSingleQuotes(SrchtypeQuery)# ORDER BY sections_pages.clic desc,sections_pages.Titre,sections_pages.Titre2

Site Sections

#sections_pages.RecordCount# recordsrecord
#DateFormat(modification,'yyyy-mm-dd')#  http://#Replace("#webpath#",'http://','')#/#attributes.FicheBase#?#attributes.URLParam#Voir=#sections_pages.niveau3#&id=#Id#&M=#Categorie_No#&Sequence_No=#Id#&Parent=#Sequence_No#&niveau=#niveau#&repertoire_no=#repertoire_no#">#Replace("#Titre#", "<[^>]*>", "", "ALL")##Replace("#Titre2#", "<[^>]*>", "", "ALL")#Voir cette publication
#Extrait#
Author : #auteur#
Previous | Next