Query Run
SELECT DATE(`log_timestamp`) as date, count(*) as... 6 years ago
SELECT DATE(`log_timestamp`) as date, count(*) as num_patrol_actions,... 6 years ago