2023-12-07 01:00:03 -- 將會員中心id寫入data-lake
2023-12-07 01:00:03 -- 
            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 '2023-12-06%';
        
2023-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214193'
                WHERE ordernumber = 'P191206110226460' 
            
2023-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278844'
                WHERE ordernumber = 'P181206110406907' 
            
2023-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307186'
                WHERE ordernumber = 'P181206110520237' 
            
2023-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '255002'
                WHERE ordernumber = 'P181206111639206' 
            
2023-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350975'
                WHERE ordernumber = 'P181206112246199' 
            
2023-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160171'
                WHERE ordernumber = 'P181206113141790' 
            
2023-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '217480'
                WHERE ordernumber = 'P181206113846423' 
            
2023-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350976'
                WHERE ordernumber = 'P201206114009228' 
            
2023-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350977'
                WHERE ordernumber = 'P181206114145166' 
            
2023-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '168182'
                WHERE ordernumber = 'P191206114200996' 
            
2023-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350979'
                WHERE ordernumber = 'P201206114230414' 
            
2023-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '172291'
                WHERE ordernumber = 'P181206114259603' 
            
2023-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347464'
                WHERE ordernumber = 'P191206114401686' 
            
2023-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350980'
                WHERE ordernumber = 'P181206114434595' 
            
2023-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '172291'
                WHERE ordernumber = 'P181206114807596' 
            
2023-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350978'
                WHERE ordernumber = 'P201206115114213' 
            
2023-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237028'
                WHERE ordernumber = 'P201206115156605' 
            
2023-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '159216'
                WHERE ordernumber = 'P181206115700944' 
            
2023-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93882'
                WHERE ordernumber = 'P421206121159298' 
            
2023-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350986'
                WHERE ordernumber = 'P201206121235696' 
            
2023-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350985'
                WHERE ordernumber = 'P191206121251228' 
            
2023-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P201206121513303' 
            
2023-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350987'
                WHERE ordernumber = 'P201206121705926' 
            
2023-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350989'
                WHERE ordernumber = 'P191206121802911' 
            
2023-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350993'
                WHERE ordernumber = 'P181206122418436' 
            
2023-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297787'
                WHERE ordernumber = 'P181206123105496' 
            
2023-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350995'
                WHERE ordernumber = 'P201206123549667' 
            
