Error in query - 1030 - Got error 28 from storage engine
SQL:

select distinct
pp.group_id id,
t1.value_de name,
'de' lang_code,
t1.value_yo yname,
count(pp.collection_id) count
from tks_coll_groups pp
left join tks_groups p on
pp.group_id = p.id
left outer join object_textvalues_col t1 on
t1.text_id = p.name_txtid
group by group_id
order by 'name'