select site_node__url(n.node_id) as url, n.node_id, n.directory_p,
n.pattern_p, n.object_id, o.object_type, n.package_key, n.package_id
from acs_objects o left outer join
(select n.node_id, n.directory_p, n.pattern_p, n.object_id,
p.package_key, p.package_id
from site_nodes n, apm_packages p
where n.object_id = p.package_id) n
using (object_id)
update site_nodes
set object_id = :package_id
where node_id = :node_id
select object_id as context_id
from site_nodes
where node_id = :parent_node_id
update site_nodes
set object_id = null
where node_id = :node_id