Untitled query #48588

SQL

use enwiki_p;
SELECT
  user_name as Username,
  COUNT(*) as Edits_since_20000101
FROM revision
JOIN revision_actor_temp
     ON  revactor_rev=rev_id
JOIN actor
     ON revactor_actor=actor_id
JOIN user
     ON user_id =actor_user
WHERE user_name in ("Ab207","Adimallikarjunareddy","Adithyak1","Adityamadhav83","Alamandrax","Altruism","Anangi krishna teja","Anwesh023","Anwesh023","Archaeo2","ArunTejaswi","Bharathponna","Bkj","Bsskchaitanya","Cdinesh","Chaduvari","Chandroos","Chenchala.ganesh","Cparimi","Dev","Divyagullapudi","Durgapradeep","Eartotheground","Edupuganti Pavan Kumar Chowdary","Elncid","En.Dev","Encyclopediaofvidyasagar","Etipakam","Fantumphool","GenericUsername2000","Girishgullapudi","Grbpradeep","Gs9here","Gunnala","Gurubrahma","Harshavs","Hemalataeditor","Hnaluru","Huntscorpio","I'm Irfan","ImpuMozhi","Jayant412","Kalyanraghu","Kandeya","Kasyap","KBM Nikhil","Kingshash","Kingshash","Kirandotc","Klkreddy83","Krishnavedala","Ksri99","Lakshmisreekanth","Leelakrishna86","Limelight753","Madalasatish","Malapati","Mamidivivek","Masti 84","Merchant of Meluha","Metamutator","Mlpkr","Mpradeep","Mr.Rambabu","MVSatish","Nagarjuna198","Naidugari Jayanna","Naresh Raja Kumar","Naseers","Nbsubbaiah","Ngopikrishna","Nivas10798","Nomula Prabhakar Goud","Ntveem","Palagiri","Pavan santhosh.s","User talk:PBR-Wiki","PBR-Wiki","Political Cricketer","Psk livewire","Pssk1988","Raghuveer Aavula","Rajanala Samyak","Rajasekhar1961","Ramcrk","Rasulnrasul","Ravichandrae","Redrisingplate","Riyan andri s","Robertfisner","S.Chidipothu","Sabbarish.govindarajan","Sagavaj","Sahil ravuri","Saketh","SamuraiJack","Scourgeofgod","Shreewiki","Shruti14","Shyamk hmp","Sjasty","Sleeper~enwiki","Sri Harsha Bhogi","Srichakra Pranav","Sridhar Babu","Srikanthkashyap","Srikanthyalavarthi","Srinath66","Srinivasaraju","Strike Eagle","Sudharsansn","Sumanth699","Sumanthk","Sumanthk/userboxes","Suneethkrishna","Sunil Mohan","Sunthosh","Suraj vas","Susruthanvesh","SuswethaK","Svnitbharath","Svpnikhil","Tangirala1234","TheAwesome21","Thunder Storm","Tpathanjali","Twooars","Twotino","Vamsikrishnachada","Veeven","Vikas4554","Vikman","Visakha veera","Visdaviva","Vishnuchakra","WeAreCreative","WP MANIKHANTA","Xlncaditya","కిరణ్మయి","దేవుడు","ప్రవీణ్")
GROUP BY user_id
ORDER BY Edits_since_20000101 DESC LIMIT 100;
SQL

Checking query status...
