Active collaborators on discussion pages (article,wikipedia ns)

Active collaborators on more than 2  discussion pages with atleast three distinct participants in year (excluding loggedin non bot, awb editors) in article talk and wikipedia talk space, which are generally more active than others.

SQL

Select
    user_name,
    COUNT(DISTINCT page_id) as num_pages
from actor
join revision on  rev_actor=actor_id
join page on revision.rev_page = page.page_id 
JOIN user  ON user_id =actor_user
Where LEFT(rev_timestamp,4)="2021" AND  actor_user !=0 AND (page_namespace =1 OR page_namespace= 5) 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 revision
JOIN page ON revision.rev_page = page.page_id 
JOIN actor on rev_actor=actor_id
JOIN user  ON user_id =actor_user
Where LEFT(rev_timestamp,4)="2021" AND   actor_user !=0 AND (page_namespace =1 OR page_namespace= 5) AND  NOT (user_name LIKE '%AWB%' OR user_name  LIKE '%Bot%' OR user_name LIKE'%bot%' OR user_name ='CommonsDelinker')
    
GROUP BY page_namespace, page_title
# atleast five revisions to eliminate, project additions, template removals, which are not real discussions
  HAVING  COUNT(DISTINCT user_name) > 2 )
  
GROUP by user_name
HAVING num_pages > 2
ORDER BY   num_pages DESC, user_name ASC 
LIMIT 1000;

SQL

Checking query status...