Error in query - 1030 - Got error 28 from storage engine SQL:
select
p.id id,
t1.value_de_data name,
'de_data' lang_code,
t2.value_de_data description,
institution_id,
sort
from tks_collections p
left join tks_coll_groups pp
on pp.collection_id = p.id
left outer join object_textvalues_col t1 on
t1.text_id = p.name_txtid
left outer join object_textvalues_col t2 on
t2.text_id = p.description_txtid
where group_id='69'
order by name
|