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/100000000))) 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>20150026132715 

group by actor_name, page_title, year;

​