SELECT DISTINCT dep.dpkg_id FROM package_dependencies dep, package_versions pv, ( /* Simulate release after packages have bee added */ SELECT rel.pv_id FROM release_content rel WHERE rtag_id = $RTAG_ID$ UNION SELECT spv.pv_id FROM packages spkg, package_versions spv WHERE spkg.pkg_id = spv.pkg_id AND spkg.pkg_name || spv.pkg_version IN ( $PKG_NAME_VERSION$ ) AND spkg.pkg_id NOT IN ( /* pkg_id list from current release */ SELECT pkg.pkg_id FROM release_content rel, packages pkg, package_versions pv WHERE pkg.pkg_id = pv.pkg_id AND pv.pv_id = rel.pv_id AND rel.rtag_id = $RTAG_ID$ AND pkg.pkg_name || pv.pkg_version IN ( $PKG_NAME_VERSION$ ) ) ) simrel WHERE pv.pv_id = simrel.pv_id AND pv.pkg_id = dep.pkg_id AND dep.pkg_id IN ( $TO_TRACK$ ) AND dep.dpkg_id IN (SELECT pkg_id FROM packages WHERE pkg_name IN ( $PKG_NAMES$ ) )