Talk page edits

SQL

use fiwiki_p;
select 
	floor(rev_timestamp/10000000000) as year, 
    sum(1) as edits, 
    count(distinct(floor(rev_timestamp/1000000))) as edits_in_unique_days, 
     count(distinct(floor(rev_timestamp/1000000))) as edits_in_unique_months,    
    actor_name as user, 
    concat("[[user_talk:",page_title,"]]") as page_title 
from 
	revision_userindex, 
    actor_revision, 
    page 
where 
	page_namespace=3 
    and page_title IN ("Pxos", "Zache")  
    and rev_page=page_id 
    and rev_actor=actor_id 
    and actor_name IN ("Zache", "Pxos") 
    and page_title!=actor_name 
    and rev_timestamp>20170026132715 
group by actor_name, page_title, year;
SQL

Checking query status...
