Problem preparing query (SELECT p.*, pi.* , f.`nombre` AS nombre_fabricante, pr.`nombre` AS nombre_proveedor, c.id_categoria, c.posicion FROM `productos` p LEFT JOIN `productos_idioma` pi ON (p.`id_producto` = pi.`id_producto`) LEFT JOIN `fabricantes` f ON (f.`id_fabricante` = p.`id_fabricante`) LEFT JOIN `proveedores` pr ON (pr.`id_proveedor` = p.`id_proveedor`)LEFT JOIN `productos_x_categoria` c ON (c.`id_producto` = p.`id_producto`) WHERE pi.`id_idioma` = 1 AND p.`id_producto`= ORDER BY c.posicion LIMIT 1) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY c.posicion LIMIT 1' at line 5