Wikimedia Foundation Thankers

SQL

use enwiki_p;

select B.user_editcount as Edit_Count, A.log_actor as User_ID, B.user_name as User_Name, coalesce(A.num_thanks, 0) as Thanks

from (select user_editcount, user_id, user_name
      from user
      where (user_name like '%LZia%')) 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('2016-01-01')
      group by log_actor) as A
      
 on B.user_id = A.log_actor
 order by B.user_id
SQL

Checking query status...
