2024-11-24 01:00:02 -- 將會員中心id寫入data-lake
2024-11-24 01:00:02 -- 
            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 '2024-11-23%';
        
2024-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '341550'
                WHERE ordernumber = 'P2411230000219' 
            
2024-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431388'
                WHERE ordernumber = 'P2411230000478' 
            
2024-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431386'
                WHERE ordernumber = 'P2411230000693' 
            
2024-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429392'
                WHERE ordernumber = 'P2411230000785' 
            
2024-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431389'
                WHERE ordernumber = 'P2411230000861' 
            
2024-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '244844'
                WHERE ordernumber = 'P2411230001037' 
            
2024-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '314307'
                WHERE ordernumber = 'P2411230001145' 
            
2024-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '251553'
                WHERE ordernumber = 'P2411230001238' 
            
2024-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382489'
                WHERE ordernumber = 'P2411230001362' 
            
2024-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '1069'
                WHERE ordernumber = 'P2411230001638' 
            
2024-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431391'
                WHERE ordernumber = 'P2411230001792' 
            
2024-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431395'
                WHERE ordernumber = 'P2411230001882' 
            
2024-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431396'
                WHERE ordernumber = 'P2411230002369' 
            
2024-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '245540'
                WHERE ordernumber = 'P2411230002953' 
            
2024-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431397'
                WHERE ordernumber = 'P2411230003065' 
            
2024-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424749'
                WHERE ordernumber = 'P2411230003465' 
            
2024-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431398'
                WHERE ordernumber = 'P2411230003517' 
            
2024-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '141777'
                WHERE ordernumber = 'P2411230003770' 
            
2024-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431399'
                WHERE ordernumber = 'P2411230003866' 
            
2024-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '289740'
                WHERE ordernumber = 'P2411230003919' 
            
2024-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431401'
                WHERE ordernumber = 'P2411230004229' 
            
2024-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '250585'
                WHERE ordernumber = 'P2411230004431' 
            
2024-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431400'
                WHERE ordernumber = 'P2411230004546' 
            
2024-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431402'
                WHERE ordernumber = 'P2411230004668' 
            
2024-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '111830'
                WHERE ordernumber = 'P2411230004928' 
            
2024-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '319399'
                WHERE ordernumber = 'P2411230005053' 
            
2024-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '319399'
                WHERE ordernumber = 'P2411230005122' 
            
