Untitled query #85852

SQL

WITH users AS (
  SELECT DISTINCT actor_id, actor_name
  FROM actor
  WHERE actor_name IN ("Smrothman1909","Thekhyberboypk","Magichero1234","R2dra","NormalguyfromUK","Siam hossain official","Raymarcbadz","Mashrafiantu","Zerolandteam385","Md Sunnat Ali Mollik","SheryOfficial","Kelownatopdog","Koitot","Danieleb82","ANZER.AYOUB","TMdydxca","RoundTeen","Poonam bollywood","Bobanfasil","Sjutt","WhiteReaperPM","Sabuj.bd71","Elizzzzz","Ibn Juferi","BaharatlıCheetos2.0","Ricemaster12","Sonnahuordia","Rajputbhatti","Tochi Clement","Crystel Moore","TheCaseOfGoliath","Rawna Praveen singh solanki","Syed Ali Ahmed Hashami","AdityaNakul","SturmFernmelder","IrishCream001","Historyenjoyer10","PaullyMatthews","Demeter39G","Abbasshaikh124","Yeu aga maj","Be Jain","Creativitylove","IndeedJob","ConstructionNGardening","Balakashyap","Munsaar55","ClarenceDeBordeaux","Okiloma","Leed110","Mischellemougly","R2dra","Ramaprabha1","NormalguyfromUK","James Moore200","Tanishkshatriyaaiims","Phedhima","SheryOfficial","Truthfindervert","Adsville","Njvndsnj","DN27ND","Amansharma111","Matan ibn Uthman","Earslaner2001","Ibn Juferi","Ottgeek","Oriental Aristocrat","Krishna7093","Aditya.nagda","Zaid Zayd","Fileman67","HinduKshatrana","Lola Majer","Kusinara","Rydex64","Sukh4655","Noriandreas","Papa2004","Shenkesh","Cleter","Letscreate","Arain-Arian","Mdd97","Marnie Hawes","Accopulocrat","DaRealConMan","IMteam2022","Srimonbanik2007","MG Calderoni","Bennyblanco10","Mel.monro","WikiNewbie1612","AsteroidComet","Epnesthede","Zessede","3 Löwi","Politialguru","Ronaldowikip","Kicks of seven","Barlas.mongol","Cianzera","832LT","Abul7ik","KBBY2019","Mr Hall of England","CodyCruickshank","Btw Santhosh","Fajar Mardiansyah","Xdwev vfre2wwd","Dominic Pringle","Aqua.107","NogeetaSangiwari","Razakhanofficial","Big Goose23","Smagzine","MANOZ GYAASI","Surinderqa","Wizkizayo","Vinayvinyill","Manshacgc","Estrella,Karpouzis","HaughtonBrit","CriticallyThinking","Danjoel99","DyutimaR01","Wildhorse3","KelvinNays2","Mariagarciacs","Sureshalahari","Abhishekkailawer5","2A00:8A60:C010:1:0:0:1:1016","SHIVA SINGHANIA98","Forward.ops","Isuzu.tf","Asyrofazman12","StarryNightSky11","Irtapil","Rishad Talukdar","Koushik Pain","Researcherofgreatness","Ariaas","AaronFresco","Cossde","Andriyrussu","ChanComThemPho","Bothiman","Shastatree748","Packistani","Meena Kurian","AvinashCabral","Sia loona","DusanSilniVujovic","Fanny.doutaz","KaterynaS","CanadianHistorian(MMA & History)")
)

SELECT actor_name, COUNT(*) as edit_count
FROM users
JOIN revision_userindex ON actor_id = rev_actor
WHERE rev_timestamp > 20240628000000
GROUP BY actor_id
ORDER BY edit_count DESC
SQL

Checking query status...
