2023-12-09 01:00:02 -- 將會員中心id寫入data-lake
2023-12-09 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 '2023-12-08%';
        
2023-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '112794'
                WHERE ordernumber = 'P201208110536917' 
            
2023-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '212547'
                WHERE ordernumber = 'P191208110558614' 
            
2023-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '191342'
                WHERE ordernumber = 'P201208111536130' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '50773'
                WHERE ordernumber = 'P181208111605817' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '110891'
                WHERE ordernumber = 'P191208111722725' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '260423'
                WHERE ordernumber = 'P201208111938302' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241995'
                WHERE ordernumber = 'P181208112049422' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351269'
                WHERE ordernumber = 'P191208112305129' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276194'
                WHERE ordernumber = 'P201208112344674' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351270'
                WHERE ordernumber = 'P191208112650870' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346218'
                WHERE ordernumber = 'P201208112755903' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351271'
                WHERE ordernumber = 'P191208112823988' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351272'
                WHERE ordernumber = 'P191208112912207' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '272747'
                WHERE ordernumber = 'P201208113146715' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '258546'
                WHERE ordernumber = 'P201208113600944' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230930'
                WHERE ordernumber = 'P191208114126799' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351275'
                WHERE ordernumber = 'P421208114301243' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346212'
                WHERE ordernumber = 'P181208114315286' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351277'
                WHERE ordernumber = 'P421208114410469' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247870'
                WHERE ordernumber = 'P201208114511136' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '131038'
                WHERE ordernumber = 'P201208115126518' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '105981'
                WHERE ordernumber = 'P181208115158165' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340888'
                WHERE ordernumber = 'P421208115411765' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351279'
                WHERE ordernumber = 'P181208115702938' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349702'
                WHERE ordernumber = 'P181208120048425' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351281'
                WHERE ordernumber = 'P421208120530190' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287531'
                WHERE ordernumber = 'P201208120536860' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351282'
                WHERE ordernumber = 'P201208120704616' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349966'
                WHERE ordernumber = 'P201208121150464' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100522'
                WHERE ordernumber = 'P191208121210738' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286571'
                WHERE ordernumber = 'P201208121247218' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337892'
                WHERE ordernumber = 'P191208122230467' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351285'
                WHERE ordernumber = 'P191208122745299' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351286'
                WHERE ordernumber = 'P201208122802473' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284471'
                WHERE ordernumber = 'P201208122915483' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102473'
                WHERE ordernumber = 'P191208122937901' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350771'
                WHERE ordernumber = 'P181208123235327' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351284'
                WHERE ordernumber = 'P191208124405287' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351284'
                WHERE ordernumber = 'P191208124435219' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279866'
                WHERE ordernumber = 'P201208124857217' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '268471'
                WHERE ordernumber = 'P201208125831609' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '268471'
                WHERE ordernumber = 'P201208125920899' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '290609'
                WHERE ordernumber = 'P201208125948915' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '129132'
                WHERE ordernumber = 'P181208125951638' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '62760'
                WHERE ordernumber = 'P201208130410502' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240565'
                WHERE ordernumber = 'P201208130620622' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351287'
                WHERE ordernumber = 'P201208131036370' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '311520'
                WHERE ordernumber = 'P421208131540498' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351289'
                WHERE ordernumber = 'P201208133208343' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '152095'
                WHERE ordernumber = 'P191208134119191' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351291'
                WHERE ordernumber = 'P191208134642710' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351293'
                WHERE ordernumber = 'P201208135101814' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351294'
                WHERE ordernumber = 'P191208135218287' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340889'
                WHERE ordernumber = 'P421208135305224' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351296'
                WHERE ordernumber = 'P201208135923497' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351297'
                WHERE ordernumber = 'P421208140122309' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351296'
                WHERE ordernumber = 'P201208140203373' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '166769'
                WHERE ordernumber = 'P201208140421629' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349978'
                WHERE ordernumber = 'P201208141023363' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351302'
                WHERE ordernumber = 'P181208141607457' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351303'
                WHERE ordernumber = 'P201208141711972' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '331947'
                WHERE ordernumber = 'P181208142127927' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351304'
                WHERE ordernumber = 'P181208142511205' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351306'
                WHERE ordernumber = 'P181208143004973' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351309'
                WHERE ordernumber = 'P181208143446397' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351310'
                WHERE ordernumber = 'P181208144350965' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351312'
                WHERE ordernumber = 'P181208144620546' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351313'
                WHERE ordernumber = 'P181208144816577' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351315'
                WHERE ordernumber = 'P181208145105502' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241193'
                WHERE ordernumber = 'P181208145138154' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351316'
                WHERE ordernumber = 'P181208145236261' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306583'
                WHERE ordernumber = 'P201208145247657' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351317'
                WHERE ordernumber = 'P421208145411168' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351318'
                WHERE ordernumber = 'P421208145616781' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351260'
                WHERE ordernumber = 'P181208145845765' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301342'
                WHERE ordernumber = 'P181208145933883' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301342'
                WHERE ordernumber = 'P181208150034964' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351321'
                WHERE ordernumber = 'P201208150156908' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351321'
                WHERE ordernumber = 'P201208150418243' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351322'
                WHERE ordernumber = 'P181208150436390' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278859'
                WHERE ordernumber = 'P181208151346561' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '155690'
                WHERE ordernumber = 'P191208151425849' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351325'
                WHERE ordernumber = 'P181208151510446' 
            
