2023-12-19 01:00:03 -- 將會員中心id寫入data-lake
2023-12-19 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-18%';
        
2023-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '246075'
                WHERE ordernumber = 'P181218110105501' 
            
2023-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353233'
                WHERE ordernumber = 'P181218110204380' 
            
2023-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348520'
                WHERE ordernumber = 'P201218110337968' 
            
2023-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353237'
                WHERE ordernumber = 'P181218110828518' 
            
2023-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353237'
                WHERE ordernumber = 'P181218110913808' 
            
2023-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353238'
                WHERE ordernumber = 'P201218111206153' 
            
2023-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '254265'
                WHERE ordernumber = 'P181218111242202' 
            
2023-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353239'
                WHERE ordernumber = 'P201218111417639' 
            
2023-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353241'
                WHERE ordernumber = 'P181218111431225' 
            
2023-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '95514'
                WHERE ordernumber = 'P181218111601202' 
            
2023-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353242'
                WHERE ordernumber = 'P191218111604785' 
            
2023-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315457'
                WHERE ordernumber = 'P181218111730702' 
            
2023-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353244'
                WHERE ordernumber = 'P201218111809791' 
            
2023-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305497'
                WHERE ordernumber = 'P181218111950724' 
            
2023-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '327300'
                WHERE ordernumber = 'P201218112145802' 
            
2023-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353245'
                WHERE ordernumber = 'P181218112415896' 
            
2023-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '111604'
                WHERE ordernumber = 'P201218112825685' 
            
2023-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '114174'
                WHERE ordernumber = 'P181218112906904' 
            
2023-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353249'
                WHERE ordernumber = 'P181218113251965' 
            
2023-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353250'
                WHERE ordernumber = 'P181218113506153' 
            
2023-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353252'
                WHERE ordernumber = 'P181218113634630' 
            
2023-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '325237'
                WHERE ordernumber = 'P201218113849956' 
            
2023-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315096'
                WHERE ordernumber = 'P201218114131875' 
            
2023-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353253'
                WHERE ordernumber = 'P201218114240293' 
            
2023-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '293690'
                WHERE ordernumber = 'P181218114600619' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353254'
                WHERE ordernumber = 'P181218114725687' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353255'
                WHERE ordernumber = 'P191218114737245' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '289746'
                WHERE ordernumber = 'P191218114834820' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353256'
                WHERE ordernumber = 'P421218115120713' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353257'
                WHERE ordernumber = 'P181218115458991' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '142190'
                WHERE ordernumber = 'P181218115611365' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353258'
                WHERE ordernumber = 'P181218115721443' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P181218115817661' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353259'
                WHERE ordernumber = 'P181218115909995' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97109'
                WHERE ordernumber = 'P181218120035629' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '132450'
                WHERE ordernumber = 'P201218120323896' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '211556'
                WHERE ordernumber = 'P181218120537112' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353261'
                WHERE ordernumber = 'P201218121442994' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '93821'
                WHERE ordernumber = 'P181218121457641' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '271209'
                WHERE ordernumber = 'P201218121613497' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '142184'
                WHERE ordernumber = 'P191218121857492' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '119332'
                WHERE ordernumber = 'P181218122006828' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97952'
                WHERE ordernumber = 'P201218122052201' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353263'
                WHERE ordernumber = 'P201218122239337' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352563'
                WHERE ordernumber = 'P201218122559129' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '112057'
                WHERE ordernumber = 'P181218123212843' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '257642'
                WHERE ordernumber = 'P181218123326981' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '148275'
                WHERE ordernumber = 'P181218123427826' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353267'
                WHERE ordernumber = 'P191218124240414' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352254'
                WHERE ordernumber = 'P201218124421817' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353268'
                WHERE ordernumber = 'P191218124429341' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352254'
                WHERE ordernumber = 'P201218124453712' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304119'
                WHERE ordernumber = 'P191218124535598' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353269'
                WHERE ordernumber = 'P421218124637532' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277769'
                WHERE ordernumber = 'P201218124733113' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '116084'
                WHERE ordernumber = 'P181218124934805' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299656'
                WHERE ordernumber = 'P421218125025633' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343622'
                WHERE ordernumber = 'P191218125217583' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343622'
                WHERE ordernumber = 'P191218125300802' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353270'
                WHERE ordernumber = 'P421218125541705' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353271'
                WHERE ordernumber = 'P181218125556351' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353272'
                WHERE ordernumber = 'P421218125647339' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304815'
                WHERE ordernumber = 'P181218125840808' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353271'
                WHERE ordernumber = 'P181218130027182' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '327431'
                WHERE ordernumber = 'P201218130216279' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353276'
                WHERE ordernumber = 'P421218130749468' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97468'
                WHERE ordernumber = 'P201218130753244' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '221989'
                WHERE ordernumber = 'P201218131227831' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353277'
                WHERE ordernumber = 'P421218131456517' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '250265'
                WHERE ordernumber = 'P201218132149339' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '93775'
                WHERE ordernumber = 'P201218132251660' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337747'
                WHERE ordernumber = 'P421218132322166' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353280'
                WHERE ordernumber = 'P201218132457379' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '117015'
                WHERE ordernumber = 'P181218132532502' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '41498'
                WHERE ordernumber = 'P201218132939577' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351825'
                WHERE ordernumber = 'P181218133026802' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353282'
                WHERE ordernumber = 'P201218133048941' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '309980'
                WHERE ordernumber = 'P181218133419550' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '309980'
                WHERE ordernumber = 'P181218133858838' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '322456'
                WHERE ordernumber = 'P201218133903955' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353285'
                WHERE ordernumber = 'P181218134224542' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353288'
                WHERE ordernumber = 'P181218135132489' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '243770'
                WHERE ordernumber = 'P181218135253419' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353289'
                WHERE ordernumber = 'P181218135351789' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102055'
                WHERE ordernumber = 'P201218135824810' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281642'
                WHERE ordernumber = 'P181218140234804' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353291'
                WHERE ordernumber = 'P201218140238404' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353292'
                WHERE ordernumber = 'P421218140903432' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '258529'
                WHERE ordernumber = 'P201218140913659' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353293'
                WHERE ordernumber = 'P181218140939668' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353295'
                WHERE ordernumber = 'P181218141400593' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353296'
                WHERE ordernumber = 'P421218141545994' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344347'
                WHERE ordernumber = 'P181218141659349' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '130003'
                WHERE ordernumber = 'P201218141830379' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '298961'
                WHERE ordernumber = 'P181218141831478' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '133740'
                WHERE ordernumber = 'P201218141929450' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '256428'
                WHERE ordernumber = 'P181218142239615' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342467'
                WHERE ordernumber = 'P421218142349308' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353299'
                WHERE ordernumber = 'P181218142356861' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277892'
                WHERE ordernumber = 'P181218142512693' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '232968'
                WHERE ordernumber = 'P201218143030521' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '265465'
                WHERE ordernumber = 'P201218143344726' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237303'
                WHERE ordernumber = 'P181218143449630' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353301'
                WHERE ordernumber = 'P201218143611917' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '266373'
                WHERE ordernumber = 'P201218144208159' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353304'
                WHERE ordernumber = 'P201218144407684' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '265465'
                WHERE ordernumber = 'P201218144503280' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353305'
                WHERE ordernumber = 'P181218144512942' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353306'
                WHERE ordernumber = 'P181218144757839' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299086'
                WHERE ordernumber = 'P181218144919161' 
            
