2024-09-25 01:00:02 -- 將會員中心id寫入data-lake
2024-09-25 01:00:02 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-09-24%';
        
2024-09-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422600'
                WHERE ordernumber = 'P200924110417797' 
            
2024-09-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '67436'
                WHERE ordernumber = 'P180924110704595' 
            
2024-09-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '399308'
                WHERE ordernumber = 'P420924110732681' 
            
2024-09-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393066'
                WHERE ordernumber = 'P200924111340153' 
            
2024-09-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '288562'
                WHERE ordernumber = 'P200924111514879' 
            
2024-09-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '106070'
                WHERE ordernumber = 'P200924111656929' 
            
2024-09-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407094'
                WHERE ordernumber = 'P200924111953911' 
            
2024-09-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '105553'
                WHERE ordernumber = 'P180924112208174' 
            
2024-09-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '358469'
                WHERE ordernumber = 'P200924112441883' 
            
2024-09-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '358469'
                WHERE ordernumber = 'P200924112725663' 
            
2024-09-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421186'
                WHERE ordernumber = 'P420924112748159' 
            
2024-09-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '417316'
                WHERE ordernumber = 'P420924113115213' 
            
2024-09-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '141228'
                WHERE ordernumber = 'P180924113429783' 
            
2024-09-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '223224'
                WHERE ordernumber = 'P420924113514232' 
            
2024-09-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422604'
                WHERE ordernumber = 'P180924113647751' 
            
2024-09-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421674'
                WHERE ordernumber = 'P420924113719201' 
            
2024-09-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422605'
                WHERE ordernumber = 'P180924113825699' 
            
2024-09-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422603'
                WHERE ordernumber = 'P730924113937437' 
            
2024-09-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349782'
                WHERE ordernumber = 'P180924114057297' 
            
2024-09-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422606'
                WHERE ordernumber = 'P420924114105531' 
            
2024-09-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422608'
                WHERE ordernumber = 'P420924114223453' 
            
2024-09-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422607'
                WHERE ordernumber = 'P730924114334598' 
            
2024-09-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '241446'
                WHERE ordernumber = 'P200924114642655' 
            
