SELECT ir.pitem_revision_id AS IrRev,
  paoir.plast_mod_date      AS IrLastModDate,
  paoir.pcreation_date      AS IrCreateDate,
  s.pname                   AS IrOwningSite,
  s.psite_id                AS IrOwningSite
FROM infodba.PITEMREVISION ir
LEFT JOIN infodba.PPOM_OBJECT o on (ir.puid = o.puid)
LEFT JOIN infodba.PPOM_IMC s on (o.rowning_siteu = s.puid)
LEFT JOIN infodba.PPOM_APPLICATION_OBJECT paoIr on (ir.puid = paoir.puid)