select site_node_url(sn2.node_id)
from site_nodes sn1, site_nodes sn2, apm_packages p
where sn1.object_id = :package_id
and sn2.parent_id = sn1.node_id
and sn2.object_id = p.package_id
and p.package_key = 'clickthrough'
select sn2.object_id as parent_package_id
from site_nodes sn1, site_nodes sn2
where sn1.object_id = :clickthrough_package_id
and sn1.parent_id = sn2.node_id
select sn2.object_id as parent_package_id
from site_nodes sn1, site_nodes sn2
where sn1.object_id = :clickthrough_package_id
and sn1.parent_id = sn2.node_id