SELECT
cscart_ult_product_prices.product_id,
MIN(
IF(
cscart_ult_product_prices.percentage_discount = 0,
cscart_ult_product_prices.price,
cscart_ult_product_prices.price - (
cscart_ult_product_prices.price * cscart_ult_product_prices.percentage_discount
)/ 100
)
) AS price
FROM
cscart_ult_product_prices
WHERE
cscart_ult_product_prices.product_id IN (
614832, 1232975, 588096, 880671, 1088508,
697953, 796373, 591739, 612280, 1120145,
695183, 600012, 614835, 1302601, 590335,
866417, 589124, 696523, 593274, 1232966,
1232977, 696950, 621062, 596399, 588307,
1434961, 590366, 697334, 590358, 594343,
866380, 1233023, 562160, 694679, 595794,
589041
)
AND cscart_ult_product_prices.lower_limit = 1
AND cscart_ult_product_prices.company_id = 1
AND cscart_ult_product_prices.usergroup_id IN (0, 0, 1)
GROUP BY
cscart_ult_product_prices.product_id