Untitled query #48588

SQL

use tewiki_p;
SELECT
  user_name as Username,
  COUNT(*) as Edits
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 ("Abbasquadir","Bharadwajravi","Cntrational","DEVEGOWDA S R","Gk007","Gyanster","Jai Kumara Yesappa","Krishnaprasaths","Lekhair","Omer123hussain","RwiTexx","Saroshp","Sganeshkumar 1989","Solatido","Tangirala1234","Vidyaben Shah","Anilkt","Anonymous303","AumprakashReddy","Bysraja","Ganesha1","Ias2008","IQAG1060","Kaliru","Kaliru","Kate Nazim","KingSarf","Mspraveen","NitRav","Nizam~enwiki","Pavani","Preethi Evangeline","Vvuppala")
GROUP BY user_id
ORDER BY Edits DESC LIMIT 100;
SQL

Checking query status...
