2023-12-13 01:00:03 -- 將會員中心id寫入data-lake
2023-12-13 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-12%';
        
2023-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248386'
                WHERE ordernumber = 'P201212110337780' 
            
2023-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351988'
                WHERE ordernumber = 'P201212110429593' 
            
2023-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351989'
                WHERE ordernumber = 'P201212110632490' 
            
2023-12-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162397'
                WHERE ordernumber = 'P181212110707730' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '320844'
                WHERE ordernumber = 'P191212110728214' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '139543'
                WHERE ordernumber = 'P201212110907248' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '139543'
                WHERE ordernumber = 'P201212110946244' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348779'
                WHERE ordernumber = 'P191212111010793' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351989'
                WHERE ordernumber = 'P201212111116428' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '132450'
                WHERE ordernumber = 'P201212111321534' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '137446'
                WHERE ordernumber = 'P421212111332769' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '231706'
                WHERE ordernumber = 'P181212111433576' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '172599'
                WHERE ordernumber = 'P181212111535956' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350028'
                WHERE ordernumber = 'P201212111645597' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351995'
                WHERE ordernumber = 'P181212111703971' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '112794'
                WHERE ordernumber = 'P201212111810802' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351997'
                WHERE ordernumber = 'P201212112046897' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351998'
                WHERE ordernumber = 'P181212112104640' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310921'
                WHERE ordernumber = 'P181212112248751' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351999'
                WHERE ordernumber = 'P181212112604802' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349708'
                WHERE ordernumber = 'P201212112815259' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352000'
                WHERE ordernumber = 'P181212113217776' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352001'
                WHERE ordernumber = 'P181212113312299' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '221743'
                WHERE ordernumber = 'P181212115108624' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282746'
                WHERE ordernumber = 'P181212115527226' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '214738'
                WHERE ordernumber = 'P181212120608357' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '214738'
                WHERE ordernumber = 'P181212120805855' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '214738'
                WHERE ordernumber = 'P181212121005781' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352006'
                WHERE ordernumber = 'P201212121145525' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352007'
                WHERE ordernumber = 'P201212121545313' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '341667'
                WHERE ordernumber = 'P421212121715449' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352008'
                WHERE ordernumber = 'P201212121802432' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '303745'
                WHERE ordernumber = 'P201212121949987' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '303745'
                WHERE ordernumber = 'P201212122103144' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352010'
                WHERE ordernumber = 'P421212122114989' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352011'
                WHERE ordernumber = 'P191212122201812' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352012'
                WHERE ordernumber = 'P191212122314939' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352013'
                WHERE ordernumber = 'P191212122450915' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344074'
                WHERE ordernumber = 'P181212122451929' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313717'
                WHERE ordernumber = 'P421212123113537' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94236'
                WHERE ordernumber = 'P201212123116877' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '160250'
                WHERE ordernumber = 'P201212123254643' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '318452'
                WHERE ordernumber = 'P201212123658846' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352014'
                WHERE ordernumber = 'P191212123924785' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297798'
                WHERE ordernumber = 'P421212124524517' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102207'
                WHERE ordernumber = 'P201212124925980' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '174924'
                WHERE ordernumber = 'P181212125545833' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352017'
                WHERE ordernumber = 'P191212125826525' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342900'
                WHERE ordernumber = 'P191212125940272' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '239096'
                WHERE ordernumber = 'P201212130046684' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352018'
                WHERE ordernumber = 'P181212130137656' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352020'
                WHERE ordernumber = 'P191212132143382' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348733'
                WHERE ordernumber = 'P181212132421500' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352021'
                WHERE ordernumber = 'P201212132808253' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351030'
                WHERE ordernumber = 'P201212133031151' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352022'
                WHERE ordernumber = 'P201212133253370' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '168988'
                WHERE ordernumber = 'P181212133319792' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '279385'
                WHERE ordernumber = 'P201212133758166' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '143531'
                WHERE ordernumber = 'P201212134243363' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352026'
                WHERE ordernumber = 'P181212134553491' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352027'
                WHERE ordernumber = 'P181212134926892' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '177234'
                WHERE ordernumber = 'P201212135324363' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347601'
                WHERE ordernumber = 'P201212135706775' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350981'
                WHERE ordernumber = 'P421212140107667' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '255594'
                WHERE ordernumber = 'P181212140207803' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352030'
                WHERE ordernumber = 'P181212140649506' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352032'
                WHERE ordernumber = 'P201212141516258' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281250'
                WHERE ordernumber = 'P181212141729622' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352033'
                WHERE ordernumber = 'P201212141819231' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352034'
                WHERE ordernumber = 'P201212141952694' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352035'
                WHERE ordernumber = 'P181212142131344' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352037'
                WHERE ordernumber = 'P201212142430188' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352039'
                WHERE ordernumber = 'P191212142722811' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '208559'
                WHERE ordernumber = 'P191212143203596' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '182156'
                WHERE ordernumber = 'P201212143652910' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '168534'
                WHERE ordernumber = 'P421212143839733' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351321'
                WHERE ordernumber = 'P201212143951715' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352040'
                WHERE ordernumber = 'P181212144535855' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352041'
                WHERE ordernumber = 'P181212144715674' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350032'
                WHERE ordernumber = 'P181212144808147' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352042'
                WHERE ordernumber = 'P181212144906229' 
            
