2023-12-14 01:00:03 -- 將會員中心id寫入data-lake
2023-12-14 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-13%';
        
2023-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343835'
                WHERE ordernumber = 'P431213110339696' 
            
2023-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352169'
                WHERE ordernumber = 'P201213110432340' 
            
2023-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352171'
                WHERE ordernumber = 'P181213110827834' 
            
2023-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315196'
                WHERE ordernumber = 'P431213110925914' 
            
2023-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352173'
                WHERE ordernumber = 'P181213111723814' 
            
2023-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '129353'
                WHERE ordernumber = 'P181213112017347' 
            
2023-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '218840'
                WHERE ordernumber = 'P181213112140645' 
            
2023-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '63093'
                WHERE ordernumber = 'P201213112243615' 
            
2023-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352165'
                WHERE ordernumber = 'P181213112408636' 
            
2023-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282636'
                WHERE ordernumber = 'P191213112413605' 
            
2023-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352165'
                WHERE ordernumber = 'P181213112501807' 
            
2023-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315119'
                WHERE ordernumber = 'P201213112549365' 
            
2023-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352175'
                WHERE ordernumber = 'P191213112608498' 
            
2023-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352176'
                WHERE ordernumber = 'P181213112638850' 
            
2023-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '268194'
                WHERE ordernumber = 'P201213113028427' 
            
2023-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297128'
                WHERE ordernumber = 'P201213113713457' 
            
2023-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352180'
                WHERE ordernumber = 'P181213114950665' 
            
2023-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '232256'
                WHERE ordernumber = 'P181213115021841' 
            
2023-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352181'
                WHERE ordernumber = 'P181213115154203' 
            
2023-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352182'
                WHERE ordernumber = 'P201213115905500' 
            
2023-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96664'
                WHERE ordernumber = 'P201213120517977' 
            
2023-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352189'
                WHERE ordernumber = 'P421213122121671' 
            
2023-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352187'
                WHERE ordernumber = 'P201213122158848' 
            
2023-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352189'
                WHERE ordernumber = 'P421213122232465' 
            
2023-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352190'
                WHERE ordernumber = 'P421213122456508' 
            
2023-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352191'
                WHERE ordernumber = 'P201213122651377' 
            
2023-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '274533'
                WHERE ordernumber = 'P181213122710261' 
            
2023-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94242'
                WHERE ordernumber = 'P201213122854584' 
            
2023-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '142919'
                WHERE ordernumber = 'P201213124221841' 
            
2023-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '270830'
                WHERE ordernumber = 'P201213124309560' 
            
