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 (
    49149, 49292, 49124, 49123, 49122, 49121, 
    49119, 49115, 49114, 49092, 49089, 
    49088, 49087, 49086, 49085, 49075, 
    49054, 49053, 48987, 48986, 48985, 
    48984, 48983, 109922, 109921, 109920, 
    109919, 49051, 49050, 49049, 49048, 
    49047, 49046, 49045, 49044, 49043, 
    49042, 49041, 49040, 48967, 48965, 
    48964, 48959, 48958, 48957, 48956, 
    48955, 48954, 48953, 48952, 48951, 
    48950, 49263, 49162, 48988, 49265, 
    48921, 48885, 48884, 48883, 48882, 
    49373, 49372, 49371, 49370, 49369, 
    49368, 49367, 49366, 49365, 49364, 
    49363, 49362, 49361, 49360, 49359, 
    49358, 49357, 49356, 49355
  ) 
  AND cscart_product_prices.lower_limit = 1 
  AND cscart_product_prices.usergroup_id IN (0, 1) 
GROUP BY 
  cscart_product_prices.product_id