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 (
    58722, 59121, 58587, 58854, 58778, 58646, 
    58357, 57734, 58959, 58958, 58961, 
    58952, 58951, 58950, 58949, 58948, 
    58947, 58946, 58945, 58944, 58943, 
    58942, 58941, 58940, 58939, 58938, 
    58937, 58936, 58935, 58934, 58933, 
    58932, 58931, 58930, 58929, 58928, 
    58927, 58926, 58925, 58924
  ) 
  AND cscart_product_prices.lower_limit = 1 
  AND cscart_product_prices.usergroup_id IN (0, 1) 
GROUP BY 
  cscart_product_prices.product_id