Untitled query #70673

SQL

SELECT page_title, r.rev_timestamp
FROM page
LEFT JOIN revision r
    on r.rev_page = page.page_id
    AND r.rev_timestamp = (
      SELECT min(rev_timestamp) from revision
      where rev_page = page_id
    )
LEFT JOIN templatelinks t
	ON t.tl_namespace=10 AND t1.tl_title=page_title
WHERE page_namespace=10
	AND r.rev_timestamp < 20180101000000
	AND t1.tl_from IS NULL
	AND page_is_redirect=0
	AND page_title NOT LIKE '%/sandbox%'
	AND page_title NOT LIKE '%/testcases%'
    AND page_title NOT LIKE '%stub'
    AND page_title NOT LIKE '%/doc'
    AND page_title NOT LIKE 'Attached_KML%'
    AND page_title NOT LIKE '%Did_you_know_nominations%'
    AND page_title NOT LIKE '%Editnotices%'
    AND page_title NOT LIKE '%/preload%'
    AND page_title NOT LIKE '%/editintro%'
    AND page_title NOT LIKE '%PBB/%'
    AND page_title NOT LIKE '%Huggle/%'
    AND page_title NOT LIKE '%POTD%'
    AND page_title NOT LIKE '%TFA_title%'
    AND page_title NOT LIKE '%User_%'
    AND page_title NOT LIKE '%Adminstats%'
    AND page_title NOT LIKE '%safesubst%'
    AND page_title NOT LIKE '%Wikiproject%'
    AND page_title NOT LIKE '%GeoTemplate/%'
    AND page_title NOT LIKE '%rater-data.js%'
    AND page_title NOT LIKE '%Db-%'  
    AND page_title NOT LIKE '%IPA-%'
    AND page_title NOT LIKE '%IPA chart%'
    AND page_title NOT LIKE '%S-line%'  
    AND page_title NOT LIKE '%Rail-interchange/doc/%'
    AND NOT EXISTS (SELECT 1 from page_props pp
                    WHERE pp.pp_page = page_id 
                    AND pp.pp_propname = "disambiguation")
    AND NOT EXISTS (SELECT 1 FROM categorylinks cl
					WHERE cl.cl_from=page_id
                        AND cl.cl_to IN ("Wikipedia_substituted_templates", "Wikipedia_templates_to_be_automatically_substituted", "Wikipedia_soft_redirects",
                                         "Templates_for_deletion","Language_icon_templates", "Expand_by_language_Wikipedia_templates",
                                         "Templates_used_by_Twinkle", "TestTemplates", "Sandbox_templates", "Wikipedia_soft_redirected_templates",
                                         "Cleanup_templates")
					LIMIT 1)
ORDER BY page_title
SQL

Checking query status...
