select item_id as resource_id from imsld_cp_resourcesi where identifier = :resource_identifier and manifest_id = :manifest_id select env.component_id from imsld_environmentsi env where content_revision__is_live(env.environment_id) = 't' and env.item_id = :environment_id select ir.item_id as role_id from imsld_rolesi ir where ir.identifier = :ref and content_revision__is_live(ir.role_id) = 't' and ir.component_id = :component_id select item_id as role_item_id from imsld_rolesi where identifier = :role_ref and content_revision__is_live(role_id) = 't' and component_id = :component_id select item_id as referenced_env_id from imsld_environmentsi where identifier = :ref and content_revision__is_live(environment_id) = 't' and component_id = :component_id select item_id as environment_id from imsld_environmentsi where identifier = :environment_ref and content_revision__is_live(environment_id) = 't' and component_id = :component_id select item_id as role_id from imsld_rolesi where identifier = :ref and content_revision__is_live(role_id) = 't' and component_id = :component_id select item_id as environment_id from imsld_environmentsi where identifier = :environment_ref and content_revision__is_live(environment_id) = 't' and component_id = :component_id select item_id as environment_id from imsld_environmentsi where identifier = :environment_ref and content_revision__is_live(environment_id) = 't' and component_id = :component_id select item_id as activity_id, activity_id as learning_activity_id from imsld_learning_activitiesi where identifier = :learning_activity_ref and content_revision__is_live(activity_id) = 't' and component_id = :component_id select item_id as activity_id, activity_id as support_activity_id from imsld_support_activitiesi where identifier = :learning_activity_ref and content_revision__is_live(activity_id) = 't' and component_id = :component_id select item_id as referenced_struct_id, structure_id from imsld_activity_structuresi where identifier = :ref and content_revision__is_live(structure_id) = 't' and component_id = :component_id select item_id as referenced_struct_id, structure_id from imsld_activity_structuresi where identifier = :learning_activity_ref and content_revision__is_live(structure_id) = 't' and component_id = :component_id select item_id as referenced_struct_id, structure_id from imsld_activity_structuresi where identifier = :support_activity_ref and content_revision__is_live(structure_id) = 't' and component_id = :component_id update imsld_activity_structures set sort_order = :sort_order where structure_id = :structure_id update imsld_activity_structures set sort_order = :sort_order where structure_id = (select live_revision from cr_items where item_id = :activity_structure_ref_id) update imsld_support_activities set sort_order = :sort_order where activity_id = :support_activity_id update imsld_learning_activities set sort_order = :sort_order where activity_id = :learning_activity_id select item_id as activity_id, activity_id as support_activity_id from imsld_support_activitiesi where identifier = :support_activity_ref and content_revision__is_live(activity_id) ='t' and component_id = :component_id select item_id as activity_id, activity_id as learning_activity_id from imsld_learning_activitiesi where identifier = :support_activity_ref and content_revision__is_live(activity_id) = 't' and component_id = :component_id select cr4.item_id as component_id from imsld_components ic, imsld_methods im, imsld_plays ip, imsld_acts ia, cr_revisions cr0, cr_revisions cr1, cr_revisions cr2, cr_revisions cr3, cr_revisions cr4 where cr4.revision_id = ic.component_id and content_revision__is_live(ic.component_id) = 't' and ic.imsld_id = cr3.item_id and content_revision__is_live(cr3.revision_id) = 't' and cr3.item_id = im.imsld_id and im.method_id = cr2.revision_id and cr2.item_id = ip.method_id and ip.play_id = cr1.revision_id and cr1.item_id = ia.play_id and ia.act_id = cr0.revision_id and cr0.item_id = :act_id select ir.item_id as role_id from imsld_rolesi ir where ir.identifier = :role_ref_ref and content_revision__is_live(ir.role_id) = 't' and ir.component_id = :component_id select la.item_id as learning_activity_id from imsld_learning_activitiesi la where la.identifier = :learning_activity_ref_ref and content_revision__is_live(la.activity_id) = 't' and la.component_id = :component_id select item_id as support_activity_id from imsld_support_activitiesi where identifier = :learning_activity_ref_ref and content_revision__is_live(activity_id) = 't' and component_id = :component_id select item_id as activity_structure_id from imsld_activity_structuresi where identifier = :learning_activity_ref_ref and content_revision__is_live(structure_id) = 't' and component_id = :component_id select sa.item_id as support_activity_id from imsld_support_activitiesi sa where sa.identifier = :support_activity_ref_ref and content_revision__is_live(sa.activity_id) = 't' and sa.component_id = :component_id select item_id as learning_activity_id from imsld_learning_activitiesi where identifier = :support_activity_ref_ref and content_revision__is_live(activity_id) = 't' and component_id = :component_id select item_id as activity_structure_id from imsld_activity_structuresi where identifier = :support_activity_ref_ref and content_revision__is_live(structure_id) = 't' and component_id = :component_id select ias.item_id as activity_structure_id from imsld_activity_structuresi ias where ias.identifier = :activity_structure_ref_ref and content_revision__is_live(ias.structure_id) = 't' and ias.component_id = :component_id select item_id as learning_activity_id from imsld_learning_activitiesi where identifier = :activity_structure_ref_ref and content_revision__is_live(activity_id) = 't' and component_id = :component_id select item_id as support_activity_id from imsld_support_activitiesi where identifier = :activity_structure_ref_ref and content_revision__is_live(activity_id) = 't' and component_id = :component_id select env.item_id as environment_id from imsld_environmentsi env where env.identifier = :environment_ref_ref and content_revision__is_live(env.environment_id) = 't' and env.component_id = :component_id select item_id as role_part_id from imsld_role_partsi where identifier = :ref and content_revision__is_live(role_part_id) = 't' and act_id = :act_id select imsld_id from imsld_componentsi where item_id = :component_id select ico.item_id as component_id im.imsld_id from imsld_methodsi im, imsld_componetnsi ico where im.item_id = :method_id and im.imsld_id = ico.imsld_id select item_id as activity_id, activity_id as learning_activity_id from imsld_learning_activitiesi where identifier = :learning_activity_ref and content_revision__is_live(activity_id) = 't' and component_id = :component_id select item_id as activity_id, activity_id as support_activity_id from imsld_support_activitiesi where identifier = :learning_activity_ref and content_revision__is_live(activity_id) = 't' and component_id = :component_id select item_id as activity_id, activity_id as support_activity_id from imsld_support_activitiesi where identifier = :support_activity_ref and content_revision__is_live(activity_id) = 't' and component_id = :component_id select item_id as activity_id, activity_id as learning_activity_id from imsld_learning_activitiesi where identifier = :support_activity_ref and content_revision__is_live(activity_id) = 't' and component_id = :component_id select ir.item_id as role_id from imsld_rolesi ir where ir.identifier = :ref and content_revision__is_live(ir.role_id) = 't' and ir.component_id = :component_id select item_id as email_property_id from imsld_propertiesi where identifier = :email_property_ref and content_revision__is_live(property_id) = 't' and component_id = :component_id select item_id as username_property_id from imsld_propertiesi where identifier = :username_property_ref and content_revision__is_live(property_id) = 't' and component_id = :component_id select item_id as play_id from imsld_playsi where identifier = :ref and content_revision__is_live(play_id) = 't' and method_id = :method_id select 1 from imsld_cp_resources where identifier = :resource_identifier and manifest_id = :manifest_id select 1 from imsld_classes where identifier = :class_identifier and method_id = :method_id