UPDATE wms.wms_product_in SET invoice_pa_id = 2408816 , invoice_id = 1316331 , cost = '148.225' , remark = '' , date_prihod = '22.09.2021' , `name` = '1520865F0A Nissan / Infiniti' WHERE id IN ( SELECT id FROM ( SELECT wpi.id AS id , wpi.pa_id AS pa_id , wi.create_date AS create_date FROM wms.wms_product_in wpi LEFT JOIN wms.wms_in wi ON wi.document_id = wpi.document_id LEFT JOIN wms.prices_all_link pal ON pal.pa_id_a = wpi.pa_id AND pal.active = 1 LEFT JOIN fin.invoice i ON i.id = 1316331 WHERE wi.supplier_id = i.supplier_id AND wpi.active =