+ LEFT JOIN virtuals_redirect AS vr ON (vr.redirect LIKE CONCAT(al.alias, '@%')
+ INNER JOIN virtuals AS v ON (v.vid = vr.vid)
+ WHERE al.alias = {?} OR v.alias = CONCAT({?}, '@', {?})
+ GROUP BY redirecturl", $username, $username, $globals->mail->alias_dom);