Untitled query #63224

SQL

SELECT
  LEFT(rev_timestamp,4) AS  iyear,
   user_name
FROM revision
LEFT JOIN page
      ON page_id = rev_page
LEFT JOIN actor
      ON rev_actor = actor_id
LEFT JOIN  user   ON user_id =actor_user
where   rev_actor != 0 AND page_namespace=0 AND LEFT(rev_timestamp,4)="2021" AND 
NOT (user_name LIKE '%AWB%' OR user_name  LIKE '%Bot%' OR user_name LIKE'%bot%' OR user_name ='CommonsDelinker')
AND page_title IN
(Select page_title
 FROM page
 join categorylinks on cl_from=page_id 
 Where  cl_to = 'ఈ_వారం_వ్యాసాల_చర్చలు_-_Y2021'  AND cl_type='page' )
 
GROUP BY iyear,user_name 
HAVING   COUNT(user_name)  > 0
ORDER BY  iyear DESC, user_name ASC
LIMIT 1000;
SQL

Checking query status...
