postgresql7.1
select package_id, instance_name as name, package_key
from apm_packages p
where (acs_permission__permission_p(package_id, :user_id, 'read') or
acs_permission__permission_p(package_id, acs__magic_object_id('the_public'), 'read'))
and not (select singleton_p from apm_package_types
where package_key = p.package_key)
and not exists (select 1
from site_nodes
where object_id = package_id)
order by name
select package_id, instance_name as name, package_key
from apm_packages p
where (acs_permission__permission_p(package_id, :user_id, 'read') or
acs_permission__permission_p(package_id, acs__magic_object_id('the_public'), 'read'))
and (select singleton_p from apm_package_types
where package_key = p.package_key)
and not exists (select 1
from site_nodes
where object_id = package_id)
order by name