Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Dušan Kreheľ
.
Toggle Highlighting
SQL
select actor_name, COUNT(rev_id) FROM revision JOIN page ON page_id = rev_page JOIN actor ON actor_id = rev_actor WHERE page_namespace = 0 and actor_name IN('Jetam2','Teslaton','Pe3kZA','Vasiľ','DurMar12','Krumpi','TeslaBot','Gateshebe','Starekolena','ScholastikosSVK','Georgeo88','Lalina','Rainbot','Wizzard','Fry1989','Nelliette','Denis Pongrácz','RickRichards','Martin Jediny','Andrej203','Pescan','PeterKLK','Akul59','OJJ','Michal62606','Petrik555','Robert Jahoda','Luppus','Pelex','Andymen79','Vegbot','Rio Paric','Johann Slovák','Kvargla','CommonsDelinker','SanoAK','ThomasanSK','Adams664','Važomír','Glorious 93','Starček','Lišiak','Tom78','Peko','Eryn Blaireová','Marek Pafčuga','Matroxko','2A02:AB04:3140:7400:C54C:F68E:3F44:3C9','Dušan Kreheľ','2A02:AB04:3140:7400:ACBD:5D8B:678A:E09','Bojars','2A02:AB04:27BD:D900:955:1473:96B3:880B','62.168.13.101','Dominik1495','Vegetator','Mr.inkognito123','Ronaldo785366','91.127.206.230','Renvoy','88.212.41.135','Ján Vitko','Matej Jediný','PaulPirovits') GROUP BY actor_name ORDER BY COUNT(rev_id) DESC, actor_name;
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...