Database error: Invalid SQL: SELECT DISTINCT(value) as name, value_clear as rewrite, spc.product_id, attribute_id, 0 as subcategory_count, 5001 as status FROM shop_product sp INNER JOIN shop_product_category as spc ON sp.product_id = spc.product_id AND category_id = INNER JOIN shop_product_attribute_value AS spav ON spav.product_id = sp.product_id AND attribute_id = 18 where spc.product_id = 299 GROUP BY sp.product_id
MySQL 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 'INNER JOIN shop_product_attribute_value AS spav ON spav.product_id = sp.product_' at line 4)
Session halted.