Thanks by year

SQL

use kowiki_p; 

select A.rev_user as ID, A.num_edits as Edits, coalesce(B.num_thanks, 0) as Thanks, C.user_name, C.user_id
      
from (select log_title, count(log_title) as num_thanks
      from logging_userindex
      where
      	 log_action = 'thank' and log_type='thanks'
		 and log_timestamp < timestamp('2018-06-01')
         and log_timestamp >= timestamp('2018-05-01')
      group by log_title) as B
 
join (select user_id, user_name
  from user) as C
on B.log_title = C.user_name
      
     
join (select rev_user, count(rev_user) as num_edits
	from revision
    where
    	rev_timestamp < timestamp('2018-06-01') 
        and rev_timestamp >= timestamp('2018-05-01') 
		and rev_user != 0 
    group by rev_user
    order by count(rev_user)) as A
      
on A.rev_user = C.user_id;
SQL

Checking query status...
