SELECT r.id, r.text_id, b.brand, p.name,p.shorttext, p.bodytext, p.cartype, p.image, p.image_drawing, p.image_extra, p.manual, i.interface, i.type , c.cyl, l.cap , m.map, r.earth, r.ie, r.extratext, r.firstimage, specs.specstable, specs.bodytext as specstext, curve.caption, curve.curvetable, CONCAT_WS('-',p.name,c.cyl, CASE l.cap WHEN 'R' THEN 'R' WHEN 'A' THEN 'A' END, m.map, CASE r.earth WHEN 1 THEN 'POS' END, CASE r.ie WHEN 1 THEN 'IE' END ) AS prodname, r.brands_id,r.text_id,r.interface_id,r.specs_id,r.curve_id,r.cyls_id,r.caps_id,r.maps_id,r.onhomepage,r.avtiveFrom,r.avtiveUntill FROM new_products_rel r LEFT JOIN new_brands b ON r.brands_id=b.id LEFT JOIN new_productstext p ON r.text_id=p.id LEFT JOIN new_specs_tables specs ON r.specs_id = specs.id LEFT JOIN new_curve_tables curve ON r.curve_id = curve.id LEFT JOIN new_interface i ON r.interface_id=i.id LEFT JOIN new_cyls c ON r.cyls_id=c.id LEFT JOIN new_caps l ON r.caps_id=l.id LEFT JOIN new_maps m ON r.maps_id=m.id WHERE p.name = "123\\CITROEN-6∩=R" AND m.map IS NULL AND earth = "0" ORDER BY p.name LIMIT 1;
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='