UPDATE prices_all AS pa
INNER JOIN (
	SELECT
		CASE
			WHEN t1.isDOK = 1 THEN 1
			WHEN t1.isKIEV = 1 THEN 2
			WHEN t1.inUKR = 1 THEN 3
			WHEN t1.podZAKAZ = 1 THEN 4
			WHEN t1.`NONE` = 1 THEN 0 ELSE 0
		END AS 'avalaible_type'
		,t1.pa_id AS 'pa_id'
	FROM (
		SELECT
			pa.id AS 'pa_id',
			MAX(IF (ss.id IS NOT NULL AND ss.supplierID IN (20, 24), 1, 0)) AS 'isDOK',
			MAX(IF (ss.id IS NOT NULL AND ss.isKyiv = 1 AND spa.avalaible >= 2, 1, 0)) AS 'isKIEV',
			MAX(IF (ss.id IS NOT NULL AND ss.no_active_price IS NULL AND spa.avalaible >= 1, 1, 0)) AS 'inUKR',
			MAX(IF (pa.pod_zakaz = 1, 1, 0)) AS 'podZAKAZ',
			MAX(IF (pa.avalaible_gen = 2 OR spa.avalaible = 0, 1, 0)) AS 'NONE'
		FROM prices_all pa
		LEFT JOIN supplier_price sp ON pa.art_num = sp.art_num AND pa.brand_id = sp.brand_id
		LEFT JOIN supplier_price_avalaible spa ON sp.`hash` = spa.`hash`
		LEFT JOIN supplier_storage ss ON spa.storage_id = ss.id
		WHERE pa.pa_ga_id_search IS NOT NULL
		GROUP BY pa.id
	) t1
) t ON pa.id = t.pa_id
SET pa.avalaible_type = t.avalaible_type;