# Previous:

# * "Danger"

# * "icon"

SET @in_string = "GA";

​

USE enwiki_p;

SELECT *

FROM page

WHERE

  page_namespace = 10

  AND page_title LIKE CONCAT("%", @in_string, "%")

  AND NOT EXISTS (

    SELECT 1

    FROM categorylinks

    WHERE cl_from = page_id

      AND cl_to IN (

        "Wikipedia_GA_templates",

        # Subcategories (I wonder if implicit checking is possible)

        "GA_discussion_templates",

        "GA_talk_message_boxes",

        "GA_user_talk_message_templates",

        "Good_content_user_templates"

      )

  )

    /* AND page_title NOT LIKE "Adminstats/%"

    AND page_title NOT LIKE "Did_you_know_nominations/%"

    AND page_title NOT LIKE "Editnotices/%" */