SELECT, r.text_id, b.brand,,p.shorttext, p.bodytext, p.cartype, p.image, p.image_drawing, p.image_extra, p.manual, i.interface, i.type , c.cyl, l.cap ,,,, r.extratext, r.firstimage, specs.specstable, specs.bodytext as specstext, curve.caption, curve.curvetable, CONCAT_WS('-',,c.cyl, CASE l.cap WHEN 'R' THEN 'R' WHEN 'A' THEN 'A' END,, CASE WHEN 1 THEN 'POS' END, CASE 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 LEFT JOIN new_productstext p ON LEFT JOIN new_specs_tables specs ON r.specs_id = LEFT JOIN new_curve_tables curve ON r.curve_id = LEFT JOIN new_interface i ON LEFT JOIN new_cyls c ON LEFT JOIN new_caps l ON LEFT JOIN new_maps m ON WHERE = "123\\CITROEN-6∩=R" AND IS NULL AND earth = "0" ORDER BY LIMIT 1;
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='