Which languages have the most terms with redundant head parameter

SQL

select language, count, lemma_count, round(cast(count as float) / cast(lemma_count as float), 2) as fraction from (
  select language, count(*) as count
  from (
    select substring(cl_to, 1, instr(cl_to, '_terms_with_redundant_head_parameter') - 1) as language
    from categorylinks
    where cl_to like '%\_terms\_with\_redundant\_head\_parameter'
  ) as category_appearances
  group by language
  order by count desc
) as languages
left join (
  select lemma_language, count(*) as lemma_count
  from (
    select
    	substring(cl_to, 1, instr(cl_to, '_lemmas') - 1) as lemma_language
    from categorylinks
    where cl_to like '%\_lemmas'
  ) as entries
) as entries
on lemma_language = language;

SQL

Checking query status...