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

 /*
 Začiatok hlasovania [1]: 2021-11-26 06:56:26 UTC (2021-11-26 07:56:26 CET)
        Dve mesiace pred: 2021-09-26 05:56:26 UTC (2021-09-26 07:56:26 CEST)
        
  [1] – https://sk.wikipedia.org/wiki/%C5%A0peci%C3%A1lne:Exportova%C5%A5Str%C3%A1nky/Diskusia_k_Wikip%C3%A9dii:Pravidl%C3%A1/%C3%9Aprava_pravidiel_2021
 */
 
 SELECT user_name 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' OR user_registration is NULL)
  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 user_name ASC

SQL

Checking query status...