2024-08-21 01:00:02 -- 將會員中心id寫入data-lake
2024-08-21 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-08-20%';
        
2024-08-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '141741'
                WHERE ordernumber = 'P630820102202469' 
            
2024-08-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '96100'
                WHERE ordernumber = 'P190820110150243' 
            
2024-08-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '304079'
                WHERE ordernumber = 'P180820110213519' 
            
2024-08-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410912'
                WHERE ordernumber = 'P200820110357764' 
            
2024-08-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407446'
                WHERE ordernumber = 'P420820110358352' 
            
2024-08-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410912'
                WHERE ordernumber = 'P200820110532339' 
            
2024-08-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387912'
                WHERE ordernumber = 'P200820110613551' 
            
2024-08-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '309849'
                WHERE ordernumber = 'P180820110851150' 
            
2024-08-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '164904'
                WHERE ordernumber = 'P420820110929748' 
            
2024-08-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410912'
                WHERE ordernumber = 'P200820110946489' 
            
2024-08-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180820111551720' 
            
2024-08-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '309459'
                WHERE ordernumber = 'P420820111817930' 
            
2024-08-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410921'
                WHERE ordernumber = 'P200820112245759' 
            
2024-08-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '13393'
                WHERE ordernumber = 'P420820112311272' 
            
2024-08-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410923'
                WHERE ordernumber = 'P420820112418958' 
            
2024-08-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '78196'
                WHERE ordernumber = 'P200820112522993' 
            
2024-08-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410924'
                WHERE ordernumber = 'P420820112613211' 
            
2024-08-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '312073'
                WHERE ordernumber = 'P190820112630173' 
            
2024-08-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '285340'
                WHERE ordernumber = 'P180820113517979' 
            
2024-08-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348545'
                WHERE ordernumber = 'P420820113546331' 
            
2024-08-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410929'
                WHERE ordernumber = 'P190820113636906' 
            
2024-08-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '400722'
                WHERE ordernumber = 'P180820113817817' 
            
2024-08-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410935'
                WHERE ordernumber = 'P420820114325290' 
            
2024-08-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410937'
                WHERE ordernumber = 'P200820114348647' 
            
2024-08-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '229855'
                WHERE ordernumber = 'P180820114656420' 
            
2024-08-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '405698'
                WHERE ordernumber = 'P420820114716352' 
            
2024-08-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371964'
                WHERE ordernumber = 'P420820114838788' 
            
2024-08-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410944'
                WHERE ordernumber = 'P200820115643617' 
            
2024-08-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '154797'
                WHERE ordernumber = 'P190820120242161' 
            
2024-08-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '156949'
                WHERE ordernumber = 'P180820120259675' 
            
2024-08-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410492'
                WHERE ordernumber = 'P180820120528483' 
            
2024-08-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410492'
                WHERE ordernumber = 'P180820120619218' 
            
2024-08-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410955'
                WHERE ordernumber = 'P200820120704587' 
            
2024-08-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410959'
                WHERE ordernumber = 'P190820121201704' 
            
2024-08-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410957'
                WHERE ordernumber = 'P200820121206197' 
            
2024-08-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410960'
                WHERE ordernumber = 'P180820121249258' 
            
2024-08-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410961'
                WHERE ordernumber = 'P190820121328569' 
            
2024-08-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '340298'
                WHERE ordernumber = 'P180820121400934' 
            
2024-08-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392572'
                WHERE ordernumber = 'P590820121847416' 
            
2024-08-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '270849'
                WHERE ordernumber = 'P420820122039119' 
            
2024-08-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407186'
                WHERE ordernumber = 'P180820122204195' 
            
2024-08-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '228713'
                WHERE ordernumber = 'P200820122431862' 
            
