Thanks senders vs receivers

SQL

use kowiki_p; 

select A.user_name as Username, A.num_edits as Edits, B.num_thanks as Thanks

from (select user_name, user_editcount as num_edits
	from user
    order by num_edits) as A
      
right 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
      limit 5000) as B
      
on A.user_name = B.log_user_text

order by A.num_edits;

/*
I want to take every person who has sent a thank in the last month and I want to know how many thanks they sent
as well as how many edits they have made (ever, as opposed to previously when I was comparing the edits for the month), 
and I want them ordered from smallest to largest number of edits
*/
SQL

Checking query status...
