[06:44:34] * reosarevok sighs at timeouts
[06:53:24] <reosarevok>	 nikki: around?
[07:17:59] <reosarevok>	 Or can anyone else suggest how to get a query like "cities with the most sitelinks but no Estonian sitelink ordered by sitelinks" not to time out?
[07:19:31] <reosarevok>	 (wanted to show it as part of a short "how can Wikidata be good for you Wikipedians" in the Estonian wiki summer days, but I can't get it not to time out, sigh)
[07:49:59] <nikki>	 reosarevok: now I am :P
[07:57:43] <nikki>	 reosarevok: something like http://tinyurl.com/y755gquq? (with the caveat that wikibase:sitelinks is not always accurate)
[08:09:43] <reosarevok>	 nikki: thanks! What about getting enlabel as well? Any way of doing *that* without a time out? :p
[08:12:01] <nikki>	 http://tinyurl.com/yckrwxyn doesn't time out for me (16 s when not cached), http://tinyurl.com/y9rww7dr is faster (10 s not cached)
[08:12:37] <nikki>	 hm. not sure why they have different results though
[08:12:52] <nikki>	 oh
[08:12:57] <nikki>	 because I moved the order by, duh
[08:13:08] <reosarevok>	 So which is good? :D
[08:13:58] <nikki>	 the second is wrong, should be http://tinyurl.com/y9v5l6ay (which is even faster, just under 9 s :P)
[08:14:18] <reosarevok>	 Thanks nikki !
[08:14:22] <nikki>	 :)
[09:25:07] <davidwbarratt>	 how many properties are there (rough estimate?)
[09:26:14] <pintoch>	 ~5000
[09:26:22] <davidwbarratt>	 sheesh, ok, thanks
[09:40:00] <nikki>	 almost 3000 of them are external ids... there are a lot of other websites and datasets out there :)
[09:40:49] <nikki>	 (query for that: http://tinyurl.com/ycql4u3j)
[09:45:53] <davidwbarratt>	 well that's interesting
[09:50:30] <davidwbarratt>	 Tpt[m] are you at wikimania? 
[09:59:14] <addshore>	 James_F: https://phabricator.wikimedia.org/T145932
[09:59:24] <James_F>	 Ta.
[10:02:03] <frickel>	 is there a bot that removes duplicated aliases?
[10:04:20] <nikki>	 I think so
[10:20:35] <nikki>	 plbot was doing it (e.g. https://www.wikidata.org/w/index.php?diff=571486310) but I don't know if it still is... probably, but I don't see any recent edits
[10:26:56] <frickel>	 ic
[11:00:49] <rosco_y>	  *newbie alert*: I'd like to learn wiki syntax using personal wiki software on my windows 10, that is easy to setup and run.  Can anyone recommend software for me?
[11:24:04] <nikki>	 frickel: I coincidentally just noticed another bot which has done it in the past - https://www.wikidata.org/w/index.php?diff=335751690
[14:42:04] <amz3>	 long time no see
[14:42:28] <amz3>	 what is the rdf sparql semweb channel?
[14:57:22] <davidwbarratt>	 is there a reason a property like this needs to have the word "film" in it? https://www.wikidata.org/wiki/Q496523
[15:02:14] <hoo>	 davidwbarratt: This is an item… and it is clearly linked to films (subclass/ instance of) also the referred Wikipedia articles are specifically about movies
[15:03:26] <hoo>	 It would make sense to somehow associate that item with heist as a general concept (although offhand I'm not sure how that would look like)
[15:04:05] <davidwbarratt>	 interesting, yeah I just noticed that the film genre's... most of them (but not all) have the world "film" after it
[15:04:59] <davidwbarratt>	 which probably makes sense for the wiki, but it's a little hard to use when you're just looking for a list of the genres
[15:05:33] <davidwbarratt>	 here's an example: https://www.wikidata.org/wiki/Q25188
[15:09:06] <davidwbarratt>	 I mean what's the difference between an adventure film and an adventure book (as a concept)? https://www.wikidata.org/wiki/Property:P136
[15:43:19] <pintoch>	 it seems fairly natural to me to have distinct genres for books and films
[15:43:44] <amz3>	 I disagree, genre should be across medium
[15:47:24] <davidwbarratt>	 if it should be distinct then the property should be distinct (imho)
[15:47:28] <davidwbarratt>	 but right now, it's the same property.