INFO 2021-06-24 14:16:16[scheduling-1] [sqlonly:228] - SELECT COUNT(*) AS CNT FROM PUSH_SCHEDULE WHERE SEND_STATE = 'W' AND SEND_TYPE != 'E' INFO 2021-06-24 14:16:16[scheduling-1] [sqlonly:228] - SELECT COUNT(*) AS cnt FROM PUSH_SCHEDULE PS, ( SELECT PS.PUSH_IDX AS push_idx, COUNT(*) TOTAL FROM PUSH_LOG WHERE PUSH_IDX = PS.PUSH_IDX AND DATE_FORMAT( START_DATE, '%Y-%M-%D' ) = DATE_FORMAT( NOW(), '%Y-%M-%D' ) ) PL WHERE PS.SEND_STATE = 'W' AND PS.SEND_TYPE = 'E' AND PL.PUSH_IDX = PS.push_idx AND PL.TOTAL = 0 INFO 2021-06-24 14:16:47[scheduling-1] [sqlonly:228] - SELECT COUNT(*) AS CNT FROM PUSH_SCHEDULE WHERE SEND_STATE = 'W' AND SEND_TYPE != 'E' INFO 2021-06-24 14:16:47[scheduling-1] [sqlonly:228] - SELECT COUNT(*) AS cnt FROM PUSH_SCHEDULE PS, ( SELECT PS.PUSH_IDX AS push_idx, COUNT(*) TOTAL FROM PUSH_LOG WHERE PUSH_IDX = PS.PUSH_IDX AND DATE_FORMAT( START_DATE, '%Y-%M-%D' ) = DATE_FORMAT( NOW(), '%Y-%M-%D' ) ) PL WHERE PS.SEND_STATE = 'W' AND PS.SEND_TYPE = 'E' AND PL.PUSH_IDX = PS.push_idx AND PL.TOTAL = 0 INFO 2021-06-24 14:17:16[scheduling-1] [sqlonly:228] - SELECT COUNT(*) AS CNT FROM PUSH_SCHEDULE WHERE SEND_STATE = 'W' AND SEND_TYPE != 'E' INFO 2021-06-24 14:17:16[scheduling-1] [sqlonly:228] - SELECT COUNT(*) AS cnt FROM PUSH_SCHEDULE PS, ( SELECT PS.PUSH_IDX AS push_idx, COUNT(*) TOTAL FROM PUSH_LOG WHERE PUSH_IDX = PS.PUSH_IDX AND DATE_FORMAT( START_DATE, '%Y-%M-%D' ) = DATE_FORMAT( NOW(), '%Y-%M-%D' ) ) PL WHERE PS.SEND_STATE = 'W' AND PS.SEND_TYPE = 'E' AND PL.PUSH_IDX = PS.push_idx AND PL.TOTAL = 0