SELECT Nom, Id, Information, Photo, Photo_texte,Actif
FROM Individu
WHERE niveau='1' AND ((Id IN (SELECT Categorie_No FROM Individu WHERE Repertoire_No=#attributes.Repertoire_No#)) OR (#PublicationsQuery#))#PreserveSingleQuotes(ActifQuery)#
ORDER BY Tri,Nom
SELECT Nom, Prenom, Fonction, Id, Categorie_No,Information,Photo_mini,Tri,Actif,Id
FROM Individu
WHERE niveau='2' and Repertoire_No=#attributes.Repertoire_No# AND (Actif='1' or Actif='3')
ORDER BY Categorie_No, Tri, Nom