Untitled query #38429

SQL

USE svwikisource_p;
SELECT * FROM (
   SELECT COUNT(rev_id) AS 'n', rev_actor, actor_user, actor_name FROM 
      revision JOIN actor ON rev_actor = actor_id
         WHERE 'bot' NOT IN (
            SELECT ug_group FROM user_groups WHERE ug_user = actor_user
            ) AND rev_timestamp > 20180816000000
         GROUP BY rev_actor
   ) AS A
   WHERE n > 50;
USE plwikisource_p;
SELECT * FROM (
   SELECT COUNT(rev_id) AS 'n', rev_actor, actor_user, actor_name FROM 
      revision JOIN actor ON rev_actor = actor_id
         WHERE 'bot' NOT IN (
            SELECT ug_group FROM user_groups WHERE ug_user = actor_user
            ) AND rev_timestamp > 20180816000000
         GROUP BY rev_actor
   ) AS A
   WHERE n > 50;
SQL

Checking query status...
