2024-03-13 01:00:02 -- 將會員中心id寫入data-lake
2024-03-13 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-03-12%';
        
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '234950'
                WHERE ordernumber = 'P200312110120831' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381143'
                WHERE ordernumber = 'P420312110250874' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '239077'
                WHERE ordernumber = 'P180312110439270' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '307514'
                WHERE ordernumber = 'P200312110712362' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381144'
                WHERE ordernumber = 'P180312111053807' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '73052'
                WHERE ordernumber = 'P200312111454971' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '139071'
                WHERE ordernumber = 'P200312111845775' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381145'
                WHERE ordernumber = 'P420312112721438' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381146'
                WHERE ordernumber = 'P590312113030825' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381148'
                WHERE ordernumber = 'P590312113142910' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '296804'
                WHERE ordernumber = 'P200312113328491' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180312113508684' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381149'
                WHERE ordernumber = 'P420312114049185' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381150'
                WHERE ordernumber = 'P420312114623828' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381151'
                WHERE ordernumber = 'P190312114908583' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '107391'
                WHERE ordernumber = 'P190312115100272' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381152'
                WHERE ordernumber = 'P420312120308759' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381153'
                WHERE ordernumber = 'P190312121359691' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381154'
                WHERE ordernumber = 'P200312121500605' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381155'
                WHERE ordernumber = 'P190312121655336' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '88162'
                WHERE ordernumber = 'P190312121746319' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '88162'
                WHERE ordernumber = 'P190312121923432' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381156'
                WHERE ordernumber = 'P420312122000930' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381156'
                WHERE ordernumber = 'P420312122709519' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380868'
                WHERE ordernumber = 'P200312122809159' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381158'
                WHERE ordernumber = 'P420312123052315' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381159'
                WHERE ordernumber = 'P420312123206729' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381160'
                WHERE ordernumber = 'P200312123301237' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '133547'
                WHERE ordernumber = 'P200312123356846' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '276090'
                WHERE ordernumber = 'P200312123611635' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381162'
                WHERE ordernumber = 'P200312123837769' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '248847'
                WHERE ordernumber = 'P200312123958311' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '374428'
                WHERE ordernumber = 'P190312124008848' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '259176'
                WHERE ordernumber = 'P200312124133642' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '239819'
                WHERE ordernumber = 'P190312124521369' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '365033'
                WHERE ordernumber = 'P420312124628733' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381163'
                WHERE ordernumber = 'P200312124917261' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381164'
                WHERE ordernumber = 'P420312125607337' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348968'
                WHERE ordernumber = 'P420312130110682' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381168'
                WHERE ordernumber = 'P420312130226724' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381169'
                WHERE ordernumber = 'P190312130613735' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '296856'
                WHERE ordernumber = 'P420312130750875' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381170'
                WHERE ordernumber = 'P190312131409632' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354303'
                WHERE ordernumber = 'P420312131553364' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '280218'
                WHERE ordernumber = 'P200312131621600' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381171'
                WHERE ordernumber = 'P190312131623928' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381172'
                WHERE ordernumber = 'P200312131738625' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '282226'
                WHERE ordernumber = 'P190312131942186' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381173'
                WHERE ordernumber = 'P190312132710454' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381165'
                WHERE ordernumber = 'P200312133037187' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '376190'
                WHERE ordernumber = 'P420312133153911' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '105984'
                WHERE ordernumber = 'P190312133810620' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381175'
                WHERE ordernumber = 'P190312133917413' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '359064'
                WHERE ordernumber = 'P200312135050992' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '172513'
                WHERE ordernumber = 'P200312135523676' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '574'
                WHERE ordernumber = 'P190312135625914' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381179'
                WHERE ordernumber = 'P420312140349335' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '112354'
                WHERE ordernumber = 'P190312140433389' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381180'
                WHERE ordernumber = 'P190312141129585' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283039'
                WHERE ordernumber = 'P190312141610696' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381181'
                WHERE ordernumber = 'P420312141640188' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381182'
                WHERE ordernumber = 'P420312143251747' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381185'
                WHERE ordernumber = 'P200312144324192' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349002'
                WHERE ordernumber = 'P190312144410927' 
            
