Subversion Repositories DevTools

/* Package Release Details */
 SELECT rc.insert_stamp, 
            ins.full_name AS insertor, 
        ins.user_email AS insertor_email,
        rc.BASE_VIEW_ID,
        used.USED_COUNT,
        rc.PKG_STATE,
        rc.DEPRECATED_STATE,
        rc.PRODUCT_STATE
   FROM RELEASE_CONTENT rc,
                USERS ins,
        ( 
         SELECT Count(*) AS USED_COUNT
           FROM PACKAGE_DEPENDENCIES dep
          WHERE dep.DPV_ID = :PV_ID                  
        ) used
 WHERE rc.RTAG_ID = :RTAG_ID  
   AND rc.PV_ID = :PV_ID
   AND rc.INSERTOR_ID = ins.USER_ID