X-Git-Url: http://gitweb.pimeys.fr/?a=blobdiff_plain;f=bde%2Fstats%2Fsoldes.sh;h=027056c1e81977df6099e12c4015dc80a8ece6a0;hb=245868bd2d7c8ac36c0fb4ca2d6af27a89779819;hp=37d9a71ec2c976a5abe5967cd2cd57cc9c157d35;hpb=f013558eb6e513204b7e409ca449695c247453e9;p=scripts-20-100.git

diff --git a/bde/stats/soldes.sh b/bde/stats/soldes.sh
index 37d9a71..027056c 100755
--- a/bde/stats/soldes.sh
+++ b/bde/stats/soldes.sh
@@ -4,8 +4,8 @@
 
 if [[ "$1" = "--no-club" ]]
 then
-    psql bde -c "SELECT nom, prenom, pseudo, solde FROM adherents WHERE NOT club ORDER BY solde DESC;"
+    psql note -c "SELECT nom, prenom, pseudo, solde FROM comptes WHERE type!='club' ORDER BY solde DESC;"
 else
-    psql bde -c "SELECT nom, prenom, pseudo, solde FROM adherents ORDER BY solde DESC;"
+    psql note -c "SELECT nom, prenom, pseudo, solde FROM comptes ORDER BY solde DESC;"
 fi