use metawiki_p;

select concat("https://meta.wikimedia.org/wiki/Grants:", page_title) as p from page

where page_namespace = 200

and page_is_redirect = 0

and page_title not in (

  "Reporting",

  "Policies",

  "Annual",

  "APG",

  "IEG",

  "PEG",

  "TPS",

  "Simple",

  "Project",

  "Conference",

  "IdeaLab",

  "Start",

  "Wikimania_2016_bids",

  "Completing_your_grant",

  "Requests",

  "Administration",

  "Principles",

  /* accounted for in another query */

  "Evaluation",

  "Learning_patterns"

)

and page_title not like "APG/%"

and page_title not like "IEG/%"

and page_title not like "PEG/%"

and page_title not like "TPS/%"

and page_title not like "Simple/%"

and page_title not like "Project/%"

and page_title not like "Conference/%"

and page_title not like "IdeaLab/%"

and page_title not like "Start/%"

and page_title not like "Wikimania_2016_bids/%"

and page_title not like "Completing_your_grant/%"

and page_title not like "Requests/%"

and page_title not like "Administration/%"

and page_title not like "Principles/%"

/* accounted for in another query */

and page_title not like "Evaluation/%"

and page_title not like "Learning_patterns/%"

​

order by p