# TODO: make this work lik my section templates query, following redirects and utilizing the main article's categorization.

SET @in_string = "GA";

​

USE enwiki_p;

SELECT *

FROM page

WHERE

  page_namespace = 10

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

  AND page_title NOT LIKE "%/doc"

  AND page_title NOT LIKE "%/doc"

  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",

        # Unrelated to GAs:

        "Gaelic_games_county_navigational_boxes",

        "Gaelic_Athletic_Association_club_navigational_boxes"

      )

  )

  AND page_title NOT LIKE "CF/%" # There's GA-related templates here, but they seem deprecated

  AND page_title NOT LIKE "%-stub%"

    /* AND page_title NOT LIKE "Adminstats/%"

    AND page_title NOT LIKE "Did_you_know_nominations/%"

    AND page_title NOT LIKE "Editnotices/%" */