SELECT *

FROM page p1

WHERE p1.page_is_redirect = 0

  AND p1.page_namespace = 0

  AND NOT EXISTS (SELECT 1

                  FROM categorylinks

                  JOIN page p2

                    ON p2.page_title = cl_to AND p2.page_namespace = 14

                  WHERE cl_from = p1.page_id

                    AND NOT EXISTS (SELECT 1

                                    FROM page_props

                                    WHERE pp_page = p2.page_id AND pp_propname = 'hiddencat'))

LIMIT 100;