2024-05-17 01:00:02 -- 將會員中心id寫入data-lake
2024-05-17 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-16%';
        
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387744'
                WHERE ordernumber = 'P630516105812339' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98810'
                WHERE ordernumber = 'P200516110301941' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353647'
                WHERE ordernumber = 'P180516110412262' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387904'
                WHERE ordernumber = 'P180516110856744' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386309'
                WHERE ordernumber = 'P420516111209772' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390212'
                WHERE ordernumber = 'P630516111238584' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '294559'
                WHERE ordernumber = 'P200516111324277' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390213'
                WHERE ordernumber = 'P180516112553167' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389786'
                WHERE ordernumber = 'P180516113010194' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248308'
                WHERE ordernumber = 'P200516113102628' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390214'
                WHERE ordernumber = 'P180516114029511' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379450'
                WHERE ordernumber = 'P200516114727496' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386721'
                WHERE ordernumber = 'P180516114800658' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390216'
                WHERE ordernumber = 'P180516115150874' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390217'
                WHERE ordernumber = 'P200516115503821' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245566'
                WHERE ordernumber = 'P190516120903918' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298003'
                WHERE ordernumber = 'P180516120906218' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390220'
                WHERE ordernumber = 'P200516121204449' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390221'
                WHERE ordernumber = 'P200516121446486' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366205'
                WHERE ordernumber = 'P630516121603768' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '317251'
                WHERE ordernumber = 'P200516121919847' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285548'
                WHERE ordernumber = 'P200516122004252' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180516122508629' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390223'
                WHERE ordernumber = 'P200516122719513' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390225'
                WHERE ordernumber = 'P420516123757776' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346680'
                WHERE ordernumber = 'P180516123908703' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271831'
                WHERE ordernumber = 'P200516124403300' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '143625'
                WHERE ordernumber = 'P180516124506232' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382565'
                WHERE ordernumber = 'P180516124640675' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390229'
                WHERE ordernumber = 'P200516125148911' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390047'
                WHERE ordernumber = 'P200516130108569' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390230'
                WHERE ordernumber = 'P200516130221399' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101732'
                WHERE ordernumber = 'P180516130706510' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240864'
                WHERE ordernumber = 'P200516131018416' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365094'
                WHERE ordernumber = 'P200516131140835' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390232'
                WHERE ordernumber = 'P790516131433577' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '151148'
                WHERE ordernumber = 'P200516131449327' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390234'
                WHERE ordernumber = 'P180516131606367' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '137430'
                WHERE ordernumber = 'P200516131643844' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275455'
                WHERE ordernumber = 'P180516132507440' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390235'
                WHERE ordernumber = 'P180516133050311' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '206534'
                WHERE ordernumber = 'P180516133805586' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353814'
                WHERE ordernumber = 'P420516134140482' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390237'
                WHERE ordernumber = 'P180516134149130' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390238'
                WHERE ordernumber = 'P180516134256754' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301837'
                WHERE ordernumber = 'P420516134516539' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '140097'
                WHERE ordernumber = 'P200516134705179' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390240'
                WHERE ordernumber = 'P420516134713867' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334987'
                WHERE ordernumber = 'P420516134749640' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390242'
                WHERE ordernumber = 'P200516134918617' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390243'
                WHERE ordernumber = 'P790516135143137' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380036'
                WHERE ordernumber = 'P180516135700221' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390245'
                WHERE ordernumber = 'P180516140702947' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100465'
                WHERE ordernumber = 'P200516140726809' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390246'
                WHERE ordernumber = 'P630516141133280' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390246'
                WHERE ordernumber = 'P630516141147847' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '132677'
                WHERE ordernumber = 'P200516141241914' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380504'
                WHERE ordernumber = 'P180516141448563' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390247'
                WHERE ordernumber = 'P200516141832370' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '9064'
                WHERE ordernumber = 'P200516141957317' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '9064'
                WHERE ordernumber = 'P200516142308967' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390247'
                WHERE ordernumber = 'P200516142400161' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '42469'
                WHERE ordernumber = 'P790516142733514' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390249'
                WHERE ordernumber = 'P630516143157124' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '88988'
                WHERE ordernumber = 'P420516143657812' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '88988'
                WHERE ordernumber = 'P420516144004457' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390251'
                WHERE ordernumber = 'P200516144030706' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381344'
                WHERE ordernumber = 'P180516144047539' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383945'
                WHERE ordernumber = 'P180516144641594' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342339'
                WHERE ordernumber = 'P420516144742156' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366850'
                WHERE ordernumber = 'P420516144911966' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390253'
                WHERE ordernumber = 'P180516145143556' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390254'
                WHERE ordernumber = 'P200516145239569' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390252'
                WHERE ordernumber = 'P790516145322114' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390124'
                WHERE ordernumber = 'P180516145543305' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381285'
                WHERE ordernumber = 'P180516145741752' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '231105'
                WHERE ordernumber = 'P190516150025450' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390256'
                WHERE ordernumber = 'P790516150801721' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390257'
                WHERE ordernumber = 'P420516151033995' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390258'
                WHERE ordernumber = 'P630516151606912' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344726'
                WHERE ordernumber = 'P180516151939633' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390260'
                WHERE ordernumber = 'P190516152022530' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374206'
                WHERE ordernumber = 'P420516152302303' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275274'
                WHERE ordernumber = 'P180516152704767' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384158'
                WHERE ordernumber = 'P420516153642402' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304863'
                WHERE ordernumber = 'P200516153906897' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390264'
                WHERE ordernumber = 'P420516154138800' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390265'
                WHERE ordernumber = 'P790516154218323' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347016'
                WHERE ordernumber = 'P180516154406361' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387086'
                WHERE ordernumber = 'P630516155537331' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389294'
                WHERE ordernumber = 'P200516155538936' 
            
