Error according to SQL query

Hi,

we are seeing some errors according to the SQL query that could be caused by the plugin:

SELECT SUM( order_item_meta.meta_value ) as qty, order_item_meta_2.meta_value as product_id FROM wp_posts AS orders INNER JOIN wp_woocommerce_order_items AS order_items ON orders.ID = order_id INNER JOIN wp_woocommerce_order_itemmeta AS order_item_meta ON order_items.order_item_id = order_item_meta.order_item_id INNER JOIN wp_woocommerce_order_itemmeta AS order_item_meta_2 ON order_items.order_item_id = order_item_meta_2.order_item_id INNER JOIN wp_postmeta AS currency_postmeta ON posts.ID = currency_postmeta.post_id WHERE orders.post_type IN ( ‘shop_order’ ) AND orders.post_status IN ( ‘wc-completed’,’wc-processing’,’wc-on-hold’ ) AND order_item_meta.meta_key = ‘_qty’ AND order_item_meta_2.meta_key = ‘_product_id’ AND orders.post_date_gmt >= ‘2024-12-01’ AND orders.post_date_gmt <= ‘2024-12-27 14:50:22’ AND currency_postmeta.meta_key = ‘_order_currency’ AND currency_postmeta.meta_value = ‘USD’ GROUP BY product_id;

Its mainly causing a issues in the backend as it slowed down a lot. Are you able to confirm that this error comes from WooCommerce Multilingual & Multicurrency with WPML? And how can we fix it?

Best regards

Jonathan

The page I need help with: [log in to see the link]