2024-08-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '105855'
                WHERE ordernumber = 'P180820122515947' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410966'
                WHERE ordernumber = 'P420820122623773' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410967'
                WHERE ordernumber = 'P420820122801857' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '272813'
                WHERE ordernumber = 'P200820122856593' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410973'
                WHERE ordernumber = 'P190820123348750' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379493'
                WHERE ordernumber = 'P180820123445851' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410977'
                WHERE ordernumber = 'P180820123907797' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '115459'
                WHERE ordernumber = 'P200820124010542' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410982'
                WHERE ordernumber = 'P180820124420775' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '220718'
                WHERE ordernumber = 'P200820125059145' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '269118'
                WHERE ordernumber = 'P200820125330369' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '122285'
                WHERE ordernumber = 'P190820125418958' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410992'
                WHERE ordernumber = 'P180820125542367' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410994'
                WHERE ordernumber = 'P180820125810449' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410998'
                WHERE ordernumber = 'P420820130245232' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385439'
                WHERE ordernumber = 'P200820130319338' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '80997'
                WHERE ordernumber = 'P200820130424678' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237799'
                WHERE ordernumber = 'P200820130738984' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411002'
                WHERE ordernumber = 'P180820131116121' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '293946'
                WHERE ordernumber = 'P180820131216279' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411005'
                WHERE ordernumber = 'P420820131256691' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339659'
                WHERE ordernumber = 'P200820131423521' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '261666'
                WHERE ordernumber = 'P420820131434415' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411007'
                WHERE ordernumber = 'P420820131800145' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411007'
                WHERE ordernumber = 'P420820131843219' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '79058'
                WHERE ordernumber = 'P420820132410781' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411015'
                WHERE ordernumber = 'P420820133309636' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237296'
                WHERE ordernumber = 'P180820133414929' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379179'
                WHERE ordernumber = 'P200820134457659' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118999'
                WHERE ordernumber = 'P200820140146511' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '192556'
                WHERE ordernumber = 'P180820140346705' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '311267'
                WHERE ordernumber = 'P200820140412476' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '311267'
                WHERE ordernumber = 'P200820140419163' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411023'
                WHERE ordernumber = 'P200820140821314' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P180820141210660' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '153894'
                WHERE ordernumber = 'P200820142421181' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385182'
                WHERE ordernumber = 'P420820142514130' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411031'
                WHERE ordernumber = 'P420820142730376' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393959'
                WHERE ordernumber = 'P190820142932336' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '318869'
                WHERE ordernumber = 'P200820143036502' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410547'
                WHERE ordernumber = 'P200820143631887' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411033'
                WHERE ordernumber = 'P420820143641957' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406693'
                WHERE ordernumber = 'P180820143732550' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411034'
                WHERE ordernumber = 'P420820143822184' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411035'
                WHERE ordernumber = 'P190820143910667' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410547'
                WHERE ordernumber = 'P200820143912421' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '332042'
                WHERE ordernumber = 'P180820143934729' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '161965'
                WHERE ordernumber = 'P200820144108267' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '136621'
                WHERE ordernumber = 'P200820144506985' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '256415'
                WHERE ordernumber = 'P180820144629807' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411034'
                WHERE ordernumber = 'P420820143822184' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411034'
                WHERE ordernumber = 'P420820145114904' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '131589'
                WHERE ordernumber = 'P180820145204619' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409455'
                WHERE ordernumber = 'P200820145236591' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411051'
                WHERE ordernumber = 'P420820145256463' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '105351'
                WHERE ordernumber = 'P200820145751810' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411060'
                WHERE ordernumber = 'P200820150601258' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411061'
                WHERE ordernumber = 'P200820150650551' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285170'
                WHERE ordernumber = 'P190820150755822' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '219421'
                WHERE ordernumber = 'P180820151220343' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381145'
                WHERE ordernumber = 'P420820151539853' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411074'
                WHERE ordernumber = 'P180820152516825' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214193'
                WHERE ordernumber = 'P180820153029652' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '69095'
                WHERE ordernumber = 'P200820153150894' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '69095'
                WHERE ordernumber = 'P200820153153203' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409345'
                WHERE ordernumber = 'P200820153304631' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '330417'
                WHERE ordernumber = 'P200820154121572' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411093'
                WHERE ordernumber = 'P200820154824604' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411095'
                WHERE ordernumber = 'P180820155306146' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '262762'
                WHERE ordernumber = 'P180820155834252' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410668'
                WHERE ordernumber = 'P200820155843266' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404701'
                WHERE ordernumber = 'P200820160001557' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404701'
                WHERE ordernumber = 'P200820160327416' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405828'
                WHERE ordernumber = 'P200820160541166' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405828'
                WHERE ordernumber = 'P200820160609193' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407830'
                WHERE ordernumber = 'P180820161102233' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411108'
                WHERE ordernumber = 'P180820161618684' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411109'
                WHERE ordernumber = 'P420820161651825' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411110'
                WHERE ordernumber = 'P180820161730176' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313957'
                WHERE ordernumber = 'P200820161835181' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411111'
                WHERE ordernumber = 'P180820161903244' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344448'
                WHERE ordernumber = 'P200820163142182' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411117'
                WHERE ordernumber = 'P200820163351469' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310246'
                WHERE ordernumber = 'P200820163503571' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411121'
                WHERE ordernumber = 'P200820163747403' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411120'
                WHERE ordernumber = 'P180820163805230' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410633'
                WHERE ordernumber = 'P180820163914533' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '375802'
                WHERE ordernumber = 'P180820164729972' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350790'
                WHERE ordernumber = 'P420820165049990' 
            
