rowiki templates with most linked redirects

SQL

USE rowiki_p;
SELECT page_title,
  COUNT(tl_title)
FROM page
JOIN templatelinks ON tl_from = page_id and tl_from_namespace = 0 AND tl_namespace = 10
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(tl_title) DESC
/* Most linked redirects in rowiki templates
SELECT page_title, rd_title, COUNT(*)
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
ORDER BY COUNT(*) DESC*/
SQL

Checking query status...
