autopatrolled articles from last 90 days

SQL

#SELECT DISTINCT `ug_group` FROM `user_groups`;
#SELECT user_name FROM `user_groups` JOIN `user` ON user_id = ug_user WHERE ug_group = 'autoreviewer' LIMIT 10;
#DESCRIBE logging_userindex;
SELECT * FROM `logging` 
#WHERE log_type='patrol' 
#WHERE log_title = 'Lamaria' 
WHERE log_timestamp > NOW() - INTERVAL 3 DAY
#AND log_namespace = 0
AND log_user IN (SELECT user_name FROM `user_groups` JOIN `user` ON user_id = ug_user WHERE ug_group = 'autoreviewer')
#AND log_params LIKE '%"6::auto";i:0%'
#AND log_type != 'patrol'
LIMIT 25;

SQL

Checking query status...