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