2024-05-08 01:00:02 -- 將會員中心id寫入data-lake
2024-05-08 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-05-07%';
        
2024-05-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388760'
                WHERE ordernumber = 'P630507102701768' 
            
2024-05-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '294236'
                WHERE ordernumber = 'P200507110004530' 
            
2024-05-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '115040'
                WHERE ordernumber = 'P180507110318458' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351888'
                WHERE ordernumber = 'P200507110426808' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383660'
                WHERE ordernumber = 'P200507110614294' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '251943'
                WHERE ordernumber = 'P200507110741212' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348860'
                WHERE ordernumber = 'P420507111552719' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388765'
                WHERE ordernumber = 'P420507111912219' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160169'
                WHERE ordernumber = 'P180507112027697' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100925'
                WHERE ordernumber = 'P200507112915549' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378451'
                WHERE ordernumber = 'P180507113139786' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '331463'
                WHERE ordernumber = 'P790507113211594' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387994'
                WHERE ordernumber = 'P630507113250649' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388766'
                WHERE ordernumber = 'P790507114201579' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388768'
                WHERE ordernumber = 'P180507114547365' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388769'
                WHERE ordernumber = 'P200507114627718' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386561'
                WHERE ordernumber = 'P420507114713772' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388770'
                WHERE ordernumber = 'P180507114950368' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281945'
                WHERE ordernumber = 'P200507115057267' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '39164'
                WHERE ordernumber = 'P200507115333307' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '154183'
                WHERE ordernumber = 'P180507115358783' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310921'
                WHERE ordernumber = 'P190507115425383' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388771'
                WHERE ordernumber = 'P200507115706672' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388772'
                WHERE ordernumber = 'P200507120149642' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348545'
                WHERE ordernumber = 'P420507120529355' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '318838'
                WHERE ordernumber = 'P790507120917485' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388775'
                WHERE ordernumber = 'P200507121754271' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99780'
                WHERE ordernumber = 'P180507121756470' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387994'
                WHERE ordernumber = 'P630507122052175' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388778'
                WHERE ordernumber = 'P200507123540512' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '105656'
                WHERE ordernumber = 'P200507124028250' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388774'
                WHERE ordernumber = 'P200507124213222' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365200'
                WHERE ordernumber = 'P420507124523181' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '360078'
                WHERE ordernumber = 'P590507124839829' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388781'
                WHERE ordernumber = 'P200507125012314' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388780'
                WHERE ordernumber = 'P420507125012467' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283429'
                WHERE ordernumber = 'P200507125259672' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285232'
                WHERE ordernumber = 'P180507125611159' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '373363'
                WHERE ordernumber = 'P200507125712292' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '226971'
                WHERE ordernumber = 'P180507131003674' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388784'
                WHERE ordernumber = 'P630507131339562' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '229358'
                WHERE ordernumber = 'P180507131645314' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352052'
                WHERE ordernumber = 'P420507131813486' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388785'
                WHERE ordernumber = 'P190507131820989' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388786'
                WHERE ordernumber = 'P180507131856366' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388787'
                WHERE ordernumber = 'P630507131915914' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113366'
                WHERE ordernumber = 'P200507131922165' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388788'
                WHERE ordernumber = 'P180507132708981' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '174358'
                WHERE ordernumber = 'P790507132742681' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299069'
                WHERE ordernumber = 'P630507133513588' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388790'
                WHERE ordernumber = 'P190507133639521' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388791'
                WHERE ordernumber = 'P190507133821285' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '1789'
                WHERE ordernumber = 'P190507133910547' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112637'
                WHERE ordernumber = 'P190507133938558' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388789'
                WHERE ordernumber = 'P790507134217258' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388792'
                WHERE ordernumber = 'P190507134257573' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388793'
                WHERE ordernumber = 'P190507134424422' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350514'
                WHERE ordernumber = 'P420507134458706' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388795'
                WHERE ordernumber = 'P790507134645578' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113156'
                WHERE ordernumber = 'P190507134811418' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241940'
                WHERE ordernumber = 'P190507135024835' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388796'
                WHERE ordernumber = 'P420507135233532' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '86113'
                WHERE ordernumber = 'P180507135336852' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238430'
                WHERE ordernumber = 'P180507135718898' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388797'
                WHERE ordernumber = 'P420507135927972' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388798'
                WHERE ordernumber = 'P180507140039322' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '137581'
                WHERE ordernumber = 'P180507140136448' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388799'
                WHERE ordernumber = 'P190507140253986' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338718'
                WHERE ordernumber = 'P180507140651601' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388801'
                WHERE ordernumber = 'P180507141318663' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385632'
                WHERE ordernumber = 'P590507141536267' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247665'
                WHERE ordernumber = 'P180507141553135' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388802'
                WHERE ordernumber = 'P790507141910690' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '84134'
                WHERE ordernumber = 'P180507141947668' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '83223'
                WHERE ordernumber = 'P200507142034641' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388804'
                WHERE ordernumber = 'P420507142426764' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275910'
                WHERE ordernumber = 'P180507142503353' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245325'
                WHERE ordernumber = 'P190507143309827' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '327762'
                WHERE ordernumber = 'P420507143857768' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341871'
                WHERE ordernumber = 'P790507143927422' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386106'
                WHERE ordernumber = 'P420507144534947' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '141878'
                WHERE ordernumber = 'P200507145236171' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '141878'
                WHERE ordernumber = 'P200507145348257' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347179'
                WHERE ordernumber = 'P420507145501374' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '12268'
                WHERE ordernumber = 'P180507145550713' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '316948'
                WHERE ordernumber = 'P180507145752142' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '105827'
                WHERE ordernumber = 'P200507150534411' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388807'
                WHERE ordernumber = 'P180507150954308' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '45480'
                WHERE ordernumber = 'P200507151550732' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388808'
                WHERE ordernumber = 'P180507151809245' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388809'
                WHERE ordernumber = 'P180507152105230' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '134844'
                WHERE ordernumber = 'P420507153421894' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388810'
                WHERE ordernumber = 'P180507153725125' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388811'
                WHERE ordernumber = 'P190507153746784' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388812'
                WHERE ordernumber = 'P200507153923947' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '376126'
                WHERE ordernumber = 'P790507154315587' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372050'
                WHERE ordernumber = 'P420507154911334' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388814'
                WHERE ordernumber = 'P420507155758914' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '233190'
                WHERE ordernumber = 'P200507160029557' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388815'
                WHERE ordernumber = 'P790507160205851' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '207267'
                WHERE ordernumber = 'P180507160503771' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304793'
                WHERE ordernumber = 'P180507160951216' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388816'
                WHERE ordernumber = 'P420507161106287' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388818'
                WHERE ordernumber = 'P200507161713297' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238709'
                WHERE ordernumber = 'P200507161815244' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388819'
                WHERE ordernumber = 'P180507162301989' 
            
