select user_id, first_names, last_name from cc_users where user_id in ([join $user_id_list ", "]) (category_id is null and subcategory_id is null and subsubcategory_id is null) (category_id=:mailing_list and subcategory_id is null) (subcategory_id=[lindex $mailing_list 1] and subsubcategory_id is null) subsubcategory_id=[lindex $mailing_list 2] select cc_users.user_id, first_names, last_name from cc_users, ec_cat_mailing_lists where cc_users.user_id=ec_cat_mailing_lists.user_id select u.user_id, first_names, last_name from cc_users u, ec_user_class_user_map m where m.user_class_id=:user_class_id and m.user_id=u.user_id select user_id, first_names, last_name from cc_users select user_id, first_names, last_name from cc_users where last_visit >= to_date(:start,'YYYY-MM-DD HH24:MI:SS') and last_visit <= to_date(:end,'YYYY-MM-DD HH24:MI:SS')