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
SELECT *        
FROM logging
WHERE log_timestamp > (NOW() - INTERVAL 3 DAY)
AND log_namespace = 0
AND log_type = 'patrol' 
AND log_params LIKE '%::auto";i:1%'
#GROUP BY `year`, `month`, `day`
#ORDER BY `year` ASC, `month` ASC, `day` ASC;
SQL

Checking query status...
