2023-12-01 01:00:02 -- 將會員中心id寫入data-lake
2023-12-01 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 '2023-11-30%';
        
2023-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '297128'
                WHERE ordernumber = 'P201130110357704' 
            
2023-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '243843'
                WHERE ordernumber = 'P191130110448874' 
            
2023-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '313744'
                WHERE ordernumber = 'P421130110530820' 
            
2023-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349982'
                WHERE ordernumber = 'P181130110603786' 
            
2023-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349983'
                WHERE ordernumber = 'P181130111018458' 
            
2023-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249719'
                WHERE ordernumber = 'P191130111037809' 
            
2023-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P201130111215916' 
            
2023-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349985'
                WHERE ordernumber = 'P191130111257582' 
            
2023-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349986'
                WHERE ordernumber = 'P181130111601640' 
            
2023-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349987'
                WHERE ordernumber = 'P191130111616915' 
            
2023-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '164144'
                WHERE ordernumber = 'P181130111716370' 
            
2023-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349989'
                WHERE ordernumber = 'P191130111743648' 
            
2023-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349988'
                WHERE ordernumber = 'P421130111837890' 
            
2023-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '202358'
                WHERE ordernumber = 'P181130112434887' 
            
2023-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '288772'
                WHERE ordernumber = 'P191130112548697' 
            
2023-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349991'
                WHERE ordernumber = 'P181130112618488' 
            
2023-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '214528'
                WHERE ordernumber = 'P191130112635562' 
            
2023-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349992'
                WHERE ordernumber = 'P181130112813431' 
            
2023-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349993'
                WHERE ordernumber = 'P201130113521178' 
            
2023-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349994'
                WHERE ordernumber = 'P201130113815179' 
            
2023-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '275564'
                WHERE ordernumber = 'P181130113840780' 
            
2023-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349995'
                WHERE ordernumber = 'P201130114017214' 
            
2023-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349997'
                WHERE ordernumber = 'P201130114238869' 
            
2023-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '97019'
                WHERE ordernumber = 'P191130114547723' 
            
2023-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349998'
                WHERE ordernumber = 'P181130114714799' 
            
2023-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350000'
                WHERE ordernumber = 'P191130114803804' 
            
2023-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350001'
                WHERE ordernumber = 'P201130114914432' 
            
2023-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350002'
                WHERE ordernumber = 'P201130115411346' 
            
2023-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350003'
                WHERE ordernumber = 'P181130120754235' 
            
2023-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350004'
                WHERE ordernumber = 'P201130121205806' 
            
2023-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99993'
                WHERE ordernumber = 'P201130121519968' 
            
2023-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '293448'
                WHERE ordernumber = 'P191130121710676' 
            
2023-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '312753'
                WHERE ordernumber = 'P181130122012427' 
            
2023-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P191130122025908' 
            
2023-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '295570'
                WHERE ordernumber = 'P201130122040842' 
            
2023-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350005'
                WHERE ordernumber = 'P201130122636819' 
            
2023-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '284779'
                WHERE ordernumber = 'P201130122925658' 
            
2023-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350006'
                WHERE ordernumber = 'P181130123048437' 
            
2023-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '281549'
                WHERE ordernumber = 'P181130123559374' 
            
