tewiki: Month-wise New articles creation

SQL

use tewiki_p;
SELECT left(t4.rev_timestamp,6) as monthe, count(left(t4.rev_timestamp,6)) as articles
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
group by t45.rev_page
having min(t45.rev_id)
order by min(t45.rev_id) desc
)
GROUP BY left(t4.rev_timestamp,6)
order BY left(t4.rev_timestamp,6) desc

​x
 
use tewiki_p;SELECT left(t4.rev_timestamp,6) as monthe, count(left(t4.rev_timestamp,6)) as articlesFROM revision AS t4WHERE t4.rev_id IN (​Select min(t45.rev_id)From revision t45inner join page p on t45.rev_page=p.page_idwhere p.page_namespace=0 and p.page_is_redirect=0group by t45.rev_pagehaving min(t45.rev_id)order by min(t45.rev_id) desc)GROUP BY left(t4.rev_timestamp,6)order BY left(t4.rev_timestamp,6) desc​

SQL

This query has never yet been executed