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.PNAME              AS IrOwningSite
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)
Order by
  paoIr.plast_mod_date Asc
