SQL
AخA
SET STATEMENT max_statement_time = 1000 FOR
SELECT Ps.page_title, Pd.page_title, 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 100;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.