use tewiki_p;

SELECT left(t4.rev_timestamp,4) as Menesis, count(left(t4.rev_timestamp,4)) as Raksti

FROM revision AS t4

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)