FROM accounts AS a
INNER JOIN email_source_account AS s1 ON (a.uid = s1.uid AND s1.type = 'forlife')
INNER JOIN email_source_account AS s2 ON (a.uid = s2.uid AND s2.email = '%s')
FROM accounts AS a
INNER JOIN email_source_account AS s1 ON (a.uid = s1.uid AND s1.type = 'forlife')
INNER JOIN email_source_account AS s2 ON (a.uid = s2.uid AND s2.email = '%s')