Articles edited by user in given month

SQL

use tewiki_p;
select count(p.page_id) from revision r, page p where rev_parent_id = 0 and p.page_namespace = 0 and p.page_is_redirect = 0 and r.rev_page = p.page_id and r.rev_timestamp > '20181130235959' and r.rev_timestamp < '20190101000000' and r.rev_user_text = 'రహ్మానుద్దీన్';
select concat("[[:te:",p.page_title,"]]"),r.rev_timestamp from revision r, page p where  rev_parent_id = 0 and p.page_namespace = 0 and p.page_is_redirect = 0 and r.rev_page = p.page_id and r.rev_user_text = 'రహ్మానుద్దీన్'and r.rev_timestamp > '20181130235959' and r.rev_timestamp < '20190101000000';
SQL

Checking query status...
