X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;ds=sidebyside;f=bin%2Fcron%2Frapports_inscription.php;h=4059445e38f7930c8b34f1985cc11e157289bb35;hb=fe13bc1d7ba9f72d452ec07baf8538a74b7c67b8;hp=b7e916787f3c067fb1cbb361c9ebafb8c09f882c;hpb=1d49ff4ae684f13250408798f4b0a945797a5229;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