[15:01:01] Technical Advice IRC meeting starting in 60 minutes in channel #wikimedia-tech, hosts: @CFisch_WMDE - all questions welcome, more infos: https://www.mediawiki.org/wiki/Technical_Advice_IRC_Meeting [15:51:50] Technical Advice IRC meeting starting in 10 minutes in channel #wikimedia-tech, hosts: @CFisch_WMDE & @chiborg - all questions welcome, more infos: https://www.mediawiki.org/wiki/Technical_Advice_IRC_Meeting [16:37:27] There's resources I can see on the website wikidata.org, but can't be found when queried through query.wikidata.org. I'm trying the simples possible query from a tutorial, although I think I understand more. [16:38:44] This is a query that works: http://tinyurl.com/y7nfsgek [16:39:10] the relation P31 is "instance of". [16:39:21] now, this is a query that doesn't work http://tinyurl.com/y9gymwfs [16:39:55] even though the show has a page on wikidata.org and the tooltip even recognizes object Q4380 and gives me the human name. [16:41:00] I must be missing something very small. [16:43:03] also: when I remove the SERVICE clause and remove ?countryLabel from SELECT, it identically works for Q458 and fails for Q4380. [16:54:30] syntaxfree: your query is looking for other items which are marked as instances of Q458/Q4380, we don't have any items which are instances of the show so it doesn't find anything [16:56:09] but this exists: https://www.wikidata.org/wiki/Q4380 [16:56:17] and it has an instance-of. [16:57:02] if you use "wd:Q4380 wdt:P31 ?instanceof" it will find the statements on that item [16:58:41] well, ?country P31 Q458 returns the value of "instance of" for Q458. Why is it different for Q4380? [16:58:52] it doesn't though [16:59:19] I mean ?country wdt:P31 wd:Q458 [16:59:46] https://www.wikidata.org/wiki/Q4649662 has a P31 Q458 statement [17:00:53] you could do something like "?show wd:P31 wd:Q5398426" (find items which have instance of tv series) and that would find the show you linked [17:01:06] err, I meant "wdt:P31" in there [17:02:22] (it would also find a lot of other things though, I assume we have a lot of tv series) [17:02:46] that returns (I used a LIMIT 50) a lot of TV shows. [17:03:49] hmm. because that's "stuff that is linked to Q5398426 through property P31" [17:04:15] because in the original example Q458 isn't a country. So the query adaptation doesn't hold. [17:05:53] I thought using P31 simplified my problem. What I was originally wanting to explore was the cast (P161) of that show. [17:06:43] so analogous to "?show wdt:P31 wd:Q5398426" should be "?country wdt:P161 wd:4380" [17:07:23] but still no dice. I should get a list of things that are related to Q4380 through property P161 [17:08:11] P161 is used on the show itself to link to the people, so you need it the other way round (wd:Q4380 wdt:P161 ?country) [17:08:58] because the show isn't in the cast of any actors. cast is the other way around. [17:10:14] which works. [17:10:20] relations in wikidata are signed. [17:10:38] I have this whole mental model from formal concept analysis where incidence relations are binary. [17:10:48] but of course cast-of is a signed relation. [17:11:34] holy mingus. [17:11:41] do I owe you any money? that really helped. [17:12:15] no :) [17:12:22] I'm glad I could help you figure it out [23:11:39] I'm getting an error when trying to use {{Complex constraint}} on P39. the query works through the web interface without errors. any ideas what could be going wrong? [23:11:40] 10[1] 10https://www.wikidata.org/wiki/Template:Complex_constraint