2024-07-15 01:00:03 -- 將會員中心id寫入data-lake
2024-07-15 01:00:03 -- 
            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-07-14%';
        
2024-07-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389445'
                WHERE ordernumber = 'P630714100718740' 
            
2024-07-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401222'
                WHERE ordernumber = 'P420714110353421' 
            
2024-07-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383764'
                WHERE ordernumber = 'P420714110554660' 
            
2024-07-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401223'
                WHERE ordernumber = 'P190714110703191' 
            
2024-07-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401224'
                WHERE ordernumber = 'P180714110810860' 
            
2024-07-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96915'
                WHERE ordernumber = 'P180714110924597' 
            
2024-07-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401225'
                WHERE ordernumber = 'P180714111120916' 
            
2024-07-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401226'
                WHERE ordernumber = 'P190714111203623' 
            
2024-07-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401227'
                WHERE ordernumber = 'P180714111233747' 
            
2024-07-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297697'
                WHERE ordernumber = 'P420714111340750' 
            
2024-07-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401228'
                WHERE ordernumber = 'P180714111358224' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401230'
                WHERE ordernumber = 'P190714111501365' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401229'
                WHERE ordernumber = 'P420714111502576' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278401'
                WHERE ordernumber = 'P180714111639847' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378256'
                WHERE ordernumber = 'P420714111829985' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '233236'
                WHERE ordernumber = 'P200714111851376' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386405'
                WHERE ordernumber = 'P180714111924726' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '243328'
                WHERE ordernumber = 'P190714112205227' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380916'
                WHERE ordernumber = 'P420714112219927' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '111604'
                WHERE ordernumber = 'P200714112704920' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401231'
                WHERE ordernumber = 'P180714112731594' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313974'
                WHERE ordernumber = 'P420714112859464' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '115215'
                WHERE ordernumber = 'P180714113010669' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '248714'
                WHERE ordernumber = 'P190714113146446' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401232'
                WHERE ordernumber = 'P180714113250386' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '130838'
                WHERE ordernumber = 'P180714113325875' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '130838'
                WHERE ordernumber = 'P180714113404149' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401234'
                WHERE ordernumber = 'P420714113444855' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236122'
                WHERE ordernumber = 'P190714113540753' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '25951'
                WHERE ordernumber = 'P200714113606211' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401236'
                WHERE ordernumber = 'P180714113611411' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401235'
                WHERE ordernumber = 'P190714114042564' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '328836'
                WHERE ordernumber = 'P180714114336696' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401235'
                WHERE ordernumber = 'P190714114420347' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401235'
                WHERE ordernumber = 'P190714114434168' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401233'
                WHERE ordernumber = 'P190714114600345' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401233'
                WHERE ordernumber = 'P190714114612917' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401237'
                WHERE ordernumber = 'P180714114704258' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393090'
                WHERE ordernumber = 'P200714114748151' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401238'
                WHERE ordernumber = 'P190714114850134' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394400'
                WHERE ordernumber = 'P200714115355505' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401240'
                WHERE ordernumber = 'P420714120307379' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '286931'
                WHERE ordernumber = 'P200714120509731' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '228579'
                WHERE ordernumber = 'P180714120515609' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '375325'
                WHERE ordernumber = 'P180714120923667' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '93476'
                WHERE ordernumber = 'P180714121835798' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401241'
                WHERE ordernumber = 'P180714122010705' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401242'
                WHERE ordernumber = 'P420714122644828' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '155696'
                WHERE ordernumber = 'P420714122732558' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288213'
                WHERE ordernumber = 'P200714122904292' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401238'
                WHERE ordernumber = 'P180714123407303' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401244'
                WHERE ordernumber = 'P200714123736140' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401246'
                WHERE ordernumber = 'P420714124524377' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284131'
                WHERE ordernumber = 'P200714125427464' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401247'
                WHERE ordernumber = 'P420714125532919' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '116467'
                WHERE ordernumber = 'P180714125852709' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401248'
                WHERE ordernumber = 'P420714130140958' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400921'
                WHERE ordernumber = 'P180714130207326' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401249'
                WHERE ordernumber = 'P420714130305923' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '171591'
                WHERE ordernumber = 'P420714130521764' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401250'
                WHERE ordernumber = 'P180714130727861' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96414'
                WHERE ordernumber = 'P190714130800214' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '235777'
                WHERE ordernumber = 'P200714131049888' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401251'
                WHERE ordernumber = 'P200714131240512' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399322'
                WHERE ordernumber = 'P180714131542392' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284933'
                WHERE ordernumber = 'P180714131701179' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398740'
                WHERE ordernumber = 'P180714132523806' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401253'
                WHERE ordernumber = 'P180714132909460' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401254'
                WHERE ordernumber = 'P180714133113922' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401255'
                WHERE ordernumber = 'P420714133124124' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401256'
                WHERE ordernumber = 'P420714133414843' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401257'
                WHERE ordernumber = 'P180714133559194' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '334577'
                WHERE ordernumber = 'P200714133738252' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401258'
                WHERE ordernumber = 'P200714134008779' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401259'
                WHERE ordernumber = 'P420714134058458' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401260'
                WHERE ordernumber = 'P180714134104570' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282738'
                WHERE ordernumber = 'P200714134106218' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342133'
                WHERE ordernumber = 'P420714135210443' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401261'
                WHERE ordernumber = 'P180714135709296' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337071'
                WHERE ordernumber = 'P420714135812527' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '317026'
                WHERE ordernumber = 'P200714140425182' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '192188'
                WHERE ordernumber = 'P420714140447711' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401263'
                WHERE ordernumber = 'P180714140730269' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '376111'
                WHERE ordernumber = 'P180714140906772' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401265'
                WHERE ordernumber = 'P420714140924398' 
            
