FROM virtual AS v
LEFT JOIN virtual_redirect AS vr ON (v.vid=vr.vid)
LEFT JOIN accounts AS a ON ( a.hruid=LEFT(vr.redirect,LOCATE('@',vr.redirect)-1) )
FROM virtual AS v
LEFT JOIN virtual_redirect AS vr ON (v.vid=vr.vid)
LEFT JOIN accounts AS a ON ( a.hruid=LEFT(vr.redirect,LOCATE('@',vr.redirect)-1) )