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, u.* 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 > CONVERT(date_format(date_sub(CURRENT_TIMESTAMP(), interval 30 day), '%Y%m%d%H%i%s'), UNSIGNED INTEGER)-30*86400
-- group by a.user_name
limit 50;
SQL

Checking query status...
