[09:40:10] how do i map many qids to the corresponding english wikipedia articles? [09:44:04] kopiersperre: https://tools.wmflabs.org/wikidata-todo/quick_statements.php supports that [09:45:55] how would this look? e.g. i have Q5282 [09:47:06] quickstatements only does it the other way, as far as I know [09:48:58] doing it in batches with sparql using something like http://tinyurl.com/hdlxhl2 might work [09:50:51] or the api - https://www.wikidata.org/w/api.php?action=wbgetentities&ids=Q5282|Q1&props=sitelinks&sitefilter=enwiki [09:51:24] I don't know of anything where you can just copy and paste a load of ids though... if there is something, I'd be interested in knowing what it is :) [10:05:03] How do you want to use it? Database query or API could be the source, but not very user friendly I guess..... [10:06:38] sjoerddebruin: Heb jij een idee wat precies de criteria zijn voor opname in biografisch portaal? [10:08:29] Ik heb http://tinyurl.com/zko5pxv gedaan. Geeft 2800 items. Als ik wat willekeurig zoek dan vind ik echt helemaal niets. [10:19:09] I might have misunderstood what you were asking (it's not like it was even aimed at me :P) but there's a faq/vragen link at the bottom of biografischportaal.nl which has something about the criteria for inclusion, if that's what you were looking for [10:43:43] nikki: Right, I read over the first part. Dead Dutch dudes and dudettes ;-) [10:44:17] And date of death is very incomplete for that set so I can't use it as a filter [10:44:32] Oh well, https://www.wikidata.org/wiki/Special:Contributions/BotMultichill seems to be going fast enough and finding enough hits [11:26:56] multichill: weet ik niet [11:43:07] nikki: Any idea how to improve http://tinyurl.com/jk9bxn9 ? The nested query completes in less than 150 ms. If I replace it with values the main query completes too [11:43:32] With values at http://tinyurl.com/hfqy86z [11:54:12] do you actually need a nested query there? http://tinyurl.com/z454xj9 seems to return the same as the second query [11:56:34] Weird, that looks like my first try, but that one didn't complete in time? [11:58:03] recently I've been having problems with some queries timing out on one server and running fine on another [11:58:55] Let's see if we can get some labels in there to make it look prettier [11:59:20] like my queries will return results in 2-3 seconds if it comes from wdqs1002 but wdqs1001 times out... and it's not cached, when it is, it returns results in a few milliseconds [12:01:01] Excellent!http://tinyurl.com/zo7yhdb [12:02:22] :) [12:05:09] nikki: If I remove the constraint on the property, it doesn't complete. So seems like we're close to the time out [12:09:02] nikki: hmm, http://tinyurl.com/jymj8pt doesn't complete. Might have to fall back to VALUES :-( [15:50:48] is there an inventory of software infobox in various languages and their equivalent fields ? For instance I'd be interested to get all "Official Website" field from all wikipedia and check how they compare. I don't think such a resource exists but ... ;-) [18:30:11] multichill: I played about a bit and http://tinyurl.com/z7yoa3s seems to return in 3.5 seconds [18:30:54] sparql is like black magic... I have no idea why moving things around does/doesn't make a difference [21:35:49] nikki: Excellent! Weird with the sub query now working [21:35:59] I need a SPARQL EXPLAIN [21:36:36] Did you add it to the example queries? It's a fun one [21:38:32] nope [21:38:42] You should add it! [21:39:18] and yeah, it was only once I isolated the part which select the properties used on the items from determining whether or not they're external ids that it stopped timing out [21:39:25] which seems a bit counterintuitive to me, but if it works... [21:39:32] Or I can do it, but credit where credit is due..... [21:39:49] feel free to, I don't mind :) [21:43:18] See https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples#Authority_control_properties_usage_for_paintings [21:43:18] I'm just happy to be able to help, I'm not really bothered about making sure everyone knows it was me [21:43:32] cool :) [21:43:42] oh, that was a different one [21:43:56] oh, the second one you mean [21:44:20] Yeah, we didn't have any properties showing off the ExternalId [21:44:39] And neither for wikibase:statements , so I added a couple [21:44:51] It's good to have examples for all features [21:44:55] * nikki nods [21:45:49] I think quite a few of the newer features are missing in the example queries [21:46:22] yeah, I've noticed that [21:46:39] I should make more effort to add examples when I come across them, but it usually happens when I'm in the middle of doing something [21:49:01] I just added some of them at the bottom to be sorted out [21:50:19] Thanks for the help nikki, time for bed