[07:23:25] Wikidata is awesome [07:23:31] I really hope wikipedia keeps citeQ [07:23:40] It is so much better than not having it [07:27:32] extremely addictive though [07:28:47] maybe wrong place to ask, researchgate requires some affiliation to organizations to be allowed to register, luckily my employer is quite big and listed there, but I'm worried if I change jobs I won't have access anymore [07:29:09] is there any open organizations where I can join that would allow me access to researchgate ? [07:58:05] eidax00: why do you need ResearchGate? [07:58:23] you can get it as unaffiliated researcher nowadays [07:59:01] Nemo_bis, I could only get it when I used @work email [07:59:06] not with @gmail.com [07:59:18] Nemo_bis, to request access to articles that is not open [08:07:33] eidax00: you can also try https://openaccessbutton.org/ for that [08:17:17] thanks Nemo_bis, TIL [19:52:34] hi [19:52:46] I'm looking for some way to find all valid values for this property with SPARQL: https://www.wikidata.org/wiki/Q169872 [19:53:34] Hi, eidax00 :) [19:53:42] That's an Item, maybe you mean P780? [19:53:51] http://www.wikidata.org/entity/P780 [19:55:06] sorry yes, that is right abian, all valid values for P780 [19:55:16] I did this: https://w.wiki/8Qa [19:55:21] But it gives duplicates [19:55:26] and I'm not sure it is optimal way [19:55:31] I'm a noob at this you see [19:57:43] eidax00: You can use https://w.wiki/8Qf [19:58:27] Better with DISTINCT, https://w.wiki/8Qg [19:58:42] thanks abian, but it should not be just subclass, it can be instance of and subclass of [20:01:39] https://w.wiki/8Qi should work but times out, it's too expensive computationally [20:03:24] And now it works, impressive :/ [20:03:38] eidax00: Maybe you can try [20:03:41] caching [20:03:42] ;) [20:03:54] abian, thanks I will try [20:04:18] it works thanks [20:04:20] Reedy: Interesting :) [20:05:29] eidax00: Without SPARQL you can also check https://www.wikidata.org/w/index.php?title=Special%3AWhatLinksHere&limit=500&target=Q169872&namespace=0, but that will only show the direct subclasses/instances (and other things), not subclases of subclases [20:05:33] (and etc.) [20:21:31] will check, thanks abian [20:21:51] I want to use query in autocomplete for web app [21:12:05] abian, thanks very much for the help, I think last query you shared is best option [21:29:26] Why does https://w.wiki/8Qx not include discovery https://www.wikidata.org/wiki/Q54384 ? [21:32:38] you only check for instance of, not for subclass of [21:35:16] Discovery, instance of Space Shuttle orbiter, subclass of spaceplane, subclass of reusable launch system, subclass of spacecraft [21:36:30] I guess then I don't understand, if it is instance of space shuttle orbiter is it not also an instance of spacecraft ? [21:36:36] I guess query is wrong? [21:37:02] dunno if it will work with P31/P279 [21:38:43] this whole instance of / subclass of thing can become quite bad [21:39:19] I tried this also: ?item (wdt:P31*/wdt:P279) wd:Q40218 [21:39:22] still no discovery [21:40:17] This works though: ?item (wdt:P31*/wdt:P279*) wd:Q40218 [21:40:57] But it also includes things which are not actually instances space shuttle orbiter Q1064394 [21:43:23] yep, it will include all subclasses aswell. [21:44:53] you should remove the first *, i think [21:46:54] https://www.wikidata.org/wiki/Wikidata:SPARQL_tutorial#Instances_and_classes [21:48:07] ah [21:48:11] great thank you [21:49:01] yw [21:51:12] SPARQL queries are powerful, but can get very complicated [21:52:16] yeah need to get better feel for them [21:52:20] still really green at it [21:52:27] I really love wikidata though [21:52:32] favourite project ever [21:54:09] well, it can get messy