Users eligible to vote on skwiki

SQL

USE skwiki_p;

SELECT
    user_name, user_registration, user_editcount
  FROM
    user
  WHERE
    user_registration < DATE_FORMAT(DATE_SUB("2019-07-01 00:00:00", INTERVAL 2 MONTH), '%Y%m%d%H%i%s') AND
    user_editcount >= 200 AND
    user_name in (SELECT DISTINCT actor_name FROM revision r, actor a WHERE a.actor_id = r.rev_actor AND r.rev_timestamp >= DATE_FORMAT(DATE_SUB("2019-07-01 00:00:00", INTERVAL 2 MONTH), '%Y%m%d%H%i%s') GROUP BY actor_name HAVING count(*) >= 50) AND
    user_name in (SELECT DISTINCT actor_name FROM revision r, actor a, page p WHERE p.page_id = r.rev_page AND a.actor_id = r.rev_actor AND p.page_namespace = 0 AND r.rev_timestamp < DATE_FORMAT("2019-07-01 00:00:00", '%Y%m%d%H%i%s') GROUP BY actor_name HAVING count(*) >= 200)
  ORDER BY
    user_name
  ;
SQL

Checking query status...
