- $res = XDB::query(
- "SELECT prenom, nom, user_id, promo, cv, a.alias AS bestalias
- FROM auth_user_md5 AS u
- INNER JOIN aliases AS a ON (u.user_id=a.id
- AND FIND_IN_SET('bestalias', a.flags))
- INNER JOIN aliases AS a1 ON (u.user_id=a1.id
- AND a1.alias = {?}
- AND a1.type!='homonyme')", $x);
-
- if ($res->numRows() != 1) {