Stich u. Schlagworte
| 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
|
D
Error in query - 1030 - Got error 28 from storage engine SQL:
select distinct
pp.keyword_id id,
pp.stichwort_id stid,
p.type_id typid,
t1.value_de name,
'de' lang_code,
t1.value_ys yname,
count(pp.collection_id) count
from tks_coll_keywords pp
left join tks_keywords p on
pp.keyword_id = p.id
left outer join object_textvalues_col t1 on
t1.text_id = p.name_txtid
where p.type_id <> 1 AND ( t1.value_de like 'D%' )
group by keyword_id
order by name
|