Number of thanks in year

SQL

use kowiki_p; 

select A.rev_user as ID, A.num_edits as Edits, coalesce(B.num_thanks, 0) as Thanks

from (select user_id, user_name
  from user) as C
      
join (select rev_user, rev_user_text, count(rev_user) as num_edits
	from revision
    where
    	rev_timestamp < timestamp('2018-06-01') 
        and rev_timestamp >= timestamp('2017-05-01') 
		and rev_user != 0 
    group by rev_user
    order by count(rev_user)) as A
on A.rev_user = C.user_id

left join (select count(distinct *) 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('2017-05-01')) as B 
on B.log_user_text = C.user_name
or B.log_user_text = A.rev_user_text

order by Edits;
SQL

Checking query status...
