Untitled query #59330

SQL

select a.user_name, max(rev_timestamp) from revision r inner join (
select actor_id, u.user_name from actor a inner join (
select user_id, u.user_name from user u inner join
(select replace(page_title,'_',' ') user_name from page p
inner join (select tl_from pid from templatelinks where tl_title='Retired' and tl_namespace=10) user1 on p.page_id=user1.pid
 where p.page_namespace=2 and p.page_title not like '%/%') p on u.user_name = p.user_name
) u on a.actor_user=u.user_id
) a on a.actor_id = r.rev_actor and r.rev_timestamp > UNIX_TIMESTAMP() - 30*86400
limit 50;
SQL

Checking query status...
