Untitled query #6370

SQL

use enwiki_p;
SELECT
  concat('* [[:Template:',tl_title,']]'),
  COUNT(*)
FROM templatelinks
WHERE tl_namespace = 10 and tl_from_namespace=0 and tl_title in
				(select p.page_title
from categorylinks
join page p on cl_from=p.page_id 
where cl_to in ("Auto_racing_external_link_templates",
"Baseball_external_link_templates",
"Basketball_external_link_templates",
"Cricket_external_link_templates",
"Cycling_external_link_templates",
"Figure_skating_external_link_templates",
"Golf_external_link_templates",
"Gymnastics_external_link_templates",
"Ice_hockey_external_link_templates",
"Olympics_external_link_templates",
"Paralympics_external_link_templates",
"Professional_wrestling_external_link_templates",
"Swimming_external_link_templates",
"Tennis_external_link_templates",
"Sports_external_link_templates",
"American_football_external_link_templates",
"Association_football_external_link_templates",
"Australian_rules_football_external_link_templates",
"Rugby_league_external_link_templates",
"Rugby_union_external_link_templates"))
GROUP BY tl_title
ORDER BY COUNT(*) DESC
LIMIT 1000;
SQL

Checking query status...
