unreviewed pages that have been editied by reviewers

SQL

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

SQL

Checking query status...