select t.package_key, t.package_uri, t.pretty_name, t.pretty_plural, t.package_type, t.initial_install_p, t.singleton_p, t.implements_subsite_p, t.inherit_templates_p, v.* from apm_package_versions v, apm_package_types t where v.version_id = :version_id and v.package_key = t.package_key select owner_uri, owner_name from apm_package_owners where version_id = :version_id order by sort_key, owner_uri select dependency_type, service_uri, service_version from apm_package_dependencies where version_id = :version_id order by dependency_type, service_uri select type, proc from apm_package_callbacks where version_id = :version_id select ap.parameter_name, ap.description, ap.datatype, ap.section_name, ap.default_value, ap.min_n_values, ap.max_n_values, ap.scope from apm_parameters ap where ap.package_key = :package_key and not exists (select 1 from apm_parameters ap2 where ap.parameter_name = ap2.parameter_name and ap2.package_key in ('[join $parent_package_keys ',']') ) order by ap.parameter_name