Wikimedia Foundation Thankers

SQL

use metawiki_p;

select A.log_actor as User_ID, B.actor_name as Actor_Name, coalesce(A.num_thanks, 0) as Thanks

from (select actor_id, actor_name
      from actor
      where (actor_name like '%(WMF)%')) as B
             
left join (select log_actor, log_timestamp, count(log_actor) as num_thanks
      from logging_userindex
     where
      	 (log_action = 'thank' and log_type='thanks'
		 and log_timestamp < timestamp('2020-01-01')
          and log_timestamp >= timestamp('2019-01-01'))
      group by log_actor) as A
      
on B.actor_id = A.log_actor
order by Thanks
SQL

Checking query status...
