Beillesztett névtérközi átirányítások

SQL

SELECT pl.page_namespace, pl.page_title, pt.page_namespace, pt.page_title
FROM templatelinks t
INNER JOIN linktarget l ON l.lt_id = t.tl_target_id
INNER JOIN page pt ON t.tl_from = pt.page_id
INNER JOIN page pl ON l.lt_namespace = pl.page_namespace AND l.lt_title = pl.page_title
WHERE (pl.page_namespace, pl.page_title) IN
	(SELECT p.page_namespace, p.page_title
	FROM page p
	INNER JOIN redirect r ON r.rd_from = p.page_id
	WHERE p.page_namespace != r.rd_namespace AND p.page_namespace NOT IN (2, 3))
ORDER BY pl.page_namespace, pl.page_title;

SQL

Checking query status...