Thanks by month

SQL

use kowiki_p; 

select A.rev_user_text as Username, A.num_edits as Edits, coalesce(B.num_thanks, 0) as Thanks

from (select rev_user_text, count(rev_user_text) as num_edits
	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)) as A
      
left join (select log_user_text, count(log_user_text) as num_thanks
      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) as B
      
on A.rev_user_text = B.log_user_text;
SQL

Checking query status...
