Unpatrolled enwiki redirects

SQL

/*
SELECT
  page_id AS 'pageid',
  page_title AS 'title',
  ptrpt_value AS 'target'
FROM
  page
  JOIN pagetriage_page ON page_id = ptrp_page_id
  JOIN pagetriage_page_tags AS tg2 ON ptrp_page_id = tg2.ptrpt_page_id
WHERE
  ptrp_reviewed = 0
  AND tg2.ptrpt_tag_id = 9
  AND page_namespace = 0
  AND page_is_redirect = 1
LIMIT 100;
*/
SELECT
	COUNT(page_id) AS 'count',
    tg2.ptrpt_value AS 'creator',
    GROUP_CONCAT(DISTINCT ug_group)
FROM
	page
	JOIN pagetriage_page ON page_id = ptrp_page_id
	JOIN pagetriage_page_tags AS tg2 ON ptrp_page_id = ptrpt_page_id
    JOIN user AS u ON user_name = ptrpt_value
    JOIN user_groups AS ug ON ug_user = user_id
WHERE
	ptrp_reviewed <> 3
	AND ptrpt_tag_id = 10
	AND page_namespace = 0
	AND page_is_redirect = 1
GROUP BY ptrpt_value
#ORDER BY COUNT(page_id) DESC
LIMIT 100;

# SELECT * FROM pagetriage_tags
SQL

Checking query status...
