Sondersammlungen


 |  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  |

E

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

select p.id id,
t1.value_de name,
'de' lang_code,
t1.value_yo yname,
t2.value_de namecomm,
left(t1.value_de,1) lname,
left(t1.value_yo,1) lyname,
institution_id,
sort
from tks_collections p
left outer join object_textvalues_col t1 on
t1.text_id = p.name_txtid
left outer join object_textvalues_col t2 on
t2.text_id = p.namecomm_txtid
where ( t1.value_de like 'E%' OR t1.value_de like 'Ē%' )
order by name