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
   DISTINCT user_name
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
ORDER BY num_talk_pages DESC, user_name
LIMIT 1000;

SQL

Checking query status...