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, to_char(v.release_date, 'YYYY-MM-DD') as release_date, v.enabled_p, v.installed_p, v.distribution_uri, (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, case when content_item.get_latest_revision(item_id) is null then 0 else 1 end as tarball_p from apm_package_versions v, apm_package_types t where t.package_key = v.package_key $filter_where_clause [template::list::orderby_clause -name package_list -orderby] (installed_p = 't' or enabled_p = 't' or not exists ( select 1 from apm_package_versions v2 where v2.package_key = v.package_key and (v2.installed_p = 't' or v2.enabled_p = 't') and apm_package_version.sortable_version_name(v2.version_name) > apm_package_version.sortable_version_name(v.version_name)))