Untitled query #54620

SQL

SELECT actor_name, COUNT(*)
FROM revision
JOIN actor ON rev_actor=actor_id
JOIN page ON rev_page=page_id

WHERE
	rev_timestamp < "20210401070000" AND
	actor_name IN (
      "Angelus Silesius",
      "Bazi",
      "Chun-mee",
      "David V.",
      "F.ponizil",
      "Grtek",
      "Hnetubud",
      "Janbery",
      "Ján Kepler",
      "Jan Myšák",
      "J. M.",
      "Khamul1",
      "KPX8",
      "Leome323",
      "Mario7",
      "Martin Urbanec",
      "Matěj Orlický",
      "OJJ",
      "Ondřej R.",
      "Patrik L.",
      "Petr Karel",
      "Petr Kinšt",
      "Poirot12345 T",
      "Robins7",
      "Rosičák",
      "RPekař",
      "Vachovec1",
      "VasekPav",
      "Vojtasafr",
      "Xyzabec",
      "Zbrnajsem"
    )
   
GROUP BY actor_id
SQL

Checking query status...
