[04:29:22] <tuxnani>	 Hello, I am trying to retrieve number of pages created in page namespace on Telugu Wikisource (te.wikisource) using quarry. I could see only page touched field, will this be accurate? Or is there another place I should try?
[04:33:18] <tuxnani>	 What I actually require is : Number of pages created in page namespace in the given time period. 
[04:33:40] <Krenair>	 I think page touched counts edits
[04:33:48] <Krenair>	 i.e. any edit, not just creation edits
[04:49:11] <tuxnani>	 Krenair: Where would be page creation edits stored woth datetime?
[04:49:45] <Krenair>	 how recently?
[04:51:30] <tuxnani>	 say in july 2014
[04:51:40] <tuxnani>	 around a year and within
[04:58:58] <Krenair>	 I'm not sure we store information against each revision to make that simple.
[04:59:21] <Krenair>	 oh, hang on
[04:59:25] <Krenair>	 rev_parent_id
[05:01:52] <domas>	 omg mediawiki
[05:02:15] <Krenair>	 tuxnani, "select count(*) from page, revision where rev_page = page_id and rev_parent_id = 0 and page_namespace = $NS and rev_timestamp <= 20140800000000 and rev_timestamp > 20140700000000;" possibly?
[05:02:47] <tuxnani>	 ok
[05:03:03] <Krenair>	 obviously you need to replace $NS
[05:03:18] <Krenair>	 domas: ?
[05:03:34] <domas>	 I sometimes get surprised by the channels I lurk in
[05:04:34] <tuxnani>	 Thank you Krenair
[05:04:45] <tuxnani>	 http://quarry.wmflabs.org/query/2081
[05:07:53] <domas>	 oh, big data
[05:08:06] <Krenair>	 big?
[05:08:32] <domas>	 yes
[05:08:51] <Krenair>	 We count tewikisource as medium sized
[05:10:02] <Lor_>	 Getting a database error on https://en.wikipedia.org/wiki/Special:ActiveUsers/Wifione currently
[05:10:07] <Lor_>	 https://gist.github.com/Lorwp/3837f6e4c56f84f68a97
[05:13:01] <Lor_>	 could i get someone smart(er) than me to work this out? seems to be a timeout error
[05:14:16] <Krenair>	 yeah I think mysql just gives up and tells you to stop wasting its time :p
[05:15:01] <Lor_>	 well with Wifione i'm not shocked..though i'm not the one who encountered this atfirest
[05:16:10] <Krenair>	 I'm not shocked because it's a special page on enwiki
[05:16:32] <Lor_>	 what did the special page do to you? :P
[09:54:16] <Nemo_bis>	 Ugh, what a pity that we can't enjoy this https://gerrit-review.googlesource.com/#/c/56241/
[10:22:01] <godog>	 the new change screen?
[11:00:36] <Nemo_bis>	 godog: no, the fixes to it :)
[11:00:44] <Nemo_bis>	 We have the new change screen in its worst release
[11:00:54] <Nemo_bis>	 (For users who select it in preferences)
[11:01:44] <godog>	 ah, I didn't bother with changing it, I'm sure people would be up to update gerrit when that gets into a release
[11:02:10] <Nemo_bis>	 godog: Hm? The new change screen is the reason we've not updated to 2.9, allegedly
[11:02:55] <godog>	 oh, is old screen still available in 2.9 ?
[11:02:58] <Nemo_bis>	 I use the new change screen because it computes the diffs server-side
[11:03:24] <Nemo_bis>	 I don't know. But  IIRC 2.8.x doesn't change defaults https://phabricator.wikimedia.org/T65847
[11:07:47] <godog>	 I see, yeah by reading the ticket I clearly lack context there
[11:09:48] <Nemo_bis>	 Well not so much, it's rather simple. 2.9 changes defaults and we prefer to avoid the disruption. 2.8.x *seems* to have no breaking changes etc.
[21:19:04] <Nemo_bis>	 Uh, something's new in phabricator :)
[21:20:10] <paravoid>	 what is?
[21:24:58] <Nemo_bis>	 For now I notice the profile changes and the scrollbars being stolen from the browser
[21:25:54] <uamaol>	 https://en.wikipedia.org/wiki/Heat_shock_protein_90kDa_alpha_(cytosolic),_member_A1#Hsp90_Inhibitors
[21:26:00] <uamaol>	 15 notes for a less that one line sentence
[21:26:06] <uamaol>	 That has got to be a record
[21:27:10] <MatmaRex>	 Nemo_bis: there's already a bug for scrollbars
[21:28:06] <Nemo_bis>	 MatmaRex: ok
[21:28:10] <Nemo_bis>	 uamaol: citation factory at work? https://en.wikipedia.org/w/index.php?title=Heat_shock_protein_90kDa_alpha_%28cytosolic%29,_member_A1&diff=647766236&oldid=647766064
[21:29:08] <Nemo_bis>	 uamaol: cf. https://lists.wikimedia.org/pipermail/wiki-research-l/2015-February/004149.html
[21:45:11] <uamaol>	 Are the logs of the foundation's IRC public anywhere?
[21:45:20] <uamaol>	 They must be a funny read at times
[21:47:21] <Reedy>	 ?
[21:55:21] <Platonides>	 uamaol, no
[21:55:25] <DanielK_WMDE_>	 uamaol: there are probably a hundred wikimedia related irc channels on freenode... some are logged... usually, the log is linked from the topic.
[21:55:36] <Platonides>	 some channels are publicly logged, on other's it's explicitely banned
[21:56:07] <uamaol>	 lol
[21:56:22] <uamaol>	 iS that a part of the accountability row?
[21:56:45] <uamaol>	 Referencing logs in arguments
[22:00:43] <Nemo_bis>	 Not really. Usually technical channels are logged because they may contain useful support information
[22:01:10] <Nemo_bis>	 (AKA the IRC helpers have one more excuse to slap you if you don't use search)
[22:01:40] <Nemo_bis>	 (Although, now that I think of it, Ubuntu channels do that but we don't much)
[22:14:14] <Nemo_bis>	 uamaol: join #wikimedia-research to discover if it's really a record (being verified right now!)
[22:15:39] <uamaol>	 Nemo_bis: What is?
[22:27:27] <tgr>	 mw.org seems down
[22:27:33] <andre__47>	 Errm, https://www.mediawiki.org/ says "File not found: /srv/mediawiki/php-1.25wmf18/index.php"
[22:28:58] <andre__47>	 alright, some actions in #ops
[22:32:24] <UaMaol>	 Think I might go to bed, good night!
[22:43:34] <wompt>	 Hey guys, looking to sign up for the mediawiki api anyone know whats going on with the servers?
[22:46:03] <Krenair>	 you want to use the api for mediawiki.org?