Number of all edits in ns0 in certain wiki per year

SQL

use ruwiki_p;
select * from page where page_id=3849755;
select cast(actor_name as char) user, min(rev_id), page_is_redirect from revision join page on rev_page=page_id join actor on actor_id=rev_actor where page_id=3849755;
select cast(actor_name as char) user, min(rev_timestamp), page_is_redirect from revision join page on rev_page=page_id join actor on actor_id=rev_actor where page_id=3849755;
select * from page where page_id=1392414;
select cast(actor_name as char) user, min(rev_id), page_is_redirect from revision join page on rev_page=page_id join actor on actor_id=rev_actor where page_id=1392414;
select cast(actor_name as char) user, min(rev_timestamp), page_is_redirect from revision join page on rev_page=page_id join actor on actor_id=rev_actor where page_id=1392414;
SQL

Checking query status...
