Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DATE_FORMAT(CONVERT_TZ(`Events`.`created`,'+00:00','{UTC_OFFSET.RAW}:00'), '%Y-%m-%d') AS `Day of Created`,
- COUNT(DISTINCT `Events`.`reminders`) AS `Count of distinct Reminders`
- FROM `events` AS `Events`
- WHERE (CONVERT_TZ(`Events`.`created`,'+00:00','{UTC_OFFSET.RAW}:00') >= TIMESTAMP('2019-05-06')
- AND CONVERT_TZ(`Events`.`created`,'+00:00','{UTC_OFFSET.RAW}:00') < DATE_ADD(TIMESTAMP('2019-05-07'), INTERVAL 1 DAY))
- GROUP BY DATE_FORMAT(CONVERT_TZ(`Events`.`created`,'+00:00','{UTC_OFFSET.RAW}:00'), '%Y-%m-%d')
- ORDER BY `Day of Created` ASC
- LIMIT 1000;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement