SELECT se.election_id, se.description FROM samosa_users su WHERE (user_id=2) LEFT JOIN samosa_assoc_groups_users USING (user_id) LEFT JOIN samosa_groups sg USING (group_id) LEFT JOIN samosa_assoc_users_elections saue USING (user_id) LEFT JOIN samosa_assoc_groups_elections sage USING (group_id) INNER JOIN samosa_elections se ON (saue.election_id=se.election_id OR sage.election_id=se.election_id);