2024-09-17 01:00:01 -- 將會員中心id寫入data-lake
2024-09-17 01:00:01 -- 
            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-16%';
        
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421402'
                WHERE ordernumber = 'P420916110145409' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421403'
                WHERE ordernumber = 'P200916110201254' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421404'
                WHERE ordernumber = 'P420916110329137' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421405'
                WHERE ordernumber = 'P200916110352725' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '402762'
                WHERE ordernumber = 'P420916110422724' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '281876'
                WHERE ordernumber = 'P190916110432914' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287636'
                WHERE ordernumber = 'P200916110437478' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406529'
                WHERE ordernumber = 'P180916110513934' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '142108'
                WHERE ordernumber = 'P190916110540123' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '369804'
                WHERE ordernumber = 'P200916110616429' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '222213'
                WHERE ordernumber = 'P180916110617520' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '337912'
                WHERE ordernumber = 'P710916110624420' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '383419'
                WHERE ordernumber = 'P200916110719143' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '81908'
                WHERE ordernumber = 'P190916110735877' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '218319'
                WHERE ordernumber = 'P190916110856909' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '329401'
                WHERE ordernumber = 'P190916110952946' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '275220'
                WHERE ordernumber = 'P200916111055695' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287386'
                WHERE ordernumber = 'P190916111110650' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '416271'
                WHERE ordernumber = 'P200916111144818' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398435'
                WHERE ordernumber = 'P200916111233227' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '245369'
                WHERE ordernumber = 'P200916111324291' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421409'
                WHERE ordernumber = 'P420916111527623' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350922'
                WHERE ordernumber = 'P180916111614678' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419565'
                WHERE ordernumber = 'P420916111658180' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '306732'
                WHERE ordernumber = 'P200916111705752' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421411'
                WHERE ordernumber = 'P420916111750264' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249881'
                WHERE ordernumber = 'P200916111844793' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421412'
                WHERE ordernumber = 'P200916111847422' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419565'
                WHERE ordernumber = 'P420916111903258' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421410'
                WHERE ordernumber = 'P180916112021581' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '266459'
                WHERE ordernumber = 'P630916112036716' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '101017'
                WHERE ordernumber = 'P180916112043840' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350836'
                WHERE ordernumber = 'P180916112122216' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421242'
                WHERE ordernumber = 'P420916112130311' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421394'
                WHERE ordernumber = 'P420916112241710' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380901'
                WHERE ordernumber = 'P420916112318258' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421413'
                WHERE ordernumber = 'P180916112353201' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '308957'
                WHERE ordernumber = 'P420916112442421' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '138130'
                WHERE ordernumber = 'P420916113125234' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389788'
                WHERE ordernumber = 'P200916113133437' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387626'
                WHERE ordernumber = 'P200916113342778' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420741'
                WHERE ordernumber = 'P420916113410880' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420727'
                WHERE ordernumber = 'P420916113512697' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '130149'
                WHERE ordernumber = 'P180916113640198' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '318790'
                WHERE ordernumber = 'P200916113859837' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421415'
                WHERE ordernumber = 'P420916114622822' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421416'
                WHERE ordernumber = 'P420916114821269' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420547'
                WHERE ordernumber = 'P420916114858665' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421417'
                WHERE ordernumber = 'P420916114947470' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '339393'
                WHERE ordernumber = 'P420916115030454' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '272613'
                WHERE ordernumber = 'P420916115322679' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380903'
                WHERE ordernumber = 'P420916115405896' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '129399'
                WHERE ordernumber = 'P200916115521413' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421418'
                WHERE ordernumber = 'P420916115554990' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '87166'
                WHERE ordernumber = 'P180916115553918' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421420'
                WHERE ordernumber = 'P420916115721491' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421419'
                WHERE ordernumber = 'P200916115731516' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420561'
                WHERE ordernumber = 'P420916120021796' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '253946'
                WHERE ordernumber = 'P190916120025331' 
            
