Redirects to deleted pages with information on last deletion in English Wiktionary

SQL

SELECT
  source_page.page_namespace,
  source_page.page_title,
  target_page.page_namespace,
  target_page.page_title
FROM redirect AS rd
JOIN page source_page
ON rd.rd_from = source_page.page_id
LEFT JOIN page AS target_page
	ON rd_namespace = target_page.page_namespace AND rd_title = target_page.page_title
LEFT JOIN logging_logindex
	on log_type = 'delete' AND log_action = 'delete' AND log_namespace = target_page.page_namespace AND log_title = target_page.page_title
WHERE rd_namespace >= 0
	AND target_page.page_id IS NULL
    AND log_title IS NOT NULL
LIMIT 10;

SQL

Checking query status...