- "SELECT forlife, email, date
- FROM register_pending
- WHERE hash != 'INSCRIT'
- ORDER BY date");
+ "SELECT u.hruid, r.email, r.date
+ FROM register_pending AS r
+ LEFT JOIN auth_user_md5 AS u ON (u.user_id = r.uid)
+ WHERE r.hash != 'INSCRIT'
+ ORDER BY r.date");