UPDATE prices_all_duplicate pa
			INNER JOIN (
				SELECT pa.id, IF(MAX(spa.avalaible) IS NULL, 2, 0) as avalaible_gen
				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

			 	WHERE pa.avalaible_gen IN (1)
			 	AND (
		  			(
	   				pa.pa_ga_id IS NOT NULL
	   				AND pa.pa_ga_id NOT IN (9998, 9999)
		  			)
		  		OR (
			   		pa.pa_ga_id IS NULL
			  	)
			 	)
			GROUP BY pa.id
			HAVING
				MAX(spa.avalaible) IS NULL
				OR SUM(spa.avalaible) = 0
				OR (
					MAX(IF(spa.avalaible > 0, IFNULL(ss.no_active_price, 0), NULL)) = 1
					AND MIN(IF(spa.avalaible > 0, IFNULL(ss.no_active_price, 0), NULL)) = 1
				)
			) t ON pa.id = t.id
			SET pa.avalaible_gen = t.avalaible_gen;