2024-04-25 01:00:02 -- 將會員中心id寫入data-lake
2024-04-25 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-04-24%';
        
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386814'
                WHERE ordernumber = 'P630424102247712' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '361342'
                WHERE ordernumber = 'P630424103920688' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240336'
                WHERE ordernumber = 'P180424110410463' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '217152'
                WHERE ordernumber = 'P180424110458927' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287298'
                WHERE ordernumber = 'P200424110603411' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '218591'
                WHERE ordernumber = 'P200424110630273' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '77985'
                WHERE ordernumber = 'P630424110852715' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386818'
                WHERE ordernumber = 'P180424111051854' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '269473'
                WHERE ordernumber = 'P200424111558769' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297128'
                WHERE ordernumber = 'P200424111848285' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277884'
                WHERE ordernumber = 'P590424112258687' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386821'
                WHERE ordernumber = 'P200424112330276' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358086'
                WHERE ordernumber = 'P200424112459153' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386394'
                WHERE ordernumber = 'P180424112534211' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385825'
                WHERE ordernumber = 'P180424112826584' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '246436'
                WHERE ordernumber = 'P180424114329501' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242230'
                WHERE ordernumber = 'P180424114433828' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386826'
                WHERE ordernumber = 'P420424114657514' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '161965'
                WHERE ordernumber = 'P200424115841949' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '290161'
                WHERE ordernumber = 'P180424115956676' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '146697'
                WHERE ordernumber = 'P200424120150752' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379342'
                WHERE ordernumber = 'P420424121017886' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386829'
                WHERE ordernumber = 'P630424121210314' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386830'
                WHERE ordernumber = 'P180424121347156' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386831'
                WHERE ordernumber = 'P630424121803419' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385283'
                WHERE ordernumber = 'P420424122247657' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '104445'
                WHERE ordernumber = 'P190424123202355' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271209'
                WHERE ordernumber = 'P420424123555157' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237475'
                WHERE ordernumber = 'P590424124843921' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '158535'
                WHERE ordernumber = 'P200424125751498' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339562'
                WHERE ordernumber = 'P420424130114450' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386836'
                WHERE ordernumber = 'P420424130257382' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386837'
                WHERE ordernumber = 'P200424130511740' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282031'
                WHERE ordernumber = 'P180424130611500' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '217445'
                WHERE ordernumber = 'P190424130827957' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228165'
                WHERE ordernumber = 'P200424130945398' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386838'
                WHERE ordernumber = 'P630424131100552' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '206628'
                WHERE ordernumber = 'P180424132036972' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380031'
                WHERE ordernumber = 'P200424132214925' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '206627'
                WHERE ordernumber = 'P180424132729608' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386840'
                WHERE ordernumber = 'P630424133350329' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386841'
                WHERE ordernumber = 'P180424133453538' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '288923'
                WHERE ordernumber = 'P180424133559327' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379133'
                WHERE ordernumber = 'P180424134719530' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '266880'
                WHERE ordernumber = 'P180424134906633' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '290827'
                WHERE ordernumber = 'P420424135353938' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348885'
                WHERE ordernumber = 'P180424135401866' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284315'
                WHERE ordernumber = 'P200424135659794' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386843'
                WHERE ordernumber = 'P420424140101214' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386844'
                WHERE ordernumber = 'P180424140322215' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245786'
                WHERE ordernumber = 'P180424140422812' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386845'
                WHERE ordernumber = 'P630424140838202' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314470'
                WHERE ordernumber = 'P200424141923651' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385997'
                WHERE ordernumber = 'P200424142533205' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339648'
                WHERE ordernumber = 'P200424142643830' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386847'
                WHERE ordernumber = 'P180424142806513' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283429'
                WHERE ordernumber = 'P200424143029251' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365226'
                WHERE ordernumber = 'P180424143042910' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '218210'
                WHERE ordernumber = 'P180424143325804' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386849'
                WHERE ordernumber = 'P180424143544631' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '218210'
                WHERE ordernumber = 'P180424143704509' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385062'
                WHERE ordernumber = 'P200424143823720' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386850'
                WHERE ordernumber = 'P180424143842128' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386851'
                WHERE ordernumber = 'P200424144140781' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350879'
                WHERE ordernumber = 'P200424144246536' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '116319'
                WHERE ordernumber = 'P180424144520743' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386853'
                WHERE ordernumber = 'P200424144749432' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '294610'
                WHERE ordernumber = 'P200424144920411' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386854'
                WHERE ordernumber = 'P200424145010997' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230249'
                WHERE ordernumber = 'P180424145108697' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276962'
                WHERE ordernumber = 'P180424145724349' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379072'
                WHERE ordernumber = 'P180424150015559' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235779'
                WHERE ordernumber = 'P200424150036656' 
            