2023-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '221930'
                WHERE ordernumber = 'P181208151945375' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '243600'
                WHERE ordernumber = 'P201208152043656' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342571'
                WHERE ordernumber = 'P181208152348186' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236923'
                WHERE ordernumber = 'P181208152623740' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348484'
                WHERE ordernumber = 'P201208152933201' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351328'
                WHERE ordernumber = 'P191208153119436' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '101475'
                WHERE ordernumber = 'P201208153506599' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351331'
                WHERE ordernumber = 'P191208153538756' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340958'
                WHERE ordernumber = 'P201208153808451' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301332'
                WHERE ordernumber = 'P201208154319674' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351334'
                WHERE ordernumber = 'P201208154403255' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351336'
                WHERE ordernumber = 'P191208154640807' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351337'
                WHERE ordernumber = 'P201208154859827' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351335'
                WHERE ordernumber = 'P421208155042897' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351338'
                WHERE ordernumber = 'P421208155454352' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '135594'
                WHERE ordernumber = 'P201208160214200' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344925'
                WHERE ordernumber = 'P421208160329536' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '222356'
                WHERE ordernumber = 'P191208160634921' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351222'
                WHERE ordernumber = 'P181208161311414' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351222'
                WHERE ordernumber = 'P181208161400704' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351342'
                WHERE ordernumber = 'P191208161647236' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351343'
                WHERE ordernumber = 'P191208161752938' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343888'
                WHERE ordernumber = 'P191208161847951' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348164'
                WHERE ordernumber = 'P201208162246638' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351345'
                WHERE ordernumber = 'P201208162409360' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351346'
                WHERE ordernumber = 'P201208162613117' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345322'
                WHERE ordernumber = 'P201208162740672' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '141541'
                WHERE ordernumber = 'P191208162921406' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349890'
                WHERE ordernumber = 'P191208163157826' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351350'
                WHERE ordernumber = 'P201208163259784' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351349'
                WHERE ordernumber = 'P191208163304848' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351351'
                WHERE ordernumber = 'P201208163814298' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351352'
                WHERE ordernumber = 'P201208164346831' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '211877'
                WHERE ordernumber = 'P191208164719688' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351355'
                WHERE ordernumber = 'P191208165530832' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349798'
                WHERE ordernumber = 'P191208170540546' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '8086'
                WHERE ordernumber = 'P201208171710164' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351359'
                WHERE ordernumber = 'P421208171712164' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342831'
                WHERE ordernumber = 'P201208172029438' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '319505'
                WHERE ordernumber = 'P191208172603225' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351364'
                WHERE ordernumber = 'P191208172803571' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345799'
                WHERE ordernumber = 'P191208173219510' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351366'
                WHERE ordernumber = 'P421208174250265' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '118209'
                WHERE ordernumber = 'P191208174442606' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '293580'
                WHERE ordernumber = 'P201208174549943' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '216385'
                WHERE ordernumber = 'P181208174710431' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '28299'
                WHERE ordernumber = 'P181208174909787' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348565'
                WHERE ordernumber = 'P201208175149691' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '286229'
                WHERE ordernumber = 'P201208175822766' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '253281'
                WHERE ordernumber = 'P191208175924353' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '119616'
                WHERE ordernumber = 'P191208180214250' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351367'
                WHERE ordernumber = 'P191208181252467' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '235753'
                WHERE ordernumber = 'P201208181533509' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343958'
                WHERE ordernumber = 'P421208181611419' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '138130'
                WHERE ordernumber = 'P421208181925471' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '311430'
                WHERE ordernumber = 'P181208181936875' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351368'
                WHERE ordernumber = 'P421208182226117' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351369'
                WHERE ordernumber = 'P181208182655539' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313481'
                WHERE ordernumber = 'P191208182728438' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351366'
                WHERE ordernumber = 'P421208183357224' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351371'
                WHERE ordernumber = 'P191208183946483' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342684'
                WHERE ordernumber = 'P201208184026863' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351370'
                WHERE ordernumber = 'P191208184332134' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351069'
                WHERE ordernumber = 'P181208184424287' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351370'
                WHERE ordernumber = 'P191208184521123' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '34454'
                WHERE ordernumber = 'P421208184522256' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351371'
                WHERE ordernumber = 'P181208184543485' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313879'
                WHERE ordernumber = 'P191208184750903' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '290301'
                WHERE ordernumber = 'P201208190109518' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '37210'
                WHERE ordernumber = 'P191208190120555' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351375'
                WHERE ordernumber = 'P201208190432164' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346792'
                WHERE ordernumber = 'P191208190536659' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '221484'
                WHERE ordernumber = 'P201208190851988' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351376'
                WHERE ordernumber = 'P421208190853164' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '246256'
                WHERE ordernumber = 'P191208190854437' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '330801'
                WHERE ordernumber = 'P191208190947269' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '251182'
                WHERE ordernumber = 'P201208191247617' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '132985'
                WHERE ordernumber = 'P201208191609509' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351377'
                WHERE ordernumber = 'P421208192908340' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '341339'
                WHERE ordernumber = 'P201208193039778' 
            
