X-Git-Url: http://gitweb.pimeys.fr/?a=blobdiff_plain;ds=sidebyside;f=bde%2Fstats%2Fsoldes.sh;h=027056c1e81977df6099e12c4015dc80a8ece6a0;hb=226838d356055b72d63e61e3ace5e166cbde8eb8;hp=37d9a71ec2c976a5abe5967cd2cd57cc9c157d35;hpb=8d4e09519e32f0c5b9325fd4c42b5c771120d592;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