[Escalated to 2nd Tier] WCML Custom Prices error when purchasing a membership product

Background of the issue:
I am using WooCommerce with WPML, WooCommerce Multilingual & Multicurrency( Multicurrency enabled), Marketplace for WooCommerce (by webkul), and WooCommerce Marketplace Membership (by webkul). A vendor tries to purchase a membership product that has a custom price set for it ('Set prices in other currencies manually') for ILS, using the ILS currency (not any other currency). The membership plugin is supposed to create a subscription with Stripe. Link to a page where the issue can be seen: hidden link
A Vendor user need to log in, choose a paid membership, add it to the cart and continue with checkout with ILS currency. This bug does not happen with other currencies, only with ILS (which is the only one that has a custom price set).

Symptoms:
The subscription with Stripe was not created because an error thrown by the WCML (multicurrency) interrupted the natural flow of the WooCommerce order. The error message is:
WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 3 for query SELECT post_id, meta_key, meta_value FROM wp_postmeta
WHERE meta_key IN ('_price', '_regular_price', '_sale_price', '_price_ILS', '_regular_price_ILS', '_sale_price_ILS')
AND post_id IN () made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), do_action('template_redirect'), WP_Hook->do_action, WP_Hook->apply_filters, WC_AJAX::do_wc_ajax, do_action('wc_ajax_checkout'), WP_Hook->do_action, WP_Hook->apply_filters, WC_AJAX::checkout, WC_Checkout->process_checkout, WC_Checkout->process_order_payment, WC_Stripe_UPE_Payment_Gateway->process_payment, WC_Stripe_UPE_Payment_Gateway->process_payment_with_deferred_intent, WC_Stripe_UPE_Payment_Gateway->process_payment_with_payment_method, WC_Stripe_Payment_Gateway->process_response, WC_Order->payment_complete, WC_Order->save, WC_Order->status_transition, do_action('woocommerce_order_status_processing'), WP_Hook->do_action, WP_Hook->apply_filters, wc_update_total_sales_counts, do_action('woocommerce_recorded_sales'), WP_Hook->do_action, WP_Hook->apply_filters, WCML_Synchronize_Product_Data->sync_product_total_sales, WC_Data_Store->__call, WC_Product_Data_Store_CPT->update_product_sales, WC_Data_Store_WP->update_lookup_table, WC_Product_Data_Store_CPT->get_data_for_lookup_table, get_post_meta, get_metadata, get_metadata_raw, apply_filters('get_post_metadata'), WP_Hook->apply_filters, WCML_Multi_Currency_Prices->product_price_filter, WPMLFP{closure}, call_user_func_array, WPMLFPLogic::WPMLFP{closure}, WCML_Multi_Currency_Prices->{closure}, WCML_Custom_Prices->get_product_custom_prices

Questions:
Why is the WCML (multicurrency) causing an error during the WooCommerce order process?
How can I resolve the SQL syntax error to ensure the subscription with Stripe is created?