CREATE TEMP TABLE temp_products AS
SELECT "id", "manufacturer_id", "weight", "sid", "slug", "name", min(price) AS "price"
FROM "product"
         INNER JOIN (SELECT "product_id", cu_price AS "price"
                     FROM (SELECT "stock_product".*,
                                  ceil(price * (1 + (COALESCE(
                                                             CASE WHEN surcharge_percent < -99 THEN 1 ELSE surcharge_percent END,
                                                             10) / 100.0))) AS "cu_price"
                           FROM (SELECT "product_id",
                                        "price",
                                        "amount",
                                        "stock_id",
                                        (SELECT "surcharge_percent"
                                         FROM "customer_group_surcharge_range"
                                         WHERE (("customer_group_surcharge_range"."stock_id" = stock_product.stock_id) OR
                                                ("customer_group_surcharge_range"."stock_id" IS NULL))
                                           AND ("customer_group_surcharge_range"."customer_group_id" = 30)
                                           AND (CEIL("stock_product".price) BETWEEN min_price AND max_price)
                                         ORDER BY "stock_id", "min_price"
                                         LIMIT 1) AS "surcharge_percent"
                                 FROM "stock_product") "stock_product"
                           WHERE ("amount" > 0)
                             AND (EXISTS(SELECT 1 FROM "stock" WHERE ("act" = 1) AND ("id" = "stock_product".stock_id)))
                             AND (NOT EXISTS(SELECT 1
                                             FROM "disabled_stock_to_customer_group"
                                             WHERE ("customer_group_id" = 30)
                                               AND ("stock_id" = "stock_product".stock_id)))) "stock_product") "sprice"
                    ON product.id = sprice.product_id
WHERE EXISTS(SELECT 1
             FROM "product_to_category"
             WHERE ("category_id" = 781)
               AND (product_to_category.product_id = product.id))
GROUP BY "product"."id"

SELECT "product_attribute_id", json_agg(DISTINCT product_attribute_value_id) AS "values"
FROM "product_attribute_value_to_product"
WHERE "product_id" IN
      (SELECT "id" FROM "temp_products" "t" WHERE ("price" BETWEEN '2' AND '241479') AND ("manufacturer_id" = '812'))
GROUP BY "product_attribute_id"

SELECT min(price) AS "min", max(price) AS "max" FROM (SELECT "price" FROM "temp_products" "t" WHERE ("price" BETWEEN '2' AND '241479') AND ("manufacturer_id"='812')) "t"

SELECT COUNT(*) FROM "temp_products" "t" WHERE ("price" BETWEEN '2' AND '241479') AND ("manufacturer_id"='812')

SELECT * FROM "temp_products" "t" WHERE ("price" BETWEEN '2' AND '241479') AND ("manufacturer_id"='812') ORDER BY "price" DESC LIMIT 10