USE skwiki_p;

​

-- Policy: https://sk.wikipedia.org/wiki/Wikip%C3%A9dia:Pravidl%C3%A1/Hlasovanie

​

-- Date and time (UTC) to list eligible voters to, e.g. start of a voting:

SELECT @t := now();

-- SELECT @t := '2023-06-07 20:49:00';

-- SELECT @t := '2015-11-09 11:08:00';

​

SELECT

    user_name, DATE_FORMAT(user_registration, '%Y-%m-%d') as user_registration, user_editcount

  FROM

    user

  WHERE

    (user_registration > DATE_FORMAT(DATE_SUB(@t, INTERVAL 2 YEAR), '%Y%m%d%H%i%s')) AND

    user_editcount > 0 AND

    user_id NOT IN (SELECT ug_user FROM user_groups WHERE ug_group = 'bot') AND

      -- excluding bots

    user_name NOT IN ('CommonsDelinker', 'InternetArchiveBot', 'Xqbot')

      -- excluding non-flagged bots

  ORDER BY

    user_name

  ;