2024-06-07 01:00:01 -- 將會員中心id寫入data-lake
2024-06-07 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-06-06%';
        
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '384919'
                WHERE ordernumber = 'P630606104009732' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394476'
                WHERE ordernumber = 'P190606110404532' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '306440'
                WHERE ordernumber = 'P200606110721515' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '209361'
                WHERE ordernumber = 'P180606110943718' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394477'
                WHERE ordernumber = 'P200606111018138' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '343835'
                WHERE ordernumber = 'P420606111059935' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '342567'
                WHERE ordernumber = 'P420606111207471' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394478'
                WHERE ordernumber = 'P180606111238127' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394477'
                WHERE ordernumber = 'P200606111452840' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '272255'
                WHERE ordernumber = 'P420606111550452' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394480'
                WHERE ordernumber = 'P200606111618632' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394482'
                WHERE ordernumber = 'P180606111746876' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394481'
                WHERE ordernumber = 'P200606111801800' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '124230'
                WHERE ordernumber = 'P180606112049420' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394483'
                WHERE ordernumber = 'P420606112207118' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394484'
                WHERE ordernumber = 'P180606112436570' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381735'
                WHERE ordernumber = 'P180606112551566' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '384919'
                WHERE ordernumber = 'P630606112602193' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '232297'
                WHERE ordernumber = 'P200606112624550' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '317295'
                WHERE ordernumber = 'P180606112843300' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '329515'
                WHERE ordernumber = 'P190606113049434' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '285697'
                WHERE ordernumber = 'P200606113130770' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '118566'
                WHERE ordernumber = 'P190606113212820' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394486'
                WHERE ordernumber = 'P180606113221198' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393017'
                WHERE ordernumber = 'P200606113240601' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391672'
                WHERE ordernumber = 'P190606113344385' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394487'
                WHERE ordernumber = 'P420606113357626' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392012'
                WHERE ordernumber = 'P200606113428114' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394488'
                WHERE ordernumber = 'P200606113536780' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391672'
                WHERE ordernumber = 'P190606113604868' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394489'
                WHERE ordernumber = 'P180606113643587' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394485'
                WHERE ordernumber = 'P180606113818509' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394485'
                WHERE ordernumber = 'P180606113848813' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '372215'
                WHERE ordernumber = 'P180606113937736' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393863'
                WHERE ordernumber = 'P200606114012276' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394491'
                WHERE ordernumber = 'P180606114440378' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '228082'
                WHERE ordernumber = 'P190606115121451' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394492'
                WHERE ordernumber = 'P780606115319997' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394494'
                WHERE ordernumber = 'P180606120000897' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390443'
                WHERE ordernumber = 'P180606120159646' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394495'
                WHERE ordernumber = 'P420606120249260' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '223384'
                WHERE ordernumber = 'P420606120541151' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '304730'
                WHERE ordernumber = 'P200606120648738' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '299709'
                WHERE ordernumber = 'P420606120717208' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394498'
                WHERE ordernumber = 'P180606120734238' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '120991'
                WHERE ordernumber = 'P190606120852870' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393911'
                WHERE ordernumber = 'P180606121008674' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394499'
                WHERE ordernumber = 'P190606121028470' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '345453'
                WHERE ordernumber = 'P200606121121294' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394497'
                WHERE ordernumber = 'P710606121329584' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '125423'
                WHERE ordernumber = 'P180606121456447' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '314728'
                WHERE ordernumber = 'P420606121619909' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394501'
                WHERE ordernumber = 'P420606121738123' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386907'
                WHERE ordernumber = 'P630606121936349' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '269948'
                WHERE ordernumber = 'P420606122109165' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '270895'
                WHERE ordernumber = 'P200606122304532' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393896'
                WHERE ordernumber = 'P420606122319966' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394502'
                WHERE ordernumber = 'P180606122345426' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '215517'
                WHERE ordernumber = 'P200606122525768' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394503'
                WHERE ordernumber = 'P180606122533284' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '358462'
                WHERE ordernumber = 'P200606122619196' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '342844'
                WHERE ordernumber = 'P420606122826956' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394505'
                WHERE ordernumber = 'P180606123420683' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394506'
                WHERE ordernumber = 'P200606123603754' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '95801'
                WHERE ordernumber = 'P200606123800346' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394076'
                WHERE ordernumber = 'P180606123846962' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394076'
                WHERE ordernumber = 'P180606123923125' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394076'
                WHERE ordernumber = 'P180606124000319' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394503'
                WHERE ordernumber = 'P180606124208354' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '358232'
                WHERE ordernumber = 'P420606124211888' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394508'
                WHERE ordernumber = 'P200606124318383' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394509'
                WHERE ordernumber = 'P420606124432849' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '216260'
                WHERE ordernumber = 'P180606124721739' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394510'
                WHERE ordernumber = 'P420606124727689' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394512'
                WHERE ordernumber = 'P420606124819298' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394511'
                WHERE ordernumber = 'P200606124836638' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391633'
                WHERE ordernumber = 'P180606124931845' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386014'
                WHERE ordernumber = 'P180606125012977' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '307175'
                WHERE ordernumber = 'P420606125054400' 
            
