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 (
40706, 39407, 40230, 31724, 39680, 39404,
39401, 39406, 39405, 39144, 39403,
40778, 31725, 31727, 30418, 30420,
30413, 30414, 30415, 30416, 30417,
30421, 30423, 31732, 39408, 39409,
39410
)
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