[Resolved] WordPress database error: [Unknown column 'posts.ID' in 'on clause']

Background of the issue:
I am trying to: I have this error in my Woocommerce Dashboard

WordPress database error: [Unknown column 'posts.ID' in 'on clause']
SELECT SUM( order_item_meta.meta_value ) as qty, order_item_meta_2.meta_value as product_id FROM db5q_wc_orders AS orders INNER JOIN db5q_woocommerce_order_items AS order_items ON orders.id = order_id INNER JOIN db5q_woocommerce_order_itemmeta AS order_item_meta ON order_items.order_item_id = order_item_meta.order_item_id INNER JOIN db5q_woocommerce_order_itemmeta AS order_item_meta_2 ON order_items.order_item_id = order_item_meta_2.order_item_id INNER JOIN db5q_postmeta AS currency_postmeta ON posts.ID = currency_postmeta.post_id WHERE orders.type IN ( 'shop_order' ) AND orders.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.date_created_gmt >= '2024-08-01' AND orders.date_created_gmt