2024-06-01 01:00:01 -- 將會員中心id寫入data-lake
2024-06-01 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-05-31%';
        
2024-06-01 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '311501'
                WHERE ordernumber = 'P420531110144835' 
            
2024-06-01 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '287106'
                WHERE ordernumber = 'P180531110144251' 
            
2024-06-01 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '393213'
                WHERE ordernumber = 'P200531110215177' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393214'
                WHERE ordernumber = 'P180531110250411' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '94003'
                WHERE ordernumber = 'P200531110255677' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393215'
                WHERE ordernumber = 'P420531110404720' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '384933'
                WHERE ordernumber = 'P420531110621692' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393217'
                WHERE ordernumber = 'P180531110949180' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '7281'
                WHERE ordernumber = 'P180531111139487' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392979'
                WHERE ordernumber = 'P420531111204292' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393220'
                WHERE ordernumber = 'P180531111459295' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393219'
                WHERE ordernumber = 'P420531111459581' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393220'
                WHERE ordernumber = 'P180531111531805' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '306748'
                WHERE ordernumber = 'P190531111624156' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393220'
                WHERE ordernumber = 'P180531111630491' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '328174'
                WHERE ordernumber = 'P190531111731456' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393220'
                WHERE ordernumber = 'P180531111746130' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393220'
                WHERE ordernumber = 'P180531112004633' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393220'
                WHERE ordernumber = 'P180531112036665' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '7281'
                WHERE ordernumber = 'P190531112138916' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '163915'
                WHERE ordernumber = 'P180531112203360' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '212017'
                WHERE ordernumber = 'P190531112354651' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389354'
                WHERE ordernumber = 'P190531112458228' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393223'
                WHERE ordernumber = 'P180531112509688' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393225'
                WHERE ordernumber = 'P420531112824569' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388992'
                WHERE ordernumber = 'P180531112850989' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393227'
                WHERE ordernumber = 'P200531113038925' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393224'
                WHERE ordernumber = 'P710531113104174' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393228'
                WHERE ordernumber = 'P420531113110528' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393229'
                WHERE ordernumber = 'P180531113116655' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354096'
                WHERE ordernumber = 'P420531113435748' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393230'
                WHERE ordernumber = 'P190531113746455' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354096'
                WHERE ordernumber = 'P420531113801349' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390395'
                WHERE ordernumber = 'P630531113957500' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393231'
                WHERE ordernumber = 'P420531114040380' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '223893'
                WHERE ordernumber = 'P190531114056585' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '199262'
                WHERE ordernumber = 'P200531114141883' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '251706'
                WHERE ordernumber = 'P420531114221966' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393232'
                WHERE ordernumber = 'P200531114352711' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '295216'
                WHERE ordernumber = 'P200531114550443' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354096'
                WHERE ordernumber = 'P420531114943899' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '364048'
                WHERE ordernumber = 'P420531115135164' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392290'
                WHERE ordernumber = 'P200531115154510' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '341009'
                WHERE ordernumber = 'P200531115436484' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '237308'
                WHERE ordernumber = 'P180531115627143' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393236'
                WHERE ordernumber = 'P420531115701593' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393237'
                WHERE ordernumber = 'P180531115912676' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393238'
                WHERE ordernumber = 'P190531115933932' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393182'
                WHERE ordernumber = 'P180531120610144' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393182'
                WHERE ordernumber = 'P180531120659979' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393240'
                WHERE ordernumber = 'P420531120858653' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393241'
                WHERE ordernumber = 'P420531120959767' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '162345'
                WHERE ordernumber = 'P180531121309613' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '341702'
                WHERE ordernumber = 'P200531121342722' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393242'
                WHERE ordernumber = 'P180531121622302' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '269501'
                WHERE ordernumber = 'P200531121634792' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377207'
                WHERE ordernumber = 'P420531122229803' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393212'
                WHERE ordernumber = 'P590531122638193' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393245'
                WHERE ordernumber = 'P180531122835702' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393246'
                WHERE ordernumber = 'P420531123123806' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '303947'
                WHERE ordernumber = 'P420531123300974' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378873'
                WHERE ordernumber = 'P200531123707993' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392526'
                WHERE ordernumber = 'P200531124154412' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393250'
                WHERE ordernumber = 'P180531124242168' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '313514'
                WHERE ordernumber = 'P420531124428599' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '313514'
                WHERE ordernumber = 'P420531124942717' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390244'
                WHERE ordernumber = 'P200531125022444' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393251'
                WHERE ordernumber = 'P180531125117137' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '292002'
                WHERE ordernumber = 'P200531125412457' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393254'
                WHERE ordernumber = 'P180531125507662' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393253'
                WHERE ordernumber = 'P790531125834344' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '273168'
                WHERE ordernumber = 'P180531125851338' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '207380'
                WHERE ordernumber = 'P180531130305690' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '207380'
                WHERE ordernumber = 'P180531130339462' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '167650'
                WHERE ordernumber = 'P420531130538712' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388110'
                WHERE ordernumber = 'P180531130610765' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '345354'
                WHERE ordernumber = 'P630531130626434' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393256'
                WHERE ordernumber = 'P200531130633773' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393257'
                WHERE ordernumber = 'P180531130751823' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393258'
                WHERE ordernumber = 'P200531130902663' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '238310'
                WHERE ordernumber = 'P630531130951226' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393260'
                WHERE ordernumber = 'P180531131119233' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389801'
                WHERE ordernumber = 'P200531131139734' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393261'
                WHERE ordernumber = 'P180531131335642' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393262'
                WHERE ordernumber = 'P200531131443824' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393263'
                WHERE ordernumber = 'P180531131948819' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113870'
                WHERE ordernumber = 'P200531132013472' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393265'
                WHERE ordernumber = 'P180531132114686' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393266'
                WHERE ordernumber = 'P420531132137769' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '224298'
                WHERE ordernumber = 'P420531132957187' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '372027'
                WHERE ordernumber = 'P630531133339271' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '166284'
                WHERE ordernumber = 'P180531133508542' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393269'
                WHERE ordernumber = 'P420531133657264' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391150'
                WHERE ordernumber = 'P200531134949858' 
            
