autopatrolled by day

SQL

SELECT EXTRACT(YEAR FROM DATE_FORMAT(log_timestamp,'%Y%m%d%H%i%s')) AS `year`,
       EXTRACT(MONTH FROM DATE_FORMAT(log_timestamp,'%Y%m%d%H%i%s')) AS `month`,
       EXTRACT(DAY FROM DATE_FORMAT(log_timestamp,'%Y%m%d%H%i%s')) AS `day`,   
       COUNT(DISTINCT log_user) AS `unique_reviewers`,
       COUNT(log_id) AS `reviews`,
       log_params
FROM logging
WHERE log_timestamp > (NOW() - INTERVAL 30 DAY)
AND log_namespace = 0
AND log_type = 'patrol' 
AND log_params LIKE '%auto%'
GROUP BY `year`, `month`, `day`
ORDER BY `year` ASC, `month` ASC, `day` ASC;
SQL

Checking query status...
