[14:20:57] Anyone know how to do queries with unknown values? [14:21:02] Or novalue? [14:22:28] multichill: I did one, once [14:22:42] I'll try to find it again [14:22:45] multichill: for novalue, ?item a wdno:P1234 [14:22:49] P1234 Masterwork From Distant Lands - https://phabricator.wikimedia.org/P1234 [14:23:02] nikki: does that work? when types are omitted on WDQS? [14:23:25] "types are omitted"? [14:23:35] https://www.mediawiki.org/wiki/Wikibase/Indexing/RDF_Dump_Format#WDQS_data_differences, point 2 [14:23:44] but perhaps I’m misreading it, and only a few special types are omitted [14:24:27] unless it changed recently [14:24:37] I can find them in sparql [14:25:35] https://www.wikidata.org/wiki/Q945625 has novalue for P195, can see it at http://tinyurl.com/jvxtfb2 [14:25:36] P195 webconsole log from viewing https://www.mediawiki.org/wiki/Talk:Sandbox - https://phabricator.wikimedia.org/P195 [14:25:38] for unknown values, I seem to remember that they work similar to normal values but return weird values like "t" followed a load of numbers... I don't know much about those [14:26:26] So " p:novalue/P195" is in there [14:26:28] multichill: yes, you can find them in a query but I don't know if you can filter to have only them [14:26:56] I could filter on the owl:class thing [14:27:10] good idea [14:27:50] Feels a bit hackish [14:30:20] the "a wdno" thing does seem to still work: http://tinyurl.com/gnn75v2 [14:31:24] wdno? [14:31:34] Ok, where the hell is that documented? :P [14:31:43] https://www.mediawiki.org/wiki/Wikibase/Indexing/RDF_Dump_Format#Novalue [14:32:57] just above that it talks about unknown values but I don't understand it [14:33:29] would probably be good to put example queries on https://www.mediawiki.org/wiki/Wikibase/Indexing/SPARQL_Query_Examples too… especially for unknown value [14:35:22] https://www.wikidata.org/w/index.php?title=User%3AMultichill%2FSOAP_allwiki_monitor&type=revision&diff=363942025&oldid=363060459 was the trick I was looking for [14:36:57] WikidataFacts: Maybe a good example query is destroyed paintings? These have collection and location set to novalue [14:37:09] multichill: ooh, that sounds very interesting [14:37:19] (and sad :( ) [14:37:36] so many sad queries [14:39:04] I'll add the example [14:39:16] http://tinyurl.com/jg63j57 [14:39:25] like this? [14:39:35] (only two results for no collection *and* location, so I went for either or instead) [14:41:36] Sure, that looks good. [14:41:46] Maybe a bit more comments [14:42:20] oh, a lot of them have images actually [14:43:38] multichill: http://tinyurl.com/h6vhzlt [14:45:15] some interesting results – https://www.wikidata.org/wiki/Q15428759 is a painting that was lost but then found recently [14:48:02] WikidataFacts: So location isn't unkown. Worse case that should be Q2 [14:48:18] :D [14:48:34] the location was unknown with start and end dates [14:48:38] the exact location is probably unknown until the legal fineries are sorted out [14:49:05] Harmonia_Amanda: are qualifiers possible on unknown value? if yes, how do you retrieve them with SPARQL? [14:49:06] We know for sure that the unknown location is somewhere on earth [14:49:17] WikidataFacts: yes qualifiers are possible [14:49:23] if unknown value is only a class of the item, I don’t see where they would be attached [14:50:55] Harmonia_Amanda: But I guess that is a bit of a philosophical discussion. I rather have somevalue than unknown [15:22:22] Funny, Google still uses the Freebase id's, see for example https://www.google.com/culturalinstitute/beta/entity/m02w7_ts [15:22:56] dennyvrandecic: Freebase id's are very broken. Any idea where to point them or is it just time to get rid of them? [20:50:48] JEM + ASIMOVBOT = AMOR [20:50:49] JEM + ASIMOVBOT = AMOR [20:50:50] JEM + ASIMOVBOT = AMOR [20:50:51] JEM + ASIMOVBOT = AMOR [20:50:52] JEM + ASIMOVBOT = AMOR [20:50:53] JEM + ASIMOVBOT = AMOR [20:50:54] JEM + ASIMOVBOT = AMOR [20:50:55] JEM + ASIMOVBOT = AMOR [20:50:57] JEM + ASIMOVBOT = AMOR [20:50:58] JEM + ASIMOVBOT = AMOR [20:50:59] JEM + ASIMOVBOT = AMOR [20:51:08] JEM + ASIMOVBOT = AMOR [20:51:09] JEM + ASIMOVBOT = AMOR [20:51:10] JEM + ASIMOVBOT = AMOR [20:51:11] JEM + ASIMOVBOT = AMOR [20:51:12] JEM + ASIMOVBOT = AMOR [20:51:13] JEM + ASIMOVBOT = AMOR [20:51:14] JEM + ASIMOVBOT = AMOR [20:51:15] JEM + ASIMOVBOT = AMOR [20:51:17] JEM + ASIMOVBOT = AMOR [20:51:18] JEM + ASIMOVBOT = AMOR [20:51:19] JEM + ASIMOVBOT = AMOR [20:51:20] JEM + ASIMOVBOT = AMOR [20:51:21] JEM + ASIMOVBOT = AMOR [20:51:22] JEM + ASIMOVBOT = AMOR [20:51:23] JEM + ASIMOVBOT = AMOR [20:51:24] JEM + ASIMOVBOT = AMOR [20:51:25] JEM + ASIMOVBOT = AMOR [20:51:26] JEM + ASIMOVBOT = AMOR [20:51:27] JEM + ASIMOVBOT = AMOR [20:51:28] JEM + ASIMOVBOT = AMOR [20:51:29] JEM + ASIMOVBOT = AMOR [20:51:30] JEM + ASIMOVBOT = AMOR [20:51:31] JEM + ASIMOVBOT = AMOR [20:51:32] JEM + ASIMOVBOT = AMOR [20:51:33] JEM + ASIMOVBOT = AMOR [20:51:34] JEM + ASIMOVBOT = AMOR [20:51:35] !ops HansTopo1993 [20:51:37] JEM + ASIMOVBOT = AMOR [20:51:39] JEM + ASIMOVBOT = AMOR [20:51:40] JEM + ASIMOVBOT = AMOR [20:51:41] JEM + ASIMOVBOT = AMOR [20:51:43] JEM + ASIMOVBOT = AMOR [20:51:44] JEM + ASIMOVBOT = AMOR [20:51:46] JEM + ASIMOVBOT = AMOR [20:51:47] JEM + ASIMOVBOT = AMOR [20:51:48] JEM + ASIMOVBOT = AMOR [20:51:49] JEM + ASIMOVBOT = AMOR [20:51:51] JEM + ASIMOVBOT = AMOR [20:51:52] JEM + ASIMOVBOT = AMOR [20:51:53] JEM + ASIMOVBOT = AMOR [20:51:55] JEM + ASIMOVBOT = AMOR [20:51:57] JEM + ASIMOVBOT = AMOR [20:51:58] JEM + ASIMOVBOT = AMOR [20:51:59] JEM + ASIMOVBOT = AMOR [20:52:00] JEM + ASIMOVBOT = AMOR [20:52:01] JEM + ASIMOVBOT = AMOR [20:52:03] JEM + ASIMOVBOT = AMOR [20:52:04] JEM + ASIMOVBOT = AMOR [20:52:06] JEM + ASIMOVBOT = AMOR [20:52:07] JEM + ASIMOVBOT = AMOR [20:52:08] JEM + ASIMOVBOT = AMOR [20:52:10] JEM + ASIMOVBOT = AMOR [20:52:10] JEM + ASIMOVBOT = AMOR [20:52:14] JEM + ASIMOVBOT = AMOR [20:52:15] JEM + ASIMOVBOT = AMOR [20:52:16] JEM + ASIMOVBOT = AMOR [20:52:17] JEM + ASIMOVBOT = AMOR [20:52:22] JEM + ASIMOVBOT = AMOR [20:52:45] JEM + ASIMOVBOT = AMOR [20:52:47] JEM + ASIMOVBOT = AMOR [20:52:48] JEM + ASIMOVBOT = AMOR [20:52:49] JEM + ASIMOVBOT = AMOR [20:52:50] JEM + ASIMOVBOT = AMOR [20:52:51] JEM + ASIMOVBOT = AMOR [20:52:52] JEM + ASIMOVBOT = AMOR [20:52:53] JEM + ASIMOVBOT = AMOR [20:52:54] JEM + ASIMOVBOT = AMOR [20:52:56] JEM + ASIMOVBOT = AMOR [20:53:04] JEM + ASIMOVBOT = AMOR [20:53:05] JEM + ASIMOVBOT = AMOR [20:53:05] JEM + ASIMOVBOT = AMOR [20:53:05] JEM + ASIMOVBOT = AMOR [20:53:05] JEM + ASIMOVBOT = AMOR [20:53:05] JEM + ASIMOVBOT = AMOR [20:53:05] JEM + ASIMOVBOT = AMOR [20:53:06] JEM + ASIMOVBOT = AMOR [20:53:08] JEM + ASIMOVBOT = AMOR [20:53:09] JEM + ASIMOVBOT = AMOR [20:53:10] JEM + ASIMOVBOT = AMOR [20:53:11] JEM + ASIMOVBOT = AMOR [20:53:13] JEM + ASIMOVBOT = AMOR [20:53:15] JEM + ASIMOVBOT = AMOR [20:53:16] JEM + ASIMOVBOT = AMOR [20:53:17] JEM + ASIMOVBOT = AMOR [20:53:19] JEM + ASIMOVBOT = AMOR [20:53:19] JEM + ASIMOVBOT = AMOR [20:53:20] JEM + ASIMOVBOT = AMOR [20:53:21] JEM + ASIMOVBOT = AMOR [20:53:22] JEM + ASIMOVBOT = AMOR [20:53:23] JEM + ASIMOVBOT = AMOR [20:53:25] JEM + ASIMOVBOT = AMOR [20:53:26] JEM + ASIMOVBOT = AMOR [20:53:27] JEM + ASIMOVBOT = AMOR [20:53:28] JEM + ASIMOVBOT = AMOR [20:53:29] JEM + ASIMOVBOT = AMOR [20:53:30] JEM + ASIMOVBOT = AMOR [20:53:31] JEM + ASIMOVBOT = AMOR [20:53:40] JEM + ASIMOVBOT = AMOR [20:53:41] JEM + ASIMOVBOT = AMOR [20:53:42] JEM + ASIMOVBOT = AMOR [21:43:53] seriously, who is that kid ? and what does he hope to accomplish ? :/ [21:44:19] are there any rival databases? (perhaps someone who hasn’t accepted Freebase’s end?) [21:44:35] JEM + ASIMOVBOT = AMOR [21:44:35] JEM + ASIMOVBOT = AMOR [21:44:35] JEM + ASIMOVBOT = AMOR [21:44:36] JEM + ASIMOVBOT = AMOR [21:44:37] JEM + ASIMOVBOT = AMOR [21:44:38] JEM + ASIMOVBOT = AMOR [21:44:39] JEM + ASIMOVBOT = AMOR [21:44:40] JEM + ASIMOVBOT = AMOR [21:44:40] JEM + ASIMOVBOT = AMOR [21:44:41] JEM + ASIMOVBOT = AMOR [21:44:42] !ops HansTopo1993 [21:44:42] JEM + ASIMOVBOT = AMOR [21:44:43] JEM + ASIMOVBOT = AMOR [21:44:44] JEM + ASIMOVBOT = AMOR [21:44:45] JEM + ASIMOVBOT = AMOR [21:44:46] JEM + ASIMOVBOT = AMOR [21:44:47] JEM + ASIMOVBOT = AMOR [21:44:49] JEM + ASIMOVBOT = AMOR [21:44:59] JEM + ASIMOVBOT = AMOR [21:44:59] JEM + ASIMOVBOT = AMOR [21:45:00] JEM + ASIMOVBOT = AMOR [21:45:00] JEM + ASIMOVBOT = AMOR [21:45:01] JEM + ASIMOVBOT = AMOR [21:45:02] JEM + ASIMOVBOT = AMOR [21:45:03] JEM + ASIMOVBOT = AMOR [21:45:05] JEM + ASIMOVBOT = AMOR [21:45:06] JEM + ASIMOVBOT = AMOR [21:45:07] JEM + ASIMOVBOT = AMOR [21:45:08] JEM + ASIMOVBOT = AMOR [21:45:09] JEM + ASIMOVBOT = AMOR [21:45:12] if i may suggest /mode #wikidata +b *!~rolodata@* [21:45:18] JEM + ASIMOVBOT = AMOR [21:45:30] thanks :) [21:45:31] Sorry, I'm on webchat. :( [21:45:36] no prob ^^ [21:46:31] next time, just +q his ident, and we're golden [21:46:50] don't forget to kick him first so he doesn't notice :p [21:47:11] and don't forget to deop so you don't get bothered yourself :D [21:47:30] Yeah, I don't use the buttons very often anymore. [21:49:26] i'm the kind of guy who always knows what buttons to push to get someone off (a channel) [21:51:30] Mostly use the GUI of my client. :P [21:52:14] Alphos: I'm the kind of girl who can't remember that to save her life >< [21:52:33] Harmonia_Amanda even if it's not "(a channel)" ? :D [21:52:46] Alphos: XD [21:52:53] * Alphos has files on EVERYBODY ! [21:53:07] I'm probably still tired, I didn't even see your innuendo [21:53:13] ^^ [21:53:13] even with the () [21:53:26] innuendos are the best kind of double-entendre [21:54:59] innuendos are your preferred mode of communication :p [21:55:34] how dare you ?! i can be straightforward if i want to ! [21:55:55] granted, it's usually so people understand the subtext of my previous innuendos, but still ! [21:56:11] (case in point :D ) [21:56:19] Alphos: "voulez-vous coucher avec moi ce soir ?" [21:56:21] :p [21:56:40] kitchy kitchy yaya da da [21:56:59] ^^ [21:57:25] creepy factor 800 : didn't know that song, the father of an american penpal i was exchanging with taught it to me when i was 10 [21:57:51] uh [21:57:51] (didn't go any further though >_> ) [21:57:59] still creepy [21:58:04] still is, innit ? [21:58:46] granted, i didn't know what the song meant, and i wasn't sleepy at the time, so i just thought the guy was weird, but now that i know, creeeepeeee