Untitled query #66610

SQL

SELECT
   user_name

FROM user
JOIN  actor   ON user_id =actor_user
JOIN revision_actor_temp ON revactor_actor=actor_id
JOIN revision ON revactor_rev=rev_id
JOIN page on  revision.rev_page = page.page_id 
Where (LEFT(rev_timestamp,4)="2021" AND   actor_user !=0 AND LEFT(rev_timestamp,4)="2021" AND page_namespace =0 AND  NOT (user_name LIKE '%AWB%' OR user_name  LIKE '%Bot%' OR user_name LIKE'%bot%' OR user_name ='CommonsDelinker')
AND page_id in
(SELECT
     page_id
FROM page
LEFT JOIN revision ON revision.rev_page = page.page_id 
JOIN revision_actor_temp
     ON  revactor_rev=rev_id
JOIN actor
     ON revactor_actor=actor_id
JOIN user
     ON user_id =actor_user
WHERE actor_user !=0 AND LEFT(rev_timestamp,4)="2021" AND page_namespace =0 AND  NOT (user_name LIKE '%AWB%' OR user_name  LIKE '%Bot%' OR user_name LIKE'%bot%' OR user_name ='CommonsDelinker')
GROUP BY page_title
 HAVING COUNT(DISTINCT user_name) > 9))
GROUP BY user_name
LIMIT 1000;
SQL

Checking query status...