2024-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '404529'
                WHERE ordernumber = 'P2411230005388' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '132559'
                WHERE ordernumber = 'P2411230005688' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431405'
                WHERE ordernumber = 'P2411230005758' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '232300'
                WHERE ordernumber = 'P2411230005832' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296594'
                WHERE ordernumber = 'P2411230005988' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '130049'
                WHERE ordernumber = 'P2411230006011' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431403'
                WHERE ordernumber = 'P2411230006271' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382939'
                WHERE ordernumber = 'P2411230006456' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431404'
                WHERE ordernumber = 'P2411230006526' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '95355'
                WHERE ordernumber = 'P2411230006983' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313870'
                WHERE ordernumber = 'P2411230007048' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404090'
                WHERE ordernumber = 'P2411230007270' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431408'
                WHERE ordernumber = 'P2411230007652' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431411'
                WHERE ordernumber = 'P2411230007721' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431410'
                WHERE ordernumber = 'P2411230007853' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431412'
                WHERE ordernumber = 'P2411230008043' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '165009'
                WHERE ordernumber = 'P2411230008221' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431413'
                WHERE ordernumber = 'P2411230008454' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431414'
                WHERE ordernumber = 'P2411230008546' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431415'
                WHERE ordernumber = 'P2411230008678' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431416'
                WHERE ordernumber = 'P2411230008744' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431418'
                WHERE ordernumber = 'P2411230008913' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418694'
                WHERE ordernumber = 'P2411230009099' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '273590'
                WHERE ordernumber = 'P2411230009185' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430493'
                WHERE ordernumber = 'P2411230009255' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350314'
                WHERE ordernumber = 'P2411230009366' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431415'
                WHERE ordernumber = 'P2411230009480' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431420'
                WHERE ordernumber = 'P2411230009766' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431040'
                WHERE ordernumber = 'P2411230009724' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431422'
                WHERE ordernumber = 'P2411230010128' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431423'
                WHERE ordernumber = 'P2411230010211' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431421'
                WHERE ordernumber = 'P2411230010393' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431424'
                WHERE ordernumber = 'P2411230010468' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431425'
                WHERE ordernumber = 'P2411230010559' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431426'
                WHERE ordernumber = 'P2411230010677' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431427'
                WHERE ordernumber = 'P2411230010885' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '375953'
                WHERE ordernumber = 'P2411230010987' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356710'
                WHERE ordernumber = 'P2411230011081' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '234266'
                WHERE ordernumber = 'P2411230011395' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431428'
                WHERE ordernumber = 'P2411230011456' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '259506'
                WHERE ordernumber = 'P2411230011579' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100925'
                WHERE ordernumber = 'P2411230011637' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282647'
                WHERE ordernumber = 'P2411230012148' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431430'
                WHERE ordernumber = 'P2411230012439' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '30912'
                WHERE ordernumber = 'P2411230012575' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431429'
                WHERE ordernumber = 'P2411230012725' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390229'
                WHERE ordernumber = 'P2411230012828' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230838'
                WHERE ordernumber = 'P2411230012952' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431431'
                WHERE ordernumber = 'P2411230013293' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431432'
                WHERE ordernumber = 'P2411230013424' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '152100'
                WHERE ordernumber = 'P2411230013560' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '215157'
                WHERE ordernumber = 'P2411230013793' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431433'
                WHERE ordernumber = 'P2411230013839' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '208649'
                WHERE ordernumber = 'P2411230013975' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '215157'
                WHERE ordernumber = 'P2411230014034' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '221701'
                WHERE ordernumber = 'P2411230014180' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431434'
                WHERE ordernumber = 'P2411230014275' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431435'
                WHERE ordernumber = 'P2411230014489' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282487'
                WHERE ordernumber = 'P2411230014567' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431435'
                WHERE ordernumber = 'P2411230014617' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431436'
                WHERE ordernumber = 'P2411230014742' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '210252'
                WHERE ordernumber = 'P2411230014875' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281711'
                WHERE ordernumber = 'P2411230015018' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431438'
                WHERE ordernumber = 'P2411230015317' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431439'
                WHERE ordernumber = 'P2411230015461' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431438'
                WHERE ordernumber = 'P2411230015589' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423288'
                WHERE ordernumber = 'P2411230015963' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103275'
                WHERE ordernumber = 'P2411230016220' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235779'
                WHERE ordernumber = 'P2411230016311' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404818'
                WHERE ordernumber = 'P2411230016621' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431441'
                WHERE ordernumber = 'P2411230016850' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291414'
                WHERE ordernumber = 'P2411230016978' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365476'
                WHERE ordernumber = 'P2411230017123' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431442'
                WHERE ordernumber = 'P2411230017376' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342311'
                WHERE ordernumber = 'P2411230017449' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379886'
                WHERE ordernumber = 'P2411230017854' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '104833'
                WHERE ordernumber = 'P2411230017996' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '173664'
                WHERE ordernumber = 'P2411230018195' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391738'
                WHERE ordernumber = 'P2411230018299' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431444'
                WHERE ordernumber = 'P2411230018593' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431445'
                WHERE ordernumber = 'P2411230018838' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '127759'
                WHERE ordernumber = 'P2411230018967' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '84477'
                WHERE ordernumber = 'P2411230019021' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431446'
                WHERE ordernumber = 'P2411230019361' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431447'
                WHERE ordernumber = 'P2411230019595' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431448'
                WHERE ordernumber = 'P2411230019667' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424831'
                WHERE ordernumber = 'P2411230019732' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '259307'
                WHERE ordernumber = 'P2411230019893' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431449'
                WHERE ordernumber = 'P2411230019916' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '90858'
                WHERE ordernumber = 'P2411230020078' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430983'
                WHERE ordernumber = 'P2411230020134' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '116257'
                WHERE ordernumber = 'P2411230020288' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431450'
                WHERE ordernumber = 'P2411230020358' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431453'
                WHERE ordernumber = 'P2411230020574' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431457'
                WHERE ordernumber = 'P2411230020771' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '290560'
                WHERE ordernumber = 'P2411230020877' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426962'
                WHERE ordernumber = 'P2411230020961' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431458'
                WHERE ordernumber = 'P2411230021091' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431456'
                WHERE ordernumber = 'P2411230021142' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431459'
                WHERE ordernumber = 'P2411230021236' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431460'
                WHERE ordernumber = 'P2411230021591' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431462'
                WHERE ordernumber = 'P2411230021796' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431458'
                WHERE ordernumber = 'P2411230021962' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431455'
                WHERE ordernumber = 'P2411230022790' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431464'
                WHERE ordernumber = 'P2411230022853' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431465'
                WHERE ordernumber = 'P2411230023091' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431461'
                WHERE ordernumber = 'P2411230023161' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431454'
                WHERE ordernumber = 'P2411230023394' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431469'
                WHERE ordernumber = 'P2411230023558' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431466'
                WHERE ordernumber = 'P2411230023621' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '232303'
                WHERE ordernumber = 'P2411230023729' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431468'
                WHERE ordernumber = 'P2411230023864' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '142524'
                WHERE ordernumber = 'P2411230023969' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431470'
                WHERE ordernumber = 'P2411230024017' 
            
