select resource_id
from imsld_cp_resourcesi
where item_id=:resource_item_id
select 1
from acs_rels ar1,
acs_rels ar2,
imsld_feedback_rel_ext ifre
where ifre.rel_id=ar1.rel_id and
ar1.object_id_two=ar2.object_id_one and
ar2.object_id_two=:resource_item_id
select prerequisite_id
from imsld_imslds
select learning_objective_id
from imsld_imslds
select count(*)
from imsld_cp_resources
where resource_id=:resource_id and
type='imsqti_xmlv1p0'
select ar1.object_id_one as identifier
from acs_rels ar1,
acs_rels ar2
where ar1.object_id_two=ar2.object_id_one
and ar2.object_id_two=:resource_item_id
select count(ar1.object_id_one)
from acs_rels ar1,
acs_rels ar2
where ar1.object_id_two=ar2.object_id_one
and ar2.object_id_two=:resource_item_id