Subversion Repositories DevTools

Rev

Go to most recent revision | Blame | Compare with Previous | Last modification | View Log | RSS feed 

SELECT pv.pv_id, 
           pkg.pkg_name, 
           pv.pkg_version, 
           lm.full_name AS modifier,
       lm.user_email AS modifier_email, 
           pv.modified_stamp, 
           own.full_name AS owner,
       own.user_email AS owner_email, 
           pv.pkg_label, 
           pv.src_path,
       pv.comments reason, 
           pv.pv_overview long_desc,
       pv.pv_description short_desc
  FROM PACKAGES pkg, package_versions pv, users lm, users own
 WHERE pv.pkg_id = pkg.pkg_id
   AND pv.modifier_id = lm.user_id
   AND pv.owner_id = own.user_id
   AND pv.pv_id = :PV_ID