2024-03-08 01:00:02 -- 將會員中心id寫入data-lake
2024-03-08 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-03-07%';
        
2024-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '240419'
                WHERE ordernumber = 'P180307110112562' 
            
2024-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '307643'
                WHERE ordernumber = 'P180307110256651' 
            
2024-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380432'
                WHERE ordernumber = 'P180307110726946' 
            
2024-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '272810'
                WHERE ordernumber = 'P200307110812757' 
            
2024-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '112335'
                WHERE ordernumber = 'P180307111106458' 
            
2024-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99617'
                WHERE ordernumber = 'P180307111148871' 
            
2024-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380434'
                WHERE ordernumber = 'P180307111405579' 
            
2024-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377488'
                WHERE ordernumber = 'P190307111427753' 
            
2024-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380435'
                WHERE ordernumber = 'P180307111512524' 
            
2024-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '272810'
                WHERE ordernumber = 'P200307111626133' 
            
2024-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380437'
                WHERE ordernumber = 'P420307111942525' 
            
2024-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380431'
                WHERE ordernumber = 'P590307112145675' 
            
2024-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380439'
                WHERE ordernumber = 'P420307112335274' 
            
2024-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380441'
                WHERE ordernumber = 'P590307112822792' 
            
2024-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380440'
                WHERE ordernumber = 'P420307112846283' 
            
2024-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353242'
                WHERE ordernumber = 'P180307113219248' 
            
2024-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '305068'
                WHERE ordernumber = 'P180307113249839' 
            
2024-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380444'
                WHERE ordernumber = 'P200307113413169' 
            
2024-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '143625'
                WHERE ordernumber = 'P180307113447959' 
            
2024-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380445'
                WHERE ordernumber = 'P420307113649600' 
            
2024-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '234552'
                WHERE ordernumber = 'P200307114503137' 
            
2024-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380447'
                WHERE ordernumber = 'P180307114600771' 
            
2024-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '293470'
                WHERE ordernumber = 'P180307114633799' 
            
2024-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380448'
                WHERE ordernumber = 'P190307114722542' 
            
2024-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380449'
                WHERE ordernumber = 'P200307114900850' 
            
2024-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '293688'
                WHERE ordernumber = 'P180307120018291' 
            
2024-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '321442'
                WHERE ordernumber = 'P200307120054268' 
            
2024-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380451'
                WHERE ordernumber = 'P200307120210543' 
            
2024-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '280802'
                WHERE ordernumber = 'P420307120242754' 
            
2024-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380453'
                WHERE ordernumber = 'P420307120557633' 
            
2024-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '346678'
                WHERE ordernumber = 'P200307120941979' 
            
2024-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353263'
                WHERE ordernumber = 'P200307121308310' 
            
2024-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380454'
                WHERE ordernumber = 'P180307121733949' 
            
2024-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '367975'
                WHERE ordernumber = 'P200307122552918' 
            
2024-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '280398'
                WHERE ordernumber = 'P200307122656322' 
            
2024-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380455'
                WHERE ordernumber = 'P420307122659496' 
            
2024-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '280398'
                WHERE ordernumber = 'P200307122756626' 
            
2024-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '257880'
                WHERE ordernumber = 'P200307123401433' 
            
