select class_instance_id from dotlrn_class_instances where class_key = :class_key order by class_instance_id select count(*) from dotlrn_terms where dotlrn_terms.term_id not in (select dotlrn_class_instances.term_id from dotlrn_class_instances where dotlrn_class_instances.class_key = :class_key)