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