$res = XDB::query("SELECT r.date, u.promo, u.nom, u.prenom, r.email, r.bestalias
FROM register_pending AS r
INNER JOIN auth_user_md5 AS u ON u.user_id = r.uid
$res = XDB::query("SELECT r.date, u.promo, u.nom, u.prenom, r.email, r.bestalias
FROM register_pending AS r
INNER JOIN auth_user_md5 AS u ON u.user_id = r.uid