SELECT id, titre, max FROM cat WHERE actif='1' #Repertoire_No=#attributes.Repertoire_No# ORDER BY Tri, Titre SELECT id,repertoire_no,Individu_Id,categorie_no,sequence_no,niveau,titre,titre2,actif,attachement,description,extrait,niveau3,niveau5,web,classement,target,photo_mini,photo_texte,entree,expiration FROM publications WHERE #PreserveSingleQuotes(ActifQuery)##PreserveSingleQuotes(EntreeQuery)##PreserveSingleQuotes(ExpirationQuery)##CategorieQuery#Repertoire_No=#attributes.Repertoire_No# AND Niveau='1' ORDER BY #trisections#