Top Staff Thankers

SQL

use mediawikiwiki_p;

select B.user_editcount as Edit_Count, A.log_actor as User_ID, A.log_timestamp as Thank_Time, B.user_name as User_Name

from (select log_actor, log_timestamp
      from logging_userindex
      where (log_action = 'thank' and log_type='thanks'
             and log_timestamp < timestamp('2020-02-01')
             and log_timestamp >= timestamp('2019-01-01'))) as A

join (select user_editcount, user_id, user_name
      from user
      where (user_name like '%WMF%')) as B
      #where (user_name like '%_(WMF)%')) as B
      
 on A.log_actor = B.user_id
 order by B.user_editcount, A.log_actor
SQL

Checking query status...
