UPDATE prices_all_duplicate AS pa
        INNER JOIN (
            SELECT tt.pa_id,
            CASE
                WHEN SUM(tt.sum_available) > 0 THEN 1
                WHEN SUM(tt.sum_available) = 0 THEN 0
                WHEN SUM(tt.sum_available) IS NULL THEN 2
            END AS 'available_new'
            FROM (
                SELECT
                    pa.id AS 'pa_id',
                    pa.price_sredn,
                    sp.price,
                    SUM(spa.avalaible) AS 'sum_available'
                FROM prices_all_duplicate pa
                LEFT JOIN supplier_price_duplicate sp ON pa.art_num = sp.art_num AND pa.brand_id = sp.brand_id
                LEFT JOIN supplier_price_avalaible_duplicate spa ON sp.`hash` = spa.`hash`
                LEFT JOIN supplier_storage ss ON spa.storage_id = ss.id
                GROUP BY pa.id, sp.id
            ) tt
            GROUP BY tt.pa_id
        ) AS t1 ON pa.id = t1.pa_id
        SET pa.avalaible_gen = t1.available_new