SELECT  users_site.LOGIN AS LOGIN, users_site.Site_code AS Site_code,	site.nom_site AS nom_site FROM site,users_site WHERE site.site_code = users_site.Site_code AND (users_site.LOGIN = ?	AND	site.activer = true)

SELECT c.codeclas as codeclas, c.libelclas as libelclas,c.effectif as effectif, c.guid as guidclas, c.site as site_code from classes c where c.site= ? and c.typeclasse=1 and c.codeclas <>'NON'

SELECT sum(s.montant) as montant, s.autref as autref, e.apayer as apayer, e.frais1 as frais1, e.frais2 as frais2, e.frais3 as frais3, e.frais4 as frais4, e.arriere as arriere  FROM SCOLARIT s, eleve e WHERE s.guid_matri = e.guid_matri and s.valide=true and s.guid_matri= '2001000564ffdb0aaa00493d8abd0772d4df7e85141' group by s.autref order by s.autref asc


SELECT sum(s.montantpaie) as montant , a.libellefrais as LibelleFrais, a.idautref as idautref FROM paiement_af s, autref a  WHERE s.idautref = a.idautref and s.valide=true and s.guid_matri= '2001000564ffdb0aaa00493d8abd0772d4df7e85141' group by a.libellefrais order by a.libellefrais asc