2025-03-11 01:00:01 -- 將會員中心id寫入data-lake
2025-03-11 01:00:01 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2025-03-10%';
        
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '167650'
                WHERE ordernumber = 'P2503100000009' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '289356'
                WHERE ordernumber = 'P2503100000016' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '245990'
                WHERE ordernumber = 'P2503100000018' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '98509'
                WHERE ordernumber = 'P2503100000020' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460317'
                WHERE ordernumber = 'P2503100000022' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '290416'
                WHERE ordernumber = 'P2503100000023' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460318'
                WHERE ordernumber = 'P2503100000026' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P2503100000028' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '329834'
                WHERE ordernumber = 'P2503100000030' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '456959'
                WHERE ordernumber = 'P2503100000031' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '231037'
                WHERE ordernumber = 'P2503100000032' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460319'
                WHERE ordernumber = 'P2503100000033' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '449089'
                WHERE ordernumber = 'P2503100000034' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460320'
                WHERE ordernumber = 'P2503100000037' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460321'
                WHERE ordernumber = 'P2503100000038' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382605'
                WHERE ordernumber = 'P2503100000039' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460322'
                WHERE ordernumber = 'P2503100000040' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460323'
                WHERE ordernumber = 'P2503100000041' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '289505'
                WHERE ordernumber = 'P2503100000045' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460320'
                WHERE ordernumber = 'P2503100000046' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460324'
                WHERE ordernumber = 'P2503100000047' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '318068'
                WHERE ordernumber = 'P2503100000049' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '453442'
                WHERE ordernumber = 'P2503100000052' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '261872'
                WHERE ordernumber = 'P2503100000054' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460326'
                WHERE ordernumber = 'P2503100000055' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '344253'
                WHERE ordernumber = 'P2503100000056' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460327'
                WHERE ordernumber = 'P2503100000057' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '299849'
                WHERE ordernumber = 'P2503100000058' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '159612'
                WHERE ordernumber = 'P2503100000059' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460328'
                WHERE ordernumber = 'P2503100000066' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '39181'
                WHERE ordernumber = 'P2503100000068' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460329'
                WHERE ordernumber = 'P2503100000069' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460330'
                WHERE ordernumber = 'P2503100000070' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460331'
                WHERE ordernumber = 'P2503100000071' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460332'
                WHERE ordernumber = 'P2503100000072' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460333'
                WHERE ordernumber = 'P2503100000077' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '225778'
                WHERE ordernumber = 'P2503100000078' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460334'
                WHERE ordernumber = 'P2503100000080' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460335'
                WHERE ordernumber = 'P2503100000084' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460336'
                WHERE ordernumber = 'P2503100000085' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460337'
                WHERE ordernumber = 'P2503100000090' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460338'
                WHERE ordernumber = 'P2503100000091' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '288772'
                WHERE ordernumber = 'P2503100000097' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460341'
                WHERE ordernumber = 'P2503100000098' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460339'
                WHERE ordernumber = 'P2503100000100' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460342'
                WHERE ordernumber = 'P2503100000101' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '129132'
                WHERE ordernumber = 'P2503100000103' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460328'
                WHERE ordernumber = 'P2503100000104' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460343'
                WHERE ordernumber = 'P2503100000105' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '346325'
                WHERE ordernumber = 'P2503100000108' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460344'
                WHERE ordernumber = 'P2503100000112' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460344'
                WHERE ordernumber = 'P2503100000115' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460347'
                WHERE ordernumber = 'P2503100000116' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460345'
                WHERE ordernumber = 'P2503100000117' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460348'
                WHERE ordernumber = 'P2503100000120' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460346'
                WHERE ordernumber = 'P2503100000122' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113555'
                WHERE ordernumber = 'P2503100000123' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460349'
                WHERE ordernumber = 'P2503100000126' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '344590'
                WHERE ordernumber = 'P2503100000127' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '136082'
                WHERE ordernumber = 'P2503100000129' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460350'
                WHERE ordernumber = 'P2503100000132' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '160342'
                WHERE ordernumber = 'P2503100000133' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '158669'
                WHERE ordernumber = 'P2503100000134' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460352'
                WHERE ordernumber = 'P2503100000135' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460353'
                WHERE ordernumber = 'P2503100000137' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '297835'
                WHERE ordernumber = 'P2503100000140' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377443'
                WHERE ordernumber = 'P2503100000142' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '219734'
                WHERE ordernumber = 'P2503100000143' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '454808'
                WHERE ordernumber = 'P2503100000144' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460355'
                WHERE ordernumber = 'P2503100000148' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '454808'
                WHERE ordernumber = 'P2503100000150' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460356'
                WHERE ordernumber = 'P2503100000152' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460356'
                WHERE ordernumber = 'P2503100000153' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460356'
                WHERE ordernumber = 'P2503100000154' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '154611'
                WHERE ordernumber = 'P2503100000155' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431549'
                WHERE ordernumber = 'P2503100000156' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460359'
                WHERE ordernumber = 'P2503100000161' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460360'
                WHERE ordernumber = 'P2503100000163' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '459533'
                WHERE ordernumber = 'P2503100000164' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460355'
                WHERE ordernumber = 'P2503100000165' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460361'
                WHERE ordernumber = 'P2503100000168' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '455690'
                WHERE ordernumber = 'P2503100000174' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460362'
                WHERE ordernumber = 'P2503100000177' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460363'
                WHERE ordernumber = 'P2503100000178' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '459813'
                WHERE ordernumber = 'P2503100000179' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '459813'
                WHERE ordernumber = 'P2503100000181' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '440035'
                WHERE ordernumber = 'P2503100000182' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460365'
                WHERE ordernumber = 'P2503100000189' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '252332'
                WHERE ordernumber = 'P2503100000191' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '301964'
                WHERE ordernumber = 'P2503100000193' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460366'
                WHERE ordernumber = 'P2503100000194' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435059'
                WHERE ordernumber = 'P2503100000195' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423699'
                WHERE ordernumber = 'P2503100000197' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460368'
                WHERE ordernumber = 'P2503100000199' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460367'
                WHERE ordernumber = 'P2503100000200' 
            
