User:Edgars2007/IDs

From Wikidata
Jump to navigation Jump to search

500+[edit]

Full list[edit]

2016-01-26

"* w:en:Template:Fauna of Ukraine, 8(5)",9

"* w:en:Template:Fauna of Ukraine, 8(3)",1 

use enwiki_p;
SELECT
  concat('* [[:Template:',tl_title,']]'),
  COUNT(*)
FROM templatelinks
WHERE tl_namespace = 10 and tl_from_namespace=0 and  exists (select *
from categorylinks
join page p on p.page_namespace=10 and cl_from=p.page_id
where p.page_title=tl_title and cl_to in ("Chemistry_external_link_templates",
"Geography_external_link_templates",
"Fauna_external_link_templates",
"Social_media_external_link_templates",
"Dictionary_external_link_templates",
"Heritage_external_link_templates",
"Music_external_link_templates",
"Theatre_external_link_templates",
"Encyclopedia_external_link_templates",
"Film_external_link_templates",
"Company_external_link_templates",
"Aviation_external_link_templates",
"Language_external_link_templates",
"Astronomy_external_link_templates",
"Television_external_link_templates",
"Anatomy_external_link_templates",
"Sports_external_link_templates",
"Radio_external_link_templates",
"Software_external_link_templates",
"Medical_external_link_templates",
"Bible_external_link_templates",
"Drink_external_link_templates",
"Canada_politics_and_government_external_link_templates",
"Cricket_external_link_templates",
"Internet_Relay_Chat_external_link_templates",
"Baseball_external_link_templates",
"Basketball_external_link_templates",
"Law_external_link_templates",
"Golf_external_link_templates",
"Tennis_external_link_templates",
"United_States_government_external_link_templates",
"Snooker_external_link_templates",
"Cue_sports_external_link_templates",
"Ice_hockey_external_link_templates",
"Auto_racing_external_link_templates",
"Rugby_union_external_link_templates",
"American_football_external_link_templates",
"Cycling_external_link_templates",
"Rugby_league_external_link_templates",
"Olympics_external_link_templates",
"United_States_Congress_external_link_templates",
"Gymnastics_external_link_templates",
"Professional_wrestling_external_link_templates",
"Paralympics_external_link_templates",
"Figure_skating_external_link_templates",
"Australian_rules_football_external_link_templates",
"Swimming_external_link_templates",
"Football_external_link_templates",
"Association_football_external_link_templates",
"Politics_external_link_templates",
"GLAM_external_link_templates",
"Video_game_external_link_templates",
"People_and_person_external_link_templates",
"Flora_external_link_templates",
"Comics_external_link_templates",
"United_States_Supreme_Court_external_link_templates",
"Singapore_external_link_templates",
"United_States_law_external_link_templates",
"Biology_external_link_templates",
"Philosophy_external_link_templates",
"Doctor_Who_external_link_templates",
"Museum_external_link_templates",
"Author_and_writer_external_link_templates",
"External_link_templates")
                                                            )
GROUP BY tl_title
ORDER BY COUNT(*) DESC
LIMIT 100000;
Retrieved from "https://www.wikidata.org/w/index.php?title=User:Edgars2007/IDs&oldid=296602220"