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 *
FROM `pagetriage_page` 
JOIN `page` 
ON ptrp_page_id = page_id 
JOIN logging ON log_page=page_id 
WHERE page_namespace = 0 
AND ptrp_reviewed_updated > (NOW() - INTERVAL 1 DAY)
AND ptrp_reviewed = 3 
LIMIT 100;
SQL

Checking query status...
