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(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 70 DAY)
#AND rev_timestamp BETWEEN (NOW() - INTERVAL 90 DAY) AND NOW()
#AND page_namespace = 0
#AND rev_user IN (
  SELECT ug_user
  FROM `user_groups`
  WHERE ug_group = 'patroller'
#)
#AND ug_group = 'patroller';
#GROUP BY page_title
#HAVING ug_group = 'patroller'
#ORDER BY COUNT(rev_user)

SQL

Checking query status...