2024-06-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393273'
                WHERE ordernumber = 'P180531135143263' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393274'
                WHERE ordernumber = 'P180531135233111' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393277'
                WHERE ordernumber = 'P200531135626805' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '272157'
                WHERE ordernumber = 'P180531135645326' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348765'
                WHERE ordernumber = 'P200531135719901' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393276'
                WHERE ordernumber = 'P710531135952952' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '90938'
                WHERE ordernumber = 'P200531140216825' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '187096'
                WHERE ordernumber = 'P420531140229498' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393278'
                WHERE ordernumber = 'P710531140242340' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '232171'
                WHERE ordernumber = 'P180531140530376' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393282'
                WHERE ordernumber = 'P200531140724279' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393285'
                WHERE ordernumber = 'P180531141028938' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '149109'
                WHERE ordernumber = 'P200531141101366' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248594'
                WHERE ordernumber = 'P180531141105915' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393284'
                WHERE ordernumber = 'P710531141114426' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393286'
                WHERE ordernumber = 'P200531141241991' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283996'
                WHERE ordernumber = 'P180531141630414' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '215035'
                WHERE ordernumber = 'P180531142559643' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228228'
                WHERE ordernumber = 'P180531143417395' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393288'
                WHERE ordernumber = 'P200531143715466' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390223'
                WHERE ordernumber = 'P200531143814519' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391322'
                WHERE ordernumber = 'P710531144018201' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393289'
                WHERE ordernumber = 'P180531144652901' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384882'
                WHERE ordernumber = 'P180531145249398' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353536'
                WHERE ordernumber = 'P180531150021902' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393290'
                WHERE ordernumber = 'P420531150235269' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393292'
                WHERE ordernumber = 'P420531150606904' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '225683'
                WHERE ordernumber = 'P180531150745772' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '225683'
                WHERE ordernumber = 'P190531150932792' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393293'
                WHERE ordernumber = 'P200531151330428' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160887'
                WHERE ordernumber = 'P420531151407616' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '332075'
                WHERE ordernumber = 'P190531151431569' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393294'
                WHERE ordernumber = 'P420531151749874' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '375826'
                WHERE ordernumber = 'P190531151823716' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '234548'
                WHERE ordernumber = 'P420531152055121' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '262592'
                WHERE ordernumber = 'P200531152715330' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393142'
                WHERE ordernumber = 'P790531152815511' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393163'
                WHERE ordernumber = 'P790531152854520' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393297'
                WHERE ordernumber = 'P180531153128908' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '114784'
                WHERE ordernumber = 'P790531153300402' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '87355'
                WHERE ordernumber = 'P180531153359934' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393298'
                WHERE ordernumber = 'P200531153529437' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393299'
                WHERE ordernumber = 'P790531153828236' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '335123'
                WHERE ordernumber = 'P180531153850374' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '156986'
                WHERE ordernumber = 'P190531154618430' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393301'
                WHERE ordernumber = 'P710531154815659' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374388'
                WHERE ordernumber = 'P180531154955421' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391783'
                WHERE ordernumber = 'P790531155229311' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '141605'
                WHERE ordernumber = 'P180531155413774' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '140470'
                WHERE ordernumber = 'P180531155733506' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '121648'
                WHERE ordernumber = 'P420531160130173' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389257'
                WHERE ordernumber = 'P190531160448236' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296784'
                WHERE ordernumber = 'P420531160732195' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393303'
                WHERE ordernumber = 'P790531160740272' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305270'
                WHERE ordernumber = 'P180531161752703' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '288305'
                WHERE ordernumber = 'P180531161929355' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393305'
                WHERE ordernumber = 'P790531162009289' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P180531162040790' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393307'
                WHERE ordernumber = 'P790531162120280' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '88195'
                WHERE ordernumber = 'P180531162147675' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378213'
                WHERE ordernumber = 'P200531162227830' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393308'
                WHERE ordernumber = 'P180531162358980' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353385'
                WHERE ordernumber = 'P180531162444289' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393309'
                WHERE ordernumber = 'P180531162709353' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103572'
                WHERE ordernumber = 'P180531162835388' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389496'
                WHERE ordernumber = 'P180531162944445' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305549'
                WHERE ordernumber = 'P420531163053442' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393311'
                WHERE ordernumber = 'P180531163149873' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393314'
                WHERE ordernumber = 'P180531163652888' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393316'
                WHERE ordernumber = 'P180531164917575' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391265'
                WHERE ordernumber = 'P180531165049154' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381471'
                WHERE ordernumber = 'P790531165347317' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393319'
                WHERE ordernumber = 'P420531165420327' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314919'
                WHERE ordernumber = 'P200531165702486' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386841'
                WHERE ordernumber = 'P180531170052141' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '308903'
                WHERE ordernumber = 'P180531170214896' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393321'
                WHERE ordernumber = 'P420531170234490' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309861'
                WHERE ordernumber = 'P180531170323495' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98988'
                WHERE ordernumber = 'P200531170520838' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99994'
                WHERE ordernumber = 'P180531170634163' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393320'
                WHERE ordernumber = 'P790531170831929' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393323'
                WHERE ordernumber = 'P190531170840688' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '133890'
                WHERE ordernumber = 'P180531171043298' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '252044'
                WHERE ordernumber = 'P200531171043696' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393324'
                WHERE ordernumber = 'P200531171658814' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391801'
                WHERE ordernumber = 'P790531171732625' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393326'
                WHERE ordernumber = 'P180531171950381' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393327'
                WHERE ordernumber = 'P180531172109339' 
            
