SELECT DATE_FORMAT(CONVERT_TZ(`Events`.`created`,'+00:00','{UTC_OFFSET.RAW}:00'), '%Y-%m-%d') AS `Day of Created`,
       COUNT(`Events`.`reminders`) AS `Count of all 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 {QUERY_LIMIT};