WordPress database error The SELECT would examine more than MAX_JOIN_SIZE rows

I am seeing lots of this in my errors logs, whats wrong? Thank you

[08-Jul-2024 03:36:57 UTC] WordPress database error The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay for query 
        SELECT  SUM(total_amount) AS ltv, AVG(total_amount) as avg_order_value, COUNT(total_amount) AS orders_count 
        FROM    wp_wc_orders 
        WHERE   id IN (498418, 502291, 507484, 515653, 519054, 521901, 522600, 522819, 524019, 525452, 526400, 528374, 529142, 530330, 530375, 530600, 530671, 530904, 531041, 531101, 531188, 531462, 532425, 532586, 532587, 533042, 533134, 533642, 534817, 535225, 535772, 536990, 537520, 538132, 539042, 539455, 540219, 540433, 541709, 549635, 552291, 552392, 553245, 553867, 554859, 555770)
                AND status IN ('wc-processing', 'wc-completed')
     made by do_action('wp_ajax_as_async_request_queue_runner'), WP_Hook->do_action, WP_Hook->apply_filters, WP_Async_Request->maybe_handle, ActionScheduler_AsyncRequest_QueueRunner->handle, do_action('action_scheduler_run_queue'), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_QueueRunner->do_batch, ActionScheduler_Abstract_QueueRunner->process_action, ActionScheduler_Action->execute, do_action_ref_array('wc-admin_import_orders'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Internal\Admin\Schedulers\ImportScheduler::do_action_or_reschedule, call_user_func_array, Automattic\WooCommerce\Internal\Admin\Schedulers\OrdersScheduler::import, Automattic\WooCommerce\Admin\API\Reports\Orders\Stats\DataStore::sync_order, Automattic\WooCommerce\Admin\API\Reports\Orders\Stats\DataStore::update, do_action('woocommerce_analytics_update_order_stats'), WP_Hook->do_action, WP_Hook->apply_filters, PixelYourSite\EnrichOrder->woo_update_analytics, PixelYourSite\getWooUserStat
[08-Jul-2024 03:37:10 UTC] WordPress database error The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay for query 
        SELECT  SUM(total_amount) AS ltv, AVG(total_amount) as avg_order_value, COUNT(total_amount) AS orders_count 
        FROM    wp_wc_orders 
        WHERE   id IN (498418, 502291, 507484, 515653, 519054, 521901, 522600, 522819, 524019, 525452, 526400, 528374, 529142, 530330, 530375, 530600, 530671, 530904, 531041, 531101, 531188, 531462, 532425, 532586, 532587, 533042, 533134, 533642, 534817, 535225, 535772, 536990, 537520, 538132, 539042, 539455, 540219, 540433, 541709, 549635, 552291, 552392, 553245, 553867, 554859, 555770, 555771)
                AND status IN ('wc-processing', 'wc-completed')
     made by do_action('wp_ajax_as_async_request_queue_runner'), WP_Hook->do_action, WP_Hook->apply_filters, WP_Async_Request->maybe_handle, ActionScheduler_AsyncRequest_QueueRunner->handle, do_action('action_scheduler_run_queue'), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_QueueRunner->do_batch, ActionScheduler_Abstract_QueueRunner->process_action, ActionScheduler_Action->execute, do_action_ref_array('wc-admin_import_orders'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Internal\Admin\Schedulers\ImportScheduler::do_action_or_reschedule, call_user_func_array, Automattic\WooCommerce\Internal\Admin\Schedulers\OrdersScheduler::import, Automattic\WooCommerce\Admin\API\Reports\Orders\Stats\DataStore::sync_order, Automattic\WooCommerce\Admin\API\Reports\Orders\Stats\DataStore::update, do_action('woocommerce_analytics_update_order_stats'), WP_Hook->do_action, WP_Hook->apply_filters, PixelYourSite\EnrichOrder->woo_update_analytics, PixelYourSite\getWooUserStat
[08-Jul-2024 04:58:59 UTC] WordPress database error The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay for query 
        SELECT  SUM(total_amount) AS ltv, AVG(total_amount) as avg_order_value, COUNT(total_amount) AS orders_count 
        FROM    wp_wc_orders 
        WHERE   id IN (502604, 518138, 518163, 518317, 519583, 519586, 519966, 521574, 521575, 521576, 521591, 523256, 523257, 523820, 529262, 529303, 529429, 529769, 529842, 530816, 530927, 531219, 531749, 531750, 531767, 532339, 532340, 532495, 532744, 542098, 542100, 542105, 542108, 542111, 542113, 542621, 542983, 542987, 542991, 542994, 542997, 543000, 544099, 549011, 549016, 549018, 549107, 549477, 549586, 549593, 550263, 552827, 552848, 554690, 554816, 554951, 554954, 555773)
                AND status IN ('wc-processing', 'wc-completed')
     made by do_action_ref_array('action_scheduler_run_queue'), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_QueueRunner->do_batch, ActionScheduler_Abstract_QueueRunner->process_action, ActionScheduler_Action->execute, do_action_ref_array('wc-admin_import_orders'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Internal\Admin\Schedulers\ImportScheduler::do_action_or_reschedule, call_user_func_array, Automattic\WooCommerce\Internal\Admin\Schedulers\OrdersScheduler::import, Automattic\WooCommerce\Admin\API\Reports\Orders\Stats\DataStore::sync_order, Automattic\WooCommerce\Admin\API\Reports\Orders\Stats\DataStore::update, do_action('woocommerce_analytics_update_order_stats'), WP_Hook->do_action, WP_Hook->apply_filters, PixelYourSite\EnrichOrder->woo_update_analytics, PixelYourSite\getWooUserStat
[08-Jul-2024 06:10:30 UTC] WordPress database error The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay for query 
        SELECT  SUM(total_amount) AS ltv, AVG(total_amount) as avg_order_value, COUNT(total_amount) AS orders_count 
        FROM    wp_wc_orders 
        WHERE   id IN (496724, 496730, 496847, 496848, 496893, 497075, 497151, 497342, 497518, 497536, 497675, 497676, 497720, 497721, 497743, 497786, 497817, 497902, 497922, 498070, 498515, 498523, 498539, 498584, 498597, 498665, 498691, 498918, 498919, 499030, 499193, 499195, 499274, 499334, 499392, 499436, 499563, 499729, 499940, 500018, 500278, 500286, 500635, 500705, 500788, 500820, 500894, 500897, 501016, 501323, 501410, 501698, 501714, 501778, 501945, 502143, 502184, 502332, 502487, 502744, 502804, 502905, 502955, 503051, 503055, 503368, 503369, 503440, 503445, 503468, 503547, 503550, 503635, 503975, 504127, 504128, 504173, 504266, 504363, 504584, 504612, 504613, 504617, 504622, 504625, 504648, 504694, 504698, 504834, 504838, 504878, 504958, 505021, 505024, 505191, 505327, 505328, 505331, 505390, 505394, 505429, 505432, 505600, 505626, 505628, 505636, 505716, 506013, 506092, 506104, 506105, 506108, 506112, 506200, 506203, 506262, 506263, 506273, 506281, 506290, 506334, 506337, 506354, 506361, 506405, 506419, 506423, 506515, 506520, 506628, 506763, 506764, 506795, 506825, 506831, 506879, 506882, 506884, 506909, 506922, 507064, 507081, 507084, 507097, 507098, 507102, 507142, 507165, 507262, 507338, 507661, 507669, 507683, 507700, 507706, 507792, 507796, 507868, 508351, 508514, 508517, 508766, 508932, 509191, 509480, 509584, 509718, 509784, 509789, 509912, 510354, 510602, 510669, 510846, 510985, 511175, 511673, 511714, 511861, 511891, 512191, 512340, 512600, 512717, 513149, 513627, 514059, 514081, 514496, 514614, 514891, 514929, 515711, 515846, 515896, 515940, 515988, 515998, 516019, 516065, 516119, 516186, 516187, 516199, 516300, 516341, 516397, 516545, 516683, 516691, 516769, 516830, 516977, 517083, 517214, 517230, 517529, 517582, 517585, 517589, 517806, 518040, 518043, 518049, 518079, 518147, 518268, 518309, 518402, 518635, 518723, 518950, 519032, 519044, 519055, 519077, 519094, 519107, 519138, 519225, 519479, 519635, 520290, 520311, 520338, 520461, 520463, 520555, 520620, 520739, 520742, 520762, 520771, 520809, 520930, 521043, 521059, 521083, 521175, 521652, 521896, 522086, 522359, 522462, 522582, 522810, 522862, 522897, 523016, 523078, 523081, 523104, 523110, 523232, 523263, 523289, 523521, 523522, 523536, 523548, 523564, 523572, 523580, 523582, 523623, 523624, 524105, 524117, 524121, 524214, 524224, 524269, 524276, 524277, 524355, 524394, 524432, 524435, 524436, 524578, 524591, 524595, 524597, 524611, 524618, 524622, 524703, 524707, 524709, 524711, 524714, 524797, 524798, 524806, 524949, 524990, 524991, 525001, 525086, 525144, 525169, 525171, 525173, 525175, 525177, 525181, 525228, 525230, 525233, 525258, 525341, 525353, 525722, 525799, 525806, 525951, 526088, 526100, 526101, 526197, 526446, 526668, 526669, 526687, 526726, 526789, 526943, 526960, 526972, 526979, 526983, 527047, 527049, 527133, 527296, 527301, 527437, 527453, 527454, 527468, 527593, 527595, 527627, 527680, 527778, 527899, 528005, 528006, 528007, 528010, 528011, 528015, 528017, 528020, 528022, 528025, 528027, 528090, 528293, 528321, 528467, 528530, 528633, 528787, 528872, 528944, 529052, 529056, 529128, 529137, 529139, 529143, 529145, 529146, 529148, 529247, 529301, 529414, 529453, 529458, 529480, 529515, 529763, 529798, 529939, 529961, 529968, 529969, 529972, 529986, 530023, 530070, 530072, 530084, 530086, 530094, 530096, 530112, 530118, 530119, 530132, 530135, 530195, 530253, 530370, 530526, 530629, 530763, 530764, 530766, 530780, 530784, 530835, 530844, 530855, 530901, 530936, 530985, 531122, 531182, 531184, 531313, 531385, 531422, 531440, 531613, 531643, 531665, 531669, 531670, 531690, 531790, 531821, 531822, 531825, 531893, 531900, 531929, 531941, 531943, 532106, 532395, 532429, 532458, 532490, 532558, 532595, 532600, 532601, 532686, 532794, 532851, 533019, 533020, 533082, 533119, 533163, 533164, 533166, 533169, 533178, 533321, 533323, 533400, 533405, 533469, 533565, 533568, 533570, 533598, 533601, 533719, 533766, 533787, 533832, 533886, 533898, 533901, 533968, 533991, 534182, 534197, 534260, 534412, 534557, 534721, 534724, 535211, 535282, 535288, 535291, 535401, 535480, 535497, 535520, 535564, 535579, 535610, 535636, 535764, 535962, 536014, 536097, 536149, 536190, 536392, 536395, 536439, 536453, 536613, 536866, 536872, 536873, 536878, 536881, 536906, 536975, 536980, 537074, 537443, 537449, 537454, 537488, 537500, 537527, 537584, 537589, 537729, 537735, 538041, 538049, 538417, 538662, 538680, 538740, 538790, 538828, 538936, 538946, 538960, 539180, 539184, 539202, 539491, 539563, 539619, 539622, 539638, 539645, 539726, 539941, 539947, 540045, 540064, 540237, 540245, 540262, 540296, 540326, 540345, 540350, 540429, 540452, 540552, 540741, 540867, 540939, 540944, 541074, 541103, 541306, 541431, 541786, 542014, 542031, 542169, 542172, 542339, 542391, 542696, 542706, 543098, 543126, 543291, 543372, 543745, 543790, 543940, 543996, 543997, 544238, 544314, 544424, 544505, 544640, 544788, 544828, 544854, 545058, 545079, 545275, 545356, 545520, 545590, 545713, 545798, 545814, 545849, 546012, 546046, 546088, 546486, 546502, 546606, 546635, 546794, 546833, 546983, 547057, 547148, 547450, 547603, 547654, 547857, 547873, 547972, 548132, 548162, 548259, 548349, 548434, 548438, 548459, 548526, 548726, 548907, 548970, 548984, 549055, 549066, 549166, 549237, 549447, 549480, 549678, 549970, 550002, 550020, 550060, 550092, 550129, 550230, 550547, 550549, 550577, 550887, 551025, 551027, 551097, 551341, 551563, 551575, 551597, 551634, 551745, 551893, 552033, 552387, 552498, 552557, 552697, 552751, 552925, 552942, 553106, 553144, 553377, 553627, 553771, 553923, 554101, 554166, 554169, 554301, 554360, 554377, 554610, 554633, 554705, 554800, 554847, 554854, 555231, 555253, 555775)
                AND status IN ('wc-processing', 'wc-completed')
     made by do_action('wp_ajax_as_async_request_queue_runner'), WP_Hook->do_action, WP_Hook->apply_filters, WP_Async_Request->maybe_handle, ActionScheduler_AsyncRequest_QueueRunner->handle, do_action('action_scheduler_run_queue'), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_QueueRunner->do_batch, ActionScheduler_Abstract_QueueRunner->process_action, ActionScheduler_Action->execute, do_action_ref_array('wc-admin_import_orders'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Internal\Admin\Schedulers\ImportScheduler::do_action_or_reschedule, call_user_func_array, Automattic\WooCommerce\Internal\Admin\Schedulers\OrdersScheduler::import, Automattic\WooCommerce\Admin\API\Reports\Orders\Stats\DataStore::sync_order, Automattic\WooCommerce\Admin\API\Reports\Orders\Stats\DataStore::update, do_action('woocommerce_analytics_update_order_stats'), WP_Hook->do_action, WP_Hook->apply_filters, PixelYourSite\EnrichOrder->woo_update_analytics, PixelYourSite\getWooUserStat

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