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 (
1660621, 1663150, 1664049, 1658333,
1658334, 1664157, 1658506, 1657840,
1657777, 1658557, 1661197, 1662527,
1658427, 1658811, 1658265, 1663182,
1658593, 1660401, 1658270, 1663613,
1659564, 1658864, 1657833, 1662451,
1661407, 1659246, 1663612, 2099795,
1660547, 1660154, 1659920, 1659832,
1658398, 1658504, 1661697, 1661022
)
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