Wikimedia Foundation Thankers

SQL

use enwiki_p; #next, see if Pine has thanks on metawiki_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

select user_editcount, user_id, user_name #from parenth
      from user
      where (user_name like '%Trizek%') #as B
             
#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('2015-01-01')
#         and log_actor = '24812038')
#      group by log_actor #as A
      
# on B.user_id = A.log_actor
# order by Thanks
SQL

Checking query status...
