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 (
    88618, 88617, 88616, 88615, 88614, 88613, 
    88612, 88611, 88610, 88609, 88608, 
    88607, 88606, 88605, 88604, 88603, 
    88602, 88601, 88600, 88599, 88598, 
    88597, 88596, 88595, 88650, 88571, 
    88957, 88956, 88955, 88593, 88592, 
    88172, 88169, 88762, 88761, 88543, 
    88542, 88487, 88486, 88449
  ) 
  AND cscart_product_prices.lower_limit = 1 
  AND cscart_product_prices.usergroup_id IN (0, 1) 
GROUP BY 
  cscart_product_prices.product_id