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
  cl_to NOT 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
  AND page_title NOT LIKE 'Adminstats/%'
  AND page_title NOT LIKE 'Attached KML/%'
  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 /%'
  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 '%/doc'
  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 '%/rater-data.js'
SQL

Checking query status...
