Polluted categories

SQL

SELECT
  p1.page_title
FROM
  page AS p1
WHERE
  p1.page_namespace = 14
  AND NOT EXISTS (
    SELECT
      1
    FROM
      templatelinks
    JOIN linktarget
    ON tl_target_id = lt_id
    WHERE
      tl_from = p1.page_id
      AND lt_namespace = 10
      AND lt_title = 'Polluted_category'
  )
  AND EXISTS (
    SELECT
      1
    FROM
      page AS p2
      JOIN categorylinks ON cl_from = p2.page_id
    WHERE
      cl_to = p1.page_title
      AND p2.page_namespace IN (2, 3)
  )
  AND EXISTS (
    SELECT
      1
    FROM
      page AS p3
      JOIN categorylinks ON cl_from = p3.page_id
    WHERE
      cl_to = p1.page_title
      AND p3.page_namespace = 0
  )
SQL

Checking query status...
