2024-04-22 01:00:02 -- 將會員中心id寫入data-lake
2024-04-22 01:00:02 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-04-21%';
        
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386385'
                WHERE ordernumber = 'P420421101058305' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '272770'
                WHERE ordernumber = 'P630421102519340' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94758'
                WHERE ordernumber = 'P630421104434370' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339191'
                WHERE ordernumber = 'P420421104746328' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '267203'
                WHERE ordernumber = 'P180421110223183' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386386'
                WHERE ordernumber = 'P190421110322586' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365962'
                WHERE ordernumber = 'P200421110347241' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386388'
                WHERE ordernumber = 'P420421110502169' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '167650'
                WHERE ordernumber = 'P420421110737207' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386389'
                WHERE ordernumber = 'P180421111144208' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386389'
                WHERE ordernumber = 'P180421111325359' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386390'
                WHERE ordernumber = 'P200421111329828' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386390'
                WHERE ordernumber = 'P200421111519677' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386391'
                WHERE ordernumber = 'P590421111534684' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386392'
                WHERE ordernumber = 'P180421111645826' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386393'
                WHERE ordernumber = 'P180421111931126' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386394'
                WHERE ordernumber = 'P190421112046524' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '16688'
                WHERE ordernumber = 'P420421112149112' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386395'
                WHERE ordernumber = 'P200421112217846' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '255328'
                WHERE ordernumber = 'P180421113210232' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386396'
                WHERE ordernumber = 'P190421113721116' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '376510'
                WHERE ordernumber = 'P420421114303771' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '49891'
                WHERE ordernumber = 'P180421114655393' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386103'
                WHERE ordernumber = 'P590421115318361' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '132684'
                WHERE ordernumber = 'P180421115405120' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386398'
                WHERE ordernumber = 'P200421115703885' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386399'
                WHERE ordernumber = 'P200421115958893' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386400'
                WHERE ordernumber = 'P420421120345502' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386401'
                WHERE ordernumber = 'P200421120534788' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386403'
                WHERE ordernumber = 'P200421121003491' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386404'
                WHERE ordernumber = 'P180421121106718' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370614'
                WHERE ordernumber = 'P200421121117595' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386405'
                WHERE ordernumber = 'P180421121500237' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386406'
                WHERE ordernumber = 'P200421121608712' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379266'
                WHERE ordernumber = 'P420421121716711' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386407'
                WHERE ordernumber = 'P200421122138338' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386408'
                WHERE ordernumber = 'P180421122726595' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '87091'
                WHERE ordernumber = 'P180421123147623' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386409'
                WHERE ordernumber = 'P190421123302683' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386410'
                WHERE ordernumber = 'P180421123326836' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386412'
                WHERE ordernumber = 'P200421123626600' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386411'
                WHERE ordernumber = 'P180421123628377' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386413'
                WHERE ordernumber = 'P180421124042501' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386414'
                WHERE ordernumber = 'P590421125254758' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386416'
                WHERE ordernumber = 'P180421125545405' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386415'
                WHERE ordernumber = 'P420421125615875' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247350'
                WHERE ordernumber = 'P200421125718727' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386417'
                WHERE ordernumber = 'P180421130130452' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380916'
                WHERE ordernumber = 'P420421130235351' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386418'
                WHERE ordernumber = 'P630421130411306' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99273'
                WHERE ordernumber = 'P180421130445544' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386421'
                WHERE ordernumber = 'P180421131129332' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '336352'
                WHERE ordernumber = 'P420421131525483' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235248'
                WHERE ordernumber = 'P200421131548492' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '84222'
                WHERE ordernumber = 'P200421132059345' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384111'
                WHERE ordernumber = 'P190421132749122' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368817'
                WHERE ordernumber = 'P180421132858848' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304393'
                WHERE ordernumber = 'P590421133054721' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386423'
                WHERE ordernumber = 'P200421133329713' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386424'
                WHERE ordernumber = 'P180421133435451' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386426'
                WHERE ordernumber = 'P180421133938417' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386428'
                WHERE ordernumber = 'P200421134508142' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386427'
                WHERE ordernumber = 'P180421134704140' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '38901'
                WHERE ordernumber = 'P200421134718476' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99263'
                WHERE ordernumber = 'P180421134929235' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '52165'
                WHERE ordernumber = 'P630421135158296' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '375337'
                WHERE ordernumber = 'P630421135350328' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380031'
                WHERE ordernumber = 'P200421135458316' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '375337'
                WHERE ordernumber = 'P630421135615439' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386429'
                WHERE ordernumber = 'P590421135752623' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '268913'
                WHERE ordernumber = 'P420421140041360' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386430'
                WHERE ordernumber = 'P200421140119556' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386431'
                WHERE ordernumber = 'P200421140339786' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386432'
                WHERE ordernumber = 'P190421140343553' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386433'
                WHERE ordernumber = 'P200421140513553' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380791'
                WHERE ordernumber = 'P180421140757925' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386031'
                WHERE ordernumber = 'P190421140921577' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386434'
                WHERE ordernumber = 'P200421140956136' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348408'
                WHERE ordernumber = 'P200421141533618' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386437'
                WHERE ordernumber = 'P420421141657475' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386435'
                WHERE ordernumber = 'P190421141745166' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386439'
                WHERE ordernumber = 'P200421141938602' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386441'
                WHERE ordernumber = 'P200421142025240' 
            
