|
|||||||||||||||
| Error in query - 1030 - Got error 28 from storage engine SQL: select p.*, tv1_0.value_de_data as lager_0, tv1_0.data_lang_de as lager_0_lang, tv2_0.value_de_data as band_0, tv2_0.data_lang_de as band_0_lang, tv2_1.value_de_data as band_1, tv2_1.data_lang_de as band_1_lang, tv3_0.value_de_data as caveat_0, tv3_0.data_lang_de as caveat_0_lang, tv3_1.value_de_data as caveat_1, tv3_1.data_lang_de as caveat_1_lang, tv4_0.value_de_data as medium_0, tv4_0.data_lang_de as medium_0_lang, tv4_1.value_de_data as medium_1, tv4_1.data_lang_de as medium_1_lang, tv5.value_de_data as 'name', tv5.data_lang_de as name_lang, tv6.value_de_data as 'name2', tv6.data_lang_de as name2_lang, tv7.value_de_data as 'comment', tv7.data_lang_de as comment_lang, tv8.value_de_data as 'comment2', tv8.data_lang_de as comment2_lang FROM bnd_seite p LEFT OUTER JOIN bnd_lager rt1 on rt1.id = p.lager_id LEFT OUTER JOIN object_textvalues_col tv1_0 on tv1_0.text_id = rt1.name_txtid LEFT OUTER JOIN bnd_band rt2 on rt2.id = p.band_id LEFT OUTER JOIN object_textvalues_col tv2_0 on tv2_0.text_id = rt2.name_txtid LEFT OUTER JOIN bnd_reihe srt2 on srt2.id = rt2.reihe_id LEFT OUTER JOIN object_textvalues_col tv2_1 on tv2_1.text_id = srt2.name_txtid LEFT OUTER JOIN bnd_caveat rt3 on rt3.id = p.caveat_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 LEFT OUTER JOIN bnd_medium rt4 on rt4.id = p.medium_id LEFT OUTER JOIN object_textvalues_col tv4_0 on tv4_0.text_id = rt4.name_txtid LEFT OUTER JOIN object_textvalues_col tv4_1 on tv4_1.text_id = rt4.comment_txtid LEFT OUTER JOIN object_textvalues_col tv5 on tv5.text_id = p.name_txtid LEFT OUTER JOIN object_textvalues_col tv6 on tv6.text_id = p.name2_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.comment2_txtid where p.medium_id = '7' ORDER BY tv5.value_de_data |