Odia Wikipedia articles created year on year

SQL

use orwiki_p;
select * from revision r, page p where r.rev_parent_id = 0 and p.page_namespace = 0 and p.page_is_redirect = 0 and r.rev_page = p.page_id and rev_timestamp <= 20030100000000 and rev_timestamp > 20011200000000;
select * from revision r, page p where r.rev_parent_id = 0 and p.page_namespace = 0 and p.page_is_redirect = 0 and r.rev_page = p.page_id and rev_timestamp <= 20040100000000 and rev_timestamp > 20021200000000;
select * from revision r, page p where r.rev_parent_id = 0 and p.page_namespace = 0 and p.page_is_redirect = 0 and r.rev_page = p.page_id and rev_timestamp <= 20050100000000 and rev_timestamp > 20031200000000;
select * from revision r, page p where r.rev_parent_id = 0 and p.page_namespace = 0 and p.page_is_redirect = 0 and r.rev_page = p.page_id and rev_timestamp <= 20060100000000 and rev_timestamp > 20041200000000;
select * from revision r, page p where r.rev_parent_id = 0 and p.page_namespace = 0 and p.page_is_redirect = 0 and r.rev_page = p.page_id and rev_timestamp <= 20070100000000 and rev_timestamp > 20051200000000;
select * from revision r, page p where r.rev_parent_id = 0 and p.page_namespace = 0 and p.page_is_redirect = 0 and r.rev_page = p.page_id and rev_timestamp <= 20080100000000 and rev_timestamp > 20061200000000;
select * from revision r, page p where r.rev_parent_id = 0 and p.page_namespace = 0 and p.page_is_redirect = 0 and r.rev_page = p.page_id and rev_timestamp <= 20090100000000 and rev_timestamp > 20071200000000;
select * from revision r, page p where r.rev_parent_id = 0 and p.page_namespace = 0 and p.page_is_redirect = 0 and r.rev_page = p.page_id and rev_timestamp <= 20100100000000 and rev_timestamp > 20081200000000;
select * from revision r, page p where r.rev_parent_id = 0 and p.page_namespace = 0 and p.page_is_redirect = 0 and r.rev_page = p.page_id and rev_timestamp <= 20110100000000 and rev_timestamp > 20091200000000;
select * from revision r, page p where r.rev_parent_id = 0 and p.page_namespace = 0 and p.page_is_redirect = 0 and r.rev_page = p.page_id and rev_timestamp <= 20120100000000 and rev_timestamp > 20101200000000;
SQL

Checking query status...
