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 'FROM SS_products p ON (ki.productID=p.productID) LEFT J' at line 3 SQL query : SELECT p.productID, p.name, Price, p.url, c.discount_products, c.discount_products_inherited, c.parent, r.source AS route FROM SS_product_kit_items ki LEFT FROM SS_products p ON (ki.productID=p.productID) LEFT JOIN SS_routes r ON (r.ID=p.routeID) LEFT JOIN SS_categories c ON (c.categoryID=p.categoryID) WHERE ki.Owner=13510