USE hewiki_p;

SELECT p1.page_id as 'from', p1.page_title as 'from title' , p2.page_id as 'to', c1.cl_to as 'to title'

FROM page as p1 JOIN categorylinks as c1 JOIN page as p2

ON p1.page_namespace = 14 AND p1.page_id=c1.cl_from AND c1.cl_to = p2.page_title AND p2.page_namespace = 14

AND EXISTS (SELECT * FROM categorylinks as c2 JOIN page as p3

            ON c1.cl_from = c2.cl_from AND (c2.cl_to = 712782 OR c2.cl_to = 712781 OR c2.cl_to = 504284)

           )

​