Untitled query #27779

This query is marked as a draft This query has been published by Maximilianklein.

SQL

select timestamp,
            receiver, 
            ru.user_id as receiver_id,
            sender,
            su.user_id as sender_id
    from
    (select log_timestamp as timestamp, replace(log_title, '_', ' ') as receiver, log_user_text as sender from hewiki_p.logging where log_type = 'thanks') t
    left join hewiki_p.user ru on ru.user_name = t.receiver
    left join hewiki_p.user su on su.user_name = t.sender
 	where
    	timestamp < 20180601000000

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...