2023-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '233858'
                WHERE ordernumber = 'P201213124648384' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '145770'
                WHERE ordernumber = 'P201213124734183' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313744'
                WHERE ordernumber = 'P421213124747216' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '331792'
                WHERE ordernumber = 'P201213125041342' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352192'
                WHERE ordernumber = 'P421213125056501' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '246001'
                WHERE ordernumber = 'P201213125341353' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '235940'
                WHERE ordernumber = 'P181213125456573' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '327313'
                WHERE ordernumber = 'P421213125704958' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '74778'
                WHERE ordernumber = 'P201213125712977' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352193'
                WHERE ordernumber = 'P181213125757375' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '129741'
                WHERE ordernumber = 'P181213125948356' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245128'
                WHERE ordernumber = 'P201213130121332' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342026'
                WHERE ordernumber = 'P181213130300794' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342026'
                WHERE ordernumber = 'P181213130438503' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342026'
                WHERE ordernumber = 'P181213130531953' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '241711'
                WHERE ordernumber = 'P181213130813960' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '154270'
                WHERE ordernumber = 'P201213130844613' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '311836'
                WHERE ordernumber = 'P421213130848844' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352197'
                WHERE ordernumber = 'P181213130931161' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '126005'
                WHERE ordernumber = 'P201213130947547' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352199'
                WHERE ordernumber = 'P201213131049592' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '298853'
                WHERE ordernumber = 'P181213131244179' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97293'
                WHERE ordernumber = 'P421213131840412' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352200'
                WHERE ordernumber = 'P181213132002713' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '211099'
                WHERE ordernumber = 'P201213132050320' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '211099'
                WHERE ordernumber = 'P201213132129547' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313283'
                WHERE ordernumber = 'P201213132239213' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310685'
                WHERE ordernumber = 'P181213132254927' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '229335'
                WHERE ordernumber = 'P181213132405906' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '32399'
                WHERE ordernumber = 'P181213132453328' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352201'
                WHERE ordernumber = 'P181213132639910' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352205'
                WHERE ordernumber = 'P201213133450160' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '336967'
                WHERE ordernumber = 'P181213133548586' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277781'
                WHERE ordernumber = 'P181213133647589' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352208'
                WHERE ordernumber = 'P181213133851175' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '206266'
                WHERE ordernumber = 'P201213134609790' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100896'
                WHERE ordernumber = 'P181213135025633' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '242982'
                WHERE ordernumber = 'P201213135154279' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352211'
                WHERE ordernumber = 'P181213135202257' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352212'
                WHERE ordernumber = 'P421213135301965' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345773'
                WHERE ordernumber = 'P181213135419719' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352213'
                WHERE ordernumber = 'P201213135704177' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275450'
                WHERE ordernumber = 'P181213140551541' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '66860'
                WHERE ordernumber = 'P181213141029739' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275581'
                WHERE ordernumber = 'P201213141351140' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352216'
                WHERE ordernumber = 'P201213143227204' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '138293'
                WHERE ordernumber = 'P181213143558578' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347511'
                WHERE ordernumber = 'P201213143830743' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '162853'
                WHERE ordernumber = 'P201213144115257' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352220'
                WHERE ordernumber = 'P181213144117454' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301943'
                WHERE ordernumber = 'P201213144215365' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '247309'
                WHERE ordernumber = 'P181213144959196' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '241324'
                WHERE ordernumber = 'P181213145154859' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '294636'
                WHERE ordernumber = 'P421213145207541' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352224'
                WHERE ordernumber = 'P431213145217345' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352224'
                WHERE ordernumber = 'P431213145308902' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278799'
                WHERE ordernumber = 'P181213145337351' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '319383'
                WHERE ordernumber = 'P181213145428671' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277888'
                WHERE ordernumber = 'P181213145535777' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345404'
                WHERE ordernumber = 'P201213145547901' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352226'
                WHERE ordernumber = 'P181213145942384' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352228'
                WHERE ordernumber = 'P201213150414584' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352229'
                WHERE ordernumber = 'P201213150531833' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '261512'
                WHERE ordernumber = 'P181213150557193' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '161314'
                WHERE ordernumber = 'P201213150920114' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352230'
                WHERE ordernumber = 'P201213151022877' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352231'
                WHERE ordernumber = 'P181213151126784' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352232'
                WHERE ordernumber = 'P201213151852984' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346682'
                WHERE ordernumber = 'P181213152252158' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346682'
                WHERE ordernumber = 'P181213152619975' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '298977'
                WHERE ordernumber = 'P181213152728615' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343585'
                WHERE ordernumber = 'P181213153148726' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '258503'
                WHERE ordernumber = 'P201213153150527' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352233'
                WHERE ordernumber = 'P181213153549528' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '295449'
                WHERE ordernumber = 'P181213153820591' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '208650'
                WHERE ordernumber = 'P181213154835859' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '147670'
                WHERE ordernumber = 'P181213155135501' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '208650'
                WHERE ordernumber = 'P181213155358910' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352236'
                WHERE ordernumber = 'P181213155655575' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352224'
                WHERE ordernumber = 'P421213160201952' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '242226'
                WHERE ordernumber = 'P201213161021530' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275999'
                WHERE ordernumber = 'P181213161532414' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96915'
                WHERE ordernumber = 'P181213162529451' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '139085'
                WHERE ordernumber = 'P201213162829216' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '243782'
                WHERE ordernumber = 'P201213162935933' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284189'
                WHERE ordernumber = 'P181213163138674' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352089'
                WHERE ordernumber = 'P421213163207492' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352242'
                WHERE ordernumber = 'P181213163629131' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '294829'
                WHERE ordernumber = 'P201213163759788' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '289001'
                WHERE ordernumber = 'P201213163854791' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '258955'
                WHERE ordernumber = 'P201213164035279' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '116809'
                WHERE ordernumber = 'P181213164109251' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352243'
                WHERE ordernumber = 'P421213164305120' 
            
