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 `revision_userindex` WHERE rev_page = ptrp_page_id AND rev_parent_id = 0  AS page_creator )
LIMIT 100;
SQL

Checking query status...