2024-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287382'
                WHERE ordernumber = 'P200307123547245' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '62661'
                WHERE ordernumber = 'P200307123842401' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380456'
                WHERE ordernumber = 'P200307123957991' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380457'
                WHERE ordernumber = 'P200307124122550' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380458'
                WHERE ordernumber = 'P420307125321265' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380459'
                WHERE ordernumber = 'P420307125556682' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380460'
                WHERE ordernumber = 'P420307130710613' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358975'
                WHERE ordernumber = 'P200307131200695' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380463'
                WHERE ordernumber = 'P200307132100222' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380465'
                WHERE ordernumber = 'P200307132249357' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380467'
                WHERE ordernumber = 'P200307132733523' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365227'
                WHERE ordernumber = 'P420307132938491' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380469'
                WHERE ordernumber = 'P200307133704713' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380470'
                WHERE ordernumber = 'P420307134241299' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '260405'
                WHERE ordernumber = 'P590307134310281' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '171742'
                WHERE ordernumber = 'P590307135247133' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380472'
                WHERE ordernumber = 'P200307135951226' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238127'
                WHERE ordernumber = 'P420307135958385' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '219481'
                WHERE ordernumber = 'P180307141221333' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '244809'
                WHERE ordernumber = 'P180307141409720' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '115668'
                WHERE ordernumber = 'P190307141745874' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338908'
                WHERE ordernumber = 'P190307142117376' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380474'
                WHERE ordernumber = 'P190307142630234' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380422'
                WHERE ordernumber = 'P200307142815341' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365581'
                WHERE ordernumber = 'P200307142900391' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380474'
                WHERE ordernumber = 'P190307143005616' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '373709'
                WHERE ordernumber = 'P200307143647236' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380475'
                WHERE ordernumber = 'P190307144034152' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275841'
                WHERE ordernumber = 'P180307145248771' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380477'
                WHERE ordernumber = 'P180307145428654' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380478'
                WHERE ordernumber = 'P200307145726444' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380480'
                WHERE ordernumber = 'P200307150223487' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380480'
                WHERE ordernumber = 'P200307150321414' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380479'
                WHERE ordernumber = 'P190307150448126' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '331068'
                WHERE ordernumber = 'P420307150549246' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '233233'
                WHERE ordernumber = 'P200307150610837' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '331068'
                WHERE ordernumber = 'P420307151418349' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380481'
                WHERE ordernumber = 'P420307151621580' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380482'
                WHERE ordernumber = 'P420307151752485' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '148024'
                WHERE ordernumber = 'P190307152616851' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380483'
                WHERE ordernumber = 'P420307152658999' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380484'
                WHERE ordernumber = 'P180307152743821' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248185'
                WHERE ordernumber = 'P190307152855686' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304793'
                WHERE ordernumber = 'P180307153108307' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286763'
                WHERE ordernumber = 'P190307153333262' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380487'
                WHERE ordernumber = 'P180307154018117' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380489'
                WHERE ordernumber = 'P180307154213860' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380488'
                WHERE ordernumber = 'P190307154248211' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235750'
                WHERE ordernumber = 'P200307154741549' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378587'
                WHERE ordernumber = 'P200307154850934' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380491'
                WHERE ordernumber = 'P420307154945441' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364496'
                WHERE ordernumber = 'P420307155038891' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380493'
                WHERE ordernumber = 'P190307155342749' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380495'
                WHERE ordernumber = 'P590307160354254' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380496'
                WHERE ordernumber = 'P420307160437956' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '363018'
                WHERE ordernumber = 'P420307160554129' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380438'
                WHERE ordernumber = 'P190307160744582' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380438'
                WHERE ordernumber = 'P190307160802882' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249083'
                WHERE ordernumber = 'P190307161022353' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380498'
                WHERE ordernumber = 'P200307161230701' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276000'
                WHERE ordernumber = 'P190307161259448' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '231382'
                WHERE ordernumber = 'P420307161653941' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380499'
                WHERE ordernumber = 'P190307162123608' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '220663'
                WHERE ordernumber = 'P190307162226763' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380501'
                WHERE ordernumber = 'P190307162355758' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380502'
                WHERE ordernumber = 'P420307162614980' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380503'
                WHERE ordernumber = 'P190307162737268' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380504'
                WHERE ordernumber = 'P190307162850712' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '321810'
                WHERE ordernumber = 'P420307163029117' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380505'
                WHERE ordernumber = 'P200307163349982' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380372'
                WHERE ordernumber = 'P200307163724280' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '104675'
                WHERE ordernumber = 'P190307163737900' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380506'
                WHERE ordernumber = 'P420307164729150' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '260507'
                WHERE ordernumber = 'P200307165557645' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380510'
                WHERE ordernumber = 'P590307170417640' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380511'
                WHERE ordernumber = 'P200307171105336' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364411'
                WHERE ordernumber = 'P180307171417958' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380512'
                WHERE ordernumber = 'P420307171500164' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380513'
                WHERE ordernumber = 'P200307171520129' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380514'
                WHERE ordernumber = 'P190307172035737' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379397'
                WHERE ordernumber = 'P200307172119705' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '146276'
                WHERE ordernumber = 'P420307172132282' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380515'
                WHERE ordernumber = 'P190307172321556' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380517'
                WHERE ordernumber = 'P590307172717588' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380516'
                WHERE ordernumber = 'P420307172759801' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380518'
                WHERE ordernumber = 'P420307173554414' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239340'
                WHERE ordernumber = 'P200307173711455' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94179'
                WHERE ordernumber = 'P200307174346544' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380519'
                WHERE ordernumber = 'P190307174804165' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347251'
                WHERE ordernumber = 'P190307174933350' 
            
