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 |

A

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

select distinct
pp.keyword_id id,
t1.value_de name,
'de' lang_code,
t1.value_yo yname,
count(pp.seite_id) count
from bnd_seite_keyword pp
left join bnd_keyword p on
pp.keyword_id = p.id
left outer join object_textvalues_col t1 on
t1.text_id = p.name_txtid
where p.ktype_id <> 1 AND ( t1.value_de like 'A%' OR t1.value_de like 'Ä%' )
group by keyword_id
order by name