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' 
AND log_action = 'patrol'
##WHERE log_title = 'Lamaria' 
AND log_timestamp > NOW() - INTERVAL 90 DAY
AND log_params LIKE '%s:7:"6::auto";i:0%'
##AND log_namespace = 0
AND log_user_text IN (SELECT user_name FROM `user_groups` JOIN `user` ON user_id = ug_user WHERE ug_group = 'autoreviewer')
AND log_user_text NOT IN (SELECT user_name FROM `user_groups` JOIN `user` ON user_id = ug_user WHERE ug_group = 'patroller')

#AND log_params LIKE '%"6::auto";i:0%'
#AND log_type != 'patrol'
#LIMIT 100;
#SELECT * FROM `logging` WHERE log_title =  'I.H._Bonsall' AND log_params LIKE '%s:7:"6::auto";i:0%';
SQL

Checking query status...
