Database error: 1064 - 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 '))) pcid LEFT JOIN kf_products p ON pcid.product_id = p.id LEFT JOIN kf_settings' at line 1 - SELECT p.id, p.name, p.url, p.price, p.image, p.available, ROUND(p.price * (1+(s.param1/100)), 2) AS price_display, s.param1 AS vat, (SELECT MIN(pv1.price) FROM kf_products_variations pv1 WHERE pv1.product_id = p.id) AS var_min, (SELECT MAX(pv2.price) FROM kf_products_variations pv2 WHERE pv2.product_id = p.id) AS var_max, (SELECT COUNT(pv3.price) FROM kf_products_variations pv3 WHERE pv3.product_id = p.id) AS var_count FROM (SELECT product_id FROM kf_products_categories WHERE category_id IN (SELECT id FROM kf_categories WHERE parent IN ())) pcid LEFT JOIN kf_products p ON pcid.product_id = p.id LEFT JOIN kf_settings s ON p.vat = s.id WHERE p.enabled = 1 AND p.available = 1 AND p.id <> 3948