if [ "${pot}" = "1" ]
then
- WHERE="WHERE titre ILIKE '%pot%' "
+ CLAUSEPOT="AND titre ILIKE '%pot%'"
fi
-psql note -c "SELECT * FROM activites ${WHERE}ORDER BY debut DESC;"
+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;"