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;
*/

select
    source_page.page_id,
    source_page.page_namespace,
    source_page.page_title,
    rd_namespace,
    rd_title,
    log_timestamp
from logging
left join redirect on rd_namespace = log_namespace and rd_title = log_title
join page as source_page on source_page.page_id = rd_from
left join page as target_page on target_page.page_namespace = rd_namespace and target_page.page_title = rd_title
where log_type = 'delete' and log_action = 'delete' and target_page.page_id is null
order by log_timestamp desc
group by source_page.page_id;
SQL

Checking query status...