2024-07-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401266'
                WHERE ordernumber = 'P420714141044903' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401267'
                WHERE ordernumber = 'P420714141222838' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401268'
                WHERE ordernumber = 'P200714141323278' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401269'
                WHERE ordernumber = 'P180714141424942' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401270'
                WHERE ordernumber = 'P190714141433405' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401271'
                WHERE ordernumber = 'P200714141449875' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401272'
                WHERE ordernumber = 'P180714142343139' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '105625'
                WHERE ordernumber = 'P200714142447474' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401273'
                WHERE ordernumber = 'P180714142821644' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401274'
                WHERE ordernumber = 'P420714142918782' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '392209'
                WHERE ordernumber = 'P420714143018782' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358336'
                WHERE ordernumber = 'P180714143051800' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401276'
                WHERE ordernumber = 'P420714143529842' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401275'
                WHERE ordernumber = 'P180714143541946' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '326943'
                WHERE ordernumber = 'P190714143826522' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401277'
                WHERE ordernumber = 'P180714143906239' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '193580'
                WHERE ordernumber = 'P420714144011662' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401278'
                WHERE ordernumber = 'P180714144125511' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401279'
                WHERE ordernumber = 'P180714144220267' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386597'
                WHERE ordernumber = 'P200714144734279' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401281'
                WHERE ordernumber = 'P180714144840755' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401282'
                WHERE ordernumber = 'P420714145024966' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386491'
                WHERE ordernumber = 'P180714145031580' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '292465'
                WHERE ordernumber = 'P200714145449112' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '172785'
                WHERE ordernumber = 'P190714145552692' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '387629'
                WHERE ordernumber = 'P180714145649770' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401283'
                WHERE ordernumber = 'P200714145951696' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401284'
                WHERE ordernumber = 'P200714150111206' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401285'
                WHERE ordernumber = 'P180714150227657' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401286'
                WHERE ordernumber = 'P180714150345303' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '348565'
                WHERE ordernumber = 'P200714150418971' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401287'
                WHERE ordernumber = 'P190714150420553' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401288'
                WHERE ordernumber = 'P200714150604432' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401289'
                WHERE ordernumber = 'P420714150643815' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401290'
                WHERE ordernumber = 'P180714150734692' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '101374'
                WHERE ordernumber = 'P180714150948187' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401291'
                WHERE ordernumber = 'P180714151618863' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '106032'
                WHERE ordernumber = 'P180714151802741' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '146193'
                WHERE ordernumber = 'P180714152229454' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401293'
                WHERE ordernumber = 'P180714152332597' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '348775'
                WHERE ordernumber = 'P200714152431576' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '385499'
                WHERE ordernumber = 'P630714152817721' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401294'
                WHERE ordernumber = 'P420714152951400' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393519'
                WHERE ordernumber = 'P200714153350126' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '339700'
                WHERE ordernumber = 'P420714153512181' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401295'
                WHERE ordernumber = 'P180714153549498' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401296'
                WHERE ordernumber = 'P180714153751238' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398275'
                WHERE ordernumber = 'P420714153756411' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401296'
                WHERE ordernumber = 'P180714153831721' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401298'
                WHERE ordernumber = 'P180714153956629' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401297'
                WHERE ordernumber = 'P420714153958150' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401296'
                WHERE ordernumber = 'P180714154023223' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '7121'
                WHERE ordernumber = 'P420714154414781' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '220135'
                WHERE ordernumber = 'P200714154632354' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '264872'
                WHERE ordernumber = 'P200714155432374' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401299'
                WHERE ordernumber = 'P180714155502669' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401300'
                WHERE ordernumber = 'P180714155835117' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372345'
                WHERE ordernumber = 'P190714160013699' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401301'
                WHERE ordernumber = 'P180714160033260' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372345'
                WHERE ordernumber = 'P190714160113203' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401302'
                WHERE ordernumber = 'P180714160215415' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401303'
                WHERE ordernumber = 'P420714160217796' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401304'
                WHERE ordernumber = 'P180714160416957' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '165201'
                WHERE ordernumber = 'P200714160713162' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401305'
                WHERE ordernumber = 'P180714160727683' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401306'
                WHERE ordernumber = 'P190714160747895' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '314442'
                WHERE ordernumber = 'P200714160757186' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '228205'
                WHERE ordernumber = 'P180714160948858' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '100444'
                WHERE ordernumber = 'P190714161005537' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '369333'
                WHERE ordernumber = 'P180714161158854' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401308'
                WHERE ordernumber = 'P200714161217425' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401309'
                WHERE ordernumber = 'P200714161556440' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '272572'
                WHERE ordernumber = 'P420714161822257' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401310'
                WHERE ordernumber = 'P190714161839630' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398430'
                WHERE ordernumber = 'P190714162153121' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '228082'
                WHERE ordernumber = 'P190714162655149' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '376584'
                WHERE ordernumber = 'P190714162822691' 
            
