select class_instance_id from dotlrn_class_instances where class_key = :class_key order by class_instance_id select class_instance_id from dotlrn_class_instances where class_key = :class_key and term_id = :term_id order by class_instance_id