[05:31:56] Hi [05:32:09] Like [11:26:39] Anyone an idea to make this faster, so that it doesn't timeout? http://tinyurl.com/y9w29ac5 [11:27:44] MichaelSchoenitz: You want to know the number of linked articles per site? [11:27:56] yes [11:28:39] I'm pretty sure we have that somewhere on wiki already [11:29:21] MichaelSchoenitz: https://www.wikidata.org/wiki/User:Pasleim/Connectivity ? [11:30:10] Seems to be updated every week [11:30:28] that's something different [11:30:57] I want the articles about a given topic (here humans) with the most sitelinks [11:31:11] Oh, that's much easier these these! [11:31:48] MichaelSchoenitz: Like https://www.wikidata.org/wiki/Wikidata:WikiProject_sum_of_all_paintings/Top_creators_by_number_of_Wikipedia_articles ? [11:31:56] (this is just painters) [11:32:13] yes [11:34:06] MichaelSchoenitz: Use the wikibase:sitelinks field [11:34:17] It contains the number of sitelinks of an item [11:34:48] https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples#Epic_poems_by_sitelink_count is probably a good example [11:36:12] Humans will usually time out :S [11:37:03] yes, times out [11:37:20] also the page says "#old method for sitelink count" [11:37:44] SELECT ?item ?linkcount WHERE { ?item wdt:P31 wd:Q5 . ?item wikibase:sitelinks ?linkcount . } ORDER BY DESC(?linkcount) LIMIT 100 [11:37:47] That just times out [11:38:00] You might have to switch to quarry..... [11:48:23] can i enter multiple names? [11:48:48] ok i knnow how [17:54:03] nikki: very late follow-up to the “most common descriptions”: https://lucaswerkmeister.de/posts/2017/09/03/wikidata+dgsh/ [19:06:15] Lucas_WMDE: cool :)