SELECT
  i.puid AS ItemPuid,
  i.pitem_id AS ItemId,
  ir.pitem_revision_id AS IrId,
  paoIr.plast_mod_date AS IrLastModDate,
  o.plsd AS IrLastSavDate,
  s.psite_id AS OwningSite_TC_pSite_ID
FROM
  dbo.PITEM i
  LEFT OUTER JOIN dbo.PITEMREVISION ir ON (i.puid = ir.ritems_tagu)
  LEFT OUTER JOIN dbo.PPOM_OBJECT o ON (ir.puid = o.puid)
  LEFT OUTER JOIN dbo.PPOM_IMC s ON (o.rowning_siteu = s.puid)
  LEFT OUTER JOIN dbo.PPOM_APPLICATION_OBJECT paoIr ON (ir.puid = paoIr.puid)
  LEFT OUTER JOIN dbo.PPOM_APPLICATION_OBJECT paoI ON (i.puid = paoI.puid)
  LEFT OUTER JOIN dbo.PWORKSPACEOBJECT pwo ON (ir.puid = pwo.puid)
WHERE
  pwo.pactive_seq = 1 AND
  (paoIr.plast_mod_date >= '20170321 21:10:00.000' OR
  o.plsd >= '20170321 20:10:00.000')

  -- Test Refile --> see o.plsd
