Untitled query #11110

SQL

USE cswiki_p;
DESCRIBE redirect;
SELECT *
FROM (SELECT * FROM pagelinks WHERE pl_from_namespace = 14 AND pl_namespace = 0) AS pl
JOIN page AS cat ON cat.page_id = pl_from
WHERE EXISTS (SELECT page AS pg WHERE pg.page_title = pl_title AND pg.page_namespace = pl_namespace
              AND pg.page_id IN (SELECT cl_from FROM categorylinks WHERE cl_to = cat.page_title)
AND NOT EXISTS (SELECT * FROM redirect WHERE rd_title = pl_title AND rd_namespace = pl_namespace
                AND rd_from IN (SELECT page_id FROM page AS rd
                                WHERE page_is_redirect = 1 AND page_namespace = 0 AND page_title = cat.page_title))
LIMIT 5;
SQL

Checking query status...
