Actively collaborated article pages - contributors

Fork of Actively collaborated article pages yearwise by Arjunaraoc

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

Actively collaborated pages  contributors for a specifc  year with year contributions (>9 loggedin non bot, awb editors) in recent years

SQL

SELECT
   LEFT(rev_timestamp,4)  as year,
   CONCAT("[[",page_title,"]]") as pagename,
   user_name
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 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 year,page_title
HAVING num_editors > 9
ORDER BY year DESC
LIMIT 1000;

SQL

Checking query status...