use kowiki_p; 

​

#select A.rev_user as ID, A.num_edits as Edits, coalesce(B.num_thanks, 0) as Thanks, C.user_name, C.user_id, A.rev_user_text, B.log_title

select B.log_title, C.user_name

​

from (select log_title, count(log_title) as num_thanks

      from logging_userindex

      where

         log_action = 'thank' and log_type='thanks'

         and log_timestamp < timestamp('2018-06-01')

         and log_timestamp >= timestamp('2018-05-01')

      group by log_title) as B

left join (select user_id, user_name

  from user) as C

on B.log_title = C.user_name

#right join (select rev_user, rev_user_text, count(rev_user) as num_edits

#   from revision

#    where

#       rev_timestamp < timestamp('2018-06-01') 

#        and rev_timestamp >= timestamp('2018-05-01') 

#       and rev_user != 0 

#    group by rev_user

#    order by count(rev_user)) as A

on A.rev_user = C.user_id;