flagification ruwiki

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

SQL

SELECT
  t1.page_title AS TemplateName,
  GROUP_CONCAT(t2.page_title SEPARATOR ', ') AS Redirects
FROM page AS t1
LEFT JOIN redirect AS r ON t1.page_id = r.rd_from
LEFT JOIN page AS t2 ON r.rd_title = t2.page_title
WHERE t1.page_namespace = 10
  AND t1.page_title LIKE "Флагификация/%"
  AND t1.page_is_redirect = 0
GROUP BY t1.page_title;

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...