postgresql7.1 select p.package_id, p.instance_name as name, pt.pretty_name as package_pretty_name from apm_packages p, apm_package_types pt, apm_package_versions v where pt.package_key = p.package_key and v.package_key = pt.package_key and (v.installed_p = 't' or v.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))) and ( acs_permission__permission_p(p.package_id, :user_id, 'read') = 't' or acs_permission__permission_p(p.package_id, acs__magic_object_id('the_public'), 'read') = 't' ) and (apm_package__singleton_p(p.package_key) = 0 or coalesce(v.auto_mount,'') != '') and not exists (select 1 from site_nodes where object_id = p.package_id) order by name select p.package_id, acs_object__name(p.package_id) as name, pt.pretty_name as package_pretty_name from apm_packages p, apm_package_types pt where pt.package_key = p.package_key and ( acs_permission__permission_p(p.package_id, :user_id, 'read') = 't' or acs_permission__permission_p(p.package_id, acs__magic_object_id('the_public'), 'read') = 't' ) and exists (select 1 from site_nodes where object_id = p.package_id) order by name select p.package_id, acs_object__name(p.package_id) as name, pt.pretty_name as package_pretty_name from apm_packages p, apm_package_types pt, apm_package_versions v where pt.package_key = p.package_key and v.package_key = pt.package_key and (v.installed_p = 't' or v.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))) and ( acs_permission__permission_p(p.package_id, :user_id, 'read') = 't' or acs_permission__permission_p(p.package_id, acs__magic_object_id('the_public'), 'read') = 't' ) and (apm_package__singleton_p(p.package_key) = 1 and coalesce(v.auto_mount,'') = '') and apm_package__singleton_p(p.package_key) = 1 and not exists (select 1 from site_nodes where object_id = p.package_id) order by name