SELECT PROCESSINSTANCEID, PROCESSID, START_DATE, END_DATE, STATUS, PARENTPROCESSINSTANCEID, OUTCOME, DURATION,
       USER_IDENTITY, PROCESSVERSION, PROCESSNAME, CORRELATIONKEY, EXTERNALID, PROCESSINSTANCEDESCRIPTION, SLA_DUE_DATE,
       SLACOMPLIANCE, LASTMODIFICATIONDATE, ERRORCOUNT
FROM
    ( SELECT LOG.PROCESSINSTANCEID, LOG.PROCESSID, LOG.START_DATE, LOG.END_DATE, LOG.STATUS, LOG.PARENTPROCESSINSTANCEID,
             LOG.OUTCOME, LOG.DURATION, LOG.USER_IDENTITY, LOG.PROCESSVERSION, LOG.PROCESSNAME, LOG.CORRELATIONKEY, LOG.EXTERNALID,
             LOG.PROCESSINSTANCEDESCRIPTION, LOG.SLA_DUE_DATE, LOG.SLACOMPLIANCE, COALESCE ( INFO.LASTMODIFICATIONDATE,
             LOG.END_DATE ) AS LASTMODIFICATIONDATE,
             (
                SELECT COUNT ( ERRINFO.ID )
                FROM EXECUTIONERRORINFO ERRINFO
                WHERE ERRINFO.PROCESS_INST_ID=LOG.PROCESSINSTANCEID
                AND ERRINFO.ERROR_ACK=0
            ) AS ERRORCOUNT
      FROM PROCESSINSTANCELOG LOG
      LEFT JOIN PROCESSINSTANCEINFO INFO ON INFO.INSTANCEID=LOG.PROCESSINSTANCEID
    ) "dbSQL"
WHERE ERRORCOUNT > 0.0
ORDER BY START_DATE DESC FETCH FIRST 10 ROWS ONLY