[13:22:53] <ToAruShiroiNeko>	 https://quarry.wmflabs.org/query/15359
[13:23:11] <ToAruShiroiNeko>	 Nemo_bis how can I efficiently limit the query to exclude user accounts that are younger than a year?
[13:36:57] <Nemo_bis>	 ToAruShiroiNeko: if you need the query just once for one wiki, you could just hardcode the user_id 
[13:40:03] <Nemo_bis>	 [enwiki_p]> select user_id from user where user_registration < ( NOW() - INTERVAL 12 MONTH ) ORDER BY user_id DESC LIMIT 1;
[13:40:08] <Nemo_bis>	 27274576
[13:40:22] <ToAruShiroiNeko>	 right but I want to make it so that it will auto adjust
[13:40:31] <ToAruShiroiNeko>	 since I will run this querry and queries like it often
[13:41:36] <Nemo_bis>	 well, if you already join user then just use user_registration
[13:42:46] * Nemo_bis is confused by the need to join 4 of the biggest tables in MediaWiki
[13:46:20] <ToAruShiroiNeko>	 user_registration-1 year ?
[13:46:25] <ToAruShiroiNeko>	 is that efficient?
[13:49:01] <ToAruShiroiNeko>	 I have not done date manimulaiton/compariosn like  this before
[14:41:41] <ibouvousaime>	 hello is it possible to have an offline version of wikitionary ? if possible how can I get it ? 
[14:53:34] <rh>	 hi, you come recommended from #wikimedia-en. not receiving forgot password mails for my account. haven't been using it for ca. a decade. 
[15:06:27] <Nemo_bis>	 rh: do you remember something about the address you had used?
[15:06:54] <rh>	 yes, super sure it is my current one :-)
[15:07:22] <rh>	 i like using my real name ... a bit too often. but it simplifies these cases.
[15:21:07] <rh>	 kk, won't hold you up any longer. will e-mail OTRS from that very same address. 
[15:21:22] <rh>	 thanks and you also, keep up the good work. 
[15:46:50] <dennyvrandecic>	 ibouvousaime: I can point you to a download of all the data. or are you looking for an app?
[15:48:29] <ibouvousaime>	 the goal here is just to be able to view a portuguese dictionary while not being with an internet connection
[15:48:52] <ibouvousaime>	 what do you mean with an app?  mobile ? nooo not mobile please lol 
[15:49:39] <ibouvousaime>	 Im downloading the html dumps from here https://dumps.wikimedia.org/
[15:49:55] <ibouvousaime>	 but I dont know it it contains the wikitionary dennyvrandecic
[15:50:05] <ibouvousaime>	 I dont know if*
[15:50:41] <dennyvrandecic>	 you were on a good track
[15:50:46] <dennyvrandecic>	 this is portuguese wiktionary:
[15:50:47] <dennyvrandecic>	 https://dumps.wikimedia.org/ptwiktionary/20170101/
[15:50:59] <dennyvrandecic>	 what you can do with that is either upload it in a local mediawiki installation
[15:51:07] <dennyvrandecic>	 or you can use an offline reader
[15:51:32] <dennyvrandecic>	 like http://www.kiwix.org/
[15:51:41] <ibouvousaime>	 ohh cool
[15:51:50] * ibouvousaime is checking it out
[15:52:54] <dennyvrandecic>	 just take kiwix
[15:53:20] <dennyvrandecic>	 and download the wiktionary pt package from here:
[15:53:22] <dennyvrandecic>	 http://wiki.kiwix.org/wiki/Content_in_all_languages
[15:53:22] <ibouvousaime>	 Im downloading it 
[15:53:28] <ibouvousaime>	 thank you 
[15:54:29] <ibouvousaime>	 okay 
[16:37:37] <snitch>	 [[Tech]]; Aghori sharma; /* Love Problem Solution Specialist BABA JI 91-9878162323 usa canada india uk */ new section; https://meta.wikimedia.org/w/index.php?diff=16217784&oldid=16214810&rcid=8809226
[16:38:53] <snitch>	 [[Tech]]; Defender; Reverted changes by [[Special:Contributions/Aghori sharma|Aghori sharma]] ([[User talk:Aghori sharma|talk]]) to last version by ArchiverBot; https://meta.wikimedia.org/w/index.php?diff=16217786&oldid=16217784&rcid=8809228
[16:39:18] <snitch>	 [[Tech]]; Aghori sharma; /* kOlKatA*$!*ChENnAi {{+91-9878162323}} -Intercaste Love Marriage Specialist in Italy  */ new section; https://meta.wikimedia.org/w/index.php?diff=16217789&oldid=16217786&rcid=8809231
[16:40:17] <snitch>	 [[Tech]]; Defender; Reverted changes by [[Special:Contributions/Aghori sharma|Aghori sharma]] ([[User talk:Aghori sharma|talk]]) to last version by Defender; https://meta.wikimedia.org/w/index.php?diff=16217794&oldid=16217789&rcid=8809240
[17:00:49] <snitch>	 [[Tech]]; Slevinski; written sign language wikipedia; https://meta.wikimedia.org/w/index.php?diff=16217820&oldid=16217794&rcid=8809302
[17:30:06] <Elitre>	 Hello everyone. In a while, you'll be able to follow and participate to the Wikimedia Foundation Technology and Product Q&A session at the Wikimedia Developer Summit in SF.  Please head to #wmhack if interested! Other details: STREAM: https://www.youtube.com/watch?v=f0JdtauJkKs
[17:30:06] <Elitre>	 NOTES: https://etherpad.wikimedia.org/p/devsummit17-dev-and-product-q&a 
[17:30:06] <Elitre>	 PHAB TASK: https://phabricator.wikimedia.org/T153063 
[17:30:14] <Elitre>	 TTYS in #wmhack.
[19:09:03] * arrbee will be taking IRC questions for the "MediaWiki history for analytics" session
[21:47:29] <Nemo_bis>	 FlorianSW: I think you too know someone shown in this article :) https://sfconservancy.org/blog/2017/jan/10/member-projects-fundraising/
[21:59:45] <FlorianSW>	 Nemo_bis: really? I don't get it, sorry :/
[22:20:21] <Nemo_bis>	 FlorianSW: you probably met Walter at the GCI meetup
[22:21:32] <FlorianSW>	 If you mean the GCI meetup at the beginning of this years GCI, I unfortunately wasn't there. I'd to spent more time at work :/