distinct user groups

SQL

#SELECT * FROM `logging` WHERE log_namespace = 0 AND log_params LIKE '%"6::auto"%' AND log_timestamp > (NOW() - INTERVAL 90 DAY);
#SELECT * FROM `logging` WHERE log_namespace = 0 AND log_params LIKE '%"6::auto";i:0;%' AND log_timestamp > (NOW() - INTERVAL 7 DAY);
#DESCRIBE pagetriage_page;
SELECT user_name, ptrp_reviewed_updated, page_title
FROM `pagetriage_page` 
JOIN `page` ON ptrp_page_id = page_id 
#JOIN `revision_userindex` ON ptrp_page_id = rev_page
JOIN `user` ON ptrp_last_reviewed_by = user_id
JOIN `user_groups` ON ptrp_last_reviewed_by = ug_user
WHERE page_namespace = 0 
AND ptrp_reviewed_updated > (NOW() - INTERVAL 1 DAY)
AND ptrp_reviewed = 3 
AND ug_group = 'autoreviewer' 
AND ug_group != 'patroller'
AND user_name != (SELECT 1 FROM `page` JOIN `revision_userindex` ON rev_page = pagetriage_page.ptrp_page_id  WHERE rev_parent_id = 0)
LIMIT 100;
SQL

Checking query status...
