use enwiktionary_p;

​

select substring(page_title

                 from if(

                   instr(page_title, "/") = 0,

                   1,

                   instr(page_title, "/") - 1)

                 for length(page_title)), count(*) from pagelinks

where pl_namespace = 106 -- Rhymes

and pl_title like 'Spanish/%'

group by pl_title

limit 10;