X-Git-Url: http://gitweb.pimeys.fr/?a=blobdiff_plain;f=bde%2Fstats%2Fconsos.sh;h=bf11e1765c7c1c8c592179cfcf7de2715e5a18e6;hb=refs%2Fheads%2Fmaster;hp=cc130f4d8dd383926192b7b5262bbaa2a3544aed;hpb=f013558eb6e513204b7e409ca449695c247453e9;p=scripts-20-100.git

diff --git a/bde/stats/consos.sh b/bde/stats/consos.sh
index cc130f4..bf11e17 100755
--- a/bde/stats/consos.sh
+++ b/bde/stats/consos.sh
@@ -3,4 +3,4 @@
 # Affiche (par ordre décroissant d'occurrence)
 # le nombre de chaque conso effectuées par un comte
 
-psql bde -c "SELECT remarque, SUM(quantite) AS qte FROM transactions WHERE $1 in (emetteur, destinataire) AND valide GROUP BY remarque ORDER BY qte DESC;"
+psql note -c "SELECT description, SUM(quantite) AS qte FROM transactions WHERE $1 in (emetteur, destinataire) AND valide GROUP BY description ORDER BY qte DESC;"