postgresql7.2
select le.*
from layout_elements le, layout_pages lp, layout_includelets li
where le.package_id = :package_id
and lp.page_id = le.page_id
and lp.pageset_id = :pageset_id
and le.includelet_name = li.name
and apm_package__is_child(li.application, :package_key)
order by le.title
select li.*
from layout_includelets li
where apm_package__is_child(li.application, :package_key)
and li.internally_managed_p = 'f'
and not exists (select 1
from layout_elements le
where le.package_id = :package_id
and le.includelet_name = li.name
and li.singleton_p = 't')
order by li.name