Untitled query #71276

SQL

select
	count(wb_items_per_site.ips_site_page) as year_count,
    YEAR(revision.rev_timestamp) as year
from revision
join page on page.page_id = revision.rev_page
join comment on comment.comment_id = revision.rev_comment_id
join wb_items_per_site on wb_items_per_site.ips_item_id=REPLACE(page.page_title,"Q","") 
where comment.comment_text like "%clientsitelink-remove%" and comment.comment_text like "%enwiki%"
#and rev_timestamp > (NOW() - INTERVAL 1 MONTH)
#and YEAR(rev_timestamp)='2023'
and wb_items_per_site.ips_site_id like "arwiki"
#and comment.comment_text not like "%Template%"
and comment.comment_text not like '%Category%'
group by YEAR(revision.rev_timestamp)
SQL

Checking query status...
