日刊電報通信
[ボリューム]
Error in query - 1030 - Got error 28 from storage engine
SQL:
select p.*,
tv1_0.value_ja_data as reihe_0,
tv1_0.data_lang_ja as reihe_0_lang,
tv1_1.value_ja_data as reihe_1,
tv1_1.data_lang_ja as reihe_1_lang,
tv2.value_ja_data as 'name',
tv2.data_lang_ja as name_lang,
tv3.value_ja_data as 'comment',
tv3.data_lang_ja as comment_lang
FROM bnd_band p
LEFT OUTER JOIN bnd_reihe rt1 on rt1.id = p.reihe_id
LEFT OUTER JOIN object_textvalues_col tv1_0 on tv1_0.text_id = rt1.name_txtid
LEFT OUTER JOIN object_textvalues_col tv1_1 on tv1_1.text_id = rt1.comment_txtid
LEFT OUTER JOIN object_textvalues_col tv2 on tv2.text_id = p.name_txtid
LEFT OUTER JOIN object_textvalues_col tv3 on tv3.text_id = p.comment_txtid
where p.reihe_id = '1' ORDER BY tv2.value_ys_data
| |
