SELECT p.currency, SUM(p.retail_price) AS retail_price_total, SUM(p.retail_price_old) AS retail_price_total_old FROM (SELECT '393123002' AS set_product_id, 'PCS.' AS set_product_size UNION ALL SELECT '272523005' AS set_product_id, '127' AS set_product_size) AS s INNER JOIN zproducts_prices_106 AS p ON p.product_id = s.set_product_id AND p.product_size = s.set_product_size