Subversion Repositories DevTools

/* Get dependencies of submitted pkgs */
SELECT DISTINCT sdep.dpkg_id 
  FROM packages spkg, package_versions spv, package_dependencies sdep
 WHERE spkg.pkg_id = spv.pkg_id
   AND spv.pv_id = sdep.pv_id
   AND spkg.pkg_name || spv.pkg_version IN ( $PKG_NAME_VERSION$ )