Illegal mix of collations (latin1_swedish_ci,IMPLICIT), (utf8_general_ci,COERCIBLE), (utf8_general_ci,COERCIBLE) for operation 'replace'
SELECT SQL_CALC_FOUND_ROWS a.id, a.name, a.text, a.preis, a.bild FROM (zeppelin_artikel AS a, zeppelin_artikel_kat AS k) LEFT JOIN zeppelin__fix_text AS text_for_sort_1 ON (text_for_sort_1.id = MID(a.name,7) AND text_for_sort_1.sprache=2) WHERE (k.artikel = a.id) AND a.status != 3 AND a.status=2 ORDER BY REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(text_for_sort_1.text,'','a~'),'','O~'),'','o~'),'','U~'),'','u~'),'','ss') LIMIT 0, 500