2024-07-13 01:00:03 -- 將會員中心id寫入data-lake
2024-07-13 01:00:03 -- 
            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-07-12%';
        
2024-07-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400836'
                WHERE ordernumber = 'P630712100654362' 
            
2024-07-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400838'
                WHERE ordernumber = 'P630712101835963' 
            
2024-07-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400839'
                WHERE ordernumber = 'P630712101957972' 
            
2024-07-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400844'
                WHERE ordernumber = 'P630712103950758' 
            
2024-07-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400845'
                WHERE ordernumber = 'P630712104104307' 
            
2024-07-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400843'
                WHERE ordernumber = 'P630712104112118' 
            
2024-07-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400846'
                WHERE ordernumber = 'P630712105039353' 
            
2024-07-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400848'
                WHERE ordernumber = 'P630712105614439' 
            
2024-07-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400847'
                WHERE ordernumber = 'P190712110236702' 
            
2024-07-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '233524'
                WHERE ordernumber = 'P180712110434604' 
            
2024-07-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '109884'
                WHERE ordernumber = 'P190712110523914' 
            
2024-07-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '155223'
                WHERE ordernumber = 'P200712110538701' 
            
2024-07-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '229685'
                WHERE ordernumber = 'P180712110554981' 
            
2024-07-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '154281'
                WHERE ordernumber = 'P200712110630918' 
            
2024-07-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '273558'
                WHERE ordernumber = 'P200712110755404' 
            
2024-07-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282963'
                WHERE ordernumber = 'P190712110805136' 
            
2024-07-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400850'
                WHERE ordernumber = 'P630712110822505' 
            
2024-07-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '168335'
                WHERE ordernumber = 'P180712111132348' 
            
2024-07-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400852'
                WHERE ordernumber = 'P200712111143127' 
            
2024-07-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350706'
                WHERE ordernumber = 'P420712111201203' 
            
2024-07-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400853'
                WHERE ordernumber = 'P630712111226753' 
            
2024-07-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400854'
                WHERE ordernumber = 'P420712111356531' 
            
2024-07-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242109'
                WHERE ordernumber = 'P630712111449473' 
            
2024-07-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400855'
                WHERE ordernumber = 'P420712111510188' 
            
2024-07-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160087'
                WHERE ordernumber = 'P180712111545483' 
            
2024-07-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400856'
                WHERE ordernumber = 'P420712112424261' 
            
2024-07-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239464'
                WHERE ordernumber = 'P200712112445772' 
            
2024-07-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400857'
                WHERE ordernumber = 'P420712112705447' 
            
2024-07-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400858'
                WHERE ordernumber = 'P180712112738454' 
            
