Untitled query #82904

SQL

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 < 20231021000000 ) ) 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 > 20230720000000 and rev_timestamp < 20240120000000) AND ( rev_actor = B.actor_id ) 
GROUP  BY user_name 
HAVING Count(rev_id) >= 100
SQL

Checking query status...