2024-09-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422613'
                WHERE ordernumber = 'P420924115330740' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422612'
                WHERE ordernumber = 'P180924115423270' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249872'
                WHERE ordernumber = 'P180924115600342' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422615'
                WHERE ordernumber = 'P730924115744497' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378092'
                WHERE ordernumber = 'P180924115745591' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348767'
                WHERE ordernumber = 'P420924115856647' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422616'
                WHERE ordernumber = 'P180924120139991' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422619'
                WHERE ordernumber = 'P180924120415324' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422415'
                WHERE ordernumber = 'P420924120540690' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230728'
                WHERE ordernumber = 'P200924121001971' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235839'
                WHERE ordernumber = 'P200924121123512' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '104000'
                WHERE ordernumber = 'P200924121345437' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235839'
                WHERE ordernumber = 'P200924121406566' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422617'
                WHERE ordernumber = 'P730924121449645' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300268'
                WHERE ordernumber = 'P200924121537205' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422620'
                WHERE ordernumber = 'P710924121934444' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313552'
                WHERE ordernumber = 'P730924122257686' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341897'
                WHERE ordernumber = 'P420924122331919' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422621'
                WHERE ordernumber = 'P180924122347632' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422622'
                WHERE ordernumber = 'P420924122452363' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397977'
                WHERE ordernumber = 'P630924122613529' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422623'
                WHERE ordernumber = 'P180924122819264' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180924122906501' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '53693'
                WHERE ordernumber = 'P730924123230539' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '255391'
                WHERE ordernumber = 'P180924123250686' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422459'
                WHERE ordernumber = 'P180924123747651' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310605'
                WHERE ordernumber = 'P200924123952654' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314569'
                WHERE ordernumber = 'P180924124115574' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310605'
                WHERE ordernumber = 'P200924124122728' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310605'
                WHERE ordernumber = 'P200924124159781' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362189'
                WHERE ordernumber = 'P420924124216379' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '292002'
                WHERE ordernumber = 'P200924124506733' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '104508'
                WHERE ordernumber = 'P180924124559864' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314651'
                WHERE ordernumber = 'P180924124810723' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '327542'
                WHERE ordernumber = 'P200924124837240' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389093'
                WHERE ordernumber = 'P200924124906197' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422627'
                WHERE ordernumber = 'P180924124950518' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422629'
                WHERE ordernumber = 'P180924125359825' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380354'
                WHERE ordernumber = 'P420924125425956' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420651'
                WHERE ordernumber = 'P420924125902265' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422630'
                WHERE ordernumber = 'P180924125958624' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422631'
                WHERE ordernumber = 'P420924130049530' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '329344'
                WHERE ordernumber = 'P200924130051144' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422625'
                WHERE ordernumber = 'P730924130238632' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '216330'
                WHERE ordernumber = 'P180924130339532' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '333398'
                WHERE ordernumber = 'P180924130519951' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422632'
                WHERE ordernumber = 'P180924130708132' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342424'
                WHERE ordernumber = 'P180924130912870' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403014'
                WHERE ordernumber = 'P420924131435254' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '413036'
                WHERE ordernumber = 'P200924131612739' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422633'
                WHERE ordernumber = 'P180924131843588' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422634'
                WHERE ordernumber = 'P180924132231361' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422635'
                WHERE ordernumber = 'P200924133042343' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374128'
                WHERE ordernumber = 'P200924133348135' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '136792'
                WHERE ordernumber = 'P180924133434800' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422637'
                WHERE ordernumber = 'P180924134150325' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421492'
                WHERE ordernumber = 'P420924134239569' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97804'
                WHERE ordernumber = 'P200924134732920' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421492'
                WHERE ordernumber = 'P420924134940773' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422639'
                WHERE ordernumber = 'P420924135207827' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422640'
                WHERE ordernumber = 'P420924135327754' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422641'
                WHERE ordernumber = 'P420924135408686' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306525'
                WHERE ordernumber = 'P420924135520366' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422642'
                WHERE ordernumber = 'P420924135646513' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '413071'
                WHERE ordernumber = 'P420924140251496' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422645'
                WHERE ordernumber = 'P420924140432765' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160711'
                WHERE ordernumber = 'P200924140557494' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422646'
                WHERE ordernumber = 'P200924141341814' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422648'
                WHERE ordernumber = 'P200924141516732' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422650'
                WHERE ordernumber = 'P200924141821427' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422651'
                WHERE ordernumber = 'P200924141911626' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '10519'
                WHERE ordernumber = 'P420924141932861' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307277'
                WHERE ordernumber = 'P200924141958692' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '10519'
                WHERE ordernumber = 'P420924142027135' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '126787'
                WHERE ordernumber = 'P200924142734897' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422652'
                WHERE ordernumber = 'P730924143838576' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '171633'
                WHERE ordernumber = 'P200924143945966' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422656'
                WHERE ordernumber = 'P180924144321645' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422657'
                WHERE ordernumber = 'P200924144444111' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '288755'
                WHERE ordernumber = 'P180924145015158' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103320'
                WHERE ordernumber = 'P180924145102121' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338997'
                WHERE ordernumber = 'P200924145126260' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422661'
                WHERE ordernumber = 'P200924145456886' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422662'
                WHERE ordernumber = 'P180924145944666' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398058'
                WHERE ordernumber = 'P190924150005135' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422663'
                WHERE ordernumber = 'P730924150342576' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422664'
                WHERE ordernumber = 'P200924150429645' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422665'
                WHERE ordernumber = 'P180924150452631' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422666'
                WHERE ordernumber = 'P200924150607916' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422667'
                WHERE ordernumber = 'P180924150632481' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287179'
                WHERE ordernumber = 'P200924150648668' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422668'
                WHERE ordernumber = 'P420924150704380' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389174'
                WHERE ordernumber = 'P420924151115513' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422669'
                WHERE ordernumber = 'P200924151154228' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422670'
                WHERE ordernumber = 'P180924151559269' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371445'
                WHERE ordernumber = 'P200924152023873' 
            
