KSA new articles by year

SQL

use arwiki_p;
SELECT left(t4.rev_timestamp,4) as Menesis, count(left(t4.rev_timestamp,4)) as Raksti
FROM revision AS t4
 JOIN page article ON 
	article.page_id = rev_page AND
    article.page_namespace = 0
INNER JOIN page talk ON 
	talk.page_title = article.page_title AND
    talk.page_namespace = 1
INNER JOIN categorylinks ON 
	cl_from = talk.page_id
    AND cl_to = "مقالات_مشروع_ويكي_السعودية"
WHERE t4.rev_id IN (

Select min(t45.rev_id)
From revision t45
inner join page p on t45.rev_page=p.page_id
where p.page_namespace=0 and p.page_is_redirect=0
  #and t45.rev_page in (select cl_from from categorylinks where cl_from = rev_page and cl_to = "بوابة_السعودية/مقالات_متعلقة") 
group by t45.rev_page
having min(t45.rev_id)
order by min(t45.rev_id) desc
)
GROUP BY left(t4.rev_timestamp,4)
#Limit 10;
SQL

Checking query status...
