select version_id, package_key, package_uri, pretty_name, version_name, version_uri, summary, description_format, description, singleton_p, initial_install_p, to_char(release_date, 'Month DD, YYYY') as release_date , vendor, vendor_uri, enabled_p, installed_p, tagged_p, imported_p, data_model_loaded_p, to_char(activation_date, 'Month DD, YYYY') as activation_date, tarball_length, distribution_uri, to_char(deactivation_date, 'Month DD, YYYY') as deactivation_date, to_char(distribution_date, 'Month DD, YYYY') as distribution_date from apm_package_version_info where version_id = :version_id select count(*) as n_files from apm_package_files where version_id = :version_id select pretty_db_name from apm_package_db_types where exists (select 1 from apm_package_files where version_id = :version_id and db_type = db_type_key) select owner_uri, owner_name from apm_package_owners where version_id = :version_id