Re: [Wikidata] Fwd: Which templates should be global?

Sure, that’s a great idea! Here <http://tinyurl.com/yb8mpu2t>’s a query for the 100 most common templates by number of sitelinks (across all projects): SELECT ?template ?templateLabel ?sitelinks WITH { SELECT ?template ?sitelinks WHERE { ?template wdt:P31/wdt:P279* wd:Q11266439; wikibase:sitelinks ?sitelinks. } ORDER BY DESC(?sitelinks) LIMIT 100 } AS %commonTemplates WHERE { INCLUDE %commonTemplates. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } ORDER BY DESC(?sitelinks) And since the query takes a while to run (about 15 to 30 seconds), I’ll paste the top ten results here: wd:Q20739451 <http://www.wikidata.org/entity/Q20739451> Template:FlowMention 720 wd:Q4299475 <http://www.wikidata.org/entity/Q4299475> Template:Bot 640 wd:Q4844001 <http://www.wikidata.org/entity/Q4844001> Template:Soft redirect 631 wd:Q4847311 <http://www.wikidata.org/entity/Q4847311> Template:Db 620 wd:Q5461620 <http://www.wikidata.org/entity/Q5461620> Template:Babel 504 wd:Q21042800 <http://www.wikidata.org/entity/Q21042800> Template:LQT Moved thread stub converted to Flow 462 wd:Q4608595 <http://www.wikidata.org/entity/Q4608595> Template:Documentation 450 wd:Q5400303 <http://www.wikidata.org/entity/Q5400303> Template:! 446 wd:Q20950423 <http://www.wikidata.org/entity/Q20950423> Template:Wikitext talk page converted to Flow 438 wd:Q21042795 <http://www.wikidata.org/entity/Q21042795> Template:LQT post imported with different signature user 433 Grouping this by project is a bit trickier due to performance, but here <http://tinyurl.com/ycgbwcft>’s a query for the most common templates across Wikivoyages: SELECT ?template ?templateLabel ?sitelinks WITH { SELECT ?template (COUNT(?article) AS ?sitelinks) WHERE { ?template wdt:P31/wdt:P279* wd:Q11266439. ?article schema:about ?template; schema:isPartOf/wikibase:wikiGroup "wikivoyage". } GROUP BY ?template ORDER BY DESC(?sitelinks) LIMIT 100 } AS %commonTemplates WHERE { INCLUDE %commonTemplates. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } ORDER BY DESC(?sitelinks) The top ten results here are: wd:Q5626735 <http://www.wikidata.org/entity/Q5626735> Template:Infobox 30 wd:Q5621162 <http://www.wikidata.org/entity/Q5621162> Template:Infobox country 26 wd:Q21680110 <http://www.wikidata.org/entity/Q21680110> MediaWiki:Recentchangestext 18 wd:Q4847311 <http://www.wikidata.org/entity/Q4847311> Template:Db 18 wd:Q14288116 <http://www.wikidata.org/entity/Q14288116> Template:Pagebanner 17 wd:Q5611978 <http://www.wikidata.org/entity/Q5611978> Template:Welcome 17 wd:Q4608595 <http://www.wikidata.org/entity/Q4608595> Template:Documentation 17 wd:Q14330485 <http://www.wikidata.org/entity/Q14330485> Template:Listing 16 wd:Q6148868 <http://www.wikidata.org/entity/Q6148868> Template:Disambiguation 16 wd:Q4844001 <http://www.wikidata.org/entity/Q4844001> Template:Soft redirect 16 You can repeat this project for each of the wikigroups with more than one project/edition (which you can find with this query <http://tinyurl.com/ybohteq6>; substitute "wikivoyage" in line 5 of the query with that value); unfortunately, I don’t think it’s possible to run them all in a single query without timeout. Cheers, Lucas On 28.06.2017 12:06, Amir E. Aharoni wrote: