Symfony Profiler

# product-listing-route::loading::aggregation::options-filter
SELECT
  LOWER(
    HEX(`product.options`.`id`)
  ) as `options.key`,
  COUNT(`product`.`id`) as `options.count`
FROM
  `product`
  LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id`
  AND `product`.`parent_version_id` = `product.parent`.`version_id`
  LEFT JOIN `swkweb_hide_soldout_products_product_availability` `product.swkwebHideSoldoutProductsAvailability` ON `product`.`id` = `product.swkwebHideSoldoutProductsAvailability`.`product_id`
  AND `product`.version_id = `product.swkwebHideSoldoutProductsAvailability`.product_version_id
  LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id`
  AND `product`.version_id = `product.visibilities`.product_version_id
  LEFT JOIN `product_option` `product.options.mapping` ON `product`.`id` = `product.options.mapping`.`product_id`
  AND `product`.`version_id` = `product.options.mapping`.`product_version_id`
  LEFT JOIN `property_group_option` `product.options` ON `product.options.mapping`.`property_group_option_id` = `product.options`.`id`
WHERE
  (`product`.`version_id` = ?)
  AND (
    (
      (
        `product.swkwebHideSoldoutProductsAvailability`.`product_id` <=> ?
        OR (
          `product.swkwebHideSoldoutProductsAvailability`.`sales_channel_id` = ?
          AND `product.swkwebHideSoldoutProductsAvailability`.`soldout` = ?
        )
      )
      AND (
        (
          `product.visibilities`.`visibility` >= ?
        )
        AND `product.visibilities`.`sales_channel_id` = ?
        AND IFNULL(
          `product`.`active`, `product.parent`.`active`
        ) = ?
      )
      AND (
        (
          (
            IFNULL(
              COALESCE(
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product`.`cheapest_price_accessor`,
                                "$.rule018b36b7bb3b71bfb4804b0de2c13f98.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product`.`cheapest_price_accessor`,
                                "$.rule018bf0e30b0d73d9ae9050706853073e.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product`.`cheapest_price_accessor`,
                                "$.ruled423228fbabe4955b94c5f74ae0988a0.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product`.`cheapest_price_accessor`,
                                "$.rulee6709adaec374e6b8793917a96177f8b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product`.`cheapest_price_accessor`,
                                "$.rulef4405b065b7e4f39b9d5db4e901894da.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product`.`cheapest_price_accessor`,
                                "$.rule018a414bb7887c7a9c8d583f1a9c5ced.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product`.`cheapest_price_accessor`,
                                "$.rule018d34d4845879c3a7735c2b198beaae.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product`.`cheapest_price_accessor`,
                                "$.rule018d3c40babe75e5b8a6d672b7844f64.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product`.`cheapest_price_accessor`,
                                "$.rule0196f6b9fcba75b7976cf2a7f71b14c8.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product`.`cheapest_price_accessor`,
                                "$.rulee44e6782c64247b796b891cf25ae38f7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product`.`cheapest_price_accessor`,
                                "$.rule018bad1f62cf725e91ce5d548bc3b051.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product`.`cheapest_price_accessor`,
                                "$.rule018bad1f6df470b1b5d7bea14815f511.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product`.`cheapest_price_accessor`,
                                "$.rule018bad1f814472918f81c4df451966b7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product`.`cheapest_price_accessor`,
                                "$.rule018bad1f81cb72cd93f79d93dfc7bdfc.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product`.`cheapest_price_accessor`,
                                "$.rule018bad1f81df7032b2d5eb7b7a214d60.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product`.`cheapest_price_accessor`,
                                "$.rule018bad1f8210700aa9c9d09f2e8e23ea.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product`.`cheapest_price_accessor`,
                                "$.rule018bad1f821870f39f4bbf8420a26754.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product`.`cheapest_price_accessor`,
                                "$.rule018bad1f822273bc8991f39b078d889e.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product`.`cheapest_price_accessor`,
                                "$.rule018bad1f823672cd91680853be6b9118.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product`.`cheapest_price_accessor`,
                                "$.rule018bad1f825170889e024f33b2c241c2.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product`.`cheapest_price_accessor`,
                                "$.rule018bad1f8281734c9beaf17084c8df61.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product`.`cheapest_price_accessor`,
                                "$.rule018bad1f86a373819178625e456fb2fd.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product`.`cheapest_price_accessor`,
                                "$.rule018bad1f86db72709809db264713484b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product`.`cheapest_price_accessor`,
                                "$.rule018bad1f86ef7018a6a62879e59bae2d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product`.`cheapest_price_accessor`,
                                "$.rule018bad1f878970adb088100b18b5040e.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product`.`cheapest_price_accessor`,
                                "$.rule018bad1f879b7117a55895399ac65f60.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product`.`cheapest_price_accessor`,
                                "$.rule018bad1f87ab73dfb82cbc42bb161918.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product`.`cheapest_price_accessor`,
                                "$.rule018bad1f87c771a09308dfc13d868e3f.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product`.`cheapest_price_accessor`,
                                "$.rule018bad1f87ee701aa38b05438327c1b7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product`.`cheapest_price_accessor`,
                                "$.rule018bf0e30b1d72c8827936ba62bd98ec.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product`.`cheapest_price_accessor`,
                                "$.rule018bf0e30b2270bdbf4a488fbfae3d3a.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product`.`cheapest_price_accessor`,
                                "$.rule018d2f4387c37014b7c4427ffbaf769d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product`.`cheapest_price_accessor`,
                                "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                )
              ),
              COALESCE(
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product.parent`.`cheapest_price_accessor`,
                                "$.rule018b36b7bb3b71bfb4804b0de2c13f98.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product.parent`.`cheapest_price_accessor`,
                                "$.rule018bf0e30b0d73d9ae9050706853073e.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product.parent`.`cheapest_price_accessor`,
                                "$.ruled423228fbabe4955b94c5f74ae0988a0.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product.parent`.`cheapest_price_accessor`,
                                "$.rulee6709adaec374e6b8793917a96177f8b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product.parent`.`cheapest_price_accessor`,
                                "$.rulef4405b065b7e4f39b9d5db4e901894da.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product.parent`.`cheapest_price_accessor`,
                                "$.rule018a414bb7887c7a9c8d583f1a9c5ced.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product.parent`.`cheapest_price_accessor`,
                                "$.rule018d34d4845879c3a7735c2b198beaae.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product.parent`.`cheapest_price_accessor`,
                                "$.rule018d3c40babe75e5b8a6d672b7844f64.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product.parent`.`cheapest_price_accessor`,
                                "$.rule0196f6b9fcba75b7976cf2a7f71b14c8.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product.parent`.`cheapest_price_accessor`,
                                "$.rulee44e6782c64247b796b891cf25ae38f7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product.parent`.`cheapest_price_accessor`,
                                "$.rule018bad1f62cf725e91ce5d548bc3b051.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product.parent`.`cheapest_price_accessor`,
                                "$.rule018bad1f6df470b1b5d7bea14815f511.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product.parent`.`cheapest_price_accessor`,
                                "$.rule018bad1f814472918f81c4df451966b7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product.parent`.`cheapest_price_accessor`,
                                "$.rule018bad1f81cb72cd93f79d93dfc7bdfc.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product.parent`.`cheapest_price_accessor`,
                                "$.rule018bad1f81df7032b2d5eb7b7a214d60.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product.parent`.`cheapest_price_accessor`,
                                "$.rule018bad1f8210700aa9c9d09f2e8e23ea.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product.parent`.`cheapest_price_accessor`,
                                "$.rule018bad1f821870f39f4bbf8420a26754.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product.parent`.`cheapest_price_accessor`,
                                "$.rule018bad1f822273bc8991f39b078d889e.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product.parent`.`cheapest_price_accessor`,
                                "$.rule018bad1f823672cd91680853be6b9118.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product.parent`.`cheapest_price_accessor`,
                                "$.rule018bad1f825170889e024f33b2c241c2.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product.parent`.`cheapest_price_accessor`,
                                "$.rule018bad1f8281734c9beaf17084c8df61.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product.parent`.`cheapest_price_accessor`,
                                "$.rule018bad1f86a373819178625e456fb2fd.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product.parent`.`cheapest_price_accessor`,
                                "$.rule018bad1f86db72709809db264713484b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product.parent`.`cheapest_price_accessor`,
                                "$.rule018bad1f86ef7018a6a62879e59bae2d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product.parent`.`cheapest_price_accessor`,
                                "$.rule018bad1f878970adb088100b18b5040e.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product.parent`.`cheapest_price_accessor`,
                                "$.rule018bad1f879b7117a55895399ac65f60.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product.parent`.`cheapest_price_accessor`,
                                "$.rule018bad1f87ab73dfb82cbc42bb161918.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product.parent`.`cheapest_price_accessor`,
                                "$.rule018bad1f87c771a09308dfc13d868e3f.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product.parent`.`cheapest_price_accessor`,
                                "$.rule018bad1f87ee701aa38b05438327c1b7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product.parent`.`cheapest_price_accessor`,
                                "$.rule018bf0e30b1d72c8827936ba62bd98ec.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product.parent`.`cheapest_price_accessor`,
                                "$.rule018bf0e30b2270bdbf4a488fbfae3d3a.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product.parent`.`cheapest_price_accessor`,
                                "$.rule018d2f4387c37014b7c4427ffbaf769d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                ),
                (
                  ROUND(
                    (
                      ROUND(
                        CAST(
                          (
                            JSON_UNQUOTE(
                              JSON_EXTRACT(
                                `product.parent`.`cheapest_price_accessor`,
                                "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross"
                              )
                            ) * 1
                          ) as DECIMAL(30, 20)
                        ),
                        2
                      )
                    ) * 100,
                    0
                  ) / 100
                )
              )
            ) >= ?
          )
        )
      )
      AND NOT (`product`.`display_group` <=> ?)
    )
  )
  AND (
    (
      (
        `product.options`.`property_group_id` IN (
          ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
          ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
          ?, ?
        )
      )
    )
  )
