[03:17:27] PROBLEM - WDQS SPARQL on wdqs1013 is CRITICAL: CRITICAL - Socket timeout after 10 seconds https://wikitech.wikimedia.org/wiki/Wikidata_query_service/Runbook [03:24:47] RECOVERY - WDQS SPARQL on wdqs1013 is OK: HTTP OK: HTTP/1.1 200 OK - 689 bytes in 1.061 second response time https://wikitech.wikimedia.org/wiki/Wikidata_query_service/Runbook [08:33:22] Hi, small question: is it possible for an entity/item to have more than one P31 claim? I.e., can an item be an instance of more than one thing? [08:34:11] Sure [08:34:39] Ok good to know, thanks! [09:26:14] Hello, I am currently developing a tool to update Wikidata, but I would need data that need to be updated weekly, would anyone have an idea about this kind of data? It's mainly to test my code (under supervision) [10:27:30] What would be an efficient way that given a Wikidata item, you find all the relations between that item and other items? Basically, all triples (Item1, Property, Item2) in which your chosen item is either Item1 or Item2. You can do something like that with SPARQL, https://paste.debian.net/1193308/, but it gives a timeout error for any item that has [10:27:30] a non-trivial amount of relations. [12:04:21] [mattermost] sdesalcala: you can get all the incoming links like this: https://w.wiki/3BHB [12:04:40] [mattermost] or all the outgoing ones, by changing ?object to ?subject in line 4 [12:04:46] [mattermost] combining both into one query doesn’t seem to work for some reason [12:05:37] Thank you. Is this more efficient than the way I showed? [12:05:51] [mattermost] I would assume so? since it doesn’t time out ^^ [12:05:59] [mattermost] or maybe I misunderstood [12:07:57] [mattermost] hm, it does time out for Q183 [12:08:24] Yes, you're right, it doesn't time out. I guess what I meant to ask is why is this more efficient? Also, how come the labels are not shown? [12:08:45] [mattermost] the labels aren’t shown because I disabled (commented out) the label service [12:08:50] [mattermost] which is also part of why it’s more efficient [12:08:56] [mattermost] the label service is super expensive [12:09:20] [mattermost] here, this version still works for Q183 (1.2 million results), at the cost of only counting “best-rank” statements https://w.wiki/3BHE [12:10:03] [mattermost] but that kind of result size is completely out of the question with the label service [12:10:14] [mattermost] I think four-digit or five-digit results counts are more or less the limit of what you can get labels for [12:10:19] [mattermost] before it’s just an inevitable timeout [12:12:25] [mattermost] (I also removed the qualifier part, since it didn’t seem relevant to the main part of your question – I assumed you meant only main statement triples) [12:18:48] I see. If I also wanted to get the labels, I should just call the Wikibase API? [12:19:56] And also the property itself [12:28:06] [mattermost] probably better to get the labels from the API, yes [12:33:24] I see, thanks for the info!