Untitled query #6370

SQL

use enwiki_p;
select *#p.page_title
from categorylinks
#join page p on p.page_namespace=0 and 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")
limit 20;
/*

use lvwiki_p;
SELECT
  tl_title,
  COUNT(*)
FROM templatelinks
WHERE tl_namespace = 10 and tl_from_namespace=10 and tl_title in
				(select use enwiki_p;
select .page_title
from categorylinks
join page p on p.page_namespace=0 and cl_from=p.page_id
#where cl_to="Дискографии")
                 
                 
                 
GROUP BY tl_title
ORDER BY COUNT(*) DESC
LIMIT 1000;*/
SQL

Checking query status...