2024-04-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386442'
                WHERE ordernumber = 'P200421142215709' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386443'
                WHERE ordernumber = 'P190421142416610' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386444'
                WHERE ordernumber = 'P200421142601320' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '261396'
                WHERE ordernumber = 'P420421143119858' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386445'
                WHERE ordernumber = 'P420421143250945' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386118'
                WHERE ordernumber = 'P590421143304992' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '217542'
                WHERE ordernumber = 'P420421143401776' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386446'
                WHERE ordernumber = 'P200421143910507' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386447'
                WHERE ordernumber = 'P190421144027183' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386448'
                WHERE ordernumber = 'P200421144110665' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386449'
                WHERE ordernumber = 'P590421144207639' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386450'
                WHERE ordernumber = 'P200421144333122' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386450'
                WHERE ordernumber = 'P200421144408589' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386451'
                WHERE ordernumber = 'P190421144413521' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386450'
                WHERE ordernumber = 'P200421144541744' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383893'
                WHERE ordernumber = 'P190421145004770' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386452'
                WHERE ordernumber = 'P200421145029139' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386453'
                WHERE ordernumber = 'P190421145236281' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386455'
                WHERE ordernumber = 'P180421145357792' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '290711'
                WHERE ordernumber = 'P190421145830887' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '37063'
                WHERE ordernumber = 'P200421150110926' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386456'
                WHERE ordernumber = 'P190421150113595' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386457'
                WHERE ordernumber = 'P190421150445349' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386458'
                WHERE ordernumber = 'P420421150505563' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386459'
                WHERE ordernumber = 'P420421150658207' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386460'
                WHERE ordernumber = 'P190421150756543' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '209438'
                WHERE ordernumber = 'P180421150933189' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '33696'
                WHERE ordernumber = 'P200421151209472' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386462'
                WHERE ordernumber = 'P200421151425211' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386463'
                WHERE ordernumber = 'P200421151530278' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '78196'
                WHERE ordernumber = 'P200421151709611' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '107770'
                WHERE ordernumber = 'P190421151724489' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379045'
                WHERE ordernumber = 'P200421152013201' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385963'
                WHERE ordernumber = 'P190421152115779' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299815'
                WHERE ordernumber = 'P200421152115408' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94416'
                WHERE ordernumber = 'P190421152613732' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '41968'
                WHERE ordernumber = 'P200421152934892' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386464'
                WHERE ordernumber = 'P190421153019727' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '260354'
                WHERE ordernumber = 'P200421153055826' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386465'
                WHERE ordernumber = 'P420421153206690' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386380'
                WHERE ordernumber = 'P180421153318620' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386466'
                WHERE ordernumber = 'P190421153409717' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '26042'
                WHERE ordernumber = 'P200421153552506' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386467'
                WHERE ordernumber = 'P200421153957568' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '89983'
                WHERE ordernumber = 'P190421154126453' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386468'
                WHERE ordernumber = 'P190421154254675' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380364'
                WHERE ordernumber = 'P190421154417840' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386469'
                WHERE ordernumber = 'P200421154601470' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386470'
                WHERE ordernumber = 'P200421154729480' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337481'
                WHERE ordernumber = 'P200421154855951' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386472'
                WHERE ordernumber = 'P630421155953537' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386474'
                WHERE ordernumber = 'P630421160118875' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '153894'
                WHERE ordernumber = 'P200421160729410' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384669'
                WHERE ordernumber = 'P200421161809759' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284827'
                WHERE ordernumber = 'P190421162008438' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386477'
                WHERE ordernumber = 'P420421162253678' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '202600'
                WHERE ordernumber = 'P180421162318255' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386478'
                WHERE ordernumber = 'P190421162325889' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '132066'
                WHERE ordernumber = 'P180421162709944' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386479'
                WHERE ordernumber = 'P200421162818670' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94237'
                WHERE ordernumber = 'P200421163012167' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386480'
                WHERE ordernumber = 'P420421163042946' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386481'
                WHERE ordernumber = 'P420421163232272' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386482'
                WHERE ordernumber = 'P190421163240922' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386476'
                WHERE ordernumber = 'P180421163319611' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386483'
                WHERE ordernumber = 'P420421163434491' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '300868'
                WHERE ordernumber = 'P180421163700195' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '290603'
                WHERE ordernumber = 'P420421164110881' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386483'
                WHERE ordernumber = 'P420421164252446' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386484'
                WHERE ordernumber = 'P180421164331988' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379342'
                WHERE ordernumber = 'P420421164628529' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386485'
                WHERE ordernumber = 'P200421164654526' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386486'
                WHERE ordernumber = 'P200421165037561' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '293103'
                WHERE ordernumber = 'P590421165157163' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383922'
                WHERE ordernumber = 'P420421165343542' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386487'
                WHERE ordernumber = 'P190421165408486' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386488'
                WHERE ordernumber = 'P190421165519458' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '222266'
                WHERE ordernumber = 'P200421165601408' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386489'
                WHERE ordernumber = 'P420421165659295' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '175107'
                WHERE ordernumber = 'P200421165747676' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386490'
                WHERE ordernumber = 'P190421165750939' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '204693'
                WHERE ordernumber = 'P420421165759840' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386491'
                WHERE ordernumber = 'P180421170359141' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386492'
                WHERE ordernumber = 'P200421170508580' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386098'
                WHERE ordernumber = 'P420421170735690' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238771'
                WHERE ordernumber = 'P200421170908540' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '89181'
                WHERE ordernumber = 'P190421171111467' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386493'
                WHERE ordernumber = 'P630421171212114' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '326311'
                WHERE ordernumber = 'P190421171535175' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '293492'
                WHERE ordernumber = 'P190421172005203' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386495'
                WHERE ordernumber = 'P200421172014907' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384669'
                WHERE ordernumber = 'P590421172145967' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353524'
                WHERE ordernumber = 'P190421172153971' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386496'
                WHERE ordernumber = 'P190421172749687' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '321965'
                WHERE ordernumber = 'P420421172808930' 
            
