rowiki templates with most linked redirects

SQL

/*cele mai folosite formate cu cele mai multe redicturi in ele*/
USE rowiki_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
/* 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
*//*
USE rowiki_p;
SELECT page_title,
  COUNT(pl_title)
FROM page
JOIN pagelinks
ON pl_from = page_id
WHERE page_namespace = 10
AND 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...