2024-09-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '360048'
                WHERE ordernumber = 'P180916120402718' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339001'
                WHERE ordernumber = 'P200916120519790' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421421'
                WHERE ordernumber = 'P200916120947683' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '119690'
                WHERE ordernumber = 'P200916121519430' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275427'
                WHERE ordernumber = 'P200916121615450' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405699'
                WHERE ordernumber = 'P420916121628729' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374291'
                WHERE ordernumber = 'P200916122520831' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421422'
                WHERE ordernumber = 'P420916123604707' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '127593'
                WHERE ordernumber = 'P200916123742695' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421423'
                WHERE ordernumber = 'P420916123800666' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230705'
                WHERE ordernumber = 'P200916123838516' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421422'
                WHERE ordernumber = 'P420916123901991' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '130987'
                WHERE ordernumber = 'P180916123903391' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421424'
                WHERE ordernumber = 'P200916124144836' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421425'
                WHERE ordernumber = 'P420916124202640' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379476'
                WHERE ordernumber = 'P200916124236212' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349217'
                WHERE ordernumber = 'P420916125010701' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421427'
                WHERE ordernumber = 'P420916125137855' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297229'
                WHERE ordernumber = 'P420916125406307' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421429'
                WHERE ordernumber = 'P420916125926743' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410596'
                WHERE ordernumber = 'P180916125944445' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '143853'
                WHERE ordernumber = 'P180916130406217' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351591'
                WHERE ordernumber = 'P200916130459931' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421431'
                WHERE ordernumber = 'P420916130656499' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '325365'
                WHERE ordernumber = 'P420916130858351' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421433'
                WHERE ordernumber = 'P420916131349393' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '321141'
                WHERE ordernumber = 'P180916131819336' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415739'
                WHERE ordernumber = 'P420916131840597' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421407'
                WHERE ordernumber = 'P200916131843423' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97293'
                WHERE ordernumber = 'P420916131925660' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339979'
                WHERE ordernumber = 'P420916132007438' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421432'
                WHERE ordernumber = 'P180916132025619' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339206'
                WHERE ordernumber = 'P420916132241409' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421434'
                WHERE ordernumber = 'P420916132420890' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421435'
                WHERE ordernumber = 'P200916132559113' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394483'
                WHERE ordernumber = 'P420916132637714' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421436'
                WHERE ordernumber = 'P420916132751199' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421437'
                WHERE ordernumber = 'P180916132814567' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421438'
                WHERE ordernumber = 'P420916132854788' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306732'
                WHERE ordernumber = 'P200916132901906' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418608'
                WHERE ordernumber = 'P420916133039844' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '82363'
                WHERE ordernumber = 'P180916133057926' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421439'
                WHERE ordernumber = 'P420916133232554' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '252519'
                WHERE ordernumber = 'P180916133305630' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421436'
                WHERE ordernumber = 'P420916133331324' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300608'
                WHERE ordernumber = 'P200916133435129' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '327850'
                WHERE ordernumber = 'P590916133439418' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '224253'
                WHERE ordernumber = 'P200916133525389' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421440'
                WHERE ordernumber = 'P420916133608211' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '373361'
                WHERE ordernumber = 'P200916133731945' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '336984'
                WHERE ordernumber = 'P180916134226755' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '114373'
                WHERE ordernumber = 'P180916134420214' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118795'
                WHERE ordernumber = 'P420916134518789' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401915'
                WHERE ordernumber = 'P420916134818277' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338388'
                WHERE ordernumber = 'P180916134829158' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421442'
                WHERE ordernumber = 'P420916135035572' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401179'
                WHERE ordernumber = 'P420916135506335' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421443'
                WHERE ordernumber = 'P200916135636336' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412493'
                WHERE ordernumber = 'P200916135805870' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421444'
                WHERE ordernumber = 'P180916135808633' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421445'
                WHERE ordernumber = 'P420916135934375' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241783'
                WHERE ordernumber = 'P180916135937739' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113366'
                WHERE ordernumber = 'P420916140029820' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '295074'
                WHERE ordernumber = 'P590916140156326' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275269'
                WHERE ordernumber = 'P180916140206141' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421448'
                WHERE ordernumber = 'P420916140437441' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286216'
                WHERE ordernumber = 'P200916140541542' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118795'
                WHERE ordernumber = 'P420916140757644' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421447'
                WHERE ordernumber = 'P180916140855371' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118795'
                WHERE ordernumber = 'P420916140951181' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379256'
                WHERE ordernumber = 'P180916141014897' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421449'
                WHERE ordernumber = 'P420916141049453' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421450'
                WHERE ordernumber = 'P200916141120332' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313776'
                WHERE ordernumber = 'P180916141320798' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421451'
                WHERE ordernumber = 'P200916141339315' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '253548'
                WHERE ordernumber = 'P200916141446294' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235457'
                WHERE ordernumber = 'P200916141546242' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '333499'
                WHERE ordernumber = 'P200916141754889' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282484'
                WHERE ordernumber = 'P180916141825184' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '167650'
                WHERE ordernumber = 'P420916142019426' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278212'
                WHERE ordernumber = 'P200916142020566' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355398'
                WHERE ordernumber = 'P420916142359825' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355907'
                WHERE ordernumber = 'P180916142424727' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '137717'
                WHERE ordernumber = 'P420916142508699' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '263060'
                WHERE ordernumber = 'P200916142607947' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421452'
                WHERE ordernumber = 'P200916142723723' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421453'
                WHERE ordernumber = 'P200916142824559' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421454'
                WHERE ordernumber = 'P420916142951882' 
            