2024-04-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386483'
                WHERE ordernumber = 'P420421173133168' 
            
2024-04-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386264'
                WHERE ordernumber = 'P200421173144887' 
            
2024-04-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '379951'
                WHERE ordernumber = 'P180421173217691' 
            
2024-04-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '341057'
                WHERE ordernumber = 'P180421173413986' 
            
2024-04-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386497'
                WHERE ordernumber = 'P200421174543642' 
            
2024-04-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '139409'
                WHERE ordernumber = 'P200421174604923' 
            
2024-04-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386498'
                WHERE ordernumber = 'P200421174710694' 
            
2024-04-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386499'
                WHERE ordernumber = 'P180421180411526' 
            
2024-04-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '96695'
                WHERE ordernumber = 'P180421180803904' 
            
2024-04-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '382806'
                WHERE ordernumber = 'P190421181507655' 
            
2024-04-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '273597'
                WHERE ordernumber = 'P590421181724234' 
            
2024-04-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '100389'
                WHERE ordernumber = 'P420421181957793' 
            
2024-04-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '99571'
                WHERE ordernumber = 'P200421182218399' 
            
2024-04-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '309177'
                WHERE ordernumber = 'P200421182953887' 
            
2024-04-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386501'
                WHERE ordernumber = 'P420421183017303' 
            
2024-04-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '303002'
                WHERE ordernumber = 'P200421183050357' 
            
2024-04-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384798'
                WHERE ordernumber = 'P190421183700662' 
            
2024-04-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '325304'
                WHERE ordernumber = 'P420421183958937' 
            
2024-04-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '304369'
                WHERE ordernumber = 'P200421184915329' 
            
2024-04-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386503'
                WHERE ordernumber = 'P200421185233292' 
            
2024-04-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355398'
                WHERE ordernumber = 'P200421185939348' 
            
2024-04-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '225617'
                WHERE ordernumber = 'P200421190034873' 
            
2024-04-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386506'
                WHERE ordernumber = 'P200421190514143' 
            
2024-04-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '86113'
                WHERE ordernumber = 'P190421191748762' 
            
2024-04-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386507'
                WHERE ordernumber = 'P200421192043219' 
            
2024-04-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386508'
                WHERE ordernumber = 'P630421192952207' 
            
2024-04-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '233323'
                WHERE ordernumber = 'P200421194518866' 
            
2024-04-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386510'
                WHERE ordernumber = 'P200421195101391' 
            
2024-04-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386511'
                WHERE ordernumber = 'P200421195214418' 
            
2024-04-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386512'
                WHERE ordernumber = 'P200421195345238' 
            
2024-04-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386515'
                WHERE ordernumber = 'P630421210903527'