2025-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460369'
                WHERE ordernumber = 'P2503100000201' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460370'
                WHERE ordernumber = 'P2503100000203' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460372'
                WHERE ordernumber = 'P2503100000204' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97445'
                WHERE ordernumber = 'P2503100000208' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364407'
                WHERE ordernumber = 'P2503100000211' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460373'
                WHERE ordernumber = 'P2503100000215' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460374'
                WHERE ordernumber = 'P2503100000216' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460375'
                WHERE ordernumber = 'P2503100000221' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460218'
                WHERE ordernumber = 'P2503100000222' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457311'
                WHERE ordernumber = 'P2503100000229' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404281'
                WHERE ordernumber = 'P2503100000231' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460379'
                WHERE ordernumber = 'P2503100000233' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '293407'
                WHERE ordernumber = 'P2503100000242' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460381'
                WHERE ordernumber = 'P2503100000244' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297104'
                WHERE ordernumber = 'P2503100000246' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430968'
                WHERE ordernumber = 'P2503100000249' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275450'
                WHERE ordernumber = 'P2503100000252' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '190612'
                WHERE ordernumber = 'P2503100000253' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460382'
                WHERE ordernumber = 'P2503100000254' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438155'
                WHERE ordernumber = 'P2503100000258' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460383'
                WHERE ordernumber = 'P2503100000260' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460386'
                WHERE ordernumber = 'P2503100000264' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460387'
                WHERE ordernumber = 'P2503100000268' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460388'
                WHERE ordernumber = 'P2503100000269' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118270'
                WHERE ordernumber = 'P2503100000270' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343585'
                WHERE ordernumber = 'P2503100000274' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460390'
                WHERE ordernumber = 'P2503100000275' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '319953'
                WHERE ordernumber = 'P2503100000277' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460312'
                WHERE ordernumber = 'P2503100000280' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460312'
                WHERE ordernumber = 'P2503100000281' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '453978'
                WHERE ordernumber = 'P2503100000284' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98115'
                WHERE ordernumber = 'P2503100000286' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460393'
                WHERE ordernumber = 'P2503100000290' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460394'
                WHERE ordernumber = 'P2503100000294' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431493'
                WHERE ordernumber = 'P2503100000295' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '116975'
                WHERE ordernumber = 'P2503100000299' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458902'
                WHERE ordernumber = 'P2503100000302' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344871'
                WHERE ordernumber = 'P2503100000306' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289783'
                WHERE ordernumber = 'P2503100000308' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '105984'
                WHERE ordernumber = 'P2503100000309' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '222536'
                WHERE ordernumber = 'P2503100000311' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460398'
                WHERE ordernumber = 'P2503100000314' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248429'
                WHERE ordernumber = 'P2503100000318' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459769'
                WHERE ordernumber = 'P2503100000319' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460399'
                WHERE ordernumber = 'P2503100000325' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460402'
                WHERE ordernumber = 'P2503100000331' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460403'
                WHERE ordernumber = 'P2503100000335' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371840'
                WHERE ordernumber = 'P2503100000337' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460404'
                WHERE ordernumber = 'P2503100000344' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '84477'
                WHERE ordernumber = 'P2503100000349' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '213453'
                WHERE ordernumber = 'P2503100000360' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '219740'
                WHERE ordernumber = 'P2503100000362' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '116608'
                WHERE ordernumber = 'P2503100000363' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340328'
                WHERE ordernumber = 'P2503100000364' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '116608'
                WHERE ordernumber = 'P2503100000365' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296300'
                WHERE ordernumber = 'P2503100000373' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96428'
                WHERE ordernumber = 'P2503100000374' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96428'
                WHERE ordernumber = 'P2503100000375' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277066'
                WHERE ordernumber = 'P2503100000379' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460405'
                WHERE ordernumber = 'P2503100000383' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459310'
                WHERE ordernumber = 'P2503100000384' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415373'
                WHERE ordernumber = 'P2503100000385' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '111306'
                WHERE ordernumber = 'P2503100000387' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249106'
                WHERE ordernumber = 'P2503100000388' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460406'
                WHERE ordernumber = 'P2503100000389' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460407'
                WHERE ordernumber = 'P2503100000390' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460408'
                WHERE ordernumber = 'P2503100000391' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455405'
                WHERE ordernumber = 'P2503100000392' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460405'
                WHERE ordernumber = 'P2503100000393' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390648'
                WHERE ordernumber = 'P2503100000399' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460409'
                WHERE ordernumber = 'P2503100000400' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '225528'
                WHERE ordernumber = 'P2503100000401' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460411'
                WHERE ordernumber = 'P2503100000402' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97780'
                WHERE ordernumber = 'P2503100000403' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432517'
                WHERE ordernumber = 'P2503100000406' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460414'
                WHERE ordernumber = 'P2503100000409' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '452626'
                WHERE ordernumber = 'P2503100000410' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460413'
                WHERE ordernumber = 'P2503100000411' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460415'
                WHERE ordernumber = 'P2503100000412' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394836'
                WHERE ordernumber = 'P2503100000414' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460417'
                WHERE ordernumber = 'P2503100000418' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298395'
                WHERE ordernumber = 'P2503100000419' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460418'
                WHERE ordernumber = 'P2503100000420' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460417'
                WHERE ordernumber = 'P2503100000421' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400565'
                WHERE ordernumber = 'P2503100000426' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460420'
                WHERE ordernumber = 'P2503100000430' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459472'
                WHERE ordernumber = 'P2503100000432' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249227'
                WHERE ordernumber = 'P2503100000435' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '316822'
                WHERE ordernumber = 'P2503100000437' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460421'
                WHERE ordernumber = 'P2503100000438' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '448272'
                WHERE ordernumber = 'P2503100000440' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '170060'
                WHERE ordernumber = 'P2503100000441' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '121795'
                WHERE ordernumber = 'P2503100000442' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365286'
                WHERE ordernumber = 'P2503100000444' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460422'
                WHERE ordernumber = 'P2503100000446' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '288614'
                WHERE ordernumber = 'P2503100000447' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '115654'
                WHERE ordernumber = 'P2503100000449' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '115654'
                WHERE ordernumber = 'P2503100000450' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460424'
                WHERE ordernumber = 'P2503100000452' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460426'
                WHERE ordernumber = 'P2503100000458' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460428'
                WHERE ordernumber = 'P2503100000463' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460431'
                WHERE ordernumber = 'P2503100000464' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '38851'
                WHERE ordernumber = 'P2503100000468' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460432'
                WHERE ordernumber = 'P2503100000470' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460433'
                WHERE ordernumber = 'P2503100000471' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460434'
                WHERE ordernumber = 'P2503100000473' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460434'
                WHERE ordernumber = 'P2503100000474' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '293891'
                WHERE ordernumber = 'P2503100000476' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460435'
                WHERE ordernumber = 'P2503100000477' 
            
2025-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460434'
                WHERE ordernumber = 'P2503100000479' 
            
2025-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '239905'
                WHERE ordernumber = 'P2503100000481' 
            
2025-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460438'
                WHERE ordernumber = 'P2503100000484' 
            
2025-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460438'
                WHERE ordernumber = 'P2503100000485' 
            
2025-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460438'
                WHERE ordernumber = 'P2503100000486'