flagification ruwiki

SQL

SELECT
  CONCAT('[[Шаблон:', SUBSTRING(lt.page_title, 14), ']]') AS TemplateName,
  GROUP_CONCAT(DISTINCT CONCAT('[[', p2.page_title, ']]') SEPARATOR ', ') AS UsedInPages,
  COUNT(DISTINCT CONCAT(p2.page_namespace, ':', p2.page_title)) AS UsageCount
FROM templatelinks AS t
INNER JOIN page AS lt ON lt.page_id = t.tl_from
LEFT JOIN page AS p2 ON t.tl_from = p2.page_id
WHERE lt.page_namespace = 10
  AND lt.page_title LIKE "Флагификация/%"
  AND p2.page_content_model = "wikitext"
  AND p2.page_namespace = 0
GROUP BY lt.page_title
LIMIT 300;
SQL

Checking query status...
