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