select user_id from cc_users where upper(screen_name) = upper(:screen_name) select user_id from cc_users where upper(screen_name) = upper(:screen_name) select email from parties where party_id = :party_id select group_id from groups where group_name = :name