Error in query - 1030 - Got error 28 from storage engine
SQL:
select p.*,
tv1.value_en_data as 'description',
tv1.data_lang_en as description_lang,
tv2.value_en_data as 'url',
tv2.data_lang_en as url_lang,
tv3_0.value_en_data as word_0,
tv3_0.data_lang_en as word_0_lang,
tv3_1.value_en_data as word_1,
tv3_1.data_lang_en as word_1_lang
FROM demglos_urls p
LEFT OUTER JOIN object_textvalues_col tv1 on tv1.text_id = p.description_txtid
LEFT OUTER JOIN object_textvalues_col tv2 on tv2.text_id = p.url_txtid
LEFT OUTER JOIN demglos_words rt3 on rt3.id = p.word_id
LEFT OUTER JOIN object_textvalues_col tv3_0 on tv3_0.text_id = rt3.name_txtid
LEFT OUTER JOIN object_textvalues_col tv3_1 on tv3_1.text_id = rt3.comment_txtid
where p.word_id = '1199' ORDER BY tv1.value_en_data