select imsld.imsld_id, coalesce(imsld.title, imsld.identifier) as imsld_title, cr3.item_id, cr3.live_revision, to_char(ao.creation_date,'MM/DD/YYYY HH24:MI') as creation_date from cr_items cr1, cr_items cr2, cr_items cr3, cr_items cr4, acs_objects ao, imsld_cp_manifests icm, imsld_cp_organizations ico, imsld_imsldsi imsld where cr1.live_revision = icm.manifest_id and cr1.parent_id = cr4.item_id and cr4.parent_id = :cr_root_folder_id and ico.manifest_id = cr1.item_id and imsld.organization_id = cr2.item_id and cr2.live_revision = ico.organization_id and cr3.item_id = imsld.item_id and cr3.item_id = ao.object_id $imsld_orderby select run.run_id, run.status, coalesce(imsld.title, imsld.identifier) as imsld_title, to_char(ao.creation_date,'MM/DD/YYYY HH24:MI') as creation_date from cr_items cr1, cr_items cr2, cr_items cr3, cr_items cr4, acs_objects ao, imsld_runs run, imsld_cp_manifests icm, imsld_cp_organizations ico, imsld_imsldsi imsld where run.imsld_id = imsld.imsld_id and ao.object_id = run.run_id and cr1.live_revision = icm.manifest_id and cr1.parent_id = cr4.item_id and cr4.parent_id = :cr_root_folder_id and ico.manifest_id = cr1.item_id and imsld.organization_id = cr2.item_id and cr2.live_revision = ico.organization_id and cr3.live_revision = imsld.imsld_id $run_orderby update imsld_runs set status = 'active' where run_id = :set_run_id_live