Texts without scan, ordered by number of pages

Fork of Texts without scan, ordered by number of pages by Candalua

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

SQL

select replace(concat('[[', Titolo, ']]'), '_', ' ') AS Titolo, replace(concat('[[Discussione:', d.page_title, ']]'), '_', ' ') AS Discussione, Sottopagine
from (
  select SUBSTRING_INDEX(p.page_title, '/', 1) AS Titolo, count(*) as Sottopagine
  from page p
  join categorylinks on cl_from = page_id and cl_to = 'Sottopagine_senza_versione_cartacea_a_fronte'
  where p.page_namespace = 0 
  and p.page_is_redirect = 0
  group by SUBSTRING_INDEX(p.page_title, '/', 1)
) i
left join page d on d.page_title = Titolo and d.page_namespace = 1
order by Sottopagine desc, Titolo

SQL

Checking query status...