From: Rahuldeshmukh101 <rahuldeshmukh101@rediffmail.com>

Date: Mon, 23 Jan 2012 21:23:41

http://mr.wikipedia.org/wiki/%E0%A4%B8%E0%A4%A6%E0%A4%B8%E0%A5%8D%E0%A4%AF:Emijrp/List_of_Wikipedians_by_number_of_edits

From: madman <madman@ferretproductions.com>

Date: Mon, 23 Jan 2012 23:30:32

SELECT DISTINCT user_name, user_editcount, MAX(rev_timestamp)
FROM user LEFT JOIN user_groups ON user_id = ug_user
LEFT JOIN revision ON user_id = rev_user
WHERE (ug_group IS NULL OR ug_group != 'bot')
GROUP BY rev_user
ORDER BY user_editcount DESC
LIMIT 100;

From: madman <madman@ferretproductions.com>

Date: Tue, 24 Jan 2012 02:16:59

Rahuldeshmukh101, please see http://mr.wikipedia.org/wiki/%E0%A4%B8%E0%A4%A6%E0%A4%B8%E0%A5%8D%E0%A4%AF:Emijrp/List_of_Wikipedians_by_number_of_edits, which I have copied from https://toolserver.org/~madman/dbq-results/dbq-174.txt. If the output looks satisfactory, I can set it up to run on the 1st and 15th of every month; if not, let me know and I'll be happy to change it.

Thanks!
-[[wikipedia:en:User:Madman]]

From: Rahuldeshmukh101 <rahuldeshmukh101@rediffmail.com>

Date: Tue, 24 Jan 2012 05:33:53

The output is satisfactory you can set it up to run on the 1st and 15th of every month;

Thanks

~~~

From: Rahuldeshmukh101 <rahuldeshmukh101@rediffmail.com>

Date: Sat, 04 Feb 2012 17:49:54

As requested please schedule the job on 1st and 15th of month to update. For Feb 2012 it did not updated the data. Also if possible please filter out the inter wiki bot from appearing on the list as may bots without local bot flag work on mr.wiki and are appearing in the list.

Thanks

Rahul

From: Rahuldeshmukh101 <rahuldeshmukh101@rediffmail.com>

Date: Sat, 04 Feb 2012 17:58:45

The schedule bot is not working. The update which was expected on 1st and 15th of a month is not updated.

From: madman <madman@ferretproductions.com>

Date: Sat, 04 Feb 2012 18:16:23

I did set it up to run on the 1st and 15th, and in fact ran a manual update yesterday to test something. I'll add a comment in the output that indicates when it was last updated.

-Madman

From: madman <madman@ferretproductions.com>

Date: Sat, 04 Feb 2012 18:20:48

Done. https://toolserver.org/~madman/dbq-results/dbq-174.txt
Will get e-mail when the job runs again on the 15th and will see why if not.

-Madman

From: Rahuldeshmukh101 <rahuldeshmukh101@rediffmail.com>

Date: Sun, 05 Feb 2012 04:19:26

Thanks. madman for the support.

• Rahul

This bug was imported as RESOLVED. The original assignee has therefore not been
set, and the original reporters/responders have not been added as CC, to
prevent bugspam.

If you re-open this bug, please consider adding these people to the CC list:
Original assignee: madman.enwiki@gmail.com
CC list: madman.enwiki@gmail.com, rahuldeshmukh101@rediffmail.com