2024-05-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100658'
                WHERE ordernumber = 'P200507162435188' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388073'
                WHERE ordernumber = 'P200507163048755' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388073'
                WHERE ordernumber = 'P200507163136856' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381642'
                WHERE ordernumber = 'P630507163920893' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388821'
                WHERE ordernumber = 'P200507165255153' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388822'
                WHERE ordernumber = 'P180507165625161' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388823'
                WHERE ordernumber = 'P420507170359593' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388824'
                WHERE ordernumber = 'P180507170553969' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388825'
                WHERE ordernumber = 'P200507171500522' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388826'
                WHERE ordernumber = 'P180507171647887' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388827'
                WHERE ordernumber = 'P200507171837179' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '204052'
                WHERE ordernumber = 'P200507172018329' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388829'
                WHERE ordernumber = 'P180507172151523' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388829'
                WHERE ordernumber = 'P180507172232933' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388828'
                WHERE ordernumber = 'P790507172258880' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388831'
                WHERE ordernumber = 'P420507172534467' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388830'
                WHERE ordernumber = 'P790507172555312' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388832'
                WHERE ordernumber = 'P200507172843138' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100976'
                WHERE ordernumber = 'P180507172919766' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388835'
                WHERE ordernumber = 'P180507173717999' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '112794'
                WHERE ordernumber = 'P200507173951636' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388323'
                WHERE ordernumber = 'P180507174219533' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388836'
                WHERE ordernumber = 'P200507174225792' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '112794'
                WHERE ordernumber = 'P200507174318822' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388837'
                WHERE ordernumber = 'P180507174423561' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '271310'
                WHERE ordernumber = 'P180507174513815' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388750'
                WHERE ordernumber = 'P190507175032748' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388750'
                WHERE ordernumber = 'P190507175047229' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388839'
                WHERE ordernumber = 'P630507175242942' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388840'
                WHERE ordernumber = 'P630507175505286' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388841'
                WHERE ordernumber = 'P180507175535805' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '115574'
                WHERE ordernumber = 'P180507175702754' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102422'
                WHERE ordernumber = 'P200507175856269' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388842'
                WHERE ordernumber = 'P630507175944190' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '363409'
                WHERE ordernumber = 'P180507180602258' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387600'
                WHERE ordernumber = 'P200507181707411' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388844'
                WHERE ordernumber = 'P630507181839115' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388009'
                WHERE ordernumber = 'P190507181842269' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388845'
                WHERE ordernumber = 'P200507182539416' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380180'
                WHERE ordernumber = 'P190507182647493' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '17484'
                WHERE ordernumber = 'P200507182808913' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388846'
                WHERE ordernumber = 'P190507183100750' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '91497'
                WHERE ordernumber = 'P630507183210209' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102743'
                WHERE ordernumber = 'P190507183428500' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388847'
                WHERE ordernumber = 'P200507183926626' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '133735'
                WHERE ordernumber = 'P190507184117725' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '64173'
                WHERE ordernumber = 'P180507184136407' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '136646'
                WHERE ordernumber = 'P200507184305670' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388848'
                WHERE ordernumber = 'P190507184722799' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275499'
                WHERE ordernumber = 'P200507184750127' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388848'
                WHERE ordernumber = 'P190507184810241' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '266145'
                WHERE ordernumber = 'P200507185218400' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388850'
                WHERE ordernumber = 'P630507185243878' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304060'
                WHERE ordernumber = 'P190507185511565' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313610'
                WHERE ordernumber = 'P190507185849691' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '272269'
                WHERE ordernumber = 'P190507190009814' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388757'
                WHERE ordernumber = 'P630507190140204' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388851'
                WHERE ordernumber = 'P200507190646596' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313481'
                WHERE ordernumber = 'P190507190936416' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388852'
                WHERE ordernumber = 'P630507191429193' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '341122'
                WHERE ordernumber = 'P200507191554529' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388853'
                WHERE ordernumber = 'P200507192553822' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386588'
                WHERE ordernumber = 'P190507192732397' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '229560'
                WHERE ordernumber = 'P190507192841811' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '271614'
                WHERE ordernumber = 'P190507193304693' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385036'
                WHERE ordernumber = 'P200507193331575' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388854'
                WHERE ordernumber = 'P420507193758535' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '124590'
                WHERE ordernumber = 'P190507194426196' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382944'
                WHERE ordernumber = 'P190507194628874' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346493'
                WHERE ordernumber = 'P200507195112527' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388855'
                WHERE ordernumber = 'P420507200733976' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388857'
                WHERE ordernumber = 'P420507201019140' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388859'
                WHERE ordernumber = 'P630507202142112' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386180'
                WHERE ordernumber = 'P630507202309388' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388860'
                WHERE ordernumber = 'P790507205314577' 
            
2024-05-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388860'
                WHERE ordernumber = 'P790507205519386'