-$res = XDB::iterRow("SELECT al.alias, pd.promo, e.email //a.alias, u.promo, email
- FROM accounts AS a
- INNER JOIN account_profile AS ap ON (ap.uid = a.uid AND FIND_IN_SET('owner', ap.perms))
- INNER JOIN profile_display AS pd ON (ap.pid = pd.pid)
- LEFT JOIN aliases AS al ON (a.uid =a.uid AND al.type = 'a_vie')
- LEFT JOIN emails AS e ON (a.uid = e.uid AND NOT FIND_IN_SET('filter', e.flags))
+$res = XDB::iterRow("SELECT DATE(a.registration_date), a.hruid, GROUP_CONCAT(DISTINCT r.redirect SEPARATOR ', ')
+ FROM accounts AS a
+ INNER JOIN account_profiles AS ap ON (ap.uid = a.uid AND FIND_IN_SET('owner', ap.perms))
+ INNER JOIN profile_display AS pd ON (ap.pid = pd.pid)
+ LEFT JOIN email_source_account AS s ON (a.uid = s.uid)
+ LEFT JOIN email_redirect_account AS r ON (a.uid = r.uid)