X-Git-Url: http://gitweb.pimeys.fr/?a=blobdiff_plain;f=bde%2Factivites.sh;h=7408d229f52112e0e49b2e32df7b425f14d66303;hb=HEAD;hp=2d3efd09e56467356690c0a43acb39db10c3e0e4;hpb=8e6221db8bf74c533d0d7ef61828400de740c703;p=scripts-20-100.git

diff --git a/bde/activites.sh b/bde/activites.sh
index 2d3efd0..7408d22 100755
--- a/bde/activites.sh
+++ b/bde/activites.sh
@@ -13,7 +13,11 @@ done
 
 if [ "${pot}" = "1" ]
 then
-    WHERE="WHERE titre ILIKE '%pot%' "
+    CLAUSEPOT="AND titre ILIKE '%pot%'"
 fi
 
-psql bde -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;"