Unreviewed redirects grouped by target

SQL

SELECT actor_name as `creator`, COUNT(*) as `#`, page_title as `Example page`, date(min(ptrp_reviewed_updated)) as `Oldest`, ptrpt_value
  FROM pagetriage_page
  JOIN page ON ptrp_page_id = page_id
  JOIN revision ON rev_page = page_id 
  JOIN actor ON actor_id = rev_actor
  JOIN pagetriage_page_tags on ptrpt_page_id = page_id
  WHERE ptrp_reviewed = 0
    AND page_namespace = 0 
    and ptrpt_tag_id = 9
    AND page_is_redirect = 1
    AND rev_parent_id = 0
  GROUP BY ptrpt_value
--  having count(*) > 1 
--  ORDER BY COUNT(*) DESC
  limit 10;

SQL

Checking query status...