Subversion Repositories DevTools

SELECT rt.rtag_id, vw.WORLD_ID, pv.*
  FROM VTREES_WORLD vw,
           RELEASE_TAGS rt,
           VTREES vt,
           RELEASE_CONTENT rc,
           PACKAGE_VERSIONS pv,
           PACKAGE_VERSIONS opv
 WHERE vw.VTREE_ID = rt.VTREE_ID
   AND rt.vtree_id = vt.vtree_id
   AND rc.rtag_id = rt.rtag_id
   AND rc.pv_id = pv.pv_id
   AND vt.HIDE = 'N'
   AND rt.OFFICIAL = 'N'
   AND rt.RTAG_ID <> :RTAG_ID
   AND opv.pv_id = :PV_ID
   AND opv.pkg_id = pv.pkg_id
   AND NVL(opv.v_ext, '|LINK_A_NULL|') = NVL(pv.v_ext, '|LINK_A_NULL|')
   AND vw.WORLD_ID IN (
                                            /* Select My Worlds */
                                            SELECT vw.world_id
                                                  FROM VTREES_WORLD vw,
                                                           RELEASE_TAGS rt
                                                 WHERE vw.VTREE_ID = rt.VTREE_ID
                                                   AND rt.rtag_id = :RTAG_ID    
                                          )