2023-12-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '6376'
                WHERE ordernumber = 'P181213164356457' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '116809'
                WHERE ordernumber = 'P181213164429290' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352244'
                WHERE ordernumber = 'P421213164458719' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '266126'
                WHERE ordernumber = 'P181213164544351' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352247'
                WHERE ordernumber = 'P181213165101130' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '280630'
                WHERE ordernumber = 'P181213165435525' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '160441'
                WHERE ordernumber = 'P201213165552797' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '309537'
                WHERE ordernumber = 'P181213165825659' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352249'
                WHERE ordernumber = 'P181213165946592' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352249'
                WHERE ordernumber = 'P181213170052746' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352250'
                WHERE ordernumber = 'P201213170340268' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '345493'
                WHERE ordernumber = 'P421213170644224' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '249382'
                WHERE ordernumber = 'P201213170801843' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351049'
                WHERE ordernumber = 'P201213171104111' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352253'
                WHERE ordernumber = 'P181213171124277' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352252'
                WHERE ordernumber = 'P181213171233989' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352254'
                WHERE ordernumber = 'P201213171258557' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352252'
                WHERE ordernumber = 'P181213171304392' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352254'
                WHERE ordernumber = 'P201213171340553' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352255'
                WHERE ordernumber = 'P201213171431917' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '211555'
                WHERE ordernumber = 'P181213171710197' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '211555'
                WHERE ordernumber = 'P181213171806245' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '212324'
                WHERE ordernumber = 'P201213172019753' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352257'
                WHERE ordernumber = 'P201213172351984' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '136062'
                WHERE ordernumber = 'P181213172501845' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352258'
                WHERE ordernumber = 'P201213172647837' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352259'
                WHERE ordernumber = 'P181213172719184' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '131655'
                WHERE ordernumber = 'P181213172840731' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352260'
                WHERE ordernumber = 'P201213172956837' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352261'
                WHERE ordernumber = 'P181213173142259' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '346661'
                WHERE ordernumber = 'P201213173209772' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '313336'
                WHERE ordernumber = 'P181213173435893' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352262'
                WHERE ordernumber = 'P181213173641803' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350141'
                WHERE ordernumber = 'P191213174214560' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350141'
                WHERE ordernumber = 'P191213174300380' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352263'
                WHERE ordernumber = 'P181213174326190' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '348643'
                WHERE ordernumber = 'P201213174340763' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '341067'
                WHERE ordernumber = 'P181213174517999' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352264'
                WHERE ordernumber = 'P421213174649273' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351359'
                WHERE ordernumber = 'P421213174743752' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352265'
                WHERE ordernumber = 'P201213174744561' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '76095'
                WHERE ordernumber = 'P181213174824607' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '150533'
                WHERE ordernumber = 'P181213175214683' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '284168'
                WHERE ordernumber = 'P181213175346322' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '166843'
                WHERE ordernumber = 'P201213175429909' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '237032'
                WHERE ordernumber = 'P181213175434754' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '166843'
                WHERE ordernumber = 'P201213175523660' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '219276'
                WHERE ordernumber = 'P181213180028632' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '310479'
                WHERE ordernumber = 'P181213180122734' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '320721'
                WHERE ordernumber = 'P421213180721149' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '295857'
                WHERE ordernumber = 'P201213180918781' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '348564'
                WHERE ordernumber = 'P421213181151626' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352269'
                WHERE ordernumber = 'P201213181242413' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '348564'
                WHERE ordernumber = 'P421213181308397' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352272'
                WHERE ordernumber = 'P181213181634976' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '346291'
                WHERE ordernumber = 'P181213182141370' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '102179'
                WHERE ordernumber = 'P201213182432391' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352274'
                WHERE ordernumber = 'P201213182612299' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352275'
                WHERE ordernumber = 'P181213182646246' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352276'
                WHERE ordernumber = 'P201213183027982' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352277'
                WHERE ordernumber = 'P181213183059796' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352279'
                WHERE ordernumber = 'P181213183348596' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352280'
                WHERE ordernumber = 'P181213183553181' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P181213183631701' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352282'
                WHERE ordernumber = 'P181213183748753' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352283'
                WHERE ordernumber = 'P191213183816591' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '249488'
                WHERE ordernumber = 'P181213183822236' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '270890'
                WHERE ordernumber = 'P191213184016128' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '148994'
                WHERE ordernumber = 'P181213184031129' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '96676'
                WHERE ordernumber = 'P201213184048247' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '319552'
                WHERE ordernumber = 'P181213184114272' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '313332'
                WHERE ordernumber = 'P201213184624742' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352287'
                WHERE ordernumber = 'P181213185106117' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '281495'
                WHERE ordernumber = 'P201213185204794' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352288'
                WHERE ordernumber = 'P201213190256644' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '291574'
                WHERE ordernumber = 'P201213190532985' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352284'
                WHERE ordernumber = 'P191213190920631' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '334506'
                WHERE ordernumber = 'P421213191051585' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '258843'
                WHERE ordernumber = 'P201213191344691' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '95483'
                WHERE ordernumber = 'P191213191528730' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '85766'
                WHERE ordernumber = 'P191213191755506' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '231956'
                WHERE ordernumber = 'P201213191903738' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '230158'
                WHERE ordernumber = 'P191213192157383' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352291'
                WHERE ordernumber = 'P191213192429677' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '131048'
                WHERE ordernumber = 'P191213192600612' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '277354'
                WHERE ordernumber = 'P191213192805419' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352293'
                WHERE ordernumber = 'P191213193037443' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352294'
                WHERE ordernumber = 'P191213193307949' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349119'
                WHERE ordernumber = 'P421213193443701' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350810'
                WHERE ordernumber = 'P191213193456203' 
            
