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