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 'camptype',
tv2.data_lang_ja as camptype_lang,
tv3.value_ja_data as 'campopen',
tv3.data_lang_ja as campopen_lang,
tv4.value_ja_data as 'campclose',
tv4.data_lang_ja as campclose_lang,
tv5.value_ja_data as 'prisoners',
tv5.data_lang_ja as prisoners_lang,
tv6.value_ja_data as 'campnote',
tv6.data_lang_ja as campnote_lang,
tv7.value_ja_data as 'comment',
tv7.data_lang_ja as comment_lang,
tv8.value_ja_data as 'isource',
tv8.data_lang_ja as isource_lang
FROM bnd_lager 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.camptype_txtid
LEFT OUTER JOIN object_textvalues_col tv3 on tv3.text_id = p.campopen_txtid
LEFT OUTER JOIN object_textvalues_col tv4 on tv4.text_id = p.campclose_txtid
LEFT OUTER JOIN object_textvalues_col tv5 on tv5.text_id = p.prisoners_txtid
LEFT OUTER JOIN object_textvalues_col tv6 on tv6.text_id = p.campnote_txtid
LEFT OUTER JOIN object_textvalues_col tv7 on tv7.text_id = p.comment_txtid
LEFT OUTER JOIN object_textvalues_col tv8 on tv8.text_id = p.isource_txtid
ORDER BY tv1.value_ys_data