2023-12-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352295'
                WHERE ordernumber = 'P421213193638914' 
            
2023-12-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352296'
                WHERE ordernumber = 'P191213194006359' 
            
2023-12-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '113796'
                WHERE ordernumber = 'P201213194022376' 
            
2023-12-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '56884'
                WHERE ordernumber = 'P191213194051159' 
            
2023-12-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352297'
                WHERE ordernumber = 'P201213194452575' 
            
2023-12-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352298'
                WHERE ordernumber = 'P191213194459200' 
            
2023-12-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '339012'
                WHERE ordernumber = 'P191213194552253' 
            
2023-12-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352299'
                WHERE ordernumber = 'P191213194823734' 
            
2023-12-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '329402'
                WHERE ordernumber = 'P201213194829442' 
            
2023-12-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '329340'
                WHERE ordernumber = 'P201213194923654' 
            
2023-12-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352300'
                WHERE ordernumber = 'P191213195146509' 
            
2023-12-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352301'
                WHERE ordernumber = 'P201213195241978' 
            
2023-12-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '347542'
                WHERE ordernumber = 'P421213195521443' 
            
2023-12-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352303'
                WHERE ordernumber = 'P421213195758251' 
            
2023-12-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '170869'
                WHERE ordernumber = 'P201213195846625'