2024-06-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '22193'
                WHERE ordernumber = 'P630606125228132' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394513'
                WHERE ordernumber = 'P420606125347639' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394500'
                WHERE ordernumber = 'P420606130126191' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296319'
                WHERE ordernumber = 'P200606130316181' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394514'
                WHERE ordernumber = 'P420606130431645' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '125933'
                WHERE ordernumber = 'P200606130621151' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394516'
                WHERE ordernumber = 'P710606130801973' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '105630'
                WHERE ordernumber = 'P200606131611830' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '274867'
                WHERE ordernumber = 'P200606132018812' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393962'
                WHERE ordernumber = 'P420606132116306' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '324099'
                WHERE ordernumber = 'P420606132206555' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394519'
                WHERE ordernumber = 'P200606132232172' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '130976'
                WHERE ordernumber = 'P180606132453364' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394520'
                WHERE ordernumber = 'P190606132523357' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346885'
                WHERE ordernumber = 'P420606133501454' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389920'
                WHERE ordernumber = 'P420606133834609' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389141'
                WHERE ordernumber = 'P200606133842679' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241865'
                WHERE ordernumber = 'P200606134057523' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394523'
                WHERE ordernumber = 'P710606134139959' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368655'
                WHERE ordernumber = 'P180606134239753' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368360'
                WHERE ordernumber = 'P180606134324644' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393642'
                WHERE ordernumber = 'P420606134413725' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '269581'
                WHERE ordernumber = 'P180606134624234' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394525'
                WHERE ordernumber = 'P630606134627244' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160114'
                WHERE ordernumber = 'P180606134921194' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '105869'
                WHERE ordernumber = 'P200606134923857' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394528'
                WHERE ordernumber = 'P420606135143900' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394526'
                WHERE ordernumber = 'P710606135212478' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394529'
                WHERE ordernumber = 'P180606140250396' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394529'
                WHERE ordernumber = 'P180606140339268' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394531'
                WHERE ordernumber = 'P420606140606798' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287639'
                WHERE ordernumber = 'P200606140704857' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '26395'
                WHERE ordernumber = 'P420606141508584' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279381'
                WHERE ordernumber = 'P200606141926240' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394534'
                WHERE ordernumber = 'P420606142055526' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394535'
                WHERE ordernumber = 'P180606142301256' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394537'
                WHERE ordernumber = 'P180606142428151' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394538'
                WHERE ordernumber = 'P180606142552369' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '211642'
                WHERE ordernumber = 'P180606142842499' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378293'
                WHERE ordernumber = 'P420606142853919' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394540'
                WHERE ordernumber = 'P200606142953227' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351827'
                WHERE ordernumber = 'P180606143237564' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160381'
                WHERE ordernumber = 'P710606143251548' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351827'
                WHERE ordernumber = 'P180606143321383' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '227225'
                WHERE ordernumber = 'P200606143651606' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302326'
                WHERE ordernumber = 'P200606143753466' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235885'
                WHERE ordernumber = 'P200606144101814' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394541'
                WHERE ordernumber = 'P190606144155267' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394543'
                WHERE ordernumber = 'P420606144513817' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '251277'
                WHERE ordernumber = 'P180606144622710' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356583'
                WHERE ordernumber = 'P420606144633171' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394542'
                WHERE ordernumber = 'P710606144637791' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394544'
                WHERE ordernumber = 'P710606144854597' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394546'
                WHERE ordernumber = 'P710606145244195' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394547'
                WHERE ordernumber = 'P180606145557534' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '154289'
                WHERE ordernumber = 'P180606150154662' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394548'
                WHERE ordernumber = 'P200606150321262' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248368'
                WHERE ordernumber = 'P200606150429537' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394549'
                WHERE ordernumber = 'P180606150657318' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '119761'
                WHERE ordernumber = 'P200606150743794' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394517'
                WHERE ordernumber = 'P420606150830341' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394551'
                WHERE ordernumber = 'P180606151441303' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350014'
                WHERE ordernumber = 'P200606151445632' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394553'
                WHERE ordernumber = 'P420606151805123' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394554'
                WHERE ordernumber = 'P180606152018649' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '114516'
                WHERE ordernumber = 'P190606152112435' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '318819'
                WHERE ordernumber = 'P420606152301905' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378447'
                WHERE ordernumber = 'P200606152334265' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99919'
                WHERE ordernumber = 'P180606152417977' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '280960'
                WHERE ordernumber = 'P180606153041987' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394541'
                WHERE ordernumber = 'P190606153052654' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '319097'
                WHERE ordernumber = 'P200606153218876' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281899'
                WHERE ordernumber = 'P420606153246133' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '236330'
                WHERE ordernumber = 'P200606153303304' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394555'
                WHERE ordernumber = 'P180606153651288' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96406'
                WHERE ordernumber = 'P180606153758931' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '217445'
                WHERE ordernumber = 'P190606154128349' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '261374'
                WHERE ordernumber = 'P420606154253807' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '159018'
                WHERE ordernumber = 'P180606154310572' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394556'
                WHERE ordernumber = 'P190606154328424' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393819'
                WHERE ordernumber = 'P180606154454548' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '163199'
                WHERE ordernumber = 'P180606154544457' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394496'
                WHERE ordernumber = 'P200606155102522' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394559'
                WHERE ordernumber = 'P420606155203308' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '212463'
                WHERE ordernumber = 'P180606155529365' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394560'
                WHERE ordernumber = 'P200606155603410' 
            
