Untitled query #90251

SQL

select transclusions, count(*) as counter from (
select replace(page_title, '_', ' ') as template, count(*) as transclusions
from page join categorylinks join linktarget join templatelinks
on cl_from = page_id
and lt_namespace = page_namespace
and lt_title = page_title
and tl_target_id = lt_id
where cl_to = "Шаблоны-карточки_по_алфавиту"
and tl_from_namespace = 0
group by page_title
order by transclusions desc
) t group by transclusions
order by transclusions asc

​x
 
select transclusions, count(*) as counter from (select replace(page_title, '_', ' ') as template, count(*) as transclusionsfrom page join categorylinks join linktarget join templatelinkson cl_from = page_idand lt_namespace = page_namespaceand lt_title = page_titleand tl_target_id = lt_idwhere cl_to = "Шаблоны-карточки_по_алфавиту"and tl_from_namespace = 0group by page_titleorder by transclusions desc) t group by transclusionsorder by transclusions asc​

SQL

Checking query status...