Miscellany

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