select user_class_name from ec_user_classes where user_class_id = :user_class_id select cc.user_id, first_names, last_name, email, m.user_class_approved_p from cc_users cc, ec_user_class_user_map m where cc.user_id = m.user_id and m.user_class_id=:user_class_id