Untitled query #62024

SQL

SELECT
  page_id,
  page_is_redirect,
  page_title
FROM
  page
  LEFT JOIN templatelinks ON page_namespace = tl_namespace
  AND page_title = tl_title
  JOIN categorylinks ON page_id = cl_from
WHERE
  NOT cl_to IN (
    'Wikipedia_substituted_templates',
    'Wikipedia_transclusionless_templates',
    'Deprecated_templates_kept_for_historical_reasons',
    'Inactive project pages',
    'Parameter_shared_content_templates',
    'Administrative service award templates',
    'Computer language user templates',
    'Language user templates',
    'Level-zero userbox templates',
    'Wikipedia administrator statistics',
    'Subtemplates of Template RussiaAdmMunRef',
    'Subtemplates of Template RussiaBasicLawRef',
    'New Pages Feed templates',
    'Templates for deletion'
  )
  AND page_namespace = 10
  AND page_is_redirect != 1
  AND tl_from IS NULL;
SQL

Checking query status...
