123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051 |
- 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
|