select role, responsibilities, public_role_p, eom.user_id from events_organizer_roles eor, events_organizers_map eom where eor.role_id = :role_id and eor.role_id = eom.role_id(+)