-$sql = "SELECT a1.alias, a2.alias, e1.email
- FROM emails AS e1
- INNER JOIN emails AS e2 ON (e1.email = e2.email AND e1.uid != e2.uid
- AND (e1.uid < e2.uid OR NOT FIND_IN_SET('active', e2.flags)))
- LEFT JOIN emails_watch AS w ON (e1.email = w.email)
- INNER JOIN aliases AS a1 ON (a1.id = e1.uid AND a1.type = 'a_vie')
- INNER JOIN aliases AS a2 ON (a2.id = e2.uid AND a2.type = 'a_vie')
- INNER JOIN auth_user_md5 AS u1 ON (a1.id = u1.user_id)
- INNER JOIN auth_user_md5 AS u2 ON (a2.id = u2.user_id)
- WHERE FIND_IN_SET('active', e1.flags) AND u1.nom != u2.nom_usage AND u2.nom != u1.nom_usage AND w.email IS NULL
- ORDER BY a1.alias";
-
-$it = Xdb::iterRow($sql);
+$it = Xdb::iterRow("SELECT al1.alias, al2.alias, e1.email
+ FROM emails AS e1
+ INNER JOIN emails AS e2 ON (e1.email = e2.email AND e1.uid != e2.uid
+ AND (e1.uid < e2.uid OR NOT FIND_IN_SET('active', e2.flags)))
+ INNER JOIN aliases AS al1 ON (al1.uid = e1.uid AND al1.type = 'a_vie')
+ INNER JOIN aliases AS al2 ON (al2.uid = e2.uid AND al2.type = 'a_vie')
+ INNER JOIN accounts AS a1 ON (al1.uid = a1.uid)
+ INNER JOIN accounts AS a2 ON (al2.uid = a2.uid)
+ LEFT JOIN email_watch AS w ON (e1.email = w.email)
+ WHERE FIND_IN_SET('active', e1.flags) AND w.email IS NULL
+ ORDER BY al1.alias");