2024-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396977'
                WHERE ordernumber = 'P2411230024356' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431467'
                WHERE ordernumber = 'P2411230024459' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431471'
                WHERE ordernumber = 'P2411230024864' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '225205'
                WHERE ordernumber = 'P2411230024915' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '95844'
                WHERE ordernumber = 'P2411230025048' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431472'
                WHERE ordernumber = 'P2411230025218' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '89284'
                WHERE ordernumber = 'P2411230025422' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '300589'
                WHERE ordernumber = 'P2411230025539' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431473'
                WHERE ordernumber = 'P2411230025814' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423826'
                WHERE ordernumber = 'P2411230026071' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '321442'
                WHERE ordernumber = 'P2411230026223' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '118047'
                WHERE ordernumber = 'P2411230026355' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431475'
                WHERE ordernumber = 'P2411230026439' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100159'
                WHERE ordernumber = 'P2411230026525' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431475'
                WHERE ordernumber = 'P2411230026679' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362170'
                WHERE ordernumber = 'P2411230026773' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431477'
                WHERE ordernumber = 'P2411230026855' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '141949'
                WHERE ordernumber = 'P2411230027039' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431476'
                WHERE ordernumber = 'P2411230027157' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431478'
                WHERE ordernumber = 'P2411230027381' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340171'
                WHERE ordernumber = 'P2411230027472' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282815'
                WHERE ordernumber = 'P2411230027530' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371590'
                WHERE ordernumber = 'P2411230027677' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431480'
                WHERE ordernumber = 'P2411230027868' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '374288'
                WHERE ordernumber = 'P2411230027982' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236690'
                WHERE ordernumber = 'P2411230028136' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '321217'
                WHERE ordernumber = 'P2411230028252' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '341544'
                WHERE ordernumber = 'P2411230028483' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431482'
                WHERE ordernumber = 'P2411230028680' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431481'
                WHERE ordernumber = 'P2411230028743' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '328044'
                WHERE ordernumber = 'P2411230029026' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431484'
                WHERE ordernumber = 'P2411230029195' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431485'
                WHERE ordernumber = 'P2411230029221' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429656'
                WHERE ordernumber = 'P2411230029343' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390757'
                WHERE ordernumber = 'P2411230029523' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431485'
                WHERE ordernumber = 'P2411230029775' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299342'
                WHERE ordernumber = 'P2411230029856' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348753'
                WHERE ordernumber = 'P2411230029924' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430536'
                WHERE ordernumber = 'P2411230030039' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430468'
                WHERE ordernumber = 'P2411230030379' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388298'
                WHERE ordernumber = 'P2411230030426' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431486'
                WHERE ordernumber = 'P2411230030678' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96707'
                WHERE ordernumber = 'P2411230030725' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431487'
                WHERE ordernumber = 'P2411230030813' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431490'
                WHERE ordernumber = 'P2411230031049' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431488'
                WHERE ordernumber = 'P2411230031146' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431489'
                WHERE ordernumber = 'P2411230031274' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431492'
                WHERE ordernumber = 'P2411230031626' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431493'
                WHERE ordernumber = 'P2411230031892' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431496'
                WHERE ordernumber = 'P2411230032158' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305954'
                WHERE ordernumber = 'P2411230032317' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431498'
                WHERE ordernumber = 'P2411230032492' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431499'
                WHERE ordernumber = 'P2411230032638' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '222034'
                WHERE ordernumber = 'P2411230032733' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '80996'
                WHERE ordernumber = 'P2411230032928' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431500'
                WHERE ordernumber = 'P2411230033047' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431499'
                WHERE ordernumber = 'P2411230033294' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425903'
                WHERE ordernumber = 'P2411230033396' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100925'
                WHERE ordernumber = 'P2411230033580' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431502'
                WHERE ordernumber = 'P2411230033625' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431503'
                WHERE ordernumber = 'P2411230033730' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431504'
                WHERE ordernumber = 'P2411230033921' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431505'
                WHERE ordernumber = 'P2411230034221' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414753'
                WHERE ordernumber = 'P2411230034532' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '164997'
                WHERE ordernumber = 'P2411230034647' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431506'
                WHERE ordernumber = 'P2411230034745' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431507'
                WHERE ordernumber = 'P2411230034872' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '285414'
                WHERE ordernumber = 'P2411230035692' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '243715'
                WHERE ordernumber = 'P2411230035799' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '111046'
                WHERE ordernumber = 'P2411230035951' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '76845'
                WHERE ordernumber = 'P2411230036089' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393465'
                WHERE ordernumber = 'P2411230036551' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431509'
                WHERE ordernumber = 'P2411230036691' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431509'
                WHERE ordernumber = 'P2411230036796' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431511'
                WHERE ordernumber = 'P2411230036937' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431513'
                WHERE ordernumber = 'P2411230037028' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94437'
                WHERE ordernumber = 'P2411230037274' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310342'
                WHERE ordernumber = 'P2411230037376' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431516'
                WHERE ordernumber = 'P2411230037485' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431517'
                WHERE ordernumber = 'P2411230037523' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392062'
                WHERE ordernumber = 'P2411230037697' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431518'
                WHERE ordernumber = 'P2411230037878' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431515'
                WHERE ordernumber = 'P2411230037947' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430987'
                WHERE ordernumber = 'P2411230038037' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '329959'
                WHERE ordernumber = 'P2411230038162' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431519'
                WHERE ordernumber = 'P2411230038210' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '63785'
                WHERE ordernumber = 'P2411230038540' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431521'
                WHERE ordernumber = 'P2411230038628' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '290726'
                WHERE ordernumber = 'P2411230038886' 
            
2024-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430029'
                WHERE ordernumber = 'P2411230039587'