2024-09-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '117676'
                WHERE ordernumber = 'P200924152035334' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422671'
                WHERE ordernumber = 'P730924152511879' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422673'
                WHERE ordernumber = 'P180924153006302' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '260398'
                WHERE ordernumber = 'P200924153546235' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422674'
                WHERE ordernumber = 'P180924153627647' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422675'
                WHERE ordernumber = 'P200924153649818' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422676'
                WHERE ordernumber = 'P180924154049367' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422677'
                WHERE ordernumber = 'P420924154238116' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422678'
                WHERE ordernumber = 'P180924154552396' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422680'
                WHERE ordernumber = 'P630924155219643' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422682'
                WHERE ordernumber = 'P180924155603771' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399308'
                WHERE ordernumber = 'P420924155846551' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '80681'
                WHERE ordernumber = 'P180924160618241' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288489'
                WHERE ordernumber = 'P200924160747697' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422686'
                WHERE ordernumber = 'P200924161003875' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417412'
                WHERE ordernumber = 'P200924161402376' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422687'
                WHERE ordernumber = 'P200924162021626' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422688'
                WHERE ordernumber = 'P420924162144640' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421792'
                WHERE ordernumber = 'P420924162450993' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '291869'
                WHERE ordernumber = 'P200924162553645' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422690'
                WHERE ordernumber = 'P710924162739275' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422692'
                WHERE ordernumber = 'P200924162755759' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422693'
                WHERE ordernumber = 'P420924162914720' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422694'
                WHERE ordernumber = 'P710924163528788' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422695'
                WHERE ordernumber = 'P180924164540378' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '82409'
                WHERE ordernumber = 'P180924164732910' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422697'
                WHERE ordernumber = 'P200924164805514' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422697'
                WHERE ordernumber = 'P200924164810985' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422698'
                WHERE ordernumber = 'P420924165001648' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422695'
                WHERE ordernumber = 'P180924165305751' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422700'
                WHERE ordernumber = 'P200924165355573' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422701'
                WHERE ordernumber = 'P710924165717809' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422704'
                WHERE ordernumber = 'P200924165835690' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '320864'
                WHERE ordernumber = 'P420924170104634' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414543'
                WHERE ordernumber = 'P630924170544508' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422602'
                WHERE ordernumber = 'P180924170836276' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '269136'
                WHERE ordernumber = 'P200924170851310' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422705'
                WHERE ordernumber = 'P710924171541347' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '216455'
                WHERE ordernumber = 'P730924171547293' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422709'
                WHERE ordernumber = 'P710924172254692' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422710'
                WHERE ordernumber = 'P420924172347397' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422459'
                WHERE ordernumber = 'P180924172649740' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '290554'
                WHERE ordernumber = 'P630924173132575' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422549'
                WHERE ordernumber = 'P200924173355219' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422708'
                WHERE ordernumber = 'P200924173441713' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '341246'
                WHERE ordernumber = 'P180924173910382' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422712'
                WHERE ordernumber = 'P200924174635418' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '171666'
                WHERE ordernumber = 'P200924174752195' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '118258'
                WHERE ordernumber = 'P180924175032814' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422713'
                WHERE ordernumber = 'P200924175445743' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384883'
                WHERE ordernumber = 'P180924175454261' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422714'
                WHERE ordernumber = 'P180924180005906' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422708'
                WHERE ordernumber = 'P200924180246443' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422715'
                WHERE ordernumber = 'P420924180344328' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391040'
                WHERE ordernumber = 'P180924180548381' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '365200'
                WHERE ordernumber = 'P420924180735548' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422717'
                WHERE ordernumber = 'P420924180842533' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422719'
                WHERE ordernumber = 'P180924180912801' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422720'
                WHERE ordernumber = 'P420924181247132' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422718'
                WHERE ordernumber = 'P710924181421480' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343867'
                WHERE ordernumber = 'P180924182442730' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422711'
                WHERE ordernumber = 'P420924182501576' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '156313'
                WHERE ordernumber = 'P180924182943591' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '88704'
                WHERE ordernumber = 'P200924183038395' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422722'
                WHERE ordernumber = 'P180924183107283' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '161112'
                WHERE ordernumber = 'P200924183209688' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '161112'
                WHERE ordernumber = 'P200924183244368' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421795'
                WHERE ordernumber = 'P180924183436248' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '334547'
                WHERE ordernumber = 'P420924183451993' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422724'
                WHERE ordernumber = 'P200924184049728' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422725'
                WHERE ordernumber = 'P420924184113433' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422726'
                WHERE ordernumber = 'P200924184200882' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422723'
                WHERE ordernumber = 'P200924184304701' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422723'
                WHERE ordernumber = 'P200924184307689' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422728'
                WHERE ordernumber = 'P180924184505752' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284853'
                WHERE ordernumber = 'P200924184509951' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236175'
                WHERE ordernumber = 'P180924184617277' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395907'
                WHERE ordernumber = 'P420924184617279' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230024'
                WHERE ordernumber = 'P180924185350124' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406014'
                WHERE ordernumber = 'P180924190028490' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237681'
                WHERE ordernumber = 'P180924190329509' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406014'
                WHERE ordernumber = 'P180924190434356' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '335282'
                WHERE ordernumber = 'P200924190535320' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422730'
                WHERE ordernumber = 'P730924190741185' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103007'
                WHERE ordernumber = 'P190924190953471' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '93028'
                WHERE ordernumber = 'P200924191932967' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421723'
                WHERE ordernumber = 'P730924191935526' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422731'
                WHERE ordernumber = 'P200924192844268' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422732'
                WHERE ordernumber = 'P200924193217784' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '263943'
                WHERE ordernumber = 'P200924193306897' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417247'
                WHERE ordernumber = 'P190924194125882' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422733'
                WHERE ordernumber = 'P710924195220912' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422733'
                WHERE ordernumber = 'P710924195704111' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422734'
                WHERE ordernumber = 'P200924200007668' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '369535'
                WHERE ordernumber = 'P710924203019861' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422739'
                WHERE ordernumber = 'P730924203813424' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422741'
                WHERE ordernumber = 'P710924210243731' 
            
2024-09-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422745'
                WHERE ordernumber = 'P710924212700751'