2024-09-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '109223'
                WHERE ordernumber = 'P180916143214264' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421455'
                WHERE ordernumber = 'P200916143350787' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420788'
                WHERE ordernumber = 'P200916143441973' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '247608'
                WHERE ordernumber = 'P200916143533277' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418385'
                WHERE ordernumber = 'P420916143535280' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421456'
                WHERE ordernumber = 'P200916143829997' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421457'
                WHERE ordernumber = 'P200916144002847' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421455'
                WHERE ordernumber = 'P200916144037549' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287245'
                WHERE ordernumber = 'P200916144138915' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421459'
                WHERE ordernumber = 'P200916144338306' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '121498'
                WHERE ordernumber = 'P200916144743813' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '329885'
                WHERE ordernumber = 'P420916145222711' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421460'
                WHERE ordernumber = 'P200916145241523' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '376186'
                WHERE ordernumber = 'P180916145732787' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94000'
                WHERE ordernumber = 'P200916145757526' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358364'
                WHERE ordernumber = 'P420916145809631' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421461'
                WHERE ordernumber = 'P180916145921475' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421463'
                WHERE ordernumber = 'P200916150215208' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382389'
                WHERE ordernumber = 'P1050916150318933' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410519'
                WHERE ordernumber = 'P420916150339660' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '365462'
                WHERE ordernumber = 'P200916150715183' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421467'
                WHERE ordernumber = 'P420916151522476' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '82826'
                WHERE ordernumber = 'P420916151701462' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421468'
                WHERE ordernumber = 'P420916152008322' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '239380'
                WHERE ordernumber = 'P180916152011527' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421470'
                WHERE ordernumber = 'P200916152553509' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358412'
                WHERE ordernumber = 'P420916152613700' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421471'
                WHERE ordernumber = 'P420916152707319' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421470'
                WHERE ordernumber = 'P200916153242955' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421472'
                WHERE ordernumber = 'P420916153344228' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421473'
                WHERE ordernumber = 'P420916153510374' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114191'
                WHERE ordernumber = 'P200916153520359' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99157'
                WHERE ordernumber = 'P180916153612315' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '218966'
                WHERE ordernumber = 'P180916154351851' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '127752'
                WHERE ordernumber = 'P190916154625437' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421476'
                WHERE ordernumber = 'P420916154659249' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397182'
                WHERE ordernumber = 'P420916154813487' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420991'
                WHERE ordernumber = 'P180916155143210' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421477'
                WHERE ordernumber = 'P420916155217980' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421479'
                WHERE ordernumber = 'P420916155558128' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387378'
                WHERE ordernumber = 'P200916155709240' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '210626'
                WHERE ordernumber = 'P420916155946405' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421481'
                WHERE ordernumber = 'P200916155949381' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '210626'
                WHERE ordernumber = 'P420916160135774' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '369338'
                WHERE ordernumber = 'P420916160314691' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '155901'
                WHERE ordernumber = 'P420916160424583' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339206'
                WHERE ordernumber = 'P420916160525815' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421482'
                WHERE ordernumber = 'P420916160933264' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '315224'
                WHERE ordernumber = 'P180916161340697' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339661'
                WHERE ordernumber = 'P420916161501670' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406463'
                WHERE ordernumber = 'P180916161708142' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '171116'
                WHERE ordernumber = 'P420916161801829' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421397'
                WHERE ordernumber = 'P200916161814716' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339885'
                WHERE ordernumber = 'P200916162626757' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394508'
                WHERE ordernumber = 'P200916163132769' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384013'
                WHERE ordernumber = 'P180916163244536' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '328860'
                WHERE ordernumber = 'P420916163507359' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421484'
                WHERE ordernumber = 'P200916163635853' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421484'
                WHERE ordernumber = 'P200916163738810' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421485'
                WHERE ordernumber = 'P200916163841795' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412689'
                WHERE ordernumber = 'P200916163939640' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421486'
                WHERE ordernumber = 'P420916164057321' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421487'
                WHERE ordernumber = 'P200916164111117' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421488'
                WHERE ordernumber = 'P420916164349291' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412729'
                WHERE ordernumber = 'P200916164549148' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421474'
                WHERE ordernumber = 'P200916164903356' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '228043'
                WHERE ordernumber = 'P180916164909483' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383508'
                WHERE ordernumber = 'P420916164920703' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275164'
                WHERE ordernumber = 'P200916165206679' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421490'
                WHERE ordernumber = 'P420916165529396' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '27291'
                WHERE ordernumber = 'P180916165545121' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421491'
                WHERE ordernumber = 'P200916170042423' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '235290'
                WHERE ordernumber = 'P200916170439155' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398973'
                WHERE ordernumber = 'P630916170456359' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421492'
                WHERE ordernumber = 'P420916170808546' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '325137'
                WHERE ordernumber = 'P200916170858863' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421493'
                WHERE ordernumber = 'P180916170954774' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421492'
                WHERE ordernumber = 'P420916171058926' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383419'
                WHERE ordernumber = 'P200916171157533' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421495'
                WHERE ordernumber = 'P180916171629166' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421496'
                WHERE ordernumber = 'P420916171848405' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402167'
                WHERE ordernumber = 'P180916171859191' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412725'
                WHERE ordernumber = 'P200916172218676' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '368244'
                WHERE ordernumber = 'P180916172303671' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '272437'
                WHERE ordernumber = 'P200916172502946' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421498'
                WHERE ordernumber = 'P420916172809188' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421499'
                WHERE ordernumber = 'P420916173537742' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '307113'
                WHERE ordernumber = 'P420916173624281' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339695'
                WHERE ordernumber = 'P420916173915931' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421501'
                WHERE ordernumber = 'P200916173923346' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371941'
                WHERE ordernumber = 'P180916173924550' 
            
