postgresql7.1 select mr.member_state, p.email, u.oid as row_id from users u JOIN parties p on (p.party_id = u.user_id) LEFT JOIN membership_rels mr on (mr.rel_id = u.user_id) where u.user_id = :user_id and u.email_verified_p = 'f'