2024-05-13 01:00:02 -- 將會員中心id寫入data-lake
2024-05-13 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-05-12%';
        
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389629'
                WHERE ordernumber = 'P630512100637588' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389630'
                WHERE ordernumber = 'P630512101502709' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388917'
                WHERE ordernumber = 'P420512103327651' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389632'
                WHERE ordernumber = 'P630512104437305' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389633'
                WHERE ordernumber = 'P630512104543419' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389634'
                WHERE ordernumber = 'P180512110151544' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '298728'
                WHERE ordernumber = 'P180512110539713' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '312854'
                WHERE ordernumber = 'P200512110559262' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389635'
                WHERE ordernumber = 'P180512111025375' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '160964'
                WHERE ordernumber = 'P180512111112391' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '351729'
                WHERE ordernumber = 'P180512111258907' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389636'
                WHERE ordernumber = 'P200512111400267' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '241208'
                WHERE ordernumber = 'P200512111425931' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '241208'
                WHERE ordernumber = 'P200512111549124' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '275673'
                WHERE ordernumber = 'P200512112751179' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389464'
                WHERE ordernumber = 'P200512113056518' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '288303'
                WHERE ordernumber = 'P200512113312864' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '305746'
                WHERE ordernumber = 'P180512113331823' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389638'
                WHERE ordernumber = 'P190512114236512' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389359'
                WHERE ordernumber = 'P190512114428980' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389639'
                WHERE ordernumber = 'P180512114531515' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389640'
                WHERE ordernumber = 'P180512115639982' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389641'
                WHERE ordernumber = 'P180512115822407' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389643'
                WHERE ordernumber = 'P180512121404940' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389644'
                WHERE ordernumber = 'P200512121444223' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389646'
                WHERE ordernumber = 'P420512122044216' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389647'
                WHERE ordernumber = 'P180512122829331' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389648'
                WHERE ordernumber = 'P420512123024430' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389649'
                WHERE ordernumber = 'P180512123214299' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389650'
                WHERE ordernumber = 'P630512123446521' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '230900'
                WHERE ordernumber = 'P180512123507776' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389651'
                WHERE ordernumber = 'P180512123725799' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99430'
                WHERE ordernumber = 'P180512123859312' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '104888'
                WHERE ordernumber = 'P420512124240745' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '264848'
                WHERE ordernumber = 'P180512124624709' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '240810'
                WHERE ordernumber = 'P180512124857717' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '321909'
                WHERE ordernumber = 'P200512125616428' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '321909'
                WHERE ordernumber = 'P200512125717278' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389652'
                WHERE ordernumber = 'P420512130011346' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389654'
                WHERE ordernumber = 'P420512130147409' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389653'
                WHERE ordernumber = 'P790512130815805' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389655'
                WHERE ordernumber = 'P630512130817781' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389653'
                WHERE ordernumber = 'P790512130937588' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '288395'
                WHERE ordernumber = 'P180512131203497' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389656'
                WHERE ordernumber = 'P200512131242518' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283301'
                WHERE ordernumber = 'P190512131353632' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388821'
                WHERE ordernumber = 'P590512131505860' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388409'
                WHERE ordernumber = 'P420512132454674' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '164118'
                WHERE ordernumber = 'P790512132508770' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '383886'
                WHERE ordernumber = 'P420512132648202' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '315506'
                WHERE ordernumber = 'P190512133002312' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287589'
                WHERE ordernumber = 'P790512133024694' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '274916'
                WHERE ordernumber = 'P200512133602782' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389659'
                WHERE ordernumber = 'P180512133802736' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '1299'
                WHERE ordernumber = 'P420512133821479' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389660'
                WHERE ordernumber = 'P420512134016228' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389662'
                WHERE ordernumber = 'P420512134214203' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389663'
                WHERE ordernumber = 'P200512134304713' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382370'
                WHERE ordernumber = 'P180512134407720' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389664'
                WHERE ordernumber = 'P200512134417519' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389666'
                WHERE ordernumber = 'P420512134639319' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389665'
                WHERE ordernumber = 'P180512134703496' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '273094'
                WHERE ordernumber = 'P200512135037735' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '83958'
                WHERE ordernumber = 'P180512135628314' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '292465'
                WHERE ordernumber = 'P790512135643419' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389670'
                WHERE ordernumber = 'P200512135813829' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389667'
                WHERE ordernumber = 'P180512140205290' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389667'
                WHERE ordernumber = 'P180512140300884' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287749'
                WHERE ordernumber = 'P420512140303164' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '351674'
                WHERE ordernumber = 'P200512140457609' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '240423'
                WHERE ordernumber = 'P180512140523758' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349725'
                WHERE ordernumber = 'P190512140650158' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389671'
                WHERE ordernumber = 'P180512141017237' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '351168'
                WHERE ordernumber = 'P200512141617197' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '339040'
                WHERE ordernumber = 'P200512141718843' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389673'
                WHERE ordernumber = 'P180512142149238' 
            
