Jobe Watersports

SELECT p.currency, SUM(p.retail_price) AS retail_price_total, SUM(p.retail_price_old) AS retail_price_total_old FROM (SELECT '647126002' AS set_product_id, 'PCS.' AS set_product_size UNION ALL SELECT '647126003' AS set_product_id, 'PCS.' AS set_product_size UNION ALL SELECT '647126004' AS set_product_id, 'PCS.' AS set_product_size UNION ALL SELECT '649926001' AS set_product_id, 'PCS.' AS set_product_size UNION ALL SELECT '649926002' AS set_product_id, 'PCS.' AS set_product_size UNION ALL SELECT '649926003' AS set_product_id, 'PCS.' AS set_product_size UNION ALL SELECT '647126005' AS set_product_id, 'PCS.' 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