select user_id from acs_users_all where lower(screen_name) = lower(:screen_name) select user_id from acs_users_all where lower(email) = lower(:email) select email from parties where party_id = :party_id select group_id from groups where group_name = :name select user_id, screen_name, last_visit, second_to_last_visit, first_names, last_name, email, first_names || ' ' || last_name as full_name from users, parties, persons where users.user_id = parties.party_id and users.user_id = persons.person_id and user_id= :user_id select 1 as one from $table_name where $id_column_name = :generated_id select 1 from dual where exists (select 1 from zip_codes where zip_code like :zip_5)