SELECT

  page_id,

  page_title

FROM

  page

LEFT JOIN linktarget ON page_namespace = lt_namespace

  AND page_title = lt_title

LEFT JOIN templatelinks ON tl_target_id=lt_id AND tl_from <> page_id

WHERE

  page_namespace = 10

  AND page_is_redirect = 0

  AND tl_target_id IS NULL

  AND page_title NOT LIKE "Adminstats/%"

  AND page_title NOT LIKE "AfC\_%"

  AND page_title NOT LIKE "Cite\_doi/%"

  AND page_title NOT LIKE "Cite\_pmid/%"

  AND page_title NOT LIKE "Did\_you\_know\_nominations/%"

  AND page_title NOT LIKE "Editnotices/%"

  AND page_title NOT LIKE "PBB/%"

  AND page_title NOT LIKE "POTD\_caption/%"

  AND page_title NOT LIKE "POTD\_credit/%"

  AND page_title NOT LIKE "POTD\_protected/%"

  AND page_title NOT LIKE "TemplateStyles\_sandbox/%"

  AND page_title NOT LIKE "TFA\_title/%"

  AND page_title NOT LIKE "User\_%"

  AND page_title NOT LIKE "%/testcases"

  AND page_title NOT LIKE "%/sandbox"

  AND page_title NOT LIKE "%/rater-data.js"

  AND page_title NOT LIKE "%-stub"

  AND page_title NOT IN (

    SELECT

      page_title

    FROM

      page

      JOIN categorylinks ON page_id = cl_from

    WHERE

      cl_to IN (

        'Wikipedia_substituted_templates',

        'Wikipedia_transclusionless_templates',

        'Deprecated_templates_kept_for_historical_reasons',

        'Inactive_project_pages',

        'Parameter_shared_content_templates',

        'Computer_language_user_templates',

        'Language_user_templates',

        'Template_test_cases',

        'Template_sandboxes',

        'Level-zero_userbox_templates',

        'Templates_for_deletion'

      )

      AND page_namespace = 10

  )

ORDER BY

  page_title ASC;

​