Untitled query #74068

SQL

SELECT
  page_id,
  page_title
FROM
  page
  LEFT JOIN linktarget ON page_namespace = lt_namespace
  AND page_title = lt_title
WHERE
  page_namespace = 10
  AND page_is_redirect = 0
  AND lt_id IS NULL
  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;
"#
SQL

Checking query status...
