Active collaborated discussion pages (article,wikipedia ns)

Fork of Actively collaborated article pages - contributors by Arjunaraoc

This query is marked as a draft This query has been published by Arjunaraoc.

Active collaborated discussion pages for a specifc  year with year contributions (>2 loggedin non bot, awb editors) in specified year in article talk and wikipedia talk space, which are generally more active than others.

SQL

SELECT
   CONCAT(IF(page_namespace=1,"చర్చ:","వికీపీడియా చర్చ:"), page_title) as fullpagename,
   COUNT(DISTINCT user_name) as editors
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  editors > 2
ORDER BY editors DESC, page_namespace DESC, page_title ASC
LIMIT 1000;

SQL

Checking query status...