2024-06-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393328'
                WHERE ordernumber = 'P790531172342505' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393326'
                WHERE ordernumber = 'P180531172413320' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393329'
                WHERE ordernumber = 'P790531172421882' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393326'
                WHERE ordernumber = 'P180531172500747' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388012'
                WHERE ordernumber = 'P420531172905717' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96952'
                WHERE ordernumber = 'P420531173307951' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387953'
                WHERE ordernumber = 'P420531173726150' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393332'
                WHERE ordernumber = 'P200531174647744' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283811'
                WHERE ordernumber = 'P180531174709642' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '56829'
                WHERE ordernumber = 'P200531175027312' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '255033'
                WHERE ordernumber = 'P200531175243787' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393334'
                WHERE ordernumber = 'P180531175245957' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393335'
                WHERE ordernumber = 'P190531175303949' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '224684'
                WHERE ordernumber = 'P190531175400372' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393336'
                WHERE ordernumber = 'P200531175443546' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393338'
                WHERE ordernumber = 'P190531175559307' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393340'
                WHERE ordernumber = 'P190531175848604' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393339'
                WHERE ordernumber = 'P200531175920312' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393343'
                WHERE ordernumber = 'P180531180024838' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393342'
                WHERE ordernumber = 'P420531180158391' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393345'
                WHERE ordernumber = 'P200531180728572' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392632'
                WHERE ordernumber = 'P710531180741219' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393347'
                WHERE ordernumber = 'P180531180931951' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393346'
                WHERE ordernumber = 'P710531180959356' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389856'
                WHERE ordernumber = 'P420531181158585' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389856'
                WHERE ordernumber = 'P420531181249634' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393339'
                WHERE ordernumber = 'P200531181300573' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393348'
                WHERE ordernumber = 'P710531181903501' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '127484'
                WHERE ordernumber = 'P180531182058497' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '111738'
                WHERE ordernumber = 'P190531182237775' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350628'
                WHERE ordernumber = 'P710531182706862' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372611'
                WHERE ordernumber = 'P200531182710969' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393349'
                WHERE ordernumber = 'P790531182912667' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393350'
                WHERE ordernumber = 'P420531182934215' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393349'
                WHERE ordernumber = 'P790531183037442' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277867'
                WHERE ordernumber = 'P180531183107790' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '211875'
                WHERE ordernumber = 'P180531183244359' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385207'
                WHERE ordernumber = 'P180531183337842' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '368281'
                WHERE ordernumber = 'P200531183613768' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346471'
                WHERE ordernumber = 'P200531183839630' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '272621'
                WHERE ordernumber = 'P200531183928319' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301150'
                WHERE ordernumber = 'P200531184032849' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '64226'
                WHERE ordernumber = 'P420531184105852' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '374458'
                WHERE ordernumber = 'P420531184307499' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393354'
                WHERE ordernumber = 'P200531184330706' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '173168'
                WHERE ordernumber = 'P710531184545909' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245847'
                WHERE ordernumber = 'P190531184646730' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '209310'
                WHERE ordernumber = 'P190531184953139' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '209310'
                WHERE ordernumber = 'P190531185038994' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '164943'
                WHERE ordernumber = 'P200531185044378' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '173168'
                WHERE ordernumber = 'P710531185058713' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81433'
                WHERE ordernumber = 'P200531185120393' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354096'
                WHERE ordernumber = 'P420531185138866' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '374458'
                WHERE ordernumber = 'P420531185222589' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393358'
                WHERE ordernumber = 'P190531185342614' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386323'
                WHERE ordernumber = 'P190531185453861' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393357'
                WHERE ordernumber = 'P190531185537887' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393361'
                WHERE ordernumber = 'P190531185727117' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393360'
                WHERE ordernumber = 'P200531185734965' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393359'
                WHERE ordernumber = 'P200531185858806' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382973'
                WHERE ordernumber = 'P420531190011770' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114286'
                WHERE ordernumber = 'P190531190052338' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393362'
                WHERE ordernumber = 'P200531190209508' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277108'
                WHERE ordernumber = 'P190531190221792' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393363'
                WHERE ordernumber = 'P190531190354145' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '369333'
                WHERE ordernumber = 'P190531190417781' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '101797'
                WHERE ordernumber = 'P200531190603255' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393364'
                WHERE ordernumber = 'P710531190623698' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '242812'
                WHERE ordernumber = 'P190531190928184' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99522'
                WHERE ordernumber = 'P190531191007354' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385358'
                WHERE ordernumber = 'P190531191148287' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287777'
                WHERE ordernumber = 'P190531191507429' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393365'
                WHERE ordernumber = 'P190531191840584' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393367'
                WHERE ordernumber = 'P200531192153196' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393369'
                WHERE ordernumber = 'P190531192331268' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393368'
                WHERE ordernumber = 'P790531192337287' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '95730'
                WHERE ordernumber = 'P200531192517968' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '128128'
                WHERE ordernumber = 'P190531192520796' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393370'
                WHERE ordernumber = 'P200531192724521' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '233911'
                WHERE ordernumber = 'P200531193004333' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352787'
                WHERE ordernumber = 'P190531193011580' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393371'
                WHERE ordernumber = 'P200531193135179' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393372'
                WHERE ordernumber = 'P200531193322178' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393373'
                WHERE ordernumber = 'P190531193612366' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '86113'
                WHERE ordernumber = 'P190531193702935' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393375'
                WHERE ordernumber = 'P200531193849727' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '272421'
                WHERE ordernumber = 'P200531194026387' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '266586'
                WHERE ordernumber = 'P190531194227154' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393377'
                WHERE ordernumber = 'P200531194310702' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '157035'
                WHERE ordernumber = 'P200531194405913' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393380'
                WHERE ordernumber = 'P190531194532184' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358265'
                WHERE ordernumber = 'P200531194536791' 
            
