MaximM,
Цитата:
Но можно ли его немного доработать так, чтобы он не учитывал цены у неактивных модификаций ?
UPDATE shop_items
JOIN (SELECT MIN(price) AS price, modification_id FROM shop_items WHERE shop_items.active = 1 AND shop_items.deleted = 0 GROUP BY modification_id) AS modification ON modification.modification_id = shop_items.id
SET shop_items.price = modification.price
WHERE shop_items.shop_group_id = 0 AND shop_items.modification_id = 0