2024-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160054'
                WHERE ordernumber = 'P200307175234392' 
            
2024-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353647'
                WHERE ordernumber = 'P190307175315994' 
            
2024-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380520'
                WHERE ordernumber = 'P420307175348730' 
            
2024-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380522'
                WHERE ordernumber = 'P190307175459478' 
            
2024-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380523'
                WHERE ordernumber = 'P190307175623555' 
            
2024-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350172'
                WHERE ordernumber = 'P190307175755860' 
            
2024-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '106191'
                WHERE ordernumber = 'P190307175842160' 
            
2024-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277788'
                WHERE ordernumber = 'P190307180616327' 
            
2024-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '228942'
                WHERE ordernumber = 'P180307180953153' 
            
2024-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380524'
                WHERE ordernumber = 'P420307181148189' 
            
2024-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349347'
                WHERE ordernumber = 'P200307181418900' 
            
2024-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '141288'
                WHERE ordernumber = 'P200307181827227' 
            
2024-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '115459'
                WHERE ordernumber = 'P200307181958913' 
            
2024-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '74730'
                WHERE ordernumber = 'P420307182101262' 
            
2024-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380527'
                WHERE ordernumber = 'P190307182308723' 
            
2024-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '163740'
                WHERE ordernumber = 'P190307182608760' 
            
2024-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '269153'
                WHERE ordernumber = 'P590307183003615' 
            
2024-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380528'
                WHERE ordernumber = 'P200307183104779' 
            
2024-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380530'
                WHERE ordernumber = 'P190307183558800' 
            
2024-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '211877'
                WHERE ordernumber = 'P190307183700941' 
            
2024-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380260'
                WHERE ordernumber = 'P420307183722375' 
            
2024-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281638'
                WHERE ordernumber = 'P200307183929887' 
            
2024-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380531'
                WHERE ordernumber = 'P200307184207584' 
            
2024-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '368861'
                WHERE ordernumber = 'P420307184209353' 
            
2024-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380532'
                WHERE ordernumber = 'P420307184329444' 
            
2024-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380533'
                WHERE ordernumber = 'P190307184634366' 
            
2024-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304798'
                WHERE ordernumber = 'P190307185223522' 
            
2024-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '79065'
                WHERE ordernumber = 'P590307185418171' 
            
2024-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380462'
                WHERE ordernumber = 'P420307185434363' 
            
2024-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99067'
                WHERE ordernumber = 'P200307190424775' 
            
2024-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114984'
                WHERE ordernumber = 'P190307190615503' 
            
2024-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '334937'
                WHERE ordernumber = 'P420307191345613' 
            
2024-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380535'
                WHERE ordernumber = 'P420307191917313' 
            
2024-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99642'
                WHERE ordernumber = 'P190307192440929' 
            
2024-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380536'
                WHERE ordernumber = 'P200307192900907' 
            
2024-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378411'
                WHERE ordernumber = 'P200307193110759' 
            
2024-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103010'
                WHERE ordernumber = 'P420307193202881' 
            
2024-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '90938'
                WHERE ordernumber = 'P200307193228591' 
            
2024-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '311958'
                WHERE ordernumber = 'P190307193243647' 
            
2024-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380537'
                WHERE ordernumber = 'P200307193324575' 
            
2024-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282434'
                WHERE ordernumber = 'P200307193457202' 
            
2024-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '250334'
                WHERE ordernumber = 'P200307194752869' 
            
2024-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278230'
                WHERE ordernumber = 'P200307195229620'