Untitled query #53755

SQL

SELECT page_namespace, page_title, cl_from, redirect_namespace, redirect_title FROM ( 
    SELECT cl_from, cl_sortkey, NULL AS redirect_namespace, NULL AS redirect_title FROM categorylinks
	WHERE cl_to = 'X1'
	UNION
	SELECT cl_from, cl_sortkey, page_namespace AS redirect_namespace, page_title AS redirect_title FROM redirect
	JOIN page ON page_id = rd_from
	JOIN categorylinks ON cl_to = page_title
	WHERE rd_title = 'X1' AND rd_namespace = 14
) AS temp
JOIN page ON cl_from = page_id
LEFT JOIN category ON cat_id = page_id AND page_namespace = 14
ORDER BY cl_sortkey
SQL

Checking query status...
