SELECT Divers18_t,Divers18,Service_t,Services,Realisations_t,Realisations
FROM Fiches
WHERE Repertoire_No=#attributes.Repertoire_No#
SELECT Id,Titre,Description,Extrait
FROM Activites
WHERE niveau='2' and Repertoire_No=#attributes.Repertoire_No# and Categorie_No=#attributes.Categorie_No# AND (Actif='3' or Actif='1')
ORDER BY Tri,Titre
Appel d'offres
Concours
Forums
Formation
#Fiches.Divers18_t#
#replace("#REReplace("#REReplace("#Fiches.Divers18#","([[:space:]])http://([^[:space:]]+?)(\.*[[:space:]])","\1\2\3","ALL")#","([[:space:]])([A-Za-z0-9_\.\-]+@[A-Za-z0-9\.\-]+\.[A-Za-z]{2,})(\.*[[:space:]])","\1\2\3","ALL")#",chr(10),"
","all")#
Produits
#replace("#REReplace("#REReplace("#Fiches.Service_t#","([[:space:]])http://([^[:space:]]+?)(\.*[[:space:]])","\1\2\3","ALL")#","([[:space:]])([A-Za-z0-9_\.\-]+@[A-Za-z0-9\.\-]+\.[A-Za-z]{2,})(\.*[[:space:]])","\1\2\3","ALL")#",chr(10),"
","all")#
Programmation
Portfolio
Projets
Propositions
Réalisations
#Fiches.Realisations_t#
#replace("#REReplace("#REReplace("#Fiches.Realisations#","([[:space:]])http://([^[:space:]]+?)(\.*[[:space:]])","\1\2\3","ALL")#","([[:space:]])([A-Za-z0-9_\.\-]+@[A-Za-z0-9\.\-]+\.[A-Za-z]{2,})(\.*[[:space:]])","\1\2\3","ALL")#",chr(10),"
","all")#
Rencontres
Services
#replace("#REReplace("#REReplace("#Fiches.Services#","([[:space:]])http://([^[:space:]]+?)(\.*[[:space:]])","\1\2\3","ALL")#","([[:space:]])([A-Za-z0-9_\.\-]+@[A-Za-z0-9\.\-]+\.[A-Za-z]{2,})(\.*[[:space:]])","\1\2\3","ALL")#",chr(10),"
","all")#
Divers