Untitled query #87346

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 = 10 AND p.page_title = 'Romániai magyar irodalmi lexikon')
ORDER BY pl.page_namespace, pl.page_title, pt.page_namespace, pt.page_title;
SQL

Checking query status...