2023-12-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353308'
                WHERE ordernumber = 'P421218145337594' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353309'
                WHERE ordernumber = 'P181218145711758' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353310'
                WHERE ordernumber = 'P181218145844934' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353311'
                WHERE ordernumber = 'P181218145959367' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '313746'
                WHERE ordernumber = 'P421218151120256' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353315'
                WHERE ordernumber = 'P201218152458600' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353316'
                WHERE ordernumber = 'P201218152645499' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353317'
                WHERE ordernumber = 'P201218152744283' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353319'
                WHERE ordernumber = 'P181218153006889' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '131983'
                WHERE ordernumber = 'P181218153109863' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353320'
                WHERE ordernumber = 'P201218153303528' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '255157'
                WHERE ordernumber = 'P201218153354622' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353321'
                WHERE ordernumber = 'P201218153630153' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '111127'
                WHERE ordernumber = 'P181218153914858' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '239086'
                WHERE ordernumber = 'P201218153922378' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '84215'
                WHERE ordernumber = 'P181218154436641' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353322'
                WHERE ordernumber = 'P181218154623142' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '264650'
                WHERE ordernumber = 'P181218154717341' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353323'
                WHERE ordernumber = 'P181218155056258' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '249382'
                WHERE ordernumber = 'P201218155246712' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '143999'
                WHERE ordernumber = 'P201218155344967' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '182156'
                WHERE ordernumber = 'P201218155837344' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353324'
                WHERE ordernumber = 'P181218155916205' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353325'
                WHERE ordernumber = 'P191218160010615' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353326'
                WHERE ordernumber = 'P181218160309544' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353329'
                WHERE ordernumber = 'P181218161032659' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '319053'
                WHERE ordernumber = 'P181218161259848' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '116854'
                WHERE ordernumber = 'P201218162012283' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353330'
                WHERE ordernumber = 'P181218162055388' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '96658'
                WHERE ordernumber = 'P421218162426180' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353332'
                WHERE ordernumber = 'P181218163019542' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '116366'
                WHERE ordernumber = 'P201218163126368' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353333'
                WHERE ordernumber = 'P181218163316632' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '267811'
                WHERE ordernumber = 'P201218164216380' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '336197'
                WHERE ordernumber = 'P181218164740342' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353336'
                WHERE ordernumber = 'P201218164924648' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '339522'
                WHERE ordernumber = 'P201218165216118' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '296856'
                WHERE ordernumber = 'P421218165358983' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '234101'
                WHERE ordernumber = 'P201218165811694' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '312876'
                WHERE ordernumber = 'P421218170002450' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '208071'
                WHERE ordernumber = 'P181218171106147' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352594'
                WHERE ordernumber = 'P201218171248748' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '254829'
                WHERE ordernumber = 'P181218171612916' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '344720'
                WHERE ordernumber = 'P421218172142275' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350897'
                WHERE ordernumber = 'P201218172504647' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '344720'
                WHERE ordernumber = 'P421218172522148' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353341'
                WHERE ordernumber = 'P201218173011340' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353342'
                WHERE ordernumber = 'P201218173056521' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353343'
                WHERE ordernumber = 'P201218173558403' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353345'
                WHERE ordernumber = 'P201218174528407' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '224338'
                WHERE ordernumber = 'P181218174554931' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '304793'
                WHERE ordernumber = 'P181218174928507' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '143799'
                WHERE ordernumber = 'P181218175211574' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '293235'
                WHERE ordernumber = 'P181218175639667' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '346291'
                WHERE ordernumber = 'P181218175752227' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '140488'
                WHERE ordernumber = 'P181218175932886' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '100163'
                WHERE ordernumber = 'P181218180214120' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '82567'
                WHERE ordernumber = 'P201218180712354' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '169376'
                WHERE ordernumber = 'P191218181243563' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '320967'
                WHERE ordernumber = 'P191218181446920' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353349'
                WHERE ordernumber = 'P181218181508370' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353350'
                WHERE ordernumber = 'P201218182027123' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '172875'
                WHERE ordernumber = 'P191218182246832' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353351'
                WHERE ordernumber = 'P201218182458572' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353353'
                WHERE ordernumber = 'P421218183447797' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353354'
                WHERE ordernumber = 'P181218183813394' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353355'
                WHERE ordernumber = 'P181218184625142' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353357'
                WHERE ordernumber = 'P201218185137773' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '254860'
                WHERE ordernumber = 'P421218185200596' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '333176'
                WHERE ordernumber = 'P201218185239387' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353359'
                WHERE ordernumber = 'P421218185329704' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '348476'
                WHERE ordernumber = 'P421218185613823' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353361'
                WHERE ordernumber = 'P191218190054997' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '342252'
                WHERE ordernumber = 'P191218190128601' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '104530'
                WHERE ordernumber = 'P201218190701215' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353353'
                WHERE ordernumber = 'P421218190954550' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '95353'
                WHERE ordernumber = 'P191218191225179' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '347616'
                WHERE ordernumber = 'P191218191341609' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '259835'
                WHERE ordernumber = 'P191218191456543' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '139849'
                WHERE ordernumber = 'P191218191902701' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '133035'
                WHERE ordernumber = 'P191218192305124' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '330705'
                WHERE ordernumber = 'P421218193010717' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '265522'
                WHERE ordernumber = 'P191218193205112' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352722'
                WHERE ordernumber = 'P201218193840569' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352722'
                WHERE ordernumber = 'P201218193908671' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '269473'
                WHERE ordernumber = 'P201218194208478' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353364'
                WHERE ordernumber = 'P191218194219763' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '311951'
                WHERE ordernumber = 'P201218194301326' 
            
2023-12-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '325352'
                WHERE ordernumber = 'P201218194341728' 
            
2023-12-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '264519'
                WHERE ordernumber = 'P191218195522490' 
            
2023-12-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '217975'
                WHERE ordernumber = 'P201218195526123' 
            
2023-12-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '217975'
                WHERE ordernumber = 'P201218195613950'