Top Staff Thankers

SQL

use itwiki_p;

select B.user_editcount as Edit_Count, A.log_user_text as User_Name, A.log_timestamp as Thank_Time

from (select log_user_text, log_timestamp
      from logging_userindex
      where (log_action = 'thank' and log_type='thanks'
             and log_timestamp < timestamp('2018-06-01')
             and log_timestamp >= timestamp('2017-06-01'))) as A

join (select user_editcount, user_name
      from user) as B
      
 on A.log_user_text = B.user_name
 order by B.user_editcount, A.log_user_text
 
 
 
use eswiki_p;

#select A.user_name, A.user_editcount, coalesce(C.num_thanks, 0) as Thanks
select A.user_name
from 

	(select user_id, user_name, user_registration, user_editcount
    from user
	where
		(user_registration < timestamp('2018-04-01')
    	and
    	user_registration >= timestamp('2018-03-01')
    	and
        user_editcount > 0)) as A
        
    left join 
    (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-05-01')
         	and log_timestamp >= timestamp('2018-03-01'))
      	group by log_title) as C
    on A.user_name = C.log_title
        
    #left join
   	#join
    #(select rev_user_text, rev_timestamp
    #	from revision
    #    where
    #		(rev_timestamp < timestamp('2018-06-01') and rev_timestamp >= timestamp('2018-05-01'))
    #	group by rev_user_text) as B
    #on A.user_name = B.rev_user_text
    
    where (C.log_title is null)
    limit 10000;
           #and
           #B.rev_user_text is null)
    #order by Thanks
    #limit 4000;
SQL

Checking query status...
