-- Формируем признак 'Под заказ' для новых категорий
UPDATE prices_all_duplicate AS pa
  INNER JOIN (
    SELECT
      psku.pa_id
         , MIN(ssr.delivery_days) AS delivery_days
    FROM supplier_price_avalaible_duplicate spa
           LEFT JOIN supplier_storage ss ON spa.storage_id = ss.id
           INNER JOIN supplier_price_duplicate sp ON spa.`hash` = sp.`hash`
           INNER JOIN price_sku psku ON sp.id = psku.price_id
           INNER JOIN supplier_storage_region ssr ON ss.id = ssr.region_id
    WHERE spa.avalaible >= 0 AND psku.is_active = 1
    GROUP BY sp.hash_brand_artnum
    HAVING MIN(IFNULL(ss.no_active_price, 0)) = 1
  ) AS t ON t.pa_id = pa.id
SET pa.pod_zakaz = t.delivery_days