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
      
join (select log_user_text, count(log_user_text)
      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;
    
/*
add a column for the number of thanks given by the user in the past month
count rev_user_text = log_user_text, select * 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')
*/
SQL

Checking query status...
