SELECT Id, Personne, Actif, Web, Presentateur, Activite, Description, Domaine, Nature, Lieu, Ville, Province, Information, date_debut, date_fin,Source_Id
FROM Agenda3
WHERE Repertoire_No=#Repertoire_No# AND Langue LIKE '%en%' AND (Actif='1' OR Actif='3')#PreserveSingleQuotes(Var.QUERY)#
ORDER BY date_debut,Activite
SELECT Repertoire_No
FROM Fiches
WHERE (Sequence_No=#Repertoire_No# OR Sequence_No=#Idfr#) AND Actif='3' AND Type = '11' AND Categorie_No IN (SELECT Repertoire_No FROM Fiches WHERE Sequence_No=#Repertoire_No# AND (Categorie_No=0 OR Categorie_No IS NULL)AND (Actif='1' OR Actif='3') ORDER BY Titre) AND Langue='en'
ORDER BY Categorie_No, Tri, Titre, Societe, Nom, Prenom