Thanks by month

SQL

use kowiki_p; 

select *

from (select rev_user_text, count(rev_user_text)
	from revision
    where
    	rev_timestamp < timestamp('2018-06-01') 
        and rev_timestamp >= timestamp('2018-05-01') 
		and rev_user_text in (select user_name from user)  
    group by rev_user_text
    order by count(rev_user_text)
      limit 5000) as A
      
left join (select log_user_text, coalesce (count(log_user_text), 0)
      from logging_userindex
      where
      	 log_action = 'thank' and log_type='thanks'
      	 and log_timestamp >= timestamp('2018-05-01')
		 and log_timestamp < timestamp('2018-06-01')
      group by log_user_text
      limit 5000) as B
      
on A.rev_user_text = B.log_user_text;
SQL

Checking query status...
