select file_type_key from apm_package_file_types select distribution_tarball from apm_package_versions where version_id = :version_id select db_type_key from apm_package_db_types select package_key from apm_package_version_info where version_id = :version_id select version_id from apm_package_files where file_id = :file_id select package_key from apm_package_versions where version_id = :version_id select f.file_id, f.path from apm_package_files f where f.version_id = :version_id order by path select path from apm_package_files where version_id = :version_id $type_sql $db_type_sql order by path