FROM auth_user_md5 AS a
INNER JOIN aliases as al ON a.user_id=al.id
WHERE al.flags='bestalias' and a.matricule = {?}",$params[1]);
$data=$res->fetchOneAssoc();
//$data['mail'].='@polytechnique.org';
FROM auth_user_md5 AS a
INNER JOIN aliases as al ON a.user_id=al.id
WHERE al.flags='bestalias' and a.matricule = {?}",$params[1]);
$data=$res->fetchOneAssoc();
//$data['mail'].='@polytechnique.org';