Untitled query #27681

SQL

select thank.uname, userids.user_id, revs.rev_timestamp
from
(select distinct uname from (
 			select replace(log_title, '_', ' ') as uname from plwiki_p.logging where log_type = 'thanks'
    		union
     		select log_user_text as uname from plwiki_p.logging where log_type = 'thanks' limit 2) send_and_rec) thank
left join 
(select user_id, user_name from plwiki_p.user) userids
on userids.user_name = thank.uname
join
(select rev_user, rev_timestamp from plwiki_p.revision) revs
on revs.rev_user = userids.user_id
SQL

Checking query status...
