select cc.course_id, cc.course_key, cc.course_name, cc.course_info, cc.assessment_id, ci.item_id from dotlrn_catalog cc, cr_items ci where cc.course_id = ci.live_revision and ci.item_id in ( select object_id from acs_permissions where grantee_id = :user_id and privilege = 'admin') select cc.course_id, cc.course_key, cc.course_name, cc.course_info, cc.assessment_id, ci.item_id from dotlrn_catalog cc, cr_items ci where cc.course_id = ci.live_revision order by lower(cc.course_name) select cc.course_id, cc.course_key, cc.course_name, cc.course_info, cc.assessment_id, ci.item_id from dotlrn_catalog cc, cr_items ci where cc.course_id = ci.live_revision and (lower(cc.course_name) like lower('%$keyword%') or lower(cc.course_key) like lower('%$keyword%')) and ci.item_id in ( select object_id from acs_permissions where grantee_id = :user_id and privilege = 'admin') select cc.course_id, cc.course_key, cc.course_name, cc.course_info, cc.assessment_id, ci.item_id from dotlrn_catalog cc, cr_items ci where cc.course_id = ci.live_revision and (lower(cc.course_name) like lower('%$keyword%') or lower(cc.course_key) like lower('%$keyword%')) 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 cc.course_id, cc.course_key, cc.course_name, cc.course_info, cc.assessment_id, ci.item_id from dotlrn_catalog cc, cr_items ci where cc.course_id = ci.live_revision and ci.item_id in ( select object_id from acs_permissions where grantee_id = :user_id and privilege = 'admin') select cc.course_id, cc.course_key, cc.course_name, cc.course_info, cc.assessment_id, ci.item_id from dotlrn_catalog cc, cr_items ci where cc.course_id = ci.live_revision select cc.course_id, cc.course_key, cc.course_name, cc.course_info, cc.assessment_id, ci.item_id from dotlrn_catalog cc, cr_items ci where cc.course_id = ci.live_revision (lower(cc.course_name) like lower('%$keyword%') or lower(cc.course_key) like lower('%$keyword%')) and ci.item_id in ( select object_id from acs_permissions where grantee_id = :user_id and privilege = 'admin') select cc.course_id, cc.course_key, cc.course_name, cc.course_info, cc.assessment_id, ci.item_id from dotlrn_catalog cc, cr_items ci where cc.course_id = ci.live_revision (lower(cc.course_name) like lower('%$keyword%') or lower(cc.course_key) like lower('%$keyword%')) and