- 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);