2024-09-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '413691'
                WHERE ordernumber = 'P420916173959297' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '421502'
                WHERE ordernumber = 'P200916174002418' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '344127'
                WHERE ordernumber = 'P420916174403698' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '108330'
                WHERE ordernumber = 'P420916175124615' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '421480'
                WHERE ordernumber = 'P200916175150685' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '421503'
                WHERE ordernumber = 'P420916175525301' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '155111'
                WHERE ordernumber = 'P200916180135473' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '421505'
                WHERE ordernumber = 'P420916180253374' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394705'
                WHERE ordernumber = 'P180916180527937' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '421506'
                WHERE ordernumber = 'P200916180528725' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '421507'
                WHERE ordernumber = 'P180916180619366' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '218636'
                WHERE ordernumber = 'P200916180628537' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '337349'
                WHERE ordernumber = 'P180916180938389' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '421509'
                WHERE ordernumber = 'P420916180949908' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '421510'
                WHERE ordernumber = 'P420916181108392' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '421511'
                WHERE ordernumber = 'P420916181217137' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377388'
                WHERE ordernumber = 'P200916181226908' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '219849'
                WHERE ordernumber = 'P180916181347514' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '421514'
                WHERE ordernumber = 'P420916181721275' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '421515'
                WHERE ordernumber = 'P200916181957871' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '421516'
                WHERE ordernumber = 'P420916182110613' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '146809'
                WHERE ordernumber = 'P420916182316971' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '363418'
                WHERE ordernumber = 'P630916182649563' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '337349'
                WHERE ordernumber = 'P180916182738637' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '249898'
                WHERE ordernumber = 'P200916182834136' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '371653'
                WHERE ordernumber = 'P200916183024154' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '421519'
                WHERE ordernumber = 'P420916183812543' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '421198'
                WHERE ordernumber = 'P420916184404621' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '138070'
                WHERE ordernumber = 'P180916184454169' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350391'
                WHERE ordernumber = 'P200916184630557' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '421430'
                WHERE ordernumber = 'P420916184916620' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '124068'
                WHERE ordernumber = 'P180916185002132' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '130043'
                WHERE ordernumber = 'P200916185031640' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '186695'
                WHERE ordernumber = 'P420916185147207' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399609'
                WHERE ordernumber = 'P200916185257811' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '360238'
                WHERE ordernumber = 'P180916185334189' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '421365'
                WHERE ordernumber = 'P180916185420937' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '421520'
                WHERE ordernumber = 'P190916185851641' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '292048'
                WHERE ordernumber = 'P200916190321379' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '193585'
                WHERE ordernumber = 'P190916190425429' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '421521'
                WHERE ordernumber = 'P190916190604626' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '421522'
                WHERE ordernumber = 'P190916190852200' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '421523'
                WHERE ordernumber = 'P190916191117266' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '300867'
                WHERE ordernumber = 'P200916191231873' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '421525'
                WHERE ordernumber = 'P190916191510210' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386894'
                WHERE ordernumber = 'P190916191617965' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '119915'
                WHERE ordernumber = 'P190916191823420' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '247872'
                WHERE ordernumber = 'P190916192004964' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '421526'
                WHERE ordernumber = 'P200916192344343' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '420472'
                WHERE ordernumber = 'P200916192441546' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '370596'
                WHERE ordernumber = 'P200916194434358' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '421529'
                WHERE ordernumber = 'P190916194944509' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P190916195718875' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '419050'
                WHERE ordernumber = 'P200916200115769' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '110872'
                WHERE ordernumber = 'P190916200243957' 
            
2024-09-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384355'
                WHERE ordernumber = 'P590916203536678'