1267 - Illegal mix of collations (latin1_german1_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'

SELECT 1 FROM products AS p LEFT JOIN products_description AS pd ON (p.products_id = pd.products_id) LEFT OUTER JOIN specials AS s ON (p.products_id = s.products_id) AND s.status = '1' WHERE p.products_status = '1' AND pd.language_id = '2' AND ( ( pd.products_keywords LIKE ('%led%') OR pd.products_name LIKE ('%led%') OR p.products_model LIKE ('%led%') ) and ( pd.products_keywords LIKE ('%vorschaltgerät%') OR pd.products_name LIKE ('%vorschaltgerät%') OR p.products_model LIKE ('%vorschaltgerät%') ) ) GROUP BY p.products_id ORDER BY p.products_id LIMIT 1

[XT SQL Error]