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 ') AS l ON l.pro_id = p.pro_id LEFT JOIN (SELECT pro_id,precio FROM listaprecio ' at line 4