2024-06-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346597'
                WHERE ordernumber = 'P190606155828955' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98423'
                WHERE ordernumber = 'P200606155914319' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '315512'
                WHERE ordernumber = 'P190606160114231' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394562'
                WHERE ordernumber = 'P180606160507312' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394563'
                WHERE ordernumber = 'P200606160922429' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393379'
                WHERE ordernumber = 'P180606161031703' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '110888'
                WHERE ordernumber = 'P200606161311668' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394564'
                WHERE ordernumber = 'P420606161333445' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381648'
                WHERE ordernumber = 'P180606161831923' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388699'
                WHERE ordernumber = 'P420606161859334' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '105625'
                WHERE ordernumber = 'P200606162217316' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '160121'
                WHERE ordernumber = 'P200606162613405' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '364384'
                WHERE ordernumber = 'P200606162824147' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394565'
                WHERE ordernumber = 'P180606163059631' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394567'
                WHERE ordernumber = 'P180606163214715' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299143'
                WHERE ordernumber = 'P420606163656691' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '75984'
                WHERE ordernumber = 'P180606163701273' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394566'
                WHERE ordernumber = 'P180606163925685' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394568'
                WHERE ordernumber = 'P420606164124917' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81029'
                WHERE ordernumber = 'P200606164207810' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394569'
                WHERE ordernumber = 'P180606164430871' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384979'
                WHERE ordernumber = 'P200606164744260' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394571'
                WHERE ordernumber = 'P780606165013524' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394570'
                WHERE ordernumber = 'P420606165018763' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278911'
                WHERE ordernumber = 'P200606165107820' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394572'
                WHERE ordernumber = 'P190606165437319' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '133735'
                WHERE ordernumber = 'P180606165524737' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394573'
                WHERE ordernumber = 'P190606165606858' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '247184'
                WHERE ordernumber = 'P180606165702919' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344768'
                WHERE ordernumber = 'P180606165749327' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394574'
                WHERE ordernumber = 'P420606170052755' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '139595'
                WHERE ordernumber = 'P780606170307195' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394575'
                WHERE ordernumber = 'P630606170316956' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394576'
                WHERE ordernumber = 'P420606170913222' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '252044'
                WHERE ordernumber = 'P200606171119921' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '286811'
                WHERE ordernumber = 'P180606171152756' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '332736'
                WHERE ordernumber = 'P180606171322201' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394578'
                WHERE ordernumber = 'P420606171335516' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394579'
                WHERE ordernumber = 'P180606171556807' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '212314'
                WHERE ordernumber = 'P180606171711495' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394580'
                WHERE ordernumber = 'P190606171744962' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97441'
                WHERE ordernumber = 'P200606171751963' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394581'
                WHERE ordernumber = 'P180606171928191' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '364687'
                WHERE ordernumber = 'P710606172009686' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302390'
                WHERE ordernumber = 'P180606172036825' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97441'
                WHERE ordernumber = 'P200606172122512' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394583'
                WHERE ordernumber = 'P180606172239777' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394584'
                WHERE ordernumber = 'P420606172439448' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394585'
                WHERE ordernumber = 'P420606172642886' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386967'
                WHERE ordernumber = 'P420606172745524' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394586'
                WHERE ordernumber = 'P780606173028561' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394587'
                WHERE ordernumber = 'P200606173140766' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393625'
                WHERE ordernumber = 'P190606173423547' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389282'
                WHERE ordernumber = 'P200606173622820' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394588'
                WHERE ordernumber = 'P180606173707618' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '86783'
                WHERE ordernumber = 'P200606173847711' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366196'
                WHERE ordernumber = 'P180606174020753' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394589'
                WHERE ordernumber = 'P200606174104854' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366196'
                WHERE ordernumber = 'P180606174111838' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394590'
                WHERE ordernumber = 'P200606174349806' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394591'
                WHERE ordernumber = 'P180606174400997' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '158272'
                WHERE ordernumber = 'P200606174542935' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '296873'
                WHERE ordernumber = 'P420606174600559' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394592'
                WHERE ordernumber = 'P780606174737797' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394593'
                WHERE ordernumber = 'P200606174755617' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '365805'
                WHERE ordernumber = 'P180606174828737' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342764'
                WHERE ordernumber = 'P420606174928894' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394594'
                WHERE ordernumber = 'P180606174938905' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394595'
                WHERE ordernumber = 'P180606175059399' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394596'
                WHERE ordernumber = 'P420606175335393' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394597'
                WHERE ordernumber = 'P200606175355192' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394598'
                WHERE ordernumber = 'P420606175446619' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394597'
                WHERE ordernumber = 'P200606175442776' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394599'
                WHERE ordernumber = 'P200606175703536' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394600'
                WHERE ordernumber = 'P200606175831369' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '225042'
                WHERE ordernumber = 'P200606175940739' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394601'
                WHERE ordernumber = 'P180606180202307' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394600'
                WHERE ordernumber = 'P200606180333264' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340924'
                WHERE ordernumber = 'P420606180543291' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394140'
                WHERE ordernumber = 'P180606180814702' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97587'
                WHERE ordernumber = 'P420606181117795' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394603'
                WHERE ordernumber = 'P200606181117569' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394140'
                WHERE ordernumber = 'P180606181122802' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394604'
                WHERE ordernumber = 'P180606181424678' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390220'
                WHERE ordernumber = 'P200606181847349' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '247023'
                WHERE ordernumber = 'P200606181951635' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394605'
                WHERE ordernumber = 'P180606182447873' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394606'
                WHERE ordernumber = 'P180606182821567' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230279'
                WHERE ordernumber = 'P180606182923241' 
            
