unreviewed pages that have been editied by reviewers

SQL

# reviewers who have edited a given article
SELECT DISTINCT page_title, rev_user_text, ug_group COUNT(DISTINCT rev_user_text) AS edits
FROM `page` 
JOIN `pagetriage_page` ON page_id = ptrp_page_id 
JOIN `revision_userindex` ON rev_page = page_id
JOIN `user_groups` ON  rev_user = ug_user
WHERE ptrp_reviewed = 0
AND ptrp_created BETWEEN (NOW() - INTERVAL 90 DAY) AND (NOW()  - INTERVAL 80 DAY)
AND rev_timestamp BETWEEN (NOW() - INTERVAL 90 DAY) AND NOW()
AND page_namespace = 0
#AND ug_group = 'patroller';
#GROUP BY page_title
HAVING ug_group = 'patroller'
#ORDER BY COUNT(rev_user)

SQL

Checking query status...