Templatelinks protection checker (only semi-protected)

SQL

SELECT
  CONCAT("Template:", REPLACE(tl_title, "_", " ")) AS "Semi-protected template",
  count(*) AS "Uses"
FROM
  templatelinks
  INNER JOIN page ON page.page_namespace = 10 AND page.page_title = templatelinks.tl_title
  INNER JOIN page_restrictions ON page.page_id = page_restrictions.pr_page
WHERE
  tl_namespace = 10
  AND page_restrictions.pr_level = "autoconfirmed"
GROUP BY
  tl_title
HAVING
  count(*) > 500
ORDER BY
  count(*) DESC

AخA
 
SELECT  CONCAT("Template:", REPLACE(tl_title, "_", " ")) AS "Semi-protected template",  count(*) AS "Uses"FROM  templatelinks  INNER JOIN page ON page.page_namespace = 10 AND page.page_title = templatelinks.tl_title  INNER JOIN page_restrictions ON page.page_id = page_restrictions.pr_pageWHERE  tl_namespace = 10  AND page_restrictions.pr_level = "autoconfirmed"GROUP BY  tl_titleHAVING  count(*) > 500ORDER BY  count(*) DESC

SQL

Checking query status...