2024-06-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '373453'
                WHERE ordernumber = 'P630531194606374' 
            
2024-06-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393381'
                WHERE ordernumber = 'P190531194850872' 
            
2024-06-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393376'
                WHERE ordernumber = 'P190531194948135' 
            
2024-06-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393383'
                WHERE ordernumber = 'P200531195015851' 
            
2024-06-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393376'
                WHERE ordernumber = 'P190531195033986' 
            
2024-06-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393382'
                WHERE ordernumber = 'P790531195151845' 
            
2024-06-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '319132'
                WHERE ordernumber = 'P190531195456845' 
            
2024-06-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388557'
                WHERE ordernumber = 'P790531195904793' 
            
2024-06-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '312116'
                WHERE ordernumber = 'P200531200015908' 
            
2024-06-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393385'
                WHERE ordernumber = 'P790531200258700' 
            
2024-06-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '367494'
                WHERE ordernumber = 'P710531201513290' 
            
2024-06-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '382800'
                WHERE ordernumber = 'P710531201914923' 
            
2024-06-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393391'
                WHERE ordernumber = 'P630531203132826' 
            
2024-06-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '385838'
                WHERE ordernumber = 'P630531203805820' 
            
2024-06-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393395'
                WHERE ordernumber = 'P790531205335723' 
            