2024-07-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '389538'
                WHERE ordernumber = 'P420714162858857' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '376584'
                WHERE ordernumber = 'P190714163136756' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401311'
                WHERE ordernumber = 'P180714163232872' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '334976'
                WHERE ordernumber = 'P180714163313259' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401312'
                WHERE ordernumber = 'P420714163514137' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401313'
                WHERE ordernumber = 'P200714163746967' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '209597'
                WHERE ordernumber = 'P180714164643650' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401314'
                WHERE ordernumber = 'P180714164803440' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401315'
                WHERE ordernumber = 'P190714164840226' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '349239'
                WHERE ordernumber = 'P180714164917783' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400541'
                WHERE ordernumber = 'P420714165143937' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401317'
                WHERE ordernumber = 'P180714165319624' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '271807'
                WHERE ordernumber = 'P200714165340700' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401320'
                WHERE ordernumber = 'P200714165846338' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401319'
                WHERE ordernumber = 'P420714165906524' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401319'
                WHERE ordernumber = 'P420714165945644' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401316'
                WHERE ordernumber = 'P180714170336611' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '334553'
                WHERE ordernumber = 'P180714170500221' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '282416'
                WHERE ordernumber = 'P190714170735353' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '379762'
                WHERE ordernumber = 'P200714170748659' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399920'
                WHERE ordernumber = 'P180714171121382' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '391066'
                WHERE ordernumber = 'P200714171423933' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401321'
                WHERE ordernumber = 'P180714171458496' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401323'
                WHERE ordernumber = 'P200714171742125' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401324'
                WHERE ordernumber = 'P420714171816314' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401325'
                WHERE ordernumber = 'P180714171838379' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '261570'
                WHERE ordernumber = 'P180714172100398' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351147'
                WHERE ordernumber = 'P200714172309811' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401326'
                WHERE ordernumber = 'P180714172437127' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401327'
                WHERE ordernumber = 'P180714172608381' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401328'
                WHERE ordernumber = 'P190714172737784' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401329'
                WHERE ordernumber = 'P180714172752694' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '241779'
                WHERE ordernumber = 'P180714172833751' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '280068'
                WHERE ordernumber = 'P180714173020524' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400577'
                WHERE ordernumber = 'P200714173244339' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '381221'
                WHERE ordernumber = 'P200714173435425' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401330'
                WHERE ordernumber = 'P420714173451151' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '379940'
                WHERE ordernumber = 'P200714173529209' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401331'
                WHERE ordernumber = 'P180714173749199' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401332'
                WHERE ordernumber = 'P420714173906458' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401333'
                WHERE ordernumber = 'P200714174010378' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '287812'
                WHERE ordernumber = 'P180714174132662' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '247164'
                WHERE ordernumber = 'P200714174307141' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '364581'
                WHERE ordernumber = 'P420714174358505' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401335'
                WHERE ordernumber = 'P180714174559928' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401334'
                WHERE ordernumber = 'P420714174601539' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '243695'
                WHERE ordernumber = 'P180714175204313' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '397479'
                WHERE ordernumber = 'P420714175823322' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '390876'
                WHERE ordernumber = 'P200714175824675' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '390876'
                WHERE ordernumber = 'P200714175900815' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400252'
                WHERE ordernumber = 'P420714180241376' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '375683'
                WHERE ordernumber = 'P180714180251915' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401336'
                WHERE ordernumber = 'P180714180631755' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '35479'
                WHERE ordernumber = 'P420714181332520' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401337'
                WHERE ordernumber = 'P180714181517572' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401338'
                WHERE ordernumber = 'P420714181810151' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '98317'
                WHERE ordernumber = 'P180714181906884' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401340'
                WHERE ordernumber = 'P200714182000151' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401341'
                WHERE ordernumber = 'P200714182328370' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401342'
                WHERE ordernumber = 'P180714182444180' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401343'
                WHERE ordernumber = 'P200714182620164' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401344'
                WHERE ordernumber = 'P420714182633991' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '67607'
                WHERE ordernumber = 'P420714182740586' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401345'
                WHERE ordernumber = 'P420714182845194' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '238709'
                WHERE ordernumber = 'P200714183117921' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '67607'
                WHERE ordernumber = 'P420714183150698' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401347'
                WHERE ordernumber = 'P420714183352329' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '69286'
                WHERE ordernumber = 'P180714183458488' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '87271'
                WHERE ordernumber = 'P200714183653799' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401348'
                WHERE ordernumber = 'P180714183740895' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '392802'
                WHERE ordernumber = 'P200714183804584' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401349'
                WHERE ordernumber = 'P190714183922674' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401351'
                WHERE ordernumber = 'P190714184050695' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401352'
                WHERE ordernumber = 'P420714184147837' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '207234'
                WHERE ordernumber = 'P180714184207574' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '325304'
                WHERE ordernumber = 'P420714184247943' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '264022'
                WHERE ordernumber = 'P200714184347910' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '318317'
                WHERE ordernumber = 'P420714184403175' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401353'
                WHERE ordernumber = 'P180714184405358' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401355'
                WHERE ordernumber = 'P190714184518410' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '393547'
                WHERE ordernumber = 'P190714190218252' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401357'
                WHERE ordernumber = 'P190714190424286' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '385308'
                WHERE ordernumber = 'P190714190952565' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '96208'
                WHERE ordernumber = 'P190714192003630' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '343808'
                WHERE ordernumber = 'P200714192540701' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401359'
                WHERE ordernumber = 'P630714193250815' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '324524'
                WHERE ordernumber = 'P190714193301266' 
            
2024-07-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '238448'
                WHERE ordernumber = 'P200714194513158' 
            
2024-07-15 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '332962'
                WHERE ordernumber = 'P200714194748267' 
            
2024-07-15 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '275312'
                WHERE ordernumber = 'P200714194928414' 
            
2024-07-15 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '401360'
                WHERE ordernumber = 'P190714194948684' 
            
2024-07-15 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '96695'
                WHERE ordernumber = 'P190714195521839' 
            
2024-07-15 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '399365'
                WHERE ordernumber = 'P190714195927486' 
            
2024-07-15 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P190714200013995' 
            
2024-07-15 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '401362'
                WHERE ordernumber = 'P200714200244637' 
            
2024-07-15 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '63326'
                WHERE ordernumber = 'P630714203629341' 
            
2024-07-15 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '298175'
                WHERE ordernumber = 'P630714203708870'