X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=bin%2Fcron%2Frapports_inscription.php;h=4059445e38f7930c8b34f1985cc11e157289bb35;hb=42f5f0074df34f3000368066c4dd81495c0c4516;hp=b7e916787f3c067fb1cbb361c9ebafb8c09f882c;hpb=d293e17c2f13ba1e27ef843b485fe6fb0edcc069;p=platal.git

diff --git a/bin/cron/rapports_inscription.php b/bin/cron/rapports_inscription.php
index b7e9167..4059445 100755
--- a/bin/cron/rapports_inscription.php
+++ b/bin/cron/rapports_inscription.php
@@ -8,7 +8,7 @@ $MESSAGE = '';
 $res = XDB::iterRow(
         "SELECT  a.alias, u.promo, email
            FROM  auth_user_md5  AS u
-      LEFT JOIN  aliases        AS a ON( u.user_id=a.id AND a.type='a_vie' )
+      LEFT JOIN  aliases        AS a ON( u.user_id=a.uid AND a.type='a_vie' )
       LEFT JOIN  emails         AS e ON( e.uid = u.user_id AND NOT FIND_IN_SET('filter',e.flags) )
           WHERE  u.date_ins > {?}
        GROUP BY  alias