2023-12-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '290185'
                WHERE ordernumber = 'P421206123920461' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103924'
                WHERE ordernumber = 'P201206124037432' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350998'
                WHERE ordernumber = 'P181206124142894' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350997'
                WHERE ordernumber = 'P181206124349933' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '90674'
                WHERE ordernumber = 'P191206124902473' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230586'
                WHERE ordernumber = 'P181206125225394' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '74778'
                WHERE ordernumber = 'P201206125241615' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '241330'
                WHERE ordernumber = 'P201206125806622' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351002'
                WHERE ordernumber = 'P201206130259481' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '268471'
                WHERE ordernumber = 'P201206130623431' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '268471'
                WHERE ordernumber = 'P201206130715811' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '6905'
                WHERE ordernumber = 'P181206130930592' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351004'
                WHERE ordernumber = 'P201206132833748' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '247581'
                WHERE ordernumber = 'P191206132857841' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351005'
                WHERE ordernumber = 'P201206132958537' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '142953'
                WHERE ordernumber = 'P181206134610259' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351008'
                WHERE ordernumber = 'P181206135235980' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351010'
                WHERE ordernumber = 'P421206135512742' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '168092'
                WHERE ordernumber = 'P181206135950883' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '124807'
                WHERE ordernumber = 'P181206140454195' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351013'
                WHERE ordernumber = 'P201206141329814' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351014'
                WHERE ordernumber = 'P201206141840821' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351015'
                WHERE ordernumber = 'P201206142029771' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351016'
                WHERE ordernumber = 'P181206142055986' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351017'
                WHERE ordernumber = 'P181206142239434' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '285644'
                WHERE ordernumber = 'P201206142313825' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351019'
                WHERE ordernumber = 'P181206142413745' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100925'
                WHERE ordernumber = 'P201206142438463' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351018'
                WHERE ordernumber = 'P201206142523939' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '311532'
                WHERE ordernumber = 'P181206142631712' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351020'
                WHERE ordernumber = 'P181206142924206' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351021'
                WHERE ordernumber = 'P201206143040479' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351022'
                WHERE ordernumber = 'P201206143503634' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351025'
                WHERE ordernumber = 'P181206144115646' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351028'
                WHERE ordernumber = 'P181206144501650' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350107'
                WHERE ordernumber = 'P421206144633741' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351030'
                WHERE ordernumber = 'P201206144908645' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '296542'
                WHERE ordernumber = 'P181206145232149' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '233881'
                WHERE ordernumber = 'P181206145432571' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351032'
                WHERE ordernumber = 'P181206145651269' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351034'
                WHERE ordernumber = 'P201206150137886' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '225480'
                WHERE ordernumber = 'P201206151151817' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351035'
                WHERE ordernumber = 'P181206151244894' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351036'
                WHERE ordernumber = 'P191206151335830' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P181206151519144' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '268147'
                WHERE ordernumber = 'P201206151709503' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '144274'
                WHERE ordernumber = 'P201206152007622' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351037'
                WHERE ordernumber = 'P181206152042753' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351038'
                WHERE ordernumber = 'P181206152228325' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351039'
                WHERE ordernumber = 'P181206152420185' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '332020'
                WHERE ordernumber = 'P421206152446505' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337285'
                WHERE ordernumber = 'P421206152802120' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351040'
                WHERE ordernumber = 'P181206152929393' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351041'
                WHERE ordernumber = 'P421206153143250' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100465'
                WHERE ordernumber = 'P201206153155834' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345732'
                WHERE ordernumber = 'P201206153335141' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343585'
                WHERE ordernumber = 'P191206153432469' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351043'
                WHERE ordernumber = 'P181206154200487' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351043'
                WHERE ordernumber = 'P181206154306480' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '36620'
                WHERE ordernumber = 'P191206154457293' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350989'
                WHERE ordernumber = 'P181206154521389' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351044'
                WHERE ordernumber = 'P201206154836250' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351046'
                WHERE ordernumber = 'P181206154849730' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '124768'
                WHERE ordernumber = 'P201206155005365' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351047'
                WHERE ordernumber = 'P181206155152427' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350555'
                WHERE ordernumber = 'P191206155247237' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351048'
                WHERE ordernumber = 'P201206155950904' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349072'
                WHERE ordernumber = 'P201206160639781' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351049'
                WHERE ordernumber = 'P201206161249116' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351050'
                WHERE ordernumber = 'P181206161515895' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342876'
                WHERE ordernumber = 'P181206161737345' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351051'
                WHERE ordernumber = 'P181206162146235' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '147682'
                WHERE ordernumber = 'P181206162551536' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351052'
                WHERE ordernumber = 'P201206162600150' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351053'
                WHERE ordernumber = 'P201206163757694' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275250'
                WHERE ordernumber = 'P201206164122772' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351054'
                WHERE ordernumber = 'P181206164314729' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '78616'
                WHERE ordernumber = 'P201206164918876' 
            
