In Magento ver 2.4.3 some of the products are not saved from admin.Showing error :
SQLSTATE[42000]: Syntax error or access violation: 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 ‘))’ at line 2,
query was:
SELECT
main_table
.*,cp_table
.type_id
FROM
cataloginventory_stock_item
ASmain_table
INNER JOIN
catalog_product_entity
AScp_table
ON main_table.product_id =
cp_table.entity_id WHERE (main_table
.website_id
= ‘0’) AND
(main_table
.product_id
IN())