2024-07-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286560'
                WHERE ordernumber = 'P200712112957362' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400859'
                WHERE ordernumber = 'P180712113019177' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '272188'
                WHERE ordernumber = 'P420712113133655' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400860'
                WHERE ordernumber = 'P180712113237419' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400861'
                WHERE ordernumber = 'P190712113259851' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400459'
                WHERE ordernumber = 'P200712113832333' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400863'
                WHERE ordernumber = 'P180712113929785' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400864'
                WHERE ordernumber = 'P420712113951689' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400865'
                WHERE ordernumber = 'P630712114335850' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313776'
                WHERE ordernumber = 'P190712114437909' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '105064'
                WHERE ordernumber = 'P180712114507906' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '182131'
                WHERE ordernumber = 'P420712114608867' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400866'
                WHERE ordernumber = 'P180712114712943' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386476'
                WHERE ordernumber = 'P180712115223757' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400868'
                WHERE ordernumber = 'P200712115259616' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400869'
                WHERE ordernumber = 'P420712115634990' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352852'
                WHERE ordernumber = 'P630712115744453' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400870'
                WHERE ordernumber = 'P420712115752612' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400873'
                WHERE ordernumber = 'P420712120050142' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283169'
                WHERE ordernumber = 'P180712120054369' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400875'
                WHERE ordernumber = 'P200712120133141' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400876'
                WHERE ordernumber = 'P180712120335663' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400877'
                WHERE ordernumber = 'P200712120636919' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400878'
                WHERE ordernumber = 'P180712120735440' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400879'
                WHERE ordernumber = 'P200712121248861' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397818'
                WHERE ordernumber = 'P180712121806557' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400881'
                WHERE ordernumber = 'P180712122444795' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382980'
                WHERE ordernumber = 'P180712122634818' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400882'
                WHERE ordernumber = 'P180712122940340' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '113420'
                WHERE ordernumber = 'P200712123423722' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278230'
                WHERE ordernumber = 'P200712123547923' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400884'
                WHERE ordernumber = 'P630712123641739' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400885'
                WHERE ordernumber = 'P180712123707274' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '290718'
                WHERE ordernumber = 'P180712124020765' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400886'
                WHERE ordernumber = 'P420712124817346' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398107'
                WHERE ordernumber = 'P630712125432204' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '113488'
                WHERE ordernumber = 'P180712125523972' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400888'
                WHERE ordernumber = 'P630712125728268' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400889'
                WHERE ordernumber = 'P180712125740787' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400890'
                WHERE ordernumber = 'P420712125824281' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347659'
                WHERE ordernumber = 'P180712130010210' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400891'
                WHERE ordernumber = 'P180712130604990' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400893'
                WHERE ordernumber = 'P180712131057579' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339215'
                WHERE ordernumber = 'P200712131156346' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400894'
                WHERE ordernumber = 'P200712131349834' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400895'
                WHERE ordernumber = 'P180712131407401' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400896'
                WHERE ordernumber = 'P180712131606498' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '201211'
                WHERE ordernumber = 'P200712132152328' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '196593'
                WHERE ordernumber = 'P200712132755323' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398122'
                WHERE ordernumber = 'P180712132938153' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400897'
                WHERE ordernumber = 'P200712133511600' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '341034'
                WHERE ordernumber = 'P200712133602916' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '33696'
                WHERE ordernumber = 'P200712133937859' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400898'
                WHERE ordernumber = 'P180712134515898' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400542'
                WHERE ordernumber = 'P180712134841621' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '318317'
                WHERE ordernumber = 'P420712134920985' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400900'
                WHERE ordernumber = 'P200712135441256' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400901'
                WHERE ordernumber = 'P420712135631347' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400904'
                WHERE ordernumber = 'P180712140441496' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400905'
                WHERE ordernumber = 'P180712140641521' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282261'
                WHERE ordernumber = 'P200712140835120' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400906'
                WHERE ordernumber = 'P180712141435805' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '129318'
                WHERE ordernumber = 'P180712142411672' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400907'
                WHERE ordernumber = 'P420712142541174' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400908'
                WHERE ordernumber = 'P180712142714712' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395188'
                WHERE ordernumber = 'P200712142850223' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400318'
                WHERE ordernumber = 'P180712142855111' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '135579'
                WHERE ordernumber = 'P190712143058638' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400899'
                WHERE ordernumber = 'P190712143412470' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395818'
                WHERE ordernumber = 'P180712143530161' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400909'
                WHERE ordernumber = 'P180712144028343' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400910'
                WHERE ordernumber = 'P180712144311677' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '314836'
                WHERE ordernumber = 'P190712144426577' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400912'
                WHERE ordernumber = 'P180712144526981' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '376469'
                WHERE ordernumber = 'P200712144612985' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400913'
                WHERE ordernumber = 'P420712144638134' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '221765'
                WHERE ordernumber = 'P180712144742815' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400914'
                WHERE ordernumber = 'P200712144844687' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237174'
                WHERE ordernumber = 'P200712145032492' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400915'
                WHERE ordernumber = 'P190712145043806' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389340'
                WHERE ordernumber = 'P180712145540608' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400918'
                WHERE ordernumber = 'P420712145833980' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400920'
                WHERE ordernumber = 'P180712150944366' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342424'
                WHERE ordernumber = 'P190712150959162' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '62902'
                WHERE ordernumber = 'P180712151044945' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400922'
                WHERE ordernumber = 'P200712151409973' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '364956'
                WHERE ordernumber = 'P200712151522498' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400924'
                WHERE ordernumber = 'P420712151711746' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '279992'
                WHERE ordernumber = 'P180712151844750' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '208555'
                WHERE ordernumber = 'P180712153321794' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396869'
                WHERE ordernumber = 'P420712153356498' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400261'
                WHERE ordernumber = 'P200712153408395' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400925'
                WHERE ordernumber = 'P420712153822440' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400926'
                WHERE ordernumber = 'P200712154132975' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400929'
                WHERE ordernumber = 'P420712154510905' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400928'
                WHERE ordernumber = 'P180712154726931' 
            