2023-12-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '249648'
                WHERE ordernumber = 'P201212145341319' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352043'
                WHERE ordernumber = 'P181212145441588' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '127195'
                WHERE ordernumber = 'P181212145832243' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352044'
                WHERE ordernumber = 'P201212145944471' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352046'
                WHERE ordernumber = 'P181212150041810' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352047'
                WHERE ordernumber = 'P181212150152911' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352048'
                WHERE ordernumber = 'P181212150329207' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352045'
                WHERE ordernumber = 'P181212150437245' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352045'
                WHERE ordernumber = 'P181212150507317' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '275701'
                WHERE ordernumber = 'P181212151314716' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '237408'
                WHERE ordernumber = 'P201212151604974' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '291495'
                WHERE ordernumber = 'P201212151704896' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352052'
                WHERE ordernumber = 'P421212152105838' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '230224'
                WHERE ordernumber = 'P201212153244388' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '343460'
                WHERE ordernumber = 'P181212153643988' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352058'
                WHERE ordernumber = 'P201212154852294' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '347830'
                WHERE ordernumber = 'P421212154936403' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '304095'
                WHERE ordernumber = 'P181212155359677' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '71982'
                WHERE ordernumber = 'P181212155501793' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352060'
                WHERE ordernumber = 'P181212155608387' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352058'
                WHERE ordernumber = 'P201212155646407' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '144076'
                WHERE ordernumber = 'P181212155722625' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352062'
                WHERE ordernumber = 'P181212155909577' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352063'
                WHERE ordernumber = 'P191212155947432' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '317049'
                WHERE ordernumber = 'P201212160117362' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '299906'
                WHERE ordernumber = 'P421212160242252' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '245603'
                WHERE ordernumber = 'P201212160339582' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '38077'
                WHERE ordernumber = 'P201212160512350' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352034'
                WHERE ordernumber = 'P201212160633391' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '38077'
                WHERE ordernumber = 'P201212160714477' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352069'
                WHERE ordernumber = 'P181212161753701' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352068'
                WHERE ordernumber = 'P181212161906970' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '340830'
                WHERE ordernumber = 'P181212162143280' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '100716'
                WHERE ordernumber = 'P201212162220389' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352070'
                WHERE ordernumber = 'P181212162430886' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352074'
                WHERE ordernumber = 'P201212162634447' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352073'
                WHERE ordernumber = 'P181212162701789' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352075'
                WHERE ordernumber = 'P181212162758788' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352076'
                WHERE ordernumber = 'P201212163445342' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352077'
                WHERE ordernumber = 'P181212163627513' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '285240'
                WHERE ordernumber = 'P181212163752881' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352079'
                WHERE ordernumber = 'P421212164053340' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352080'
                WHERE ordernumber = 'P201212164804648' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '219261'
                WHERE ordernumber = 'P201212165435820' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '24223'
                WHERE ordernumber = 'P191212165436472' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352083'
                WHERE ordernumber = 'P181212165535125' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352084'
                WHERE ordernumber = 'P181212165836407' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '341121'
                WHERE ordernumber = 'P201212170021627' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352085'
                WHERE ordernumber = 'P181212170416198' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352086'
                WHERE ordernumber = 'P181212170516556' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '276353'
                WHERE ordernumber = 'P201212170654119' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352087'
                WHERE ordernumber = 'P181212170746580' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '342180'
                WHERE ordernumber = 'P201212170834666' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '342473'
                WHERE ordernumber = 'P201212171053885' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352088'
                WHERE ordernumber = 'P181212171112177' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '277324'
                WHERE ordernumber = 'P201212171245204' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352089'
                WHERE ordernumber = 'P421212171345511' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352090'
                WHERE ordernumber = 'P181212172121875' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352091'
                WHERE ordernumber = 'P181212172319395' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349574'
                WHERE ordernumber = 'P181212172831906' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '341930'
                WHERE ordernumber = 'P421212173032506' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '343981'
                WHERE ordernumber = 'P201212173201509' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352092'
                WHERE ordernumber = 'P181212173542998' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '232568'
                WHERE ordernumber = 'P181212173857207' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '90873'
                WHERE ordernumber = 'P421212174327442' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '250562'
                WHERE ordernumber = 'P181212174420277' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '305288'
                WHERE ordernumber = 'P191212174755407' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352094'
                WHERE ordernumber = 'P201212174827448' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352096'
                WHERE ordernumber = 'P181212175021436' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352095'
                WHERE ordernumber = 'P201212175034931' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352097'
                WHERE ordernumber = 'P181212175133187' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352095'
                WHERE ordernumber = 'P201212175148618' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352098'
                WHERE ordernumber = 'P181212175311322' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '101890'
                WHERE ordernumber = 'P181212175709461' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '120889'
                WHERE ordernumber = 'P181212175849151' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349299'
                WHERE ordernumber = 'P181212180053283' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '159522'
                WHERE ordernumber = 'P201212180228150' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '231119'
                WHERE ordernumber = 'P421212180549744' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '169376'
                WHERE ordernumber = 'P181212180905491' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352100'
                WHERE ordernumber = 'P181212181157443' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352102'
                WHERE ordernumber = 'P181212181437149' 
            
