SELECT

    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

WHERE

    pl_namespace IS NULL AND

    page_namespace = 0 AND

    page_is_redirect = 0 AND

    tl_namespace IS NULL

;