[06:35:58] <Amir1>	 Lydia_WMDE: Hey, around?
[11:46:09] <multichill>	 Or anti-vandalism measures really suck. How can an edit like https://www.wikidata.org/w/index.php?title=Q254&type=revision&diff=310125002&oldid=309328293 stay around for 2 full days!!
[11:48:07] <sjoerddebruin>	 6 recent watchlist users...
[11:51:17] <sjoerddebruin>	 this is still happening btw https://www.wikidata.org/wiki/Special:Contributions/2003:66:8F55:2828:FD25:C274:1CAE:732A
[12:15:19] <sjoerddebruin>	 So annoying that exact matches show up on almost the last search result page...
[12:18:07] <Amir1>	 multichill: this edit is reported in #wikidata-vandalism but no one checks there
[12:18:36] <Amir1>	 ORES scored it 95% which mean anti-vandalism measures  don't suck
[12:18:44] <Amir1>	 at least not as much as you think
[12:18:47] <Amir1>	 ;)
[12:18:58] <sjoerddebruin>	 lack of volunteers it is
[12:19:13] <Amir1>	 biggest problem right now is the interface 
[12:19:27] <Amir1>	 I implemented the ORES extension which make things much much easier
[12:19:54] <Amir1>	 I think volunteer work is more than enough *if* we have the extenson
[12:19:57] <Amir1>	 *extension
[12:20:07] <Amir1>	 but Ops are not working
[12:20:08] <sjoerddebruin>	 Wish we had stats about unpatrolled edits etc
[12:20:23] <Amir1>	 we are blocked on migrating ores service to prod for at least a month
[12:20:33] <Amir1>	 and no one doing what they are assigned to
[12:20:34] <sjoerddebruin>	 addshore: *cough* ^
[12:20:44] <sjoerddebruin>	 yikes Amir1 
[12:21:03] <Amir1>	 We need Ops people
[12:21:40] <Amir1>	 this is one of the blockers: https://phabricator.wikimedia.org/T125562
[12:22:01] <Amir1>	 honestly I'm frustrated
[12:25:38] <multichill>	 Amir1: Tools are probably good, it's all about process and communication
[12:26:03] <multichill>	 Say I want to look at edits by ip's that are possible vandalism and not checked yet by someone else. I have no idea where to look
[12:26:16] <Amir1>	 in the channel
[12:26:16] <multichill>	 At the Dutch Wikipedia I would just look at the unpatrolled edits
[12:26:38] <Amir1>	 multichill: check the channel
[12:26:39] <multichill>	 Channel reports here and now, not what is not checked on the 4th
[12:27:31] <Amir1>	 Yeah, it's not the best mean 
[12:27:39] <Amir1>	 the best mean would be the extension
[12:27:44] <Amir1>	 have you tested multichill ?
[12:28:07] <sjoerddebruin>	 wondering why https://www.wikidata.org/w/index.php?title=Q16943273&action=history isn't autopatrolled by a bot
[12:28:42] <multichill>	 https://nl.wikipedia.org/w/index.php?namespace=&tagfilter=Misbruikfilter%3A+Schuttingtaal&hideliu=1&hidepatrolled=1&title=Speciaal%3ARecenteWijzigingen
[12:29:09] <sjoerddebruin>	 yeah multichill, but the abusefilter extension doesn't work perfect with wikibase
[12:31:31] <multichill>	 Maybe a different extension or something, something I can just drop into and check some stuff
[12:32:10] <Amir1>	 mw-revscoring.wmflabs.org/wiki/Special:Preferences#mw-prefsection-betafeatures
[12:32:19] <Amir1>	 you can test the ORES extension here
[15:38:03] <physikerwelt_>	 Hi anyone around?
[15:38:08] <sjoerddebruin>	 hi physikerwelt_ 
[15:38:15] <HakanIST>	 hello physikerwelt_ 
[15:38:32] <physikerwelt_>	 I need someone to review https://gerrit.wikimedia.org/r/#/c/274166/
[15:40:01] <physikerwelt_>	 it looks quite bad in production see https://en.wikipedia.org/w/index.php?title=Help:Displaying_a_formula&oldid=708601342#Chemistry
[15:41:40] <sjoerddebruin>	 Sorry, I think someone with more experience with the code can handle that better than me
[15:42:33] <physikerwelt_>	 thank you anyhow
[15:43:46] <physikerwelt_>	 I'll look in the operations channel if I find someone
[15:44:38] <multichill>	 physikerwelt_: How does this relate to Wikidata? You might want to add some other reviewers, "Derk-Jan service interruption due to small skiing accident" ( http://status.wikimedia.org/ )
[15:48:00] <sjoerddebruin>	 yikes
[15:48:39] <physikerwelt_>	 it's not related to wikidata. TheDJ was added automatically as reviewer I filed a bug here https://phabricator.wikimedia.org/T129032
[15:49:31] <sjoerddebruin>	 Unbreak now? Well that's overrated.
[15:55:09] <multichill>	 Does anyone know if sitelinks are also in sparql?
[15:55:54] <matej_suchanek>	 multichill: yes, they are
[15:56:05] <matej_suchanek>	 search in examples how to query for them
[15:57:25] <sjoerddebruin>	 the wdq converter also supports them now btw
[15:57:40] <multichill>	 Just tried that, but it failed
[15:57:53] <multichill>	 How do I just get all items that have an link to nlwiki?
[15:58:51] <multichill>	 I'm actually looking for a fast sparql query to get all items from a site that don't have P31 OR P279
[15:59:03] <sjoerddebruin>	 I asked for that in project chat
[15:59:08] <sjoerddebruin>	 WDQS times out
[15:59:23] <multichill>	 The current solution with autolist is to get all items with P31 AND P279 (huge list) and use that in an intersection
[15:59:56] <multichill>	 I would rather get all nlwiki (2M) filtered with P31 and P279 with a result of about 30.000
[16:04:18] <matej_suchanek>	 try this: http://tinyurl.com/h8gc3nu
[16:10:05] <physikerwelt_>	 sjoerddebruin I would say it's somehow significant see https://en.wikipedia.org/wiki/Water
[16:10:32] <sjoerddebruin>	 yikes
[16:11:41] <multichill>	 matej_suchanek: Thank you, playing around with http://tinyurl.com/hffzfef now
[16:12:27] <multichill>	 Do you know if instead of "wdt:P31" I can make that "wdt:?" or something like that?
[16:12:39] <multichill>	 Item has someproperty
[16:13:04] <matej_suchanek>	 yes, wait a minute
[16:13:23] <matej_suchanek>	 try looking at PC for what sjoerddebruin mentioned
[16:14:05] <matej_suchanek>	 https://www.wikidata.org/wiki/Wikidata:Project_chat#SPARQL:_items_without_any_statements
[16:14:16] <matej_suchanek>	 but it times out
[16:15:01] <sjoerddebruin>	 Wish autolist2 sorted on creation date.
[16:17:03] <multichill>	 Yeah, . OPTIONAL { ?item ?prop ?dummy0 } FILTER(!bound(?dummy0)) times out
[16:17:57] <multichill>	 Would be nice if the page_props would be exposed in sparql
[16:18:45] <multichill>	 SMalyshev: Would that be possible? Including the page_props in sparql? The two that are of interest are the number of statements and the number of sitelinks.
[16:22:18] <hoo|busy>	 multichill: Not directly
[16:22:41] <hoo|busy>	 but it could be made part of our rdf exports
[16:28:11] <hoo|busy>	 multichill: It's probably best if you open a ticket about what you need and then we could add additional triples for that
[16:31:36] <hoo|busy>	 <http://www.wikidata.org/entity/Q1234> <http://wikiba.se/ontology-beta#somethingsomethingstatementcount> "1234"^^<http://www.w3.org/2001/XMLSchema#integer> .
[16:34:44] <multichill>	 Yeah! I found a query that completes :-D
[16:35:50] <sjoerddebruin>	 :O
[16:35:51] <sjoerddebruin>	 :O
[16:35:51] <sjoerddebruin>	 :O
[16:36:11] <multichill>	 Check out http://tinyurl.com/jll9bfd . You can raise the limit to 1 million and it still completes
[16:36:23] <multichill>	 AND in category NOT WDQS
[16:39:19] <multichill>	 https://tools.wmflabs.org/autolist/?language=nl&project=wikipedia&category=Motorfietstechniek&depth=0&wdq=&pagepile=&wdqs=SELECT%20%3Fitem%20%0AWHERE%0A%7B%0A%09%3Fsitelink%20schema%3Aabout%20%3Fitem%20.%20%3Fsitelink%20schema%3AinLanguage%20%22nl%22%20%0A%20%20%20%20.%20%7B%20%3Fitem%20wdt%3AP31%20%3Fp31%20%7D%20UNION%20%7B%20%3Fitem%20wdt%3AP279%20%3F279%20%7D%0A%7D%20LIMIT%201000000&statementli
[16:41:12] <multichill>	 sjoerddebruin:  
[16:41:38] <sjoerddebruin>	 Yeah, but I can't do that on all the site?
[16:42:09] <multichill>	 I guess nlwiki is small enough to just make it
[16:43:41] <multichill>	 hoo|busy: What is that? How am I supposed to read that?
[16:44:02] <hoo|busy>	 multichill: That's how I imagine the triple to look like
[16:44:08] <hoo|busy>	 for statement count
[16:44:11] <multichill>	 right
[16:44:39] <multichill>	 So we just have a trim for <item> <somenewtriple> <integer>?
[16:44:58] <multichill>	 So we just have a triple for <item> <somenewtriple> <integer>?
[16:46:07] <hoo|busy>	 Yeah, about that… but we would probably create something in the wikiba.se ontology for <somenewtriple>
[16:56:18] <multichill>	 Filed https://phabricator.wikimedia.org/T129037 hoo and subscribed you guys
[17:01:28] <hoo|busy>	 Thansk :)
[17:02:06] <nikki>	 I wish I could combine autolist and harvesttemplates...
[17:03:20] <nikki>	 I was looking at jawiki items with no statements the other day and there's a bunch of things like singles which would surely not be that hard to add a bunch of statements for, it's just figuring out a way to actually do it :/
[17:25:19] <Josve05a>	 What's wrong w/ WIkidatat now...
[17:25:22] <Josve05a>	 Wikidata*
[17:25:34] <Josve05a>	 https://www.wikidata.org/wiki/Q2688862 won't stop loading, and I can't add statememnts...
[17:26:06] <matej_suchanek>	 worksforme
[17:27:39] <Josve05a>	 hmm...did a purge, can no add statements (the edit links wasn't even there before for statements) but the pageis still "Loading" (the tab-loading-spinner is spinning...
[17:29:04] <nikki>	 that usually happens to me if some gadget or some script in my common.js is not loading
[17:29:28] <nikki>	 sometimes it happens in a tab and no amount of refreshing will make it work, but opening the same page in a new tab works fine. I can only imagine that's chromium being stupid
[17:29:59] <Josve05a>	 https://usercontent.irccloud-cdn.com/file/9Moz6Ivi/Untitled%20Screencast%20(1).webm
[17:30:01] <Josve05a>	 stupid javascript, if that's the case...
[17:31:04] <matej_suchanek>	 open console for its messages for you :)
[17:31:23] <HakanIST>	 is it possible to add more than 20mb to mix'n match with split files?
[17:31:26] <Josve05a>	 nothing special in the conole...
[17:32:04] <Josve05a>	 console*
[19:11:11] <multichill>	 Building image suggestions at https://www.wikidata.org/wiki/User:Multichill/Image_suggestions . Got quite a few matches (3128)
[19:22:59] <SMalyshev>	 multichill: page_props in wikidata or on other wikis?
[19:23:10] <multichill>	 Wikidata
[19:23:21] <multichill>	 see https://phabricator.wikimedia.org/T129037  SMalyshev
[21:53:11] <multichill>	 hoo|away: Do you know if there is a way to prefil a statement P123 -> Q456 in a url so user just has to press ok?
[21:55:28] <sjoerddebruin>	 feed the primary sources tool? :P
[21:58:14] <multichill>	 I could use quickstatements, but that is very unstable recently :-(
[21:59:40] <sjoerddebruin>	 maybe we need a special page to set statements
[21:59:45] <sjoerddebruin>	 with url parameters
[21:59:57] <multichill>	 sjoerddebruin: I want to have a direct link at https://www.wikidata.org/wiki/User:Multichill/Image_suggestions to click and it adds the image
[22:00:16] <multichill>	 I can do it with quickstatements, but would be more fun to have it on wikidata itself
[22:00:36] <multichill>	 Did you ever use https://commons.wikimedia.org/wiki/Template:Possible_Rijksmonument ?
[22:01:06] <sjoerddebruin>	 yeah
[22:02:10] <multichill>	 I want to have it as easy as that one
[22:51:34] <multichill>	 sjoerddebruin: Do you know if it's possible to open a link in MediaWIki in a new window?
[22:51:47] <multichill>	 Link the html A target="blank"
[22:51:50] <sjoerddebruin>	 links made with wikitext?
[22:52:42] <multichill>	 See https://www.wikidata.org/wiki/User:Multichill/Image_suggestions . The add link should open in a new window
[22:52:49] <multichill>	 Damn quick statements is down again
[22:58:31] <SMalyshev>	 multichill: not sure I see the link between page_props and T129037
[22:58:41] <sjoerddebruin>	 not possible multichill 
[22:59:09] <multichill>	 SMalyshev: Not that long ago page_props were introduced that contain the number of statements and the number of sitelinks
[22:59:51] <multichill>	 So the data is already there. It just needs to be exposed in the xml/rdf/whatever dump you're feeding the sparql engine.
[23:00:17] <SMalyshev>	 multichill: ah, I see. Is there any docs on current page_props in wikidata? Or any place where the list can be seen?
[23:01:27] <multichill>	 SMalyshev: connect wikidatawiki_p wikidatawiki.labsdb; SELECT DISTINCT(pp_propname) FROM page_props LIMIT 100;
[23:01:51] <multichill>	 In this case it's wb-claims and wb-sitelinks
[23:02:42] <SMalyshev>	 multichill: aha, I see. We can probably support it if there aren't too many.
[23:03:33] <multichill>	 Currently returns 19 row. I think only these 2 are of interest right now
[23:08:58] <SMalyshev>	 multichill: is there any definition for them? i.e. how do I know if wb-claims is string, number, URI or anything else?
[23:09:19] <SMalyshev>	 multichill: https://phabricator.wikimedia.org/T129046
[23:11:26] <multichill>	 SMalyshev: Great. I made https://phabricator.wikimedia.org/T129037 blocked by that one. For all the details you probably need hoo. 
[23:11:40] <SMalyshev>	 multichill: ok, i'll look into that
[23:11:44] <multichill>	 Or one of the other wikidata devs who know the details
[23:22:40] <hoo|away>	 multichill: FYI https://phabricator.wikimedia.org/T113168
[23:27:33] <multichill>	 hoo|busy: I now added a link to quickstatements at https://www.wikidata.org/wiki/User:Multichill/Image_suggestions . That works for now
[23:28:06] <hoo|busy>	 that works
[23:30:44] <SMalyshev>	 how "What links here" is updated on wikidata? I see tons of items in https://www.wikidata.org/wiki/Special:WhatLinksHere/Property:P627 but when I go to actual items, none of them has P627 as it seems
[23:31:57] <hoo|busy>	 SMalyshev: In a LinksUpdate job post edit/ purge with forcelinkupdate on the items
[23:32:20] <multichill>	 SMalyshev: Exactly how you would expect it. Probably used as reference so you won't see it in default view
[23:32:33] <hoo|busy>	 yeah
[23:32:48] <hoo|busy>	 checking a few random examples, I can grep for it in the json representation
[23:32:50] <SMalyshev>	 multichill: ahh, reference... that may explain it
[23:32:58] <multichill>	 Ah, reference for IUCN conservation status
[23:33:47] <SMalyshev>	 that's a bit weird usage... but OK, I can see it
[23:34:11] <multichill>	 pagelinks table contains every link on a page no matter how it's used
[23:34:54] <SMalyshev>	 yeah I know... I didn't think of references :)