SELECT i.puid          AS ItemPuid,
  i.pitem_id           AS ItemName,
  ir.puid              AS IrPuid,
  ir.pitem_revision_id AS IrRev,
  paoir.plast_mod_date AS IrLastModDate,
  s.psite_id           AS IrOwningSite_TC_pSite_ID
FROM infodba.PITEM i
LEFT JOIN infodba.PITEMREVISION ir on (i.puid = ir.ritems_tagu)
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)
where i.pitem_id like 'Item0%'
