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