2024-05-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305271'
                WHERE ordernumber = 'P180516155541604' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '292220'
                WHERE ordernumber = 'P200516155644506' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390269'
                WHERE ordernumber = 'P420516155851325' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390270'
                WHERE ordernumber = 'P200516160457566' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390272'
                WHERE ordernumber = 'P420516161008690' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '262592'
                WHERE ordernumber = 'P200516161157309' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '243696'
                WHERE ordernumber = 'P190516161746701' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343835'
                WHERE ordernumber = 'P420516161819124' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390274'
                WHERE ordernumber = 'P180516161924210' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '336070'
                WHERE ordernumber = 'P180516162335405' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390276'
                WHERE ordernumber = 'P180516162902860' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390277'
                WHERE ordernumber = 'P200516162954849' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276379'
                WHERE ordernumber = 'P180516163003256' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390278'
                WHERE ordernumber = 'P420516163151558' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388712'
                WHERE ordernumber = 'P180516163225881' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390279'
                WHERE ordernumber = 'P420516163454926' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390280'
                WHERE ordernumber = 'P420516163553410' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '229745'
                WHERE ordernumber = 'P200516163645952' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390281'
                WHERE ordernumber = 'P180516163738439' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '229745'
                WHERE ordernumber = 'P200516163917962' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390284'
                WHERE ordernumber = 'P630516164102438' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '323661'
                WHERE ordernumber = 'P180516164133404' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '161325'
                WHERE ordernumber = 'P190516164137515' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344749'
                WHERE ordernumber = 'P420516164317930' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390286'
                WHERE ordernumber = 'P630516165819649' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387917'
                WHERE ordernumber = 'P180516165915138' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388208'
                WHERE ordernumber = 'P200516170004934' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '311758'
                WHERE ordernumber = 'P180516170731515' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390287'
                WHERE ordernumber = 'P790516172459226' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '216942'
                WHERE ordernumber = 'P180516173053450' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '265694'
                WHERE ordernumber = 'P630516173214996' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '107945'
                WHERE ordernumber = 'P200516173611980' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353531'
                WHERE ordernumber = 'P190516173713601' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390290'
                WHERE ordernumber = 'P190516173957762' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390291'
                WHERE ordernumber = 'P190516174119150' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '72480'
                WHERE ordernumber = 'P180516174250457' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390292'
                WHERE ordernumber = 'P420516174412831' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390293'
                WHERE ordernumber = 'P200516175155302' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '129909'
                WHERE ordernumber = 'P180516175207570' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384418'
                WHERE ordernumber = 'P180516175708686' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '260426'
                WHERE ordernumber = 'P200516180316975' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '105373'
                WHERE ordernumber = 'P180516180709274' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390295'
                WHERE ordernumber = 'P180516181015747' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390295'
                WHERE ordernumber = 'P180516181131868' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357888'
                WHERE ordernumber = 'P420516181219941' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '338789'
                WHERE ordernumber = 'P200516181233962' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390296'
                WHERE ordernumber = 'P630516181822301' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390297'
                WHERE ordernumber = 'P790516181842966' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '274998'
                WHERE ordernumber = 'P180516181921528' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390299'
                WHERE ordernumber = 'P420516182021657' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382621'
                WHERE ordernumber = 'P200516182047218' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390298'
                WHERE ordernumber = 'P790516182134993' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381664'
                WHERE ordernumber = 'P180516182143506' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390300'
                WHERE ordernumber = 'P190516182200808' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '303973'
                WHERE ordernumber = 'P200516182432867' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390195'
                WHERE ordernumber = 'P180516182845926' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390195'
                WHERE ordernumber = 'P180516182926423' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390303'
                WHERE ordernumber = 'P180516183034631' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390302'
                WHERE ordernumber = 'P200516183646455' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305950'
                WHERE ordernumber = 'P200516184020396' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '73826'
                WHERE ordernumber = 'P630516184330149' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390305'
                WHERE ordernumber = 'P200516184857411' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '29379'
                WHERE ordernumber = 'P200516184959151' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '294659'
                WHERE ordernumber = 'P630516185026115' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386795'
                WHERE ordernumber = 'P200516185033835' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94815'
                WHERE ordernumber = 'P200516185421481' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390306'
                WHERE ordernumber = 'P200516185525676' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100537'
                WHERE ordernumber = 'P790516185615123' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '364203'
                WHERE ordernumber = 'P190516190158785' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390307'
                WHERE ordernumber = 'P420516190352534' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390308'
                WHERE ordernumber = 'P200516190434239' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114907'
                WHERE ordernumber = 'P190516190818229' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390310'
                WHERE ordernumber = 'P420516191144487' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '286713'
                WHERE ordernumber = 'P190516191208891' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390311'
                WHERE ordernumber = 'P190516191440353' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340540'
                WHERE ordernumber = 'P190516192311891' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347910'
                WHERE ordernumber = 'P420516192516271' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '222852'
                WHERE ordernumber = 'P200516193120518' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390315'
                WHERE ordernumber = 'P190516193423881' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390315'
                WHERE ordernumber = 'P190516193509937' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '139402'
                WHERE ordernumber = 'P200516193618265' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388638'
                WHERE ordernumber = 'P200516193914982' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390317'
                WHERE ordernumber = 'P190516194803753' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390317'
                WHERE ordernumber = 'P190516194841207' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390318'
                WHERE ordernumber = 'P190516194934816' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347214'
                WHERE ordernumber = 'P190516195623362' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347214'
                WHERE ordernumber = 'P190516195747753' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '242243'
                WHERE ordernumber = 'P190516200017645' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390321'
                WHERE ordernumber = 'P790516200728598' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390322'
                WHERE ordernumber = 'P790516203127672' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390325'
                WHERE ordernumber = 'P790516205233387' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390326'
                WHERE ordernumber = 'P790516210642397' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '376810'
                WHERE ordernumber = 'P790516212132316' 
            
2024-05-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '215957'
                WHERE ordernumber = 'P790516212524345'