select user_id, email 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) (subcategory_id=[lindex $mailing_list 1] and subsubcategory_id is null) select u.user_id as user_id, email from cc_users u, ec_cat_mailing_lists l where u.user_id=l.user_id select u.user_id as user_id, first_names, last_name, email 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, email from cc_users select user_id, first_names, last_name, email 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') select count(*) from ec_spam_log where spam_id=:spam_id