2023-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345622'
                WHERE ordernumber = 'P421208193055786' 
            
2023-12-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '251341'
                WHERE ordernumber = 'P191208193104868' 
            
2023-12-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '172367'
                WHERE ordernumber = 'P191208193250777' 
            
2023-12-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '298758'
                WHERE ordernumber = 'P201208193421474' 
            
2023-12-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351379'
                WHERE ordernumber = 'P201208193724213' 
            
2023-12-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351380'
                WHERE ordernumber = 'P201208194102380' 
            
2023-12-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351381'
                WHERE ordernumber = 'P201208194701854' 
            
2023-12-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '276432'
                WHERE ordernumber = 'P191208194811783' 
            
2023-12-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351382'
                WHERE ordernumber = 'P201208194943178' 
            
2023-12-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351384'
                WHERE ordernumber = 'P191208195347456' 
            
2023-12-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '95310'
                WHERE ordernumber = 'P191208195436436' 
            
2023-12-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '100450'
                WHERE ordernumber = 'P191208195653959' 
            
2023-12-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351387'
                WHERE ordernumber = 'P201208195731728' 
            
2023-12-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '300132'
                WHERE ordernumber = 'P421208200036205' 
            
2023-12-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '295725'
                WHERE ordernumber = 'P201208200219987'