Infoboxes by number of transclusions in ruwiki

Fork of Templates with 50 or more transclusions in ruwiki by Wikisaurus

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

SQL

USE ruwiki_p;
SELECT
  CONCAT('[[ш:', REPLACE(page_title, '_', ' '), ']]'),
  (
        SELECT
            COUNT(*)
        FROM templatelinks
        WHERE tl_title = page_title
            AND tl_namespace = page_namespace
    ) as transclusion_count
FROM page
JOIN categorylinks
ON cl_from = page_id 
WHERE
  page_namespace = 10
  AND (cl_to LIKE "Шаблоны-карточки%"
    OR cl_to = "Шаблоны на основе шаблона Административная единица"
    OR cl_to = "Википедия:Шаблоны для перевода на шаблон АЕ"
    OR cl_to = "Шаблоны на основе шаблона АЕ2"
    OR cl_to = "Подстраницы шаблона Судно")
GROUP BY page_title
ORDER BY transclusion_count DESC
;

SQL

Checking query status...