Untitled query #77651

SQL

set @yeare = 2023;
SELECT user_name, COUNT(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)<=@yeare 
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 = 'ఈ_వారం_వ్యాసాల_చర్చలు_-_Y2023'  AND cl_type='page' )
 
GROUP BY user_name 
HAVING   COUNT(user_name)  > 4
ORDER BY  COUNT(user_name) desc
SQL

Checking query status...
