Woocommerce: Grab total revenue of a product over all orders

Got it solved. Probably not the most efficient way but it works!

SELECT product_id, meta_value FROM
    (
        SELECT order_meta.order_item_id, order_meta.meta_value AS 'product_id'
        FROM wp_woocommerce_order_itemmeta AS order_meta
        LEFT JOIN wp_woocommerce_order_items AS order_items
            ON order_meta.order_item_id = order_items.order_item_id
        LEFT JOIN wp_term_relationships AS term_rels
            ON term_rels.object_id = order_items.order_id
        WHERE term_taxonomy_id = 24
        AND order_meta.meta_key = '_product_id'
    ) AS product_ID
    JOIN
    (
        SELECT order_meta2.meta_value, order_meta2.order_item_id
        FROM wp_woocommerce_order_itemmeta AS order_meta2
        LEFT JOIN wp_woocommerce_order_items AS order_items
            ON order_meta2.order_item_id = order_items.order_item_id
        LEFT JOIN wp_term_relationships AS term_rels
                ON term_rels.object_id = order_items.order_id
        WHERE term_taxonomy_id = 24
        AND (
            order_meta2.meta_key = 'Item Details'
            OR order_meta2.meta_key = 'Product Name'
        )
    ) AS product_qty
    ON product_qty.order_item_id = product_ID.order_item_id
    WHERE product_id = " . $post->ID