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 (
    94340, 95201, 94314, 94294, 94293, 94292, 
    94290, 94289, 94288, 94287, 94258, 
    94257, 94250, 94249, 94248, 94247, 
    94246, 94245, 94244, 94243, 94242, 
    94241, 94240, 94239, 94238, 94237, 
    94236, 94235, 94234, 94233, 94232, 
    94229, 94228, 94224, 94223, 94222, 
    94221, 94220, 94219, 94218
  ) 
  AND cscart_product_prices.lower_limit = 1 
  AND cscart_product_prices.usergroup_id IN (0, 1) 
GROUP BY 
  cscart_product_prices.product_id