2024-04-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386856'
                WHERE ordernumber = 'P180424150332329' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '88045'
                WHERE ordernumber = 'P420424150725722' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '368246'
                WHERE ordernumber = 'P180424150948564' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385632'
                WHERE ordernumber = 'P590424151350994' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386858'
                WHERE ordernumber = 'P200424151426233' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386859'
                WHERE ordernumber = 'P630424151559850' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386858'
                WHERE ordernumber = 'P200424152150153' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386860'
                WHERE ordernumber = 'P420424152216586' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386861'
                WHERE ordernumber = 'P180424152440805' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386862'
                WHERE ordernumber = 'P200424152817421' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277884'
                WHERE ordernumber = 'P630424152847753' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386863'
                WHERE ordernumber = 'P180424153509549' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287605'
                WHERE ordernumber = 'P630424153651241' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '218966'
                WHERE ordernumber = 'P180424153942304' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347940'
                WHERE ordernumber = 'P590424154614341' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386865'
                WHERE ordernumber = 'P630424154755570' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386868'
                WHERE ordernumber = 'P630424154858827' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386869'
                WHERE ordernumber = 'P180424155044743' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386866'
                WHERE ordernumber = 'P200424155118873' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386871'
                WHERE ordernumber = 'P420424155148308' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '62031'
                WHERE ordernumber = 'P200424155219837' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386873'
                WHERE ordernumber = 'P180424160129231' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386872'
                WHERE ordernumber = 'P420424160224696' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '127085'
                WHERE ordernumber = 'P420424160359358' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '332953'
                WHERE ordernumber = 'P420424160552520' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386874'
                WHERE ordernumber = 'P200424160651767' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386875'
                WHERE ordernumber = 'P190424161354483' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386875'
                WHERE ordernumber = 'P190424161433690' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386873'
                WHERE ordernumber = 'P190424161519388' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344237'
                WHERE ordernumber = 'P200424161942764' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386876'
                WHERE ordernumber = 'P630424162119267' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386877'
                WHERE ordernumber = 'P190424162334521' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386878'
                WHERE ordernumber = 'P200424162406525' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386879'
                WHERE ordernumber = 'P630424162545475' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282521'
                WHERE ordernumber = 'P190424163821673' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386880'
                WHERE ordernumber = 'P200424164116179' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '155370'
                WHERE ordernumber = 'P200424164448485' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386881'
                WHERE ordernumber = 'P630424164507550' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380727'
                WHERE ordernumber = 'P420424164548898' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386882'
                WHERE ordernumber = 'P200424164601548' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386883'
                WHERE ordernumber = 'P630424164810547' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '374864'
                WHERE ordernumber = 'P420424165353694' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386885'
                WHERE ordernumber = 'P630424165500150' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386886'
                WHERE ordernumber = 'P630424170007616' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230607'
                WHERE ordernumber = 'P630424170107287' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '206693'
                WHERE ordernumber = 'P190424170236523' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386887'
                WHERE ordernumber = 'P420424170542473' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297233'
                WHERE ordernumber = 'P420424170630520' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386890'
                WHERE ordernumber = 'P630424171230980' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386891'
                WHERE ordernumber = 'P420424171316678' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386892'
                WHERE ordernumber = 'P180424171446657' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386893'
                WHERE ordernumber = 'P630424171838704' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '161511'
                WHERE ordernumber = 'P630424172500733' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '259013'
                WHERE ordernumber = 'P200424173044260' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '289590'
                WHERE ordernumber = 'P180424173046851' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '320474'
                WHERE ordernumber = 'P420424173724705' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386896'
                WHERE ordernumber = 'P180424173750446' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386897'
                WHERE ordernumber = 'P200424174108744' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386898'
                WHERE ordernumber = 'P180424174301999' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '259652'
                WHERE ordernumber = 'P180424174415844' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386899'
                WHERE ordernumber = 'P630424174542656' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '319752'
                WHERE ordernumber = 'P630424174707158' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386900'
                WHERE ordernumber = 'P180424174835569' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386901'
                WHERE ordernumber = 'P200424175131788' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386903'
                WHERE ordernumber = 'P190424175513693' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379086'
                WHERE ordernumber = 'P180424175830313' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386904'
                WHERE ordernumber = 'P420424180549154' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '314007'
                WHERE ordernumber = 'P630424180818854' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386905'
                WHERE ordernumber = 'P180424181044779' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386906'
                WHERE ordernumber = 'P180424181335925' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '199389'
                WHERE ordernumber = 'P180424181515345' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386907'
                WHERE ordernumber = 'P630424181710939' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94455'
                WHERE ordernumber = 'P180424181955917' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346376'
                WHERE ordernumber = 'P180424182045527' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385763'
                WHERE ordernumber = 'P180424182441561' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386908'
                WHERE ordernumber = 'P630424182601794' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386909'
                WHERE ordernumber = 'P200424182739690' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386910'
                WHERE ordernumber = 'P630424182948432' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '93028'
                WHERE ordernumber = 'P200424183152774' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386911'
                WHERE ordernumber = 'P630424183717686' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386912'
                WHERE ordernumber = 'P180424184019878' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '101890'
                WHERE ordernumber = 'P180424184227960' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '270148'
                WHERE ordernumber = 'P200424184400992' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '289885'
                WHERE ordernumber = 'P180424184442695' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386914'
                WHERE ordernumber = 'P190424190544662' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386916'
                WHERE ordernumber = 'P190424190758325' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '40003'
                WHERE ordernumber = 'P190424191439488' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '13514'
                WHERE ordernumber = 'P420424191500685' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386917'
                WHERE ordernumber = 'P190424191726405' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '228043'
                WHERE ordernumber = 'P190424192315150' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '270103'
                WHERE ordernumber = 'P190424192506602' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '289265'
                WHERE ordernumber = 'P420424192756188' 
            
2024-04-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '293456'
                WHERE ordernumber = 'P200424193138181' 
            
2024-04-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386366'
                WHERE ordernumber = 'P590424193241687' 
            
2024-04-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '371358'
                WHERE ordernumber = 'P190424193547979' 
            
2024-04-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '327453'
                WHERE ordernumber = 'P200424194853571'