1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='

SELECT p.products_id, p.products_model, p.products_image, d.products_name, m.manufacturers_name, c.categories_id FROM products p, products_description d, manufacturers m, products_to_categories c WHERE p.products_id = d.products_id AND p.products_id = c.products_id AND m.manufacturers_id = p.manufacturers_id AND p.products_status = 1 AND d.language_id = 1 AND c.categories_id > 40 AND c.categories_id < 50 AND p.products_model = 'Piva catalá' ORDER BY products_model ASC, manufacturers_name ASC, products_name ASC

[TEP STOP]