select dc.course_id, dc.course_key, dc.course_name from dotlrn_catalog dc, cr_items ci where dc.course_id = ci.live_revision and dc.course_id = :course_id select dc.course_id, dc.course_key, dc.course_name from dotlrn_catalog dc, cr_items ci where dc.course_id = ci.live_revision and dc.course_id not in ( select object_id from category_object_map where category_id in ( select category_id from categories where tree_id =:tree_id ) )