select man_id, community_id, lorsm_instance_id from ims_cp_manifest_class where man_id = :man_id and community_id = :community_id" select cp.man_id, cp.course_name, cp.identifier, cp.version, text 'Yes' as hello, case when hasmetadata = 't' then 'Yes' else 'No' end as man_metadata, case when isscorm = 't' then 'Yes' else 'No' end as isscorm, cp.isshared, acs.creation_user, acs.creation_date, acs.context_id from ims_cp_manifests cp, acs_objects acs where cp.man_id = acs.object_id and cp.man_id = :man_id and cp.parent_man_id = 0 select count(*) as submanifests from ims_cp_manifests where man_id = :man_id and parent_man_id = :man_id select org.org_id, org.org_title as org_title, org.hasmetadata, tree_level(o.tree_sortkey) as indent from ims_cp_organizations org, acs_objects o where org.org_id = o.object_id and man_id = :man_id order by org_id