select ii.imsld_item_id from imsld_items ii, imsld_activity_descs lad, imsld_learning_activitiesi la, cr_items cr1, cr_items cr2, acs_rels ar where la.item_id = :activity_item_id and content_revision__is_live(la.activity_id) and la.activity_description_id = cr1.item_id and cr1.live_revision = lad.description_id and ar.object_id_one = la.activity_description_id and ar.object_id_two = cr2.item_id and cr2.live_revision = ii.imsld_item_id select icr.resource_id, cp.item_id as resource_item_id, icr.type as resource_type from imsld_cp_resources icr, imsld_items ii, -- imsld_attribute_instances iai, cr_items ci, cr_items cp, acs_rels ar where ii.imsld_item_id = ci.live_revision and ar.object_id_one = ci.item_id and icr.resource_id = cp.live_revision and ar.object_id_two = cp.item_id and content_revision__is_live(icr.resource_id) = 't' and (imsld_tree_sortkey between tree_left((select imsld_tree_sortkey from imsld_items where imsld_item_id = :imsld_item_id)) and tree_right((select imsld_tree_sortkey from imsld_items where imsld_item_id = :imsld_item_id)) or ii.imsld_item_id = :imsld_item_id) -- and iai.owner_id = ii.imsld_item_id -- and iai.run_id = :run_id -- and iai.user_id = :user_id -- and iai.type = 'isvisible' -- and iai.is_visible_p = 't'