Untitled query #88320

SQL

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

Checking query status...
