Список избирателей

Участники со стажем не менее 3 месяцев, сделавшие не менее 500 правок, и не менее 100 правок за последние полгода.

SQL

USE ruwiki_p;
SELECT user_name, user_registration, user_editcount, COUNT(rev_id) FROM
(SELECT * FROM
(SELECT user_id, user_name, user_registration, user_editcount FROM user
 WHERE ((user_registration IS NULL)
        OR (user_registration < DATE_FORMAT(DATE_SUB("2020-07-20", INTERVAL 3 MONTH), "%Y%m%d%H%i%s")))
        AND (user_editcount >= 500)) AS A
INNER JOIN actor
 ON (actor_user = A.user_id)
 WHERE NOT EXISTS (SELECT * FROM user_groups WHERE (ug_user = A.user_id) AND (ug_group = "bot")) ) AS B
INNER JOIN revision
 ON (rev_timestamp > DATE_FORMAT(DATE_SUB("2020-07-20", INTERVAL 6 MONTH), "%Y%m%d%H%i%s")) AND (rev_actor = B.actor_id)
 GROUP BY user_name
 HAVING COUNT(rev_id) >= 100

SQL

Checking query status...