Untitled query #36631

SQL

use enwiki_p;
select thank_timestamp, receiver, ru.user_id as receiver_id, a.actor_name as sender, a.actor_user as sender_id from
                        (select log_timestamp as thank_timestamp, replace(log_title, '_', ' ') as receiver, log_actor
                        from logging_userindex
                        where log_actor = (select actor_id from actor where actor_name = 'Nick Moyes')
                        and log_action = 'thank'
                        and log_timestamp <= 20190101000000
                        and log_timestamp >= 20180101000000) t
                    left join user ru on ru.user_name = t.receiver
                    left join actor a on a.actor_id = t.log_actor
SQL

Checking query status...
