Untitled query #7148

SQL

USE arwiki_p;
SELECT page_title,
  COUNT(pl_title)
FROM page
JOIN templatelinks ON tl_title = page_title and tl_from_namespace = 0 AND tl_namespace = 10
left JOIN pagelinks ON pl_from = page_id AND page_namespace = 10
WHERE pl_title in (SELECT page_title 
FROM (SELECT * FROM page WHERE page_is_redirect = 1 AND page_namespace = 0) AS red
JOIN (SELECT * FROM pagelinks WHERE pl_from_namespace = 10) AS pag
ON pl_title = page_title AND pl_namespace = page_namespace
JOIN redirect ON rd_from = page_id)
GROUP BY page_title
having COUNT(pl_title)=10
ORDER BY COUNT(pl_title) DESC
SQL

Checking query status...
