Untitled query #40609

SQL

use arwiki_p;

select * from actor where actor_user = 137408;

select count(*) from revision_userindex 
where rev_actor = 39044
and rev_timestamp > 20190607134357
and rev_timestamp < 20190802134357;

select * from wikilove_log
where wll_sender = 39044
and wll_timestamp > 20190607134357
and wll_timestamp < 20190802134357;

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 = 39044
                        and log_action = 'thank'
                        and log_timestamp <=20190802134357 
                        and log_timestamp >= 20190607134357) 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...