2023-12-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352103'
                WHERE ordernumber = 'P201212181542216' 
            
2023-12-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352104'
                WHERE ordernumber = 'P201212182016761' 
            
2023-12-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '130987'
                WHERE ordernumber = 'P181212182043792' 
            
2023-12-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352105'
                WHERE ordernumber = 'P191212182423960' 
            
2023-12-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '284422'
                WHERE ordernumber = 'P201212182738761' 
            
2023-12-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '108234'
                WHERE ordernumber = 'P201212183130671' 
            
2023-12-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352107'
                WHERE ordernumber = 'P201212183428659' 
            
2023-12-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352109'
                WHERE ordernumber = 'P201212183726269' 
            
2023-12-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '297415'
                WHERE ordernumber = 'P421212183736225' 
            
2023-12-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '282020'
                WHERE ordernumber = 'P191212184109617' 
            
2023-12-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352111'
                WHERE ordernumber = 'P201212184411860' 
            
2023-12-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '278786'
                WHERE ordernumber = 'P191212184619989' 
            
2023-12-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '240087'
                WHERE ordernumber = 'P421212185021152' 
            
2023-12-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '337144'
                WHERE ordernumber = 'P191212185100475' 
            
2023-12-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '292710'
                WHERE ordernumber = 'P201212185548178' 
            
2023-12-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352113'
                WHERE ordernumber = 'P421212185700752' 
            
2023-12-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352113'
                WHERE ordernumber = 'P421212190159309' 
            
2023-12-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '319102'
                WHERE ordernumber = 'P191212190300462' 
            
2023-12-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352114'
                WHERE ordernumber = 'P191212191235562' 
            
2023-12-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '142206'
                WHERE ordernumber = 'P191212191357150' 
            
2023-12-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352117'
                WHERE ordernumber = 'P201212191718328' 
            
2023-12-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '340824'
                WHERE ordernumber = 'P201212191809654' 
            
2023-12-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '166831'
                WHERE ordernumber = 'P201212192407429' 
            
2023-12-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '270284'
                WHERE ordernumber = 'P201212192621809' 
            
2023-12-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352120'
                WHERE ordernumber = 'P191212192915883' 
            
2023-12-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352122'
                WHERE ordernumber = 'P421212193113225' 
            
2023-12-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352123'
                WHERE ordernumber = 'P201212193125935' 
            
2023-12-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '324342'
                WHERE ordernumber = 'P191212193207775' 
            
2023-12-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '344166'
                WHERE ordernumber = 'P191212193341668' 
            
2023-12-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352124'
                WHERE ordernumber = 'P191212193728425' 
            
2023-12-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '319273'
                WHERE ordernumber = 'P201212194415443' 
            
2023-12-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352125'
                WHERE ordernumber = 'P191212194550530' 
            
2023-12-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '344334'
                WHERE ordernumber = 'P201212194601712' 
            
2023-12-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '320967'
                WHERE ordernumber = 'P191212194646782' 
            
2023-12-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '119761'
                WHERE ordernumber = 'P201212195127860' 
            
2023-12-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '110839'
                WHERE ordernumber = 'P201212195242996' 
            
2023-12-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '153380'
                WHERE ordernumber = 'P191212195705884' 
            
2023-12-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '153380'
                WHERE ordernumber = 'P191212200013614' 
            
2023-12-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '339111'
                WHERE ordernumber = 'P201212200658810' 
            
2023-12-13 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352130'
                WHERE ordernumber = 'P421212200855199'