~ - Quarry

SQL

#USE stop;
USE commonswiki_p;
SET @tltitle = 'Category_redirect';
SELECT p1.page_title, pl_to
FROM page p1
INNER JOIN templatelinks tl1 ON tl1.tl_from = p1.page_id AND tl1.tl_from_namespace = 14 AND tl1.tl_namespace = 10 AND tl1.tl_title = @tltitle
INNER JOIN pagelinks ON pl_from = p1.page_id AND pl_from_namespace = 14 AND pl_namespace = 14
#INNER JOIN page p2 ON p2.page_title = cl_to
#INNER JOIN templatelinks tl2 ON tl2.tl_from = p2.page_id AND tl2.tl_from_namespace = 14 AND tl2.tl_namespace = 10 AND tl2.tl_title = @tltitle
WHERE p1.page_namespace = 14
#AND p2.page_namespace = 14
LIMIT 10;
SQL

Checking query status...
