Error in query - 1030 - Got error 28 from storage engine
SQL:
select p.*,
tv1_0.value_ja_data as collection_0,
tv1_0.data_lang_ja as collection_0_lang,
tv1_1.value_ja_data as collection_1,
tv1_1.data_lang_ja as collection_1_lang,
tv2_0.value_ja_data as group_0,
tv2_0.data_lang_ja as group_0_lang,
rt2.code as group_1
FROM tks_coll_groups p
LEFT OUTER JOIN tks_collections rt1 on rt1.id = p.collection_id
LEFT OUTER JOIN object_textvalues_col tv1_0 on tv1_0.text_id = rt1.name_txtid
LEFT OUTER JOIN object_textvalues_col tv1_1 on tv1_1.text_id = rt1.namecomm_txtid
LEFT OUTER JOIN tks_groups rt2 on rt2.id = p.group_id
LEFT OUTER JOIN object_textvalues_col tv2_0 on tv2_0.text_id = rt2.name_txtid
where p.collection_id = '193' ORDER BY group_1