function wpneo_crowdfunding_get_total_fund_raised_by_campaign($campaign_id = 0){
                global $wpdb, $post;
                $db_prefix = $wpdb->prefix;

                if ($campaign_id == 0)
                        $campaign_id = $post->ID;

                // WPML compatibility.
                if ( apply_filters( 'wpml_setting', false, 'setup_complete' ) ) {
                        $type = apply_filters( 'wpml_element_type', get_post_type( $campaign_id ) );
                        $trid = apply_filters( 'wpml_element_trid', null, $campaign_id, $type );
                        $translations = apply_filters( 'wpml_get_element_translations', null, $trid, $type );
                        $campaign_ids = wp_list_pluck( $translations, 'element_id' );
                } else {
                        $campaign_ids = array( $campaign_id );
                }
                $placeholders = implode( ',', array_fill( 0, count( $campaign_ids ), '%d' ) );

                $query = "SELECT
                    SUM(ltoim.meta_value) as total_sales_amount
                FROM
                    {$wpdb->prefix}woocommerce_order_itemmeta woim
                            LEFT JOIN
                    {$wpdb->prefix}woocommerce_order_items oi ON woim.order_item_id = oi.order_item_id
                            LEFT JOIN
                    {$wpdb->prefix}posts wpposts ON order_id = wpposts.ID
                            LEFT JOIN
                    {$wpdb->prefix}woocommerce_order_itemmeta ltoim ON ltoim.order_item_id = oi.order_item_id AND ltoim.meta_key = '_line_total'
                            WHERE
                    woim.meta_key = '_product_id' AND woim.meta_value IN ($placeholders) AND wpposts.post_status = 'wc-completed';";

                $wp_sql = $wpdb->get_row($wpdb->prepare($query, $campaign_ids));

                return $wp_sql->total_sales_amount;
        }