2024-06-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393398'
                WHERE ordernumber = 'P790531210020647' 
            
2024-06-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393397'
                WHERE ordernumber = 'P790531210128883' 
            
2024-06-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393399'
                WHERE ordernumber = 'P790531210318734' 
            
2024-06-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393400'
                WHERE ordernumber = 'P790531210604558' 
            
2024-06-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393404'
                WHERE ordernumber = 'P790531211925949' 
            
2024-06-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393403'
                WHERE ordernumber = 'P710531212113121' 
            
2024-06-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393406'
                WHERE ordernumber = 'P790531212129436' 
            
2024-06-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393405'
                WHERE ordernumber = 'P790531212252924' 
            
2024-06-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '390637'
                WHERE ordernumber = 'P790531213142874' 
            
2024-06-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393408'
                WHERE ordernumber = 'P790531213417270' 
            
2024-06-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393409'
                WHERE ordernumber = 'P790531213629618' 
            
2024-06-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '371156'
                WHERE ordernumber = 'P790531213734449' 
            
2024-06-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393412'
                WHERE ordernumber = 'P790531214035942' 
            
2024-06-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393410'
                WHERE ordernumber = 'P790531214202415' 
            
2024-06-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393413'
                WHERE ordernumber = 'P790531214423443' 
            
2024-06-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393414'
                WHERE ordernumber = 'P790531214738813' 
            
2024-06-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393416'
                WHERE ordernumber = 'P790531215618376'