Error in query - 1030 - Got error 28 from storage engine
SQL:
select p.*,
tv1.value_ja_data as 'name',
tv1.data_lang_ja as name_lang,
tv2.value_ja_data as 'comment',
tv2.data_lang_ja as comment_lang
FROM bnd_ktype p
LEFT OUTER JOIN object_textvalues_col tv1 on tv1.text_id = p.name_txtid
LEFT OUTER JOIN object_textvalues_col tv2 on tv2.text_id = p.comment_txtid
ORDER BY tv1.value_ys_data