[00:08:41] <Theredproject>	 hrm... no response in 25m. I have posted the details here: https://www.wikidata.org/wiki/User_talk:Theredproject if anyone knows, please respond there. KTHXBYE
[10:29:24] <sjoerddebruin>	 https://grafana.wikimedia.org/dashboard/db/wikidata-datamodel-statements?refresh=30m&panelId=4&fullscreen&orgId=1 :(
[10:44:10] <WikidataFacts>	 that import’s still going on, then? https://grafana.wikimedia.org/dashboard/db/wikidata-datamodel
[10:44:38] <WikidataFacts>	 that sudden curve upwards in all the charts…
[10:49:47] <nikki>	 it seems like multiple people have been mass adding items
[10:50:18] <nikki>	 I was worried it might be the wiktionary stuff but last I checked that was only about 20,000 items so far
[10:50:56] <WikidataFacts>	 I thought this was the Cebuano Wikipedia import
[10:51:02] <WikidataFacts>	 which apparently has loads of auto-generated articles
[10:51:23] <sjoerddebruin>	 It's hitting the dispatch now, see project chat.
[10:51:30] <nikki>	 lydia mentioned gzwder too on https://www.wikidata.org/wiki/Wikidata:Project_chat#Q32000000
[10:51:49] <sjoerddebruin>	 Not the first time he's mentioned in connection with that afaik
[16:38:48] <multichill>	 Lydia_WMDE: https://www.wikidata.org/w/index.php?title=Special:Contributions/GZWDer_(flood)&offset=&limit=500&target=GZWDer+%28flood%29 seems to be rapidly creating items and dispatch lag keeps going up
[16:40:21] <multichill>	 This user has been warned and blocked before for causing technical problems because of him editing too fast. 
[16:44:46] <sjoerddebruin>	 multichill: see project chat too
[16:44:56] <sjoerddebruin>	 Lydia already complained over there.
[16:46:32] <MisterSynergy>	 link to this discussion: https://www.wikidata.org/wiki/Wikidata:Project_chat#Punta_Barrica_.28Q32000000.29
[16:46:59] <multichill>	 Yeah, I just read that
[16:47:20] <MisterSynergy>	 do you think it is okay how fast this bot operates?
[16:47:42] <MisterSynergy>	 Right now I don't fully understand this hack which I found in the code
[16:48:57] <multichill>	 No, blocked it
[16:49:42] <sjoerddebruin>	 this is also why we shouldn't have large backlogs...
[16:50:08] <sjoerddebruin>	 Just look at this. https://grafana.wikimedia.org/dashboard/db/wikidata-datamodel-statements?refresh=30m&panelId=3&fullscreen&orgId=1
[16:50:13] <sjoerddebruin>	 (select WM_Category for example)
[16:50:36] <sjoerddebruin>	  ‎GZWDer is adding zero statements though.
[16:50:54] <multichill>	 He is adding statements
[16:51:24] <sjoerddebruin>	 Yeah, for the categories.
[16:51:27] <sjoerddebruin>	 For the rest?
[16:52:32] <MisterSynergy>	 by far not for all items
[16:55:32] <multichill>	 Funny, he got warned and blocked exactly one year ago for doing the same thing.....
[16:55:45] <sjoerddebruin>	 Vacation?
[17:16:32] <sjoerddebruin>	 This still makes me happy. https://www.wikidata.org/w/index.php?title=Q29020951&type=revision&diff=516865060&oldid=491237865
[17:20:30] <nikki>	 it seems like he gets blocked every year for something related to mass creating items...
[17:20:45] <nikki>	 I'm not sure where last year's block was, since it's not in our log, but there's blocks from 2015 and 2014
[17:21:49] <MisterSynergy>	 I was wondering about that as well
[17:23:17] <MisterSynergy>	 mh, but there is this: https://www.wikidata.org/wiki/User_talk:GZWDer#GZWDer_.28flood.29
[17:25:24] <sjoerddebruin>	 Hey, I know that guy.
[17:29:24] <sjoerddebruin>	 It's Sunday, you shouldn't be working Lucas.
[17:29:59] <WikidataFacts>	 oops, did I join IRC? I just quickly un-standbied the laptop
[17:30:10] <WikidataFacts>	 (un-stood by?)
[17:30:20] <sjoerddebruin>	 :P
[17:50:11] <nikki>	 sjoerddebruin: are edits like https://www.wikidata.org/w/index.php?title=Q26269877&diff=436684651 right?
[17:53:11] <mbch331>	 If there's no Dutch title, then the edit is correct. If it were the description, the edit would be incorrect as the description needs to be in Dutch. English labels aren't a problem if no Dutch alternative is available.
[17:56:45] <nikki>	 ok
[18:00:28] <nikki>	 there are a surprising number of labels with random cyrillic characters...
[18:04:52] <sjoerddebruin>	 I've found a example for Siri to see how long it takes Apple to update their use of Wikidata.
[18:05:20] <nikki>	 I get that they look the same but I'm not sure how anyone manages to accidentally change one letter in the middle of a word to another script
[18:05:22] <nikki>	 sjoerddebruin: oh?
[18:05:34] <sjoerddebruin>	 Yeah, I know for sure they use Wikidata now.
[18:05:44] <sjoerddebruin>	 They even follow our property names.
[18:33:02] <pintoch>	 sjoerddebruin: that's very interesting! I'd love to have more details about that :)
[18:33:24] <sjoerddebruin>	 pintoch: someone noticed on the mailing list.
[18:33:42] <sjoerddebruin>	 Take someone with a lot of family members,  for example.
[18:33:52] <pintoch>	 oh yeah, I had not noticed that thread
[18:34:03] <pintoch>	 I don't have Siri so I cannot experiment myself :)
[18:34:15] <sjoerddebruin>	 hi abian <3
[18:36:03] <WikidataFacts>	 sjoerddebruin: did you find out what the delay is? do they use the live data?
[18:36:48] <sjoerddebruin>	 WikidataFacts: well, there was a issue with content caching two weeks ago where a racist text was there for several days. Wonder if it is the same for data.
[18:40:25] <abian>	 sjoerddebruin! <3
[18:44:58] <abian>	 I'm making a fan of Muse (still in initial stages) :)
[18:48:26] <sjoerddebruin>	 Good good. :P
[20:53:49] <nikki>	 WikidataFacts: are you around? I need help :P
[20:54:01] <WikidataFacts>	 nikki: yes?
[20:54:16] <nikki>	 I was responding to https://www.wikidata.org/wiki/Wikidata:Request_a_query#Get_sitelinks_for_list_of_items and I have three queries which all produce different numbers of results
[20:55:02] <WikidataFacts>	 slightly different or very different?
[20:55:07] <nikki>	 http://tinyurl.com/yc6pdke5 gives me 374, http://tinyurl.com/yb3y6bbk gives me 410 and http://tinyurl.com/ybsw2qtv gives me 316 and I don't know why I get different numbers
[20:55:15] <WikidataFacts>	 hm
[20:55:23] <WikidataFacts>	 that doesn’t sound like different WDQS servers being slightly out of sync
[20:55:33] <nikki>	 that's what I thought
[20:56:02] <nikki>	 but I'm not sure what would make the queries produce different results, that's why I'm hoping you can spot the problem :)
[20:58:17] <WikidataFacts>	 hm, #2 has much more results without sitelink than #1 and #3
[21:01:05] <WikidataFacts>	 #2 always includes a result without sitelink
[21:01:43] <WikidataFacts>	 and I assume the intended semantics were to only have such a result if the item has no sitelinks
[21:04:02] <WikidataFacts>	 and #1 and #3 have the same number of results (367) if you fix the label service by adding all the variables except ?sitelink to the subquery SELECT clause
[21:04:56] <WikidataFacts>	 (#1' = http://tinyurl.com/yb8v7sjn, #3' = http://tinyurl.com/y8q4qts6)
[21:07:08] <nikki>	 hm, moving the values ?lang bit inside the optional section makes it go from 410 to 316, I guess that's because some ?lang values have a sitelink and some don't
[21:10:10] <nikki>	 hm... and I guess the other thing is probably some people having multiple citizenships, which get collapsed into a single row when I accidentally break the label service
[21:10:15] <nikki>	 thanks :D
[21:10:32] <WikidataFacts>	 ah, ?citizenship wasn’t selected
[21:10:36] <WikidataFacts>	 yeah, that’d do it :)
[21:11:10] <WikidataFacts>	 (I was about to write “or multiple birthplaces or deathplaces” but, no, that’s stupid :D )
[21:18:18] <nikki>	 I'm not sure whether you meant because that wouldn't get collapsed into a single row or because it would be odd to have multiple, but now I'm thinking of ways to have multiple :P
[21:18:29] <WikidataFacts>	 just because it would be odd
[21:18:38] <WikidataFacts>	 I’m sure there’s a couple of items, where it’s disputed or whatever
[21:18:48] <nikki>	 like what if someone lies down on the border between two countries to give birth?
[21:19:17] <nikki>	 or is declared dead, but the doctors then manage to revive them?
[21:19:26] <WikidataFacts>	 oh! I *like* that
[21:19:39] <WikidataFacts>	 like, IIRC Harry Potter has two date of death statements
[21:20:06] <WikidataFacts>	 aw, not any more :(
[21:21:34] <nikki>	 (even better, one of these dreiländereck places)
[21:21:52] <WikidataFacts>	 https://www.wikidata.org/wiki/Q706445
[21:22:28] <WikidataFacts>	 town, province, *and* country all entered as place of birth
[21:22:46] <nikki>	 and the town is in a different province to the province listed
[21:22:52] <WikidataFacts>	 yeah…
[21:23:20] <WikidataFacts>	 hm, the next example I found is similar, also with Ontario and Canada
[21:24:10] <WikidataFacts>	 four statements: https://www.wikidata.org/wiki/Q3290670
[21:24:34] <WikidataFacts>	 and I’m pretty sure this one’s incorrect, Chavannes-les-Forts wasn’t part of Siviriez until 2004 according to dewiki
[21:25:41] <WikidataFacts>	 jesus, 6 statements https://www.wikidata.org/wiki/Q15140007
[21:27:14] <nikki>	 >_<
[22:00:46] <Josve05a>	 Lydia_WMDE: How will the planned structured data for Commons handle cases such as https://commons.wikimedia.org/wiki/File:Morevna_Project_-_Pepper%26Carrot_(animated_comic)_-_Episode_6_-_The_Potion_Contest.webm ?
[22:05:00] <nikki>	 what exactly makes it complicated?
[22:05:46] <WikidataFacts>	 wait, there are animated pepper&carrors?
[22:46:47] <YairRand>	 Anyone know if there's a way to have the results of a Wikidata query shown directly on a page? {{Wikidata list}} only seems to work for when there's one column of wikidata items with no duplicates.
[22:46:47] <AsimovBot>	 10[3] 10https://www.wikidata.org/wiki/Template:Wikidata_list
[22:55:45] <nikki>	 I'm not aware of anything other than listeria
[22:56:05] <nikki>	 and if you find something, I'd be interested in knowing about it too :)