GROUP BY
  `product.options`.`id`

# product-listing-route::loading::aggregation::options-filter
SELECT LOWER(HEX(`product.options`.`id`)) as `options.key`, COUNT(`product`.`id`) as `options.count` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `swkweb_hide_soldout_products_product_availability` `product.swkwebHideSoldoutProductsAvailability` ON `product`.`id` = `product.swkwebHideSoldoutProductsAvailability`.`product_id` AND `product`.version_id = `product.swkwebHideSoldoutProductsAvailability`.product_version_id LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_option` `product.options.mapping` ON `product`.`id` = `product.options.mapping`.`product_id`  AND `product`.`version_id` = `product.options.mapping`.`product_version_id` LEFT JOIN `property_group_option` `product.options` ON `product.options.mapping`.`property_group_option_id` = `product.options`.`id`  WHERE (`product`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (((`product.swkwebHideSoldoutProductsAvailability`.`product_id` <=> NULL OR (`product.swkwebHideSoldoutProductsAvailability`.`sales_channel_id` = 0x018BF0E055567177BC26645AE8AF5AB2 AND `product.swkwebHideSoldoutProductsAvailability`.`soldout` = 0)) AND ((`product.visibilities`.`visibility` >= 30) AND `product.visibilities`.`sales_channel_id` = 0x018BF0E055567177BC26645AE8AF5AB2 AND IFNULL(`product`.`active`, `product.parent`.`active`) = 1) AND (((IFNULL(COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018b36b7bb3b71bfb4804b0de2c13f98.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018bf0e30b0d73d9ae9050706853073e.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruled423228fbabe4955b94c5f74ae0988a0.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulee6709adaec374e6b8793917a96177f8b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulef4405b065b7e4f39b9d5db4e901894da.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018a414bb7887c7a9c8d583f1a9c5ced.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018d34d4845879c3a7735c2b198beaae.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018d3c40babe75e5b8a6d672b7844f64.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule0196f6b9fcba75b7976cf2a7f71b14c8.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulee44e6782c64247b796b891cf25ae38f7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018bad1f62cf725e91ce5d548bc3b051.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018bad1f6df470b1b5d7bea14815f511.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018bad1f814472918f81c4df451966b7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018bad1f81cb72cd93f79d93dfc7bdfc.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018bad1f81df7032b2d5eb7b7a214d60.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018bad1f8210700aa9c9d09f2e8e23ea.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018bad1f821870f39f4bbf8420a26754.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018bad1f822273bc8991f39b078d889e.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018bad1f823672cd91680853be6b9118.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018bad1f825170889e024f33b2c241c2.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018bad1f8281734c9beaf17084c8df61.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018bad1f86a373819178625e456fb2fd.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018bad1f86db72709809db264713484b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018bad1f86ef7018a6a62879e59bae2d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018bad1f878970adb088100b18b5040e.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018bad1f879b7117a55895399ac65f60.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018bad1f87ab73dfb82cbc42bb161918.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018bad1f87c771a09308dfc13d868e3f.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018bad1f87ee701aa38b05438327c1b7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018bf0e30b1d72c8827936ba62bd98ec.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018bf0e30b2270bdbf4a488fbfae3d3a.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018d2f4387c37014b7c4427ffbaf769d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)), COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018b36b7bb3b71bfb4804b0de2c13f98.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018bf0e30b0d73d9ae9050706853073e.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruled423228fbabe4955b94c5f74ae0988a0.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulee6709adaec374e6b8793917a96177f8b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulef4405b065b7e4f39b9d5db4e901894da.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018a414bb7887c7a9c8d583f1a9c5ced.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018d34d4845879c3a7735c2b198beaae.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018d3c40babe75e5b8a6d672b7844f64.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule0196f6b9fcba75b7976cf2a7f71b14c8.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulee44e6782c64247b796b891cf25ae38f7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018bad1f62cf725e91ce5d548bc3b051.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018bad1f6df470b1b5d7bea14815f511.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018bad1f814472918f81c4df451966b7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018bad1f81cb72cd93f79d93dfc7bdfc.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018bad1f81df7032b2d5eb7b7a214d60.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018bad1f8210700aa9c9d09f2e8e23ea.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018bad1f821870f39f4bbf8420a26754.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018bad1f822273bc8991f39b078d889e.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018bad1f823672cd91680853be6b9118.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018bad1f825170889e024f33b2c241c2.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018bad1f8281734c9beaf17084c8df61.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018bad1f86a373819178625e456fb2fd.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018bad1f86db72709809db264713484b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018bad1f86ef7018a6a62879e59bae2d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018bad1f878970adb088100b18b5040e.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018bad1f879b7117a55895399ac65f60.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018bad1f87ab73dfb82cbc42bb161918.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018bad1f87c771a09308dfc13d868e3f.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018bad1f87ee701aa38b05438327c1b7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018bf0e30b1d72c8827936ba62bd98ec.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018bf0e30b2270bdbf4a488fbfae3d3a.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018d2f4387c37014b7c4427ffbaf769d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.percentage.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100))) >= 0))) AND NOT (`product`.`display_group` <=> NULL))) AND (((`product.options`.`property_group_id` IN (0xC3002F6A41A74FC48F54DEC0D418F9F5, 0xC3002F6A41A74FC48F54DEC0D418F9F5, 0x30A3ADB6C3D7464FA8FFCD3918FE767F, 0x30A3ADB6C3D7464FA8FFCD3918FE767F, 0x741C68C143E94575948CA661948477A5, 0x741C68C143E94575948CA661948477A5, 0x980B83F6E4FE4EF6836BD0D1F0C47526, 0x980B83F6E4FE4EF6836BD0D1F0C47526, 0x511B9CF5BC9743DFB007A13B0CACB02C, 0x511B9CF5BC9743DFB007A13B0CACB02C, 0x9F233BFEE6A34C0B919D857EC6125925, 0x9F233BFEE6A34C0B919D857EC6125925, 0xC0F49CEFA0554209A08F26B7943F22B5, 0xC0F49CEFA0554209A08F26B7943F22B5, 0x3DFF425D69B44F9DBC8FF5CDF86B64CF, 0x3DFF425D69B44F9DBC8FF5CDF86B64CF, 0x61BCF26789C24D9DA19B4FA2009DF615, 0x61BCF26789C24D9DA19B4FA2009DF615, 0x8FC52C19874043DF988FCD1AEFEB374A, 0x8FC52C19874043DF988FCD1AEFEB374A, 0xB34B96397182421F9762440A3E01CCDA, 0xB34B96397182421F9762440A3E01CCDA, 0x069A593E2BB6479DB6BB4D7E1AFA5426, 0x069A593E2BB6479DB6BB4D7E1AFA5426, 0x0CC331DB37034EED82D3A8FBF770BCAD, 0x0CC331DB37034EED82D3A8FBF770BCAD, 0x70958A0F7049421C8A08FCAD2AC57092, 0x70958A0F7049421C8A08FCAD2AC57092, 0xEBDFC0EA1B8446579BADE13F871CBFA5, 0xEBDFC0EA1B8446579BADE13F871CBFA5, 0xADA69BB780BB45EF9512629525DFFB1C, 0xADA69BB780BB45EF9512629525DFFB1C, 0xE6D71FBCC16548EE9390A2F53F2BD6DD)))) GROUP BY `product.options`.`id`;