2024-06-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379866'
                WHERE ordernumber = 'P200606183153362' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '339940'
                WHERE ordernumber = 'P200606184410948' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394609'
                WHERE ordernumber = 'P420606184441994' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '325138'
                WHERE ordernumber = 'P200606184505716' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394610'
                WHERE ordernumber = 'P420606184620324' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '333470'
                WHERE ordernumber = 'P190606184627196' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '325138'
                WHERE ordernumber = 'P200606184652969' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394611'
                WHERE ordernumber = 'P190606185006898' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '128439'
                WHERE ordernumber = 'P200606185129999' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372870'
                WHERE ordernumber = 'P180606185130828' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394613'
                WHERE ordernumber = 'P710606185330854' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394612'
                WHERE ordernumber = 'P780606185401372' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394614'
                WHERE ordernumber = 'P200606185524878' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '99642'
                WHERE ordernumber = 'P190606185639795' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '262432'
                WHERE ordernumber = 'P590606185906774' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '199590'
                WHERE ordernumber = 'P200606185927973' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '342473'
                WHERE ordernumber = 'P200606190118877' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394617'
                WHERE ordernumber = 'P200606190304289' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394618'
                WHERE ordernumber = 'P420606190406710' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '225202'
                WHERE ordernumber = 'P190606190435884' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '213205'
                WHERE ordernumber = 'P200606190534564' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '310337'
                WHERE ordernumber = 'P200606190655350' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '219746'
                WHERE ordernumber = 'P200606191027114' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '346212'
                WHERE ordernumber = 'P190606191210374' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394620'
                WHERE ordernumber = 'P190606191501385' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394619'
                WHERE ordernumber = 'P710606191537434' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '389531'
                WHERE ordernumber = 'P190606191623600' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '212391'
                WHERE ordernumber = 'P190606191707602' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '316679'
                WHERE ordernumber = 'P200606191757437' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394621'
                WHERE ordernumber = 'P190606191809898' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '161965'
                WHERE ordernumber = 'P200606191834726' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394623'
                WHERE ordernumber = 'P200606192211666' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '239181'
                WHERE ordernumber = 'P190606192321319' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '338326'
                WHERE ordernumber = 'P190606192446507' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '103028'
                WHERE ordernumber = 'P200606192458165' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '63047'
                WHERE ordernumber = 'P190606192608441' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '63047'
                WHERE ordernumber = 'P190606192843195' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394624'
                WHERE ordernumber = 'P200606192931620' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '84218'
                WHERE ordernumber = 'P190606193157743' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394625'
                WHERE ordernumber = 'P780606193159892' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394626'
                WHERE ordernumber = 'P190606193304959' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '276758'
                WHERE ordernumber = 'P190606193745214' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394627'
                WHERE ordernumber = 'P190606193916689' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394628'
                WHERE ordernumber = 'P190606194103895' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '146541'
                WHERE ordernumber = 'P200606194322996' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394631'
                WHERE ordernumber = 'P780606194550760' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394633'
                WHERE ordernumber = 'P630606194707988' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '348816'
                WHERE ordernumber = 'P200606194735556' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394634'
                WHERE ordernumber = 'P200606195124348' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394630'
                WHERE ordernumber = 'P630606200509283' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394637'
                WHERE ordernumber = 'P780606201910580' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383120'
                WHERE ordernumber = 'P590606202930953' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394640'
                WHERE ordernumber = 'P710606204557844' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '387367'
                WHERE ordernumber = 'P710606205820249' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394644'
                WHERE ordernumber = 'P780606210053252' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394641'
                WHERE ordernumber = 'P630606210549613' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '245289'
                WHERE ordernumber = 'P710606211948533' 
            
2024-06-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394647'
                WHERE ordernumber = 'P780606212300300'