Error in query - 1030 - Got error 28 from storage engine
SQL:
select p.*,
rt1.id as seite_0,
tv1_1.value_de_data as seite_1,
tv1_1.data_lang_de as seite_1_lang,
tv1_2.value_de_data as seite_2,
tv1_2.data_lang_de as seite_2_lang,
rt2.id as seite2_0,
tv2_1.value_de_data as seite2_1,
tv2_1.data_lang_de as seite2_1_lang,
tv2_2.value_de_data as seite2_2,
tv2_2.data_lang_de as seite2_2_lang
FROM bnd_seite_seite p
LEFT OUTER JOIN bnd_seite rt1 on rt1.id = p.seite_id
LEFT OUTER JOIN object_textvalues_col tv1_1 on tv1_1.text_id = rt1.name_txtid
LEFT OUTER JOIN bnd_band srt1 on srt1.id = rt1.band_id
LEFT OUTER JOIN object_textvalues_col tv1_2 on tv1_2.text_id = srt1.name_txtid
LEFT OUTER JOIN bnd_seite rt2 on rt2.id = p.seite2_id
LEFT OUTER JOIN object_textvalues_col tv2_1 on tv2_1.text_id = rt2.name_txtid
LEFT OUTER JOIN bnd_band srt2 on srt2.id = rt2.band_id
LEFT OUTER JOIN object_textvalues_col tv2_2 on tv2_2.text_id = srt2.name_txtid
where p.seite_id = '103' ORDER BY tv2_2.value_de_data