2023-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350007'
                WHERE ordernumber = 'P191130123858932' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350009'
                WHERE ordernumber = 'P201130124332163' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338908'
                WHERE ordernumber = 'P181130124446444' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299101'
                WHERE ordernumber = 'P191130124544713' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350010'
                WHERE ordernumber = 'P201130124938283' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350011'
                WHERE ordernumber = 'P181130124940414' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350012'
                WHERE ordernumber = 'P191130125114127' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275133'
                WHERE ordernumber = 'P201130125606256' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350014'
                WHERE ordernumber = 'P201130125827930' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350015'
                WHERE ordernumber = 'P201130130027475' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350016'
                WHERE ordernumber = 'P181130130144116' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350017'
                WHERE ordernumber = 'P181130130416538' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350014'
                WHERE ordernumber = 'P201130130521230' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350018'
                WHERE ordernumber = 'P191130130603556' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350019'
                WHERE ordernumber = 'P181130130720142' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350020'
                WHERE ordernumber = 'P191130130750272' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '88344'
                WHERE ordernumber = 'P181130130851448' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '263989'
                WHERE ordernumber = 'P181130131259915' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344391'
                WHERE ordernumber = 'P191130131443164' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347636'
                WHERE ordernumber = 'P201130131452128' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '168433'
                WHERE ordernumber = 'P191130132244326' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350024'
                WHERE ordernumber = 'P421130132648735' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350025'
                WHERE ordernumber = 'P191130132659280' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '163742'
                WHERE ordernumber = 'P201130133129468' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '136084'
                WHERE ordernumber = 'P201130133501837' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '232171'
                WHERE ordernumber = 'P191130133712214' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '259850'
                WHERE ordernumber = 'P191130133916654' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276826'
                WHERE ordernumber = 'P191130134013834' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '221743'
                WHERE ordernumber = 'P181130134104959' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350026'
                WHERE ordernumber = 'P191130134511999' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286011'
                WHERE ordernumber = 'P201130134550604' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347630'
                WHERE ordernumber = 'P421130134603425' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275450'
                WHERE ordernumber = 'P181130135258827' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350027'
                WHERE ordernumber = 'P201130135716934' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350027'
                WHERE ordernumber = 'P201130140020794' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350028'
                WHERE ordernumber = 'P201130140423530' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350030'
                WHERE ordernumber = 'P201130140635433' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350031'
                WHERE ordernumber = 'P181130140637589' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350032'
                WHERE ordernumber = 'P191130140810557' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '220038'
                WHERE ordernumber = 'P201130140920313' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350033'
                WHERE ordernumber = 'P181130141009365' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350034'
                WHERE ordernumber = 'P181130141136552' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '217982'
                WHERE ordernumber = 'P191130141658728' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350035'
                WHERE ordernumber = 'P181130141758670' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347354'
                WHERE ordernumber = 'P191130142335749' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347354'
                WHERE ordernumber = 'P191130142353362' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '232879'
                WHERE ordernumber = 'P201130142359186' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350013'
                WHERE ordernumber = 'P201130142508542' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350036'
                WHERE ordernumber = 'P201130142735438' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348905'
                WHERE ordernumber = 'P201130144011682' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348779'
                WHERE ordernumber = 'P181130144449560' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350038'
                WHERE ordernumber = 'P421130144901602' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350039'
                WHERE ordernumber = 'P181130145252138' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350042'
                WHERE ordernumber = 'P181130145815181' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '105667'
                WHERE ordernumber = 'P181130150506451' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '68264'
                WHERE ordernumber = 'P181130150613535' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349966'
                WHERE ordernumber = 'P201130150652213' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350043'
                WHERE ordernumber = 'P201130150950687' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350044'
                WHERE ordernumber = 'P201130151136708' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349966'
                WHERE ordernumber = 'P201130151251379' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349966'
                WHERE ordernumber = 'P201130151806123' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '142615'
                WHERE ordernumber = 'P201130151844643' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101878'
                WHERE ordernumber = 'P191130152151378' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '135594'
                WHERE ordernumber = 'P201130152159239' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '211729'
                WHERE ordernumber = 'P181130152607637' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350047'
                WHERE ordernumber = 'P181130153606345' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350048'
                WHERE ordernumber = 'P201130153622998' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '109908'
                WHERE ordernumber = 'P181130153937596' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350051'
                WHERE ordernumber = 'P421130154050282' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242842'
                WHERE ordernumber = 'P201130154414818' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347889'
                WHERE ordernumber = 'P181130154734448' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350052'
                WHERE ordernumber = 'P191130155325664' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '223891'
                WHERE ordernumber = 'P191130155954301' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '267295'
                WHERE ordernumber = 'P181130160108470' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350054'
                WHERE ordernumber = 'P181130160256784' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348933'
                WHERE ordernumber = 'P201130160327341' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '110046'
                WHERE ordernumber = 'P201130160616628' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118585'
                WHERE ordernumber = 'P181130160713777' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102238'
                WHERE ordernumber = 'P201130161526310' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346573'
                WHERE ordernumber = 'P181130161536630' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282420'
                WHERE ordernumber = 'P421130161647529' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271982'
                WHERE ordernumber = 'P181130162110816' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350056'
                WHERE ordernumber = 'P201130162154445' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350057'
                WHERE ordernumber = 'P181130162428807' 
            