2024-07-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400931'
                WHERE ordernumber = 'P420712155617842' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '337280'
                WHERE ordernumber = 'P200712155908228' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400938'
                WHERE ordernumber = 'P180712161509300' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400937'
                WHERE ordernumber = 'P200712161714634' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '357970'
                WHERE ordernumber = 'P200712161942946' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '264172'
                WHERE ordernumber = 'P200712162155331' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '156612'
                WHERE ordernumber = 'P180712163618441' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350207'
                WHERE ordernumber = 'P180712163747510' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400941'
                WHERE ordernumber = 'P180712164644163' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400942'
                WHERE ordernumber = 'P200712164924972' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400944'
                WHERE ordernumber = 'P420712165048313' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '241711'
                WHERE ordernumber = 'P180712165246801' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368215'
                WHERE ordernumber = 'P420712165321431' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '220760'
                WHERE ordernumber = 'P190712165343177' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400934'
                WHERE ordernumber = 'P590712165353641' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400945'
                WHERE ordernumber = 'P420712165501813' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400946'
                WHERE ordernumber = 'P180712165559216' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '273202'
                WHERE ordernumber = 'P180712165753910' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '230236'
                WHERE ordernumber = 'P180712165924260' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400947'
                WHERE ordernumber = 'P420712170119349' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400948'
                WHERE ordernumber = 'P180712170133329' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400949'
                WHERE ordernumber = 'P180712170304715' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '103193'
                WHERE ordernumber = 'P180712170444698' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400950'
                WHERE ordernumber = 'P200712170559176' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '118690'
                WHERE ordernumber = 'P180712171029630' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '318659'
                WHERE ordernumber = 'P180712171247194' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400951'
                WHERE ordernumber = 'P420712171420766' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393246'
                WHERE ordernumber = 'P420712171552514' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400953'
                WHERE ordernumber = 'P180712171632176' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '315119'
                WHERE ordernumber = 'P200712171700382' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354039'
                WHERE ordernumber = 'P180712171825318' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400954'
                WHERE ordernumber = 'P630712171850221' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '278743'
                WHERE ordernumber = 'P420712171918791' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350014'
                WHERE ordernumber = 'P200712172042883' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400955'
                WHERE ordernumber = 'P190712172155874' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396477'
                WHERE ordernumber = 'P420712172210696' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '279928'
                WHERE ordernumber = 'P180712172239596' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400956'
                WHERE ordernumber = 'P180712172351142' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400842'
                WHERE ordernumber = 'P420712172400554' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350397'
                WHERE ordernumber = 'P190712172440517' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '34187'
                WHERE ordernumber = 'P420712172541315' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400957'
                WHERE ordernumber = 'P180712172703772' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '348591'
                WHERE ordernumber = 'P200712173051137' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400959'
                WHERE ordernumber = 'P180712173327244' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '391191'
                WHERE ordernumber = 'P420712173631159' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '255168'
                WHERE ordernumber = 'P190712173749815' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '283363'
                WHERE ordernumber = 'P180712174219334' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400961'
                WHERE ordernumber = 'P180712174416338' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400960'
                WHERE ordernumber = 'P200712174707823' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '219494'
                WHERE ordernumber = 'P180712175022610' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388632'
                WHERE ordernumber = 'P200712175156626' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400962'
                WHERE ordernumber = 'P180712175237978' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '300239'
                WHERE ordernumber = 'P420712175630479' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '254216'
                WHERE ordernumber = 'P180712175644771' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388483'
                WHERE ordernumber = 'P200712175919286' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400965'
                WHERE ordernumber = 'P180712180031631' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '379635'
                WHERE ordernumber = 'P200712180107378' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '257105'
                WHERE ordernumber = 'P180712180151227' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400966'
                WHERE ordernumber = 'P180712180349317' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '240419'
                WHERE ordernumber = 'P180712180440808' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400967'
                WHERE ordernumber = 'P180712180932303' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '286464'
                WHERE ordernumber = 'P180712181107201' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398350'
                WHERE ordernumber = 'P420712181130606' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '389589'
                WHERE ordernumber = 'P420712181255372' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400968'
                WHERE ordernumber = 'P180712181502946' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400970'
                WHERE ordernumber = 'P630712181605141' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400971'
                WHERE ordernumber = 'P180712181650403' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '236805'
                WHERE ordernumber = 'P200712181807460' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400972'
                WHERE ordernumber = 'P180712181811176' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '380851'
                WHERE ordernumber = 'P180712181957654' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400973'
                WHERE ordernumber = 'P420712182054396' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '275840'
                WHERE ordernumber = 'P200712182136519' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '270709'
                WHERE ordernumber = 'P180712182141245' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400974'
                WHERE ordernumber = 'P190712182211285' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400975'
                WHERE ordernumber = 'P180712182345634' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '387281'
                WHERE ordernumber = 'P200712182426841' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400968'
                WHERE ordernumber = 'P180712182556826' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398412'
                WHERE ordernumber = 'P180712182653740' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400977'
                WHERE ordernumber = 'P180712182824590' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400978'
                WHERE ordernumber = 'P630712182910141' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '248723'
                WHERE ordernumber = 'P200712182931157' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400979'
                WHERE ordernumber = 'P190712183546661' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '387281'
                WHERE ordernumber = 'P200712183636221' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '97942'
                WHERE ordernumber = 'P200712183724903' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '25'
                WHERE ordernumber = 'P180712183739563' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '247872'
                WHERE ordernumber = 'P180712183846206' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '285581'
                WHERE ordernumber = 'P630712183904443' 
            
