+psql note -c "SELECT cresp.pseudo AS responsablepseudo, cval.pseudo AS valideparpseudo, a.*
+ FROM activites AS a, comptes AS cresp, comptes AS cval
+ WHERE a.responsable = cresp.idbde AND a.validepar = cval.idbde
+ ${CLAUSEPOT}
+ ORDER BY debut DESC;"