Untitled query #11110

SQL

USE cswiki_p;
SELECT CONCAT("Kategorie:", cat.page_title) "kategorie", pl_title "článek", cat.page_title "přesměrování"
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 page AS rd WHERE page_namespace = 0 AND page_title = cat.page_title)
AND cat.page_title NOT LIKE "Absolventi%"
AND cat.page_title NOT LIKE "%&_podle&_%" ESCAPE "&"
ORDER BY přesměrování
LIMIT 100;
SQL

Checking query status...
