Sql : Group by query is cause error in wordpress

Question

SELECT oi.order_id, MAX( CASE WHEN pm.meta_key = '_order_total' AND o.ID = pm.post_id THEN pm.meta_value END ) AS 'OrderTotal', (SELECT meta_value FROM wp_3_woocommerce_order_itemmeta WHERE order_item_id = oi.order_item_id AND meta_key = '_variation_id' ) as 'variationid', (SELECT meta_value FROM wp_3_woocommerce_order_itemmeta WHERE order_item_id = oi.order_item_id AND meta_key = '_qty') as 'qty' FROM wp_3_term_relationships tr INNER JOIN wp_3_term_taxonomy tt ON tr.term_taxonomy_id = tt.term_taxonomy_id INNER JOIN wp_3_woocommerce_order_itemmeta oim ON tr.object_id = oim.meta_value INNER JOIN wp_3_woocommerce_order_items oi ON oim.order_item_id = oi.order_item_id INNER JOIN wp_3_terms t ON tt.term_id = t.term_id INNER JOIN wp_3_posts as o ON oi.order_id = o.ID INNER JOIN wp_3_postmeta AS pm ON o.ID = pm.post_id WHERE tt.taxonomy = 'product_cat' AND oim.meta_key = '_product_id' AND o.post_type = 'shop_order' AND o.post_status IN ('wc-completed','wc-processing') AND o.post_date BETWEEN '2021-09-29T00:00:00' AND '2022-03-29T23:59:59' GROUP BY oi.order_id Order By oi.order_id DESC

ERROR

SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'teamspirit_wordpress.oi.order_item_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Please help