SELECT TASK.SECURITYSYSTEM , TASK.TASKTYPE ,COUNT(TASK.TASKKEY) AS TOTALTASKS FROM ARSTASKS TASK WHERE TASK.SECURITYSYSTEM IS NOT NULL AND TASK.STATUS IN (1,6)  AND TASK.SECURITYSYSTEM IN (7,8,9) AND TASK.SECURITYSYSTEM IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15) AND (TASK.STARTDATE IS NULL OR TASK.STARTDATE <= UTC_TIMESTAMP()) AND NOT EXISTS( SELECT 1 FROM ARSTASKS_EXEC TEXEC WHERE TEXEC.ARSTASKKEY = TASK.TASKKEY )  GROUP BY TASK.SECURITYSYSTEM,TASK.TASKTYPE  UNION  SELECT SS.SYSTEMKEY , TASK.TASKTYPE ,COUNT(TASK.TASKKEY) AS TOTALTASKS FROM ARSTASKS TASK, SECURITYSYSTEMS SS 
                        WHERE TASK.SECURITYSYSTEM IS NULL AND TASK.EXTERNALCONNECTION IS NOT NULL AND 
                        TASK.EXTERNALCONNECTION=SS.PROVISIONINGCONNECTION AND 
                        TASK.STATUS IN (1,6) AND TASK.EXTERNALCONNECTION in (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15)
                 AND SS.SYSTEMKEY IN (7,8,9) AND (TASK.STARTDATE IS NULL OR TASK.STARTDATE <= UTC_TIMESTAMP()) AND NOT EXISTS(SELECT 1 FROM ARSTASKS_EXEC TEXEC WHERE TEXEC.ARSTASKKEY = TASK.TASKKEY)  GROUP BY SS.SYSTEMKEY,TASK.TASKTYPE