select kind_s, kind_v from ims_md_relation where ims_md_re_id = :ims_md_re_id and ims_md_id = :ims_md_id select identifier from ims_md_relation_resource where ims_md_re_id = :ims_md_re_id and ims_md_re_re_id = :ims_md_re_re_id select catalog, entry_l, entry_s from ims_md_relation_resource_catalog where ims_md_re_re_id = :ims_md_re_re_id select '[' || descrip_l || ']' || ' ' || descrip_s as descrip from ims_md_relation_resource where ims_md_re_id = :ims_md_re_id and ims_md_re_re_id = :ims_md_re_re_id