2024-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '123516'
                WHERE ordernumber = 'P200312144606815' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381186'
                WHERE ordernumber = 'P190312144937460' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381187'
                WHERE ordernumber = 'P180312145053797' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381184'
                WHERE ordernumber = 'P420312145148603' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '234960'
                WHERE ordernumber = 'P200312145542532' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381188'
                WHERE ordernumber = 'P200312145641453' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381189'
                WHERE ordernumber = 'P180312145729683' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381190'
                WHERE ordernumber = 'P190312145747653' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379470'
                WHERE ordernumber = 'P200312150519281' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346765'
                WHERE ordernumber = 'P180312150706937' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381191'
                WHERE ordernumber = 'P180312150957898' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381192'
                WHERE ordernumber = 'P420312151106594' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381193'
                WHERE ordernumber = 'P180312151149914' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381178'
                WHERE ordernumber = 'P190312151808339' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381178'
                WHERE ordernumber = 'P190312151846542' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380410'
                WHERE ordernumber = 'P420312152105240' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287759'
                WHERE ordernumber = 'P190312152132842' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380410'
                WHERE ordernumber = 'P420312152147196' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381198'
                WHERE ordernumber = 'P420312152751303' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357366'
                WHERE ordernumber = 'P590312152930255' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '255502'
                WHERE ordernumber = 'P200312153001673' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381194'
                WHERE ordernumber = 'P590312153013398' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381199'
                WHERE ordernumber = 'P420312153028153' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381200'
                WHERE ordernumber = 'P200312153207261' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282735'
                WHERE ordernumber = 'P420312153415932' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '206890'
                WHERE ordernumber = 'P190312153641169' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381201'
                WHERE ordernumber = 'P420312153932665' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381202'
                WHERE ordernumber = 'P180312153946803' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381203'
                WHERE ordernumber = 'P420312154054300' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342900'
                WHERE ordernumber = 'P180312154450678' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381205'
                WHERE ordernumber = 'P420312154607159' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381183'
                WHERE ordernumber = 'P180312154820708' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381183'
                WHERE ordernumber = 'P180312154855990' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381207'
                WHERE ordernumber = 'P200312155008935' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381208'
                WHERE ordernumber = 'P180312155953566' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381209'
                WHERE ordernumber = 'P420312160114547' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381210'
                WHERE ordernumber = 'P420312160322216' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '294266'
                WHERE ordernumber = 'P200312160542681' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381210'
                WHERE ordernumber = 'P420312160710430' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381211'
                WHERE ordernumber = 'P420312160921426' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94854'
                WHERE ordernumber = 'P190312161750350' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381213'
                WHERE ordernumber = 'P420312162300483' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307604'
                WHERE ordernumber = 'P200312162337780' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '206353'
                WHERE ordernumber = 'P190312162527659' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368838'
                WHERE ordernumber = 'P420312163022277' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '280066'
                WHERE ordernumber = 'P200312164051738' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381217'
                WHERE ordernumber = 'P420312164125539' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '292259'
                WHERE ordernumber = 'P200312164246573' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380676'
                WHERE ordernumber = 'P180312164435455' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381218'
                WHERE ordernumber = 'P420312164435496' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '308600'
                WHERE ordernumber = 'P420312164717385' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '253543'
                WHERE ordernumber = 'P180312165001912' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94974'
                WHERE ordernumber = 'P200312165230900' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '62031'
                WHERE ordernumber = 'P200312165410993' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381219'
                WHERE ordernumber = 'P590312165517444' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381221'
                WHERE ordernumber = 'P200312165933846' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381220'
                WHERE ordernumber = 'P420312165950164' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347340'
                WHERE ordernumber = 'P190312171459486' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374936'
                WHERE ordernumber = 'P190312171658832' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '224581'
                WHERE ordernumber = 'P190312171805130' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381224'
                WHERE ordernumber = 'P590312172835721' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381227'
                WHERE ordernumber = 'P190312173547346' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237408'
                WHERE ordernumber = 'P200312173610562' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '58269'
                WHERE ordernumber = 'P190312173840532' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381230'
                WHERE ordernumber = 'P190312174145251' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381231'
                WHERE ordernumber = 'P190312174352361' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381233'
                WHERE ordernumber = 'P420312175532715' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '219275'
                WHERE ordernumber = 'P200312175810160' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297582'
                WHERE ordernumber = 'P420312180820456' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381174'
                WHERE ordernumber = 'P190312180925847' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381234'
                WHERE ordernumber = 'P190312181707198' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '335379'
                WHERE ordernumber = 'P420312182013659' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '224258'
                WHERE ordernumber = 'P200312182156946' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377871'
                WHERE ordernumber = 'P420312182546353' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381237'
                WHERE ordernumber = 'P190312182610624' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346471'
                WHERE ordernumber = 'P200312182927378' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284934'
                WHERE ordernumber = 'P420312183059431' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238273'
                WHERE ordernumber = 'P200312183102379' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380245'
                WHERE ordernumber = 'P420312183201149' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '376195'
                WHERE ordernumber = 'P190312183404654' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240044'
                WHERE ordernumber = 'P190312183853864' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '262000'
                WHERE ordernumber = 'P200312183922536' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381240'
                WHERE ordernumber = 'P190312184915656' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381241'
                WHERE ordernumber = 'P190312185537941' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381243'
                WHERE ordernumber = 'P190312190139565' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381244'
                WHERE ordernumber = 'P190312191322933' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381245'
                WHERE ordernumber = 'P200312192614517' 
            
2024-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381247'
                WHERE ordernumber = 'P200312194013744' 
            
2024-03-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '267978'
                WHERE ordernumber = 'P420312194425531' 
            
2024-03-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '206345'
                WHERE ordernumber = 'P190312194736406' 
            
2024-03-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97821'
                WHERE ordernumber = 'P200312195139119' 
            
2024-03-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '2588'
                WHERE ordernumber = 'P420312195202779' 
            
2024-03-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '270598'
                WHERE ordernumber = 'P190312195906516' 
            
2024-03-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381250'
                WHERE ordernumber = 'P590312203927433'