SELECT
cscart_product_prices.product_id,
MIN(
IF(
cscart_product_prices.percentage_discount = 0,
cscart_product_prices.price,
cscart_product_prices.price - (
cscart_product_prices.price * cscart_product_prices.percentage_discount
)/ 100
)
) AS price
FROM
cscart_product_prices
WHERE
cscart_product_prices.product_id IN (
11509, 13776, 11511, 11521, 11527, 11489,
11524, 11497, 11510, 13775, 11515,
13772, 11486, 11487, 11520, 11503,
13781, 11548, 11547, 11549, 11573,
11493, 11490, 11512
)
AND cscart_product_prices.lower_limit = 1
AND cscart_product_prices.usergroup_id IN (0, 1)
GROUP BY
cscart_product_prices.product_id