select first_names || ' ' || last_name as user_name
from persons
where person_id = :owner_id
select name, sort_key as page_num, portal_id
from portal_pages
where portal_id = :user_portal_id
order by sort_key
select name, 0 as page_num, portal_id
from portals
where owner_id = :package_id