2024-08-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411128'
                WHERE ordernumber = 'P180820165110189' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411131'
                WHERE ordernumber = 'P180820165554372' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94254'
                WHERE ordernumber = 'P180820165627188' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411134'
                WHERE ordernumber = 'P200820170104605' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408033'
                WHERE ordernumber = 'P180820170701536' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399286'
                WHERE ordernumber = 'P180820171044565' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411139'
                WHERE ordernumber = 'P180820171450636' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411140'
                WHERE ordernumber = 'P200820171841143' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393774'
                WHERE ordernumber = 'P200820172119166' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '101435'
                WHERE ordernumber = 'P200820172459585' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '218548'
                WHERE ordernumber = 'P200820172632170' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401831'
                WHERE ordernumber = 'P180820172720228' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398016'
                WHERE ordernumber = 'P200820173140890' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411148'
                WHERE ordernumber = 'P200820173807245' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411148'
                WHERE ordernumber = 'P200820173811598' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411152'
                WHERE ordernumber = 'P200820173955159' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411156'
                WHERE ordernumber = 'P420820174443299' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405100'
                WHERE ordernumber = 'P200820174811782' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '133492'
                WHERE ordernumber = 'P200820174909418' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '217292'
                WHERE ordernumber = 'P180820175419915' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '268471'
                WHERE ordernumber = 'P200820175526397' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408428'
                WHERE ordernumber = 'P180820175635193' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '119732'
                WHERE ordernumber = 'P180820180230928' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388931'
                WHERE ordernumber = 'P630820180358832' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350903'
                WHERE ordernumber = 'P200820180629466' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390180'
                WHERE ordernumber = 'P180820180831515' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396097'
                WHERE ordernumber = 'P180820181020159' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237010'
                WHERE ordernumber = 'P200820181320135' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '328000'
                WHERE ordernumber = 'P200820181427642' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '328000'
                WHERE ordernumber = 'P200820181721496' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377388'
                WHERE ordernumber = 'P200820182315614' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411177'
                WHERE ordernumber = 'P420820182459182' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411178'
                WHERE ordernumber = 'P180820182512996' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411177'
                WHERE ordernumber = 'P420820182545664' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '225010'
                WHERE ordernumber = 'P590820183230582' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '225010'
                WHERE ordernumber = 'P590820183236686' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395158'
                WHERE ordernumber = 'P420820183356449' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411182'
                WHERE ordernumber = 'P180820183451114' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411184'
                WHERE ordernumber = 'P420820183607492' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411186'
                WHERE ordernumber = 'P180820183948851' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '128712'
                WHERE ordernumber = 'P200820183954601' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411188'
                WHERE ordernumber = 'P200820184059869' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411189'
                WHERE ordernumber = 'P180820184125377' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '211236'
                WHERE ordernumber = 'P180820184158887' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411192'
                WHERE ordernumber = 'P180820184434200' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411193'
                WHERE ordernumber = 'P180820184747424' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282775'
                WHERE ordernumber = 'P200820184931712' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411195'
                WHERE ordernumber = 'P180820185100339' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411166'
                WHERE ordernumber = 'P190820185809574' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '93655'
                WHERE ordernumber = 'P630820185923218' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281574'
                WHERE ordernumber = 'P200820190225525' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411199'
                WHERE ordernumber = 'P200820190712493' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '190703'
                WHERE ordernumber = 'P200820190916609' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411201'
                WHERE ordernumber = 'P200820191108794' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '111804'
                WHERE ordernumber = 'P190820191124972' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401285'
                WHERE ordernumber = 'P190820191610875' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411207'
                WHERE ordernumber = 'P200820192028936' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '222395'
                WHERE ordernumber = 'P190820192131751' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411210'
                WHERE ordernumber = 'P200820192348250' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411211'
                WHERE ordernumber = 'P190820192439240' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '209842'
                WHERE ordernumber = 'P190820192506297' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411215'
                WHERE ordernumber = 'P200820192956510' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411217'
                WHERE ordernumber = 'P190820193222927' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411220'
                WHERE ordernumber = 'P200820193511483' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411199'
                WHERE ordernumber = 'P200820193825328' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411223'
                WHERE ordernumber = 'P190820193859622' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '253771'
                WHERE ordernumber = 'P190820194804425' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114177'
                WHERE ordernumber = 'P190820194950504' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '140788'
                WHERE ordernumber = 'P190820200006920' 
            
2024-08-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98968'
                WHERE ordernumber = 'P630820201529915'