Untitled query #88320

SQL

SELECT
  p1.page_title
FROM
  page AS p1
LEFT JOIN templatelinks tl ON tl.tl_from = p1.page_id
LEFT JOIN linktarget lt ON tl.tl_target_id = lt.lt_id AND lt.lt_namespace = 10 AND lt.lt_title = 'Polluted_category'
LEFT JOIN categorylinks cl1 ON cl1.cl_to = p1.page_title
LEFT JOIN page p2 ON p2.page_id = cl1.cl_from AND p2.page_namespace IN (2, 3)
LEFT JOIN categorylinks cl2 ON cl2.cl_to = p1.page_title
LEFT JOIN page p3 ON p3.page_id = cl2.cl_from AND p3.page_namespace = 0
WHERE
  p1.page_namespace = 14
  AND lt.lt_id IS NULL
  AND cl1.cl_from IS NOT NULL
  AND cl2.cl_from IS NOT NULL
LIMIT 1000;
SQL

Checking query status...
