[09:30:03] Hi, I have a question concerning a SPARQL query. I have read the basics on the wiki however this seemingly very basic thing appears not to be covered anywhere. I'm looking for a way to look up properties of objects and specify the objects using their item ids. [09:30:55] so for example I have a working query that lists all literary works from Douglas Adams with their label from the label service and the date of publication [09:30:56] https://query.wikidata.org/#SELECT%20%3Fitem%20%3FitemLabel%20%3Fdate%20WHERE%20%7B%0A%20%20%7B%20%3Fitem%20wdt%3AP31%20wd%3AQ7725634.%20%7D%0A%20%20%3Fitem%20wdt%3AP50%20wd%3AQ42%3B%0A%20%20%20%20wdt%3AP577%20%3Fdate.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%20%7D%0A%7D [09:31:52] how could I rewrite this giving the same table as results but instead of selecting by author, just select label and publication date from items wd:Q7739857, wd:Q7771858, wd:Q17110831 [09:39:32] I guess it could be done if there was a property "item id" so that I could write "?item wdt:P31 wd:Q7739857." but instead of P31 use the property for item id [09:56:55] sebkur: I constructed the following query based on the answer in https://stackoverflow.com/questions/30501124/or-in-a-sparql-query : [09:57:01] https://query.wikidata.org/#SELECT%20%3Fitem%20%3FitemLabel%20%3Fauthor%20%3Fdate%20WHERE%20%7B%0A%20%20VALUES%20%3Fitem%20%7Bwd%3AQ7739857%20wd%3AQ7771858%20wd%3AQ17110831%20%7D%0A%20%20%3Fitem%20wdt%3AP50%20%3Fauthor.%0A%20%20%3Fitem%20wdt%3AP577%20%3Fdate.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%20%7D%0A%7D [09:57:08] is that what you were looking for? [10:03:14] LotR: thanks, yes, that's exactly it [10:07:29] now that I know how it works, looking at the Wiki article about the SPARQL Query Service I think it is not explained there. Do you think it would make a good example? [10:07:43] worthwhile adding it? [10:10:45] that's a question that I think is better answered by someone who is more familiar with wikidata [12:39:38] hi, I'm having troubles uploading coordinates using Quickstatements, could anyone point me to a working example CSV file, please? [16:21:32] hi [16:22:06] is there a place where I can discuss weather an Item should be split into seperate items? [21:07:35] Hi Lizraya [21:09:21] Lizraya: do you actually want to query the coordinates which fall inside the German border, or is it enough to consider P17:Q183 and any P625? [21:09:53] Lets say the supervisor expect results next week which includes generating two training set with different criterias from wikidata data. [21:11:09] Don't you have any literature which suggests a method to use? For a bachelor thesis you wouldn't normally be expected to come up with novel method etc. [21:12:53] I would probably just do some simplistic query with jq to extract something reasonably useful... might take a day single threaded I think (?)