Redlinks from pages in a category

SQL

SET STATEMENT max_statement_time = 10 FOR
SELECT (SELECT Ps.page_title FROM page Ps WHERE Ps.page_id = rd_from) AS redirect, Pd.page_title AS deletee, rc_timestamp
FROM templatelinks
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
WHERE tl_from_namespace = 0 AND tl_namespace = 10 AND tl_title = "Article_for_deletion/dated"
LIMIT 2

SQL

Checking query status...