Subversion Repositories DevTools

SELECT vi.view_id, vi.view_name, pv.dlocked, pv.pv_id, rc.pkg_state, pkg.pkg_name, pv.pkg_version, 
       owner.full_name AS owner, owner.user_email AS owner_email, 
       modifier.full_name AS modifier, modifier.user_email AS modifier_email,
       rc.insert_stamp  
  FROM release_content rc,
       package_versions pv,
       packages pkg,
       users owner,
       users modifier,
       views vi
 WHERE rc.pv_id = pv.pv_id
   AND pv.pkg_id = pkg.pkg_id
   AND pv.owner_id = owner.user_id
   AND pv.modifier_id = modifier.user_id
   AND rc.base_view_id = vi.view_id
   AND rc.pkg_state IN ( /*PKG_STATES*/ )
   AND rc.rtag_id = :RTAG_ID
ORDER BY UPPER(vi.view_name), rc.pkg_state, UPPER(pkg.pkg_name)