Untitled query #86484

SQL

SELECT 
    actor_name AS username,
    COUNT(*) AS contributions_count
FROM
    frwiki_p.revision
JOIN
    frwiki_p.actor ON revision.rev_actor = actor.actor_id
WHERE
    actor_name IN ("Nouill", "Trizek", "Sherwood6", "Levieuxtoby", "Nattes à chat", "Goodshort", "O.Taris", "HMa", 
                   "Triboulet sur une montagne", "Bob Saint Clar", "Fécamp №0²", "Le chat perché", "JMGuyon", "Jules*", 
                   "Lewisiscrazy", "Waltercolor", "Braveheidi", "Pre7", "Le Petit Chat", "L'embellie", "Jorune", "Dastel", 
                   "Ælfgar", "Lepticed7", "LadyBirdy38", "El Comandante", "Æpherys", "Hyméros", "LD", "Frenouille",
                   "CoffeeEngineer", "Cody escouade delta", "Fanchb29", "Witcher of Izalith", "Ash Crow", "Pic-Sou", 
                   "Julien1978", "Hibrideacus", ".Anja.", "JohnNewton8", "Lebrouillard", "Kertraon", "Romuald 2", 
                   "Paul.schrepfer", "DarkVador79-UA", "Omnilaika02", "Michel421", "Laurent Jerry", "CaféBuzz", 
                   "Goombiis", "GF38storic", "Abdoucondorcet", "Authueil", "Mogador", "Ménestor", "Adoscam", "Hatonjan", 
                   "Okhjon", "Sinkra", "Manacore", "Raphiphou2", "Fabius Lector", "Jean-Christophe BENOIST", "VIGNERON", 
                   "Chaps the idol", "GrandEscogriffe", "Raresvent", "Thomas.R", "Geugeor", "Alacoolwiki", "Mwarf", "Laugriville", 
                   "Hadrianus", "Louis-garden", "Kvardek du", "TigH", "Acer11", "Kelam", "PetiPandaRou", "Hereptol", "Orlodrim", 
                   "Slzbg", "Jilucorg", "Metamorforme42", "Lngarnaud777", "Cosmophilus", "Matpib", "L'engoulevent", "Odilon Taris", 
                   "Marc Mongenet", "Erdé51", "Gaspart de la Meije", "Uchroniste 40", "Sg7438", "Sismarinho", "Supertoff", "Thesana", 
                   "Mr Tortue", "Runi Gerardsen", "Anthere", "Mocaline", "Phil94", "Guil2027", "Bertrand Labévue", "Habertix")
    AND rev_timestamp BETWEEN '20230221000000' AND '20240221235959' 
GROUP BY
    actor_name;
SQL

Checking query status...