2024-05-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '231898'
                WHERE ordernumber = 'P200512142357514' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307296'
                WHERE ordernumber = 'P790512143655389' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389677'
                WHERE ordernumber = 'P200512143851564' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389678'
                WHERE ordernumber = 'P180512144111323' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389679'
                WHERE ordernumber = 'P630512144228164' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389676'
                WHERE ordernumber = 'P790512144229236' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377382'
                WHERE ordernumber = 'P200512144339759' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389680'
                WHERE ordernumber = 'P420512144345511' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389679'
                WHERE ordernumber = 'P630512144352772' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385507'
                WHERE ordernumber = 'P630512144849439' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389682'
                WHERE ordernumber = 'P190512144856585' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389683'
                WHERE ordernumber = 'P200512145139362' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289921'
                WHERE ordernumber = 'P180512145139322' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228397'
                WHERE ordernumber = 'P180512145834797' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387332'
                WHERE ordernumber = 'P200512145859954' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377470'
                WHERE ordernumber = 'P200512150019892' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359350'
                WHERE ordernumber = 'P200512150133328' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389684'
                WHERE ordernumber = 'P180512150222647' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389685'
                WHERE ordernumber = 'P200512150346464' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389687'
                WHERE ordernumber = 'P200512151246545' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '264004'
                WHERE ordernumber = 'P200512151422327' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389689'
                WHERE ordernumber = 'P180512151601295' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389690'
                WHERE ordernumber = 'P200512151641595' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389688'
                WHERE ordernumber = 'P420512151835451' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379051'
                WHERE ordernumber = 'P420512152005416' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389691'
                WHERE ordernumber = 'P200512152019356' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '95987'
                WHERE ordernumber = 'P200512152126999' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389683'
                WHERE ordernumber = 'P630512152251626' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '216856'
                WHERE ordernumber = 'P200512152301749' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '140470'
                WHERE ordernumber = 'P180512152414656' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388951'
                WHERE ordernumber = 'P420512153536254' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '225685'
                WHERE ordernumber = 'P200512153702847' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389693'
                WHERE ordernumber = 'P420512153816973' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284474'
                WHERE ordernumber = 'P180512154337616' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389695'
                WHERE ordernumber = 'P180512154717419' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235945'
                WHERE ordernumber = 'P180512154938217' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389696'
                WHERE ordernumber = 'P200512155317375' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389697'
                WHERE ordernumber = 'P180512155322822' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '266911'
                WHERE ordernumber = 'P420512155324141' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389698'
                WHERE ordernumber = 'P180512155502768' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389699'
                WHERE ordernumber = 'P420512155644121' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '154610'
                WHERE ordernumber = 'P630512155726136' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389700'
                WHERE ordernumber = 'P180512155802923' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389701'
                WHERE ordernumber = 'P200512155816784' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '233074'
                WHERE ordernumber = 'P200512160213893' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389702'
                WHERE ordernumber = 'P790512160453826' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389703'
                WHERE ordernumber = 'P180512160602463' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389704'
                WHERE ordernumber = 'P180512160809569' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389706'
                WHERE ordernumber = 'P200512161052899' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389705'
                WHERE ordernumber = 'P790512161116928' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389707'
                WHERE ordernumber = 'P420512161121791' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389708'
                WHERE ordernumber = 'P180512161139902' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389709'
                WHERE ordernumber = 'P420512161246428' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381919'
                WHERE ordernumber = 'P200512161436804' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389637'
                WHERE ordernumber = 'P180512161703861' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389710'
                WHERE ordernumber = 'P420512161853575' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389686'
                WHERE ordernumber = 'P630512162001981' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389711'
                WHERE ordernumber = 'P420512162100482' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389712'
                WHERE ordernumber = 'P180512162204791' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389713'
                WHERE ordernumber = 'P180512162655243' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389714'
                WHERE ordernumber = 'P420512162740521' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291481'
                WHERE ordernumber = 'P200512162900472' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382327'
                WHERE ordernumber = 'P420512162941785' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372979'
                WHERE ordernumber = 'P790512163038990' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389716'
                WHERE ordernumber = 'P420512163147112' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389718'
                WHERE ordernumber = 'P630512163834916' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '155210'
                WHERE ordernumber = 'P200512164235880' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389719'
                WHERE ordernumber = 'P200512164355543' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '318216'
                WHERE ordernumber = 'P190512164404545' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '321095'
                WHERE ordernumber = 'P180512164423957' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389720'
                WHERE ordernumber = 'P180512164918195' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352303'
                WHERE ordernumber = 'P420512165043696' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389721'
                WHERE ordernumber = 'P630512165111486' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389722'
                WHERE ordernumber = 'P180512165212505' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '117544'
                WHERE ordernumber = 'P200512165321896' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307366'
                WHERE ordernumber = 'P420512165451981' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '80966'
                WHERE ordernumber = 'P180512165733252' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302614'
                WHERE ordernumber = 'P200512165743784' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389724'
                WHERE ordernumber = 'P200512170056449' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389726'
                WHERE ordernumber = 'P200512170610176' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389668'
                WHERE ordernumber = 'P790512170632300' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389727'
                WHERE ordernumber = 'P200512170755156' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389661'
                WHERE ordernumber = 'P790512170803498' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389729'
                WHERE ordernumber = 'P180512171215269' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389418'
                WHERE ordernumber = 'P180512171342933' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389730'
                WHERE ordernumber = 'P180512171644316' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389731'
                WHERE ordernumber = 'P200512171724952' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313180'
                WHERE ordernumber = 'P420512171738436' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389733'
                WHERE ordernumber = 'P180512172205317' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389734'
                WHERE ordernumber = 'P200512173324488' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94506'
                WHERE ordernumber = 'P180512173627747' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389735'
                WHERE ordernumber = 'P180512174023475' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389736'
                WHERE ordernumber = 'P200512174606894' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389737'
                WHERE ordernumber = 'P180512175245580' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249752'
                WHERE ordernumber = 'P180512175355246' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '324599'
                WHERE ordernumber = 'P180512175858383' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389738'
                WHERE ordernumber = 'P180512180630754' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389739'
                WHERE ordernumber = 'P200512180703554' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389740'
                WHERE ordernumber = 'P180512181546881' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240045'
                WHERE ordernumber = 'P790512182223211' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389741'
                WHERE ordernumber = 'P630512182450673' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287807'
                WHERE ordernumber = 'P200512182605257' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388342'
                WHERE ordernumber = 'P200512182611604' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287807'
                WHERE ordernumber = 'P200512182658309' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389742'
                WHERE ordernumber = 'P630512182723808' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389740'
                WHERE ordernumber = 'P180512182726873' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287807'
                WHERE ordernumber = 'P200512182841441' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389743'
                WHERE ordernumber = 'P630512182846262' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '360338'
                WHERE ordernumber = 'P190512182917468' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389740'
                WHERE ordernumber = 'P180512183128985' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389744'
                WHERE ordernumber = 'P180512183938264' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384808'
                WHERE ordernumber = 'P630512184303669' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389745'
                WHERE ordernumber = 'P200512184305648' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389746'
                WHERE ordernumber = 'P420512184616861' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112841'
                WHERE ordernumber = 'P190512185253389' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389747'
                WHERE ordernumber = 'P790512185403238' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372885'
                WHERE ordernumber = 'P420512185916796' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372885'
                WHERE ordernumber = 'P420512190028264' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '363434'
                WHERE ordernumber = 'P790512190206271' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389748'
                WHERE ordernumber = 'P190512190540436' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '140510'
                WHERE ordernumber = 'P190512190639852' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389749'
                WHERE ordernumber = 'P190512191042708' 
            
2024-05-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389750'
                WHERE ordernumber = 'P190512191916423' 
            
2024-05-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389751'
                WHERE ordernumber = 'P190512192248821' 
            
2024-05-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386512'
                WHERE ordernumber = 'P200512192919267' 
            
2024-05-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '152791'
                WHERE ordernumber = 'P190512193151872' 
            
2024-05-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '166111'
                WHERE ordernumber = 'P630512193251202' 
            
2024-05-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '315314'
                WHERE ordernumber = 'P790512204144633'