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 (
1233012, 1067180, 696234, 591722, 589214,
1067678, 1033163, 992088, 1730410,
614833, 600286, 588439, 588446, 589740,
697903, 1067318, 1025367, 695078,
1233020, 599887, 1067521, 588910,
612038, 991897, 590755, 1025365, 622101,
1120163, 697332, 697155, 1073044,
591218, 1070391, 593887, 697609, 991976
)
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