select role, responsibilities, public_role_p, eom.user_id from events_organizer_roles eor left join events_organizers_map eom using ( role_id ) where eor.role_id = :role_id