SELECT t.fin_id
    , t.art_num AS art_num
    , t.brand AS brand
    , t.kol_wms AS kol
    , t.kol_prihod AS kol_prihod
FROM (
    SELECT f.id AS fin_id
         , f.art_num AS art_num
         , f.brand AS brand
         , f.order_id
         , f.kol_prihod AS kol_prihod
         , (
            SELECT SUM(vpl1.new_available - vpl1.old_available) AS s1
            FROM yii_doc.vitrina_product_log vpl1
            WHERE vpl1.source_identifier = f.order_id
                AND f.art_num = vpl1.art_num
                AND vpl1.source = 'receipt'
                AND vpl1.new_available >= vpl1.old_available
        ) AS kol_rec
        , (
            SELECT MIN(vpl2.new_available - vpl2.old_available) AS s2
            FROM yii_doc.vitrina_product_log vpl2
            WHERE vpl2.source_identifier = wi.id
                AND f.art_num = vpl2.art_num
                AND vpl2.source = 'wms_income'
                AND vpl2.new_available >= vpl2.old_available
        ) AS kol_wms
    FROM wms.wms_product_in wpi
    LEFT JOIN wms.wms_in wi ON wi.document_id = wpi.document_id
    LEFT JOIN fin.fin_in f ON f.id = wpi.fin_in_id
    LEFT JOIN yii_doc.orders o ON o.id = f.order_id
    WHERE f.parent_id IS NULL
        AND o.manager_id = 93
#         AND f.id IN (6386164)
#         AND f.id IN (6390700,6395383,6395384,6395385)
    GROUP BY f.id
) t
WHERE t.kol_rec = t.kol_wms