X-Git-Url: http://gitweb.pimeys.fr/?a=blobdiff_plain;f=bde%2Fstats%2Frecord.sh;h=321f3b7a053bafd3567f5e7102b9516c31f98750;hb=226838d356055b72d63e61e3ace5e166cbde8eb8;hp=ba9ed786a8b50b53953adab31f2e4e0a3e329c65;hpb=8d4e09519e32f0c5b9325fd4c42b5c771120d592;p=scripts-20-100.git

diff --git a/bde/stats/record.sh b/bde/stats/record.sh
index ba9ed78..321f3b7 100755
--- a/bde/stats/record.sh
+++ b/bde/stats/record.sh
@@ -3,4 +3,4 @@
 # Affiche par ordre décroissant les plus grand consommateur d'une conso
 # La comparaison est faite avec un ILIKE, on peut donc utiliser % et _
 
-psql bde -c "SELECT t.remarque, a.nom, a.prenom, a.pseudo, SUM(t.quantite) AS qte FROM transactions AS t, adherents AS a WHERE remarque ILIKE '$1' AND a.numcbde=t.emetteur AND valide GROUP BY t.remarque, a.nom, a.prenom, a.pseudo ORDER BY qte DESC;"
+psql note -c "SELECT t.description, c.nom, c.prenom, c.pseudo, SUM(t.quantite) AS qte FROM transactions AS t, comptes AS c WHERE description ILIKE '$1' AND c.idbde=t.emetteur AND valide GROUP BY t.description, c.nom, c.prenom, c.pseudo ORDER BY qte DESC;"