select dc.course_id, dc.course_key, dc.course_name, dc.course_info, dc.assessment_id, ci.live_revision from dotlrn_catalog dc, cr_items ci where ci.item_id = :item_id and dc.course_id in (select revision_id from cr_revisions where item_id = :item_id ) and ci.live_revision <> dc.course_id order by dc.course_id asc select dc.course_id, dc.course_key, dc.course_name, dc.course_info, dc.assessment_id, ci.live_revision from dotlrn_catalog dc, cr_items ci where ci.item_id = :item_id and dc.course_id in (select revision_id from cr_revisions where item_id = :item_id ) and ci.live_revision=dc.course_id select cr.title from cr_folders cf, cr_items ci, cr_revisions cr, as_assessments a where cr.revision_id = ci.latest_revision and a.assessment_id = cr.revision_id and ci.parent_id = cf.folder_id and ci.item_id = :assessment_id order by cr.title select pretty_name, url from dotlrn_class_instances_full where class_instance_id = :class_id