2023-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350058'
                WHERE ordernumber = 'P181130162940646' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '211379'
                WHERE ordernumber = 'P191130163057407' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350059'
                WHERE ordernumber = 'P191130163400484' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350061'
                WHERE ordernumber = 'P201130163621437' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350062'
                WHERE ordernumber = 'P191130163707322' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350060'
                WHERE ordernumber = 'P421130163744206' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350062'
                WHERE ordernumber = 'P191130164027642' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '109535'
                WHERE ordernumber = 'P181130164321122' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '124608'
                WHERE ordernumber = 'P181130164424482' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350064'
                WHERE ordernumber = 'P191130164432406' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278210'
                WHERE ordernumber = 'P201130165150285' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342271'
                WHERE ordernumber = 'P181130170125547' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98384'
                WHERE ordernumber = 'P181130171246980' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350070'
                WHERE ordernumber = 'P191130171720509' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347520'
                WHERE ordernumber = 'P181130172008959' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '309611'
                WHERE ordernumber = 'P201130172107311' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230683'
                WHERE ordernumber = 'P421130172309452' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '76607'
                WHERE ordernumber = 'P181130172447801' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350071'
                WHERE ordernumber = 'P201130172502654' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337093'
                WHERE ordernumber = 'P181130172616785' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350072'
                WHERE ordernumber = 'P201130173018823' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342022'
                WHERE ordernumber = 'P181130173140111' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81680'
                WHERE ordernumber = 'P181130173326825' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350072'
                WHERE ordernumber = 'P201130173434775' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337808'
                WHERE ordernumber = 'P181130173525657' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '327939'
                WHERE ordernumber = 'P421130175217472' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310091'
                WHERE ordernumber = 'P201130175557932' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349347'
                WHERE ordernumber = 'P201130175716522' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350076'
                WHERE ordernumber = 'P201130175843624' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '253152'
                WHERE ordernumber = 'P191130175851270' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350077'
                WHERE ordernumber = 'P191130180521774' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350079'
                WHERE ordernumber = 'P181130181840731' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349801'
                WHERE ordernumber = 'P181130182136772' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349801'
                WHERE ordernumber = 'P181130182202209' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346291'
                WHERE ordernumber = 'P191130182335970' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350081'
                WHERE ordernumber = 'P181130182349538' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350082'
                WHERE ordernumber = 'P191130182953266' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350083'
                WHERE ordernumber = 'P421130183519132' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350085'
                WHERE ordernumber = 'P191130183524399' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350086'
                WHERE ordernumber = 'P191130184205596' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350087'
                WHERE ordernumber = 'P191130185259625' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '39606'
                WHERE ordernumber = 'P191130185443619' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345060'
                WHERE ordernumber = 'P201130190247978' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348772'
                WHERE ordernumber = 'P191130191558381' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350089'
                WHERE ordernumber = 'P191130192129163' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345670'
                WHERE ordernumber = 'P191130192431824' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345670'
                WHERE ordernumber = 'P191130192512773' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '324941'
                WHERE ordernumber = 'P421130192517854' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350091'
                WHERE ordernumber = 'P191130192819525' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94067'
                WHERE ordernumber = 'P191130193238424' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350092'
                WHERE ordernumber = 'P201130193732386' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '249478'
                WHERE ordernumber = 'P191130193833874' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350095'
                WHERE ordernumber = 'P201130193926697' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350096'
                WHERE ordernumber = 'P191130193950584' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345628'
                WHERE ordernumber = 'P201130194145344' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350097'
                WHERE ordernumber = 'P191130194522159' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '111022'
                WHERE ordernumber = 'P191130194706828' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '216597'
                WHERE ordernumber = 'P191130194804945' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287818'
                WHERE ordernumber = 'P191130195011986' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '266600'
                WHERE ordernumber = 'P191130195135956' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350098'
                WHERE ordernumber = 'P201130195257628' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347941'
                WHERE ordernumber = 'P201130195533301' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350100'
                WHERE ordernumber = 'P191130195719498' 
            
2023-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '329340'
                WHERE ordernumber = 'P201130195741581'