Shopware 6: Set smallest active product.main_variant_id (ordered by variant product_number)

query.sql

UPDATE product AS mainProduct
SET main_variant_id = (
    SELECT p.id
    FROM product AS p
             INNER JOIN product_option AS po
                        ON p.id = po.product_id
             INNER JOIN property_group_option AS pgo
                        ON po.property_group_option_id = pgo.id
    WHERE p.parent_id = mainProduct.id
      AND (p.active IS NULL OR p.active = 1)
    GROUP BY p.product_number
    ORDER BY p.product_number
    LIMIT 1
)
WHERE mainProduct.parentId IS NULL