finding /meta/color redirects

This query is marked as a draft This query has been published by Primefac.

Following https://en.wikipedia.org/wiki/Wikipedia:Templates_for_discussion/Log/2021_August_26#Political_shortname_and_color_templates there are a large number of templates with a /meta/color suffix that need to be merged into a single module. This Quarry gives all redirects to those templates so that they can be included in the module.

SQL

select page_id, page_title, rd_title from redirect 
inner join page on rd_from = page_id
where rd_namespace = 10 and rd_title LIKE '%/meta/color'

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...