2023-12-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '296749'
                WHERE ordernumber = 'P421206164932905' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '347465'
                WHERE ordernumber = 'P181206165044745' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351057'
                WHERE ordernumber = 'P181206165242870' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351058'
                WHERE ordernumber = 'P181206170324699' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351059'
                WHERE ordernumber = 'P181206172416720' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '308099'
                WHERE ordernumber = 'P181206172614298' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '327917'
                WHERE ordernumber = 'P201206173007631' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351061'
                WHERE ordernumber = 'P181206173213325' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351060'
                WHERE ordernumber = 'P201206173306756' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '269154'
                WHERE ordernumber = 'P181206173713567' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351062'
                WHERE ordernumber = 'P181206173943337' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351063'
                WHERE ordernumber = 'P181206174124662' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351065'
                WHERE ordernumber = 'P181206174227520' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '123697'
                WHERE ordernumber = 'P181206174306702' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351066'
                WHERE ordernumber = 'P421206174705582' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '245227'
                WHERE ordernumber = 'P181206174804392' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '245227'
                WHERE ordernumber = 'P181206174846505' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '245227'
                WHERE ordernumber = 'P181206174931231' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '245227'
                WHERE ordernumber = 'P181206175021926' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351067'
                WHERE ordernumber = 'P181206175437192' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351068'
                WHERE ordernumber = 'P191206175654770' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351068'
                WHERE ordernumber = 'P191206175738544' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '110093'
                WHERE ordernumber = 'P201206180110888' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '110093'
                WHERE ordernumber = 'P201206180302210' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351070'
                WHERE ordernumber = 'P421206180645193' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '245138'
                WHERE ordernumber = 'P181206180927205' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '135457'
                WHERE ordernumber = 'P201206181039452' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '156998'
                WHERE ordernumber = 'P181206181836564' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '346291'
                WHERE ordernumber = 'P191206182457617' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '130125'
                WHERE ordernumber = 'P181206183018979' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351073'
                WHERE ordernumber = 'P191206183038519' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351075'
                WHERE ordernumber = 'P201206183143252' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351074'
                WHERE ordernumber = 'P421206183156770' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351076'
                WHERE ordernumber = 'P181206183355240' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351076'
                WHERE ordernumber = 'P181206183433316' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351077'
                WHERE ordernumber = 'P201206183611580' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351078'
                WHERE ordernumber = 'P201206183747456' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351080'
                WHERE ordernumber = 'P421206183917785' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '161853'
                WHERE ordernumber = 'P181206184714189' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '161853'
                WHERE ordernumber = 'P191206184949478' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '339068'
                WHERE ordernumber = 'P421206185805941' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351083'
                WHERE ordernumber = 'P191206190051399' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351083'
                WHERE ordernumber = 'P191206190144576' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351084'
                WHERE ordernumber = 'P201206190345957' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351085'
                WHERE ordernumber = 'P191206190403456' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351073'
                WHERE ordernumber = 'P191206190448298' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351086'
                WHERE ordernumber = 'P201206190651514' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '342089'
                WHERE ordernumber = 'P201206191305993' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351087'
                WHERE ordernumber = 'P201206191511665' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '348658'
                WHERE ordernumber = 'P191206191918217' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '227945'
                WHERE ordernumber = 'P191206192138161' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351088'
                WHERE ordernumber = 'P201206192520899' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351089'
                WHERE ordernumber = 'P191206192609581' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '226971'
                WHERE ordernumber = 'P191206193019388' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '226971'
                WHERE ordernumber = 'P191206193124554' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351091'
                WHERE ordernumber = 'P201206193125489' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '245566'
                WHERE ordernumber = 'P191206193738304' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351056'
                WHERE ordernumber = 'P191206193831268' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '217038'
                WHERE ordernumber = 'P201206194618273' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351092'
                WHERE ordernumber = 'P191206194733357' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351093'
                WHERE ordernumber = 'P201206195107273' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351095'
                WHERE ordernumber = 'P191206195239560' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351094'
                WHERE ordernumber = 'P421206195301844' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '102207'
                WHERE ordernumber = 'P201206195416686' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '1592'
                WHERE ordernumber = 'P191206195550671' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351097'
                WHERE ordernumber = 'P191206195732645' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '293872'
                WHERE ordernumber = 'P191206195924767' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '289885'
                WHERE ordernumber = 'P191206200009522' 
            
2023-12-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351098'
                WHERE ordernumber = 'P191206200306981'