+ "SELECT redirect,
+ IF(u.nom IS NOT NULL, IF(u.nom_usage<>'', u.nom_usage, u.nom), m.nom) AS nom,
+ IF(u.prenom IS NOT NULL, u.prenom, m.prenom) AS prenom,
+ IF(u.promo IS NOT NULL, u.promo, 'extérieur') AS promo,
+ IF(m2.perms, m2.perms = 'admin', m.perms = 'admin') AS admin,
+ a.alias