- INNER JOIN emails_watch AS w ON(w.email = e1.email AND w.state = 'pending')
- 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)
+ INNER JOIN email_watch AS w ON(w.email = e1.email AND w.state = 'pending')
+ INNER JOIN aliases AS a1 ON(a1.uid=e1.uid AND a1.type='a_vie')
+ INNER JOIN aliases AS a2 ON(a2.uid=e2.uid AND a2.type='a_vie')
+ INNER JOIN auth_user_md5 AS u1 ON(a1.uid=u1.user_id)
+ INNER JOIN auth_user_md5 AS u2 ON(a2.uid=u2.user_id)