/* SLOW_OK */

SELECT page_id, page_namespace, page_title

FROM page

​

    LEFT JOIN pagelinks

        ON pl_namespace = page_namespace

            AND pl_title = page_title

    LEFT JOIN templatelinks

        ON tl_namespace = page_namespace

            AND tl_title = page_title

    LEFT JOIN categorylinks

    ON cl_from = page_id

        AND cl_to = ('All_set_index_articles' AND 'All_article_disambiguation_pages' AND 'All_orphaned_articles')

WHERE   pl_namespace IS NULL

    AND page_is_redirect = 0

    AND cl_to IS NULL

LIMIT 10;