Wikipedia talk:Wikipedians by most recent edit

Page Generation

This page was generated with the following SQL query on the cur table.

DROP TABLE tester2; CREATE TABLE tester2 SELECT IF( cur_user_text = "Koyaanisqatsi", "Koyaanis Qatsi", IF( cur_user_text = "KoyaanisQatsi", "Koyaanis Qatsi", IF( cur_user_text = "Koyaansqatsi2350", "Koyaanis Qatsi", IF( cur_user_text = "Zxcvb", "Lir", IF( cur_user_text = "Ril", "Lir", IF( cur_user_text = "Like a Virgin", "Lir", IF( cur_user_text = "Shino Baku", "Lir", IF( cur_user_text = "Dietary Fiber", "Lir", IF( cur_user_text = "Susan Mason", "Lir", IF( cur_user_text = "Vera Cruz", "Lir", IF( cur_user_text = "Anonymous56789", "LittleDan", IF( cur_user_text = "Tokerboy", "TUF-KAT", IF( cur_user_text = "Tucci528", "TUF-KAT", IF( cur_user_text = "Tzartzam", "Sam Francis", IF( cur_user_text = "62.253.64.xxx", "TwoOneTwo", IF( cur_user_text = "62.253.64.7", "TwoOneTwo", IF( cur_user_text = "JimboWales", "Jimbo Wales", IF( cur_user_text = "66.47.62.xxx", "H.J.", IF( cur_user_text = "66.47.62.78", "H.J.", IF( cur_user_text = "Greg_Lindahl", "Greg Lindahl", IF( cur_user_text = "GregLindahl", "Greg Lindahl", IF( cur_user_text = "J. Jonat", "H.J.", IF( cur_user_text = "HannesHirzel", "Hannes Hirzel", IF( cur_user_text = "F. Lee Horn", "F. Lee Horn", IF( cur_user_text = "DickBeldin", "Dick Beldin", IF( cur_user_text = "David_spector", "David spector", IF( cur_user_text = "Dave_McKee", "Dave McKee", IF( cur_user_text = "ChuckSmith", "Chuck Smith", IF( cur_user_text = "Chris_mahan", "Chris mahan", IF( cur_user_text = "CareyEvans", "Cary Evans", IF( cur_user_text = "Simon_J_Kissane", "Simon J Kissane", IF( cur_user_text = "Ray G. Van De Walker", "Ray Van De Walker", IF( cur_user_text = "Perry@bebbington.org", "Perry Bebbington", IF( cur_user_text = "ManningBartlett", "Manning Bartlett", IF( cur_user_text = "Magnus", "Magnus Manske", IF( cur_user_text = "LeeDanielCrocker", "Lee Daniel Crocker", IF( cur_user_text = "LarrySanger", "Larry Sanger", IF( cur_user_text = "Larry_Sanger", "Larry Sanger", IF( TRIM(cur_user_text) REGEXP "^[0-9]{1,3}.[0-9]{1,3}.[0-9]{1,3}.[0-9x]{1,3}$", "Anonymous IP", cur_user_text ))))))))))))))))))))))))))))))))))))))) AS user FROM cur;

select @value := 0; create table tester3 select

CONCAT("", @value := @value + 1, "", user, "", count(*)) AS str,

count(*) AS counter, @value AS rank from tester2 group by user order by counter DESC; select str from tester3 where rank < 202 into outfile 'tester.txt';