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 'description',
tv2.data_lang_ja as description_lang,
tv3.value_ja_data as 'street',
tv3.data_lang_ja as street_lang,
tv4.value_ja_data as 'city',
tv4.data_lang_ja as city_lang,
tv5_0.value_ja_data as pref_0,
tv5_0.data_lang_ja as pref_0_lang,
tv6.value_ja_data as 'access',
tv6.data_lang_ja as access_lang
FROM tks_institutions 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.description_txtid
LEFT OUTER JOIN object_textvalues_col tv3 on tv3.text_id = p.street_txtid
LEFT OUTER JOIN object_textvalues_col tv4 on tv4.text_id = p.city_txtid
LEFT OUTER JOIN tks_prefectures rt5 on rt5.id = p.pref_id
LEFT OUTER JOIN object_textvalues_col tv5_0 on tv5_0.text_id = rt5.name_txtid
LEFT OUTER JOIN object_textvalues_col tv6 on tv6.text_id = p.access_txtid
where p.pref_id = '40' ORDER BY tv1.value_ys_data