UPDATE fin.fin_in f
            LEFT JOIN (
                SELECT wpi.fin_in_id AS fin_in_id
                    , GROUP_CONCAT(DISTINCT i.invoice_number) AS invoices
                    , SUM(wpi.cost) AS cost_sum
                    , i.date_received AS date_received
                    , bu.name AS bu_name
                FROM wms.wms_product_in wpi
                LEFT JOIN fin.invoice i ON i.id = wpi.invoice_id
                LEFT JOIN yii_doc.backend_users bu ON bu.id = i.manager_id
                WHERE wpi.fin_in_id <> -1
                    AND EXISTS(
                        SELECT 1
                        FROM wms.wms_product_in wpi1
                        WHERE wpi1.fin_in_id = wpi.fin_in_id
                            AND wpi1.active = 1

AND wpi1.invoice_id = 1328078
                    )
                GROUP BY wpi.fin_in_id
            ) t