Untitled query #69744

SQL

SET STATEMENT max_statement_time = 100 FOR
SELECT Ps.page_namespace AS rfn, Ps.page_title AS redirect, Pd.page_title AS article, actor_name AS redirector, rc_timestamp
FROM categorylinks
JOIN templatelinks ON tl_from_namespace = 0 AND tl_target_id = cl_from 
JOIN page Pd ON Pd.page_id = tl_from
JOIN redirect ON rd_title = Pd.page_title AND rd_namespace = 0
JOIN recentchanges ON rc_cur_id = rd_from AND rc_old_len - rc_new_len > 500
JOIN page Ps ON Ps.page_id = rd_from
JOIN actor ON actor_id = rc_actor
WHERE cl_to = "Shades_of_violet"
ORDER BY article, rfn, redirect, actor_name, rc_timestamp
LIMIT 1000
SQL

Checking query status...
