Oprávnení voliči k hlasovaniu Wikipédia:Pravidlá/Úprava pravidiel 2021

[SK] Oprávnení voliči k hlasovaniu :skwiki:Wikipédia:Pravidlá/Úprava pravidiel 2021.
[EN] Eligible voters :skwiki:Wikipédia:Pravidlá/Úprava pravidiel 2021.

SQL

 SELECT user_name, count(rev_id) FROM revision
 JOIN page ON page_id = rev_page
 JOIN actor ON actor_id = rev_actor
 JOIN user ON user_id = actor_user
 WHERE page_namespace = 0
  AND rev_timestamp <= '20211126065626'
  AND user_registration <= '20210926065626'
  AND rev_actor IN (
   SELECT rev_actor FROM revision
   WHERE rev_timestamp >= '20210926055626' AND rev_timestamp < '20211126065626'
   GROUP BY rev_actor HAVING COUNT(rev_id) >= 50
  )
 GROUP BY actor_name HAVING count(rev_id) >= 200 ORDER BY COUNT(rev_id) DESC, actor_name

SQL

Checking query status...