|  A  |  B  |  C  |  D  |  E  |  F  |  G  |  H  |  I  |  J  |  K  |  L  |  M  |  N  |  O  |  P  |  Q  |  R  |  S  |  T  |  U  |  V  |  W  |  X  |  Y  |  Z  |

Error in query - 1030 - Got error 28 from storage engine
SQL:



select count(p.id) count,
p.id id,
t1.value_de dename,
t21.value_de natdename,
UCASE(LEFT(t1.value_de,1)) stde,
t2.value_en enname,
t22.value_en natenname,
UCASE(LEFT(t1.value_en,1)) sten,
t3.value_ja janame,
t23.value_ja natjaname,
t4.value_yo yoname,
t24.value_yo natyoname,
t5.value_ys ysname,
t25.value_ys natysname,
LEFT(t1.value_ys,1) stys,
t6.value_ro roname,
UCASE(LEFT(t1.value_ro,1)) stro,
t7.value_de desecname,
t8.value_en ensecname,
t9.value_ja jasecname,
t10.value_yo yosecname,
t11.value_ys yssecname,
t12.value_ro rosecname,
t13.value_de deabr,
t14.value_en enabr,
t15.value_ja jaabr,
t16.value_yo yoabr,
t17.value_yo ysabr,
t18.value_ro roabr,
t26.value_en encomm,
t27.value_ja jacomm,
t28.value_de decomm,

wl.language_id langid,
wnal.language_id nlangid




from demglos_words p
left outer join object_textvalues_col t1 on
t1.text_id = p.name_txtid
left outer join object_textvalues_col t21 on
t21.text_id = p.natname_txtid
left outer join object_textvalues_col t2 on
t2.text_id = p.name_txtid
left outer join object_textvalues_col t22 on
t22.text_id = p.natname_txtid
left outer join object_textvalues_col t3 on
t3.text_id = p.name_txtid
left outer join object_textvalues_col t23 on
t23.text_id = p.natname_txtid
left outer join object_textvalues_col t4 on
t4.text_id = p.name_txtid
left outer join object_textvalues_col t24 on
t24.text_id = p.natname_txtid
left outer join object_textvalues_col t5 on
t5.text_id = p.name_txtid
left outer join object_textvalues_col t25 on
t25.text_id = p.natname_txtid
left outer join object_textvalues_col t26 on
t26.text_id = p.comment_txtid
left outer join object_textvalues_col t27 on
t27.text_id = p.comment_txtid
left outer join object_textvalues_col t28 on
t28.text_id = p.comment_txtid
left outer join object_textvalues_col t6 on
t6.text_id = p.name_txtid
left outer join object_textvalues_col t7 on
t7.text_id = p.secname_txtid
left outer join object_textvalues_col t8 on
t8.text_id = p.secname_txtid
left outer join object_textvalues_col t9 on
t9.text_id = p.secname_txtid
left outer join object_textvalues_col t10 on
t10.text_id = p.secname_txtid
left outer join object_textvalues_col t11 on
t11.text_id = p.secname_txtid
left outer join object_textvalues_col t12 on
t12.text_id = p.secname_txtid
left outer join object_textvalues_col t13 on
t13.text_id = p.abrev_txtid
left outer join object_textvalues_col t14 on
t14.text_id = p.abrev_txtid
left outer join object_textvalues_col t15 on
t15.text_id = p.abrev_txtid
left outer join object_textvalues_col t16 on
t16.text_id = p.abrev_txtid
left outer join object_textvalues_col t17 on
t17.text_id = p.abrev_txtid
left outer join object_textvalues_col t18 on
t18.text_id = p.abrev_txtid
left outer join objects o on
p.id = o.object_id

left outer join demglos_word_lang wl on
wl.word_id = p.id
left outer join demglos_word_nalang wnal on
wnal.word_id = p.id


where ( t1.value_de like 'A%' OR t1.value_de like 'Ä%' )

group by dename
order by dename