]>
gitweb.pimeys.fr Git - scripts-20-100.git/blob - bde/activites.sh
3 # Pour avoir rapidement la liste des activités
16 CLAUSEPOT
="AND titre ILIKE '%pot%'"
19 psql note
-c "SELECT cresp.pseudo AS responsablepseudo, cval.pseudo AS valideparpseudo, a.*
20 FROM activites AS a, comptes AS cresp, comptes AS cval
21 WHERE a.responsable = cresp.idbde AND a.validepar = cval.idbde