[01:32:48] <binni>	 what's the best guide in terms of getting the performance right when importing wikipedia articles SQL dump into a local database?
[03:09:42] <gry>	 hi
[03:10:04] <gry>	 I do console.log($( '<p>' ).msg('feedback-bugornote'));, then chang the message (	mw.messages.set({'feedback-bugornote':'your text'});), and log again. apparently no change. why?
[05:05:42] <Gloria>	 gry: You can make {{YESTERDAY}} using #expr: or Lua or something, presumably.
[05:09:15] <gry>	 Gloria: sounds reasonable to make it a template, thanks; any examples about expr that you could refer me to?
[05:11:32] <Gloria>	 gry: Search for the English Wikipedia's date and time calculation templates. There's a whole category somewhere
[05:11:35] <Gloria>	 .
[05:12:15] <gry>	 danke
[21:22:36] <Newyorkadam>	 hi Betacommand 
[21:22:49] <Newyorkadam>	 is there a way to sort Wikipedia:Good_article_nominations by page size?
[21:22:51] <Newyorkadam>	 the nominations
[21:35:15] <Reedy>	 database query
[21:41:03] <huh>	 Newyorkadam: still want it?
[21:41:19] <Newyorkadam>	 huh: yeh if you can do it
[21:43:58] <huh>	 Newyorkadam: https://tools.wmflabs.org/paste/view/14843772
[21:44:06] <Newyorkadam>	 huh: :o thanks dude
[21:44:09] <Newyorkadam>	 how’d you do it?
[21:44:12] <huh>	 SQL ;)
[21:44:24] <Newyorkadam>	 cool
[21:44:37] <Newyorkadam>	 did you have to manually input all of the submissions?
[21:44:38] <huh>	 Do you have labs account?
[21:44:40] <huh>	 no
[21:44:44] <Newyorkadam>	 yea
[21:44:45] <huh>	 I put the query on the top
[21:44:47] <Newyorkadam>	 don’t use it though
[21:45:11] <huh>	 Newyorkadam: just ssh to tools-login(-eqiad), run the command "sql enwiki"
[21:45:19] <huh>	 and then paste the stuff at https://tools.wmflabs.org/paste/view/14843772 line 1
[21:45:33] <huh>	 (after the enwiki_p prompt)
[21:45:35] <Newyorkadam>	 cool thanks
[21:45:41] <huh>	 SELECT talk.page_title, gan.page_len FROM categorylinks LEFT JOIN page talk ON cl_from=talk.page_id JOIN page gan ON gan.page_title=talk.page_title AND gan.page_namespace=0 WHERE cl_to="Good_article_nominees" ORDER BY gan.page_len DESC;
[21:46:18] <huh>	 actually, it might be missing some, because 327 pages are in that category :/
[21:46:29] <huh>	 but only 321 rows from the query
[21:46:46] <huh>	 I maybe could make a Lua module to do this, not sure
[21:46:46] <Newyorkadam>	 it’s ok thanks :P
[21:46:48] <Newyorkadam>	 :) *
[21:46:54] * huh  busy now, np

[21:47:01] <Newyorkadam>	 just trying to remove the backlog but too busy to do big reviews
[21:47:44] <huh>	 well, https://en.wikipedia.org/wiki/Trent_Milton is the shortest (apparently), so go for it ;)
[21:47:59] <Newyorkadam>	 thanks :0
[21:48:00] <Newyorkadam>	 :)
[21:48:05] <Newyorkadam>	 I need to press harder on keys :p
[21:52:17] <huh>	 Newyorkadam: I can also exclude reviewed ones
[21:52:22] <huh>	 if you need anything else, please ask
[21:52:30] <huh>	 although I should be doing something else ...
[21:52:39] <Newyorkadam>	 :p not at the moment, thanks
[23:32:02] <Betacommand>	 thanks huh 
[23:32:13] <huh>	 np Betacommand
[23:32:19] <huh>	 Wait, thanks for what? ;P
[23:32:38] <Betacommand>	 huh: taking care of the Newyorkadam  question
[23:32:42] <huh>	 oh
[23:33:04] <huh>	 Betacommand: hope I didn't mess it up too badly
[23:33:11] <huh>	 How would you have done it?
[23:33:25] <Betacommand>	 something similar