oracle8.1.6 select email from parties where party_id = :user_id select v.version_id, v.package_key, t.pretty_name, v.version_name, v.enabled_p, v.installed_p, v.distribution_uri, (select count(*) from apm_package_files f where f.version_id = v.version_id) as n_files, (select count(*) from apm_package_versions v2 where v2.package_key = v.package_key and v2.installed_p = 't' and apm_package_version.sortable_version_name(v2.version_name) > apm_package_version.sortable_version_name(v.version_name)) as superseded_p, (select count(*) from cr_revisions where revision_id = content_item.get_latest_revision(item_id)) as tarball_p from apm_package_versions v, apm_package_types t where t.package_key = v.package_key [ad_dimensional_sql $dimensional_list where and] [ad_order_by_from_sort_spec $orderby $table_def]