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'
SQL

Checking query status...