2024-07-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400982'
                WHERE ordernumber = 'P630712184145251' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400983'
                WHERE ordernumber = 'P200712184215134' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400985'
                WHERE ordernumber = 'P180712184504133' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399751'
                WHERE ordernumber = 'P630712184508417' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400981'
                WHERE ordernumber = 'P630712184512151' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400984'
                WHERE ordernumber = 'P630712184523375' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399323'
                WHERE ordernumber = 'P180712184902751' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '81721'
                WHERE ordernumber = 'P180712185001788' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400986'
                WHERE ordernumber = 'P630712185032500' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '275290'
                WHERE ordernumber = 'P180712185157541' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400988'
                WHERE ordernumber = 'P200712185233514' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400980'
                WHERE ordernumber = 'P420712185641307' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353514'
                WHERE ordernumber = 'P190712185702374' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400991'
                WHERE ordernumber = 'P630712185907617' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400989'
                WHERE ordernumber = 'P200712190055582' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400992'
                WHERE ordernumber = 'P630712190355236' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400993'
                WHERE ordernumber = 'P630712190514858' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '96283'
                WHERE ordernumber = 'P190712191359604' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '287248'
                WHERE ordernumber = 'P200712191521685' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400994'
                WHERE ordernumber = 'P630712191728783' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '308644'
                WHERE ordernumber = 'P190712191800445' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400995'
                WHERE ordernumber = 'P630712191813687' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400996'
                WHERE ordernumber = 'P190712192036879' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '395154'
                WHERE ordernumber = 'P190712192133325' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400997'
                WHERE ordernumber = 'P190712192308390' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '132651'
                WHERE ordernumber = 'P200712192318155' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400998'
                WHERE ordernumber = 'P200712192453983' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '281733'
                WHERE ordernumber = 'P190712192527464' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400999'
                WHERE ordernumber = 'P630712192546545' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '206434'
                WHERE ordernumber = 'P190712192733184' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '161033'
                WHERE ordernumber = 'P190712192953907' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '95365'
                WHERE ordernumber = 'P200712193215767' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '347104'
                WHERE ordernumber = 'P190712193244591' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '174924'
                WHERE ordernumber = 'P190712193452408' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401001'
                WHERE ordernumber = 'P190712193809498' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401002'
                WHERE ordernumber = 'P200712194012609' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401003'
                WHERE ordernumber = 'P630712194100344' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '397555'
                WHERE ordernumber = 'P190712194240768' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '309135'
                WHERE ordernumber = 'P200712194356968' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401004'
                WHERE ordernumber = 'P630712194508502' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '235019'
                WHERE ordernumber = 'P630712194615199' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '84458'
                WHERE ordernumber = 'P190712194620641' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351381'
                WHERE ordernumber = 'P200712194757925' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '34642'
                WHERE ordernumber = 'P630712194822843' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401005'
                WHERE ordernumber = 'P190712194936826' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401006'
                WHERE ordernumber = 'P630712194945712' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401007'
                WHERE ordernumber = 'P190712195032140' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401008'
                WHERE ordernumber = 'P630712195118675' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401009'
                WHERE ordernumber = 'P190712195138409' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401010'
                WHERE ordernumber = 'P630712195339200' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '360376'
                WHERE ordernumber = 'P630712195642851' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '311758'
                WHERE ordernumber = 'P190712195910125' 
            
2024-07-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401013'
                WHERE ordernumber = 'P630712203055333'