Created articles, grouped by month (lvwiki)

SQL

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

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

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

Checking query status...
