select dc.class_instance_id as com_id, dc.department_name, dc.term_name, dc.class_name, dc.pretty_name, dc.url from dotlrn_class_instances_full dc where dc.class_instance_id not in ( select icmc.community_id from ims_cp_manifest_class icmc where icmc.community_id is not null and man_id in ( select revision_id from cr_revisions where item_id = :item_id ) ) order by department_name, term_name, class_name, pretty_name select dc.class_instance_id as com_id, dc.department_name, dc.term_name, dc.class_name, dc.pretty_name, dc.url from dotlrn_class_instances_full dc where dc.class_instance_id in ( select icmc.community_id from ims_cp_manifest_class icmc where icmc.man_id in ( select revision_id from cr_revisions where item_id = :item_id ) ) order by department_name, term_name, class_name, pretty_name