select

    page_id,

    page_title

from page

where

    page_namespace = 1

    and page_title not in (

        select pl_title

        from pagelinks

        where pl_from = 65539331 -- User:MajavahBot/DYK blurb not found

        and pl_namespace = 1

    )

    and exists (

        select 1

        from categorylinks

        where cl_from = page_id

        and cl_to = "Pages_with_a_missing_DYK_entry"

    )

    and exists (

        select 1

        from templatelinks

        where tl_from = page_id

    )

order by page_title;

​