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 '%JJMC89%') #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...
