Untitled query #11110

SQL

USE cswiki_p;
SELECT CONCAT("Kategorie:", cat.page_title) "kategorie", pl_title "článek"
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 pl_title <> cat.page_title
AND EXISTS (SELECT * FROM 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 100;
SQL

Checking query status...
