Which languages have the most terms with redundant head parameter

SQL

select language, count, lemma_count 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)
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 lemmas
  group by lemma_language
) as lemmas
on lemma_language = language;

SQL

Checking query status...