Illegal mix of collations (latin1_swedish_ci,IMPLICIT), (utf8mb3_general_ci,COERCIBLE), (utf8mb3_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 k.kategorien='52' ORDER BY REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(text_for_sort_1.text,'ä','a~'),'Ö','O~'),'ö','o~'),'Ü','U~'),'ü','u~'),'ß','ss') LIMIT 0, 500