2024-09-19 01:00:01 -- 將會員中心id寫入data-lake
2024-09-19 01:00:01 -- 
            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 '2024-09-18%';
        
2024-09-19 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '277404'
                WHERE ordernumber = 'P190918110613495' 
            
2024-09-19 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '306732'
                WHERE ordernumber = 'P200918110827960' 
            
2024-09-19 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '421583'
                WHERE ordernumber = 'P190918110930899' 
            
2024-09-19 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '421571'
                WHERE ordernumber = 'P200918110939307' 
            
2024-09-19 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '282484'
                WHERE ordernumber = 'P180918111040320' 
            
2024-09-19 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '421584'
                WHERE ordernumber = 'P190918111248530' 
            
2024-09-19 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '11076'
                WHERE ordernumber = 'P420918111752341' 
            
2024-09-19 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '299325'
                WHERE ordernumber = 'P420918112127506' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '128454'
                WHERE ordernumber = 'P200918112155910' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '413699'
                WHERE ordernumber = 'P180918112410772' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421586'
                WHERE ordernumber = 'P190918112751161' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421585'
                WHERE ordernumber = 'P190918112950160' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P200918113038219' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421588'
                WHERE ordernumber = 'P190918113159433' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421589'
                WHERE ordernumber = 'P200918113800826' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421590'
                WHERE ordernumber = 'P190918113835910' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '270298'
                WHERE ordernumber = 'P200918113908430' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '284262'
                WHERE ordernumber = 'P180918114039266' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419853'
                WHERE ordernumber = 'P420918114141263' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421591'
                WHERE ordernumber = 'P190918114349635' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '340608'
                WHERE ordernumber = 'P420918114552553' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421592'
                WHERE ordernumber = 'P710918114736819' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421594'
                WHERE ordernumber = 'P180918114845440' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420874'
                WHERE ordernumber = 'P420918114901260' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180918114942877' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100465'
                WHERE ordernumber = 'P200918115006392' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421595'
                WHERE ordernumber = 'P200918115123695' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '346622'
                WHERE ordernumber = 'P200918115252342' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '189702'
                WHERE ordernumber = 'P190918115500267' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '362843'
                WHERE ordernumber = 'P180918120024221' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '137893'
                WHERE ordernumber = 'P190918120426920' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '167650'
                WHERE ordernumber = 'P420918120502196' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421598'
                WHERE ordernumber = 'P180918120615431' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421597'
                WHERE ordernumber = 'P190918120831158' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '399295'
                WHERE ordernumber = 'P420918121006779' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '276738'
                WHERE ordernumber = 'P180918122411300' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '417339'
                WHERE ordernumber = 'P180918122611873' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393774'
                WHERE ordernumber = 'P200918122859942' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410977'
                WHERE ordernumber = 'P180918122902340' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421600'
                WHERE ordernumber = 'P180918123233486' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421601'
                WHERE ordernumber = 'P420918123546143' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421602'
                WHERE ordernumber = 'P420918123656350' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421603'
                WHERE ordernumber = 'P200918123901764' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '39509'
                WHERE ordernumber = 'P200918124235981' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '250029'
                WHERE ordernumber = 'P200918124453892' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '411621'
                WHERE ordernumber = 'P200918124747381' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421604'
                WHERE ordernumber = 'P420918130603792' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '298853'
                WHERE ordernumber = 'P180918130910789' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421578'
                WHERE ordernumber = 'P180918131535256' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421578'
                WHERE ordernumber = 'P180918131604376' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421578'
                WHERE ordernumber = 'P180918131629755' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421607'
                WHERE ordernumber = 'P180918132354794' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421606'
                WHERE ordernumber = 'P710918132712232' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350540'
                WHERE ordernumber = 'P180918133013476' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421608'
                WHERE ordernumber = 'P180918133534515' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '269134'
                WHERE ordernumber = 'P420918133718729' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421610'
                WHERE ordernumber = 'P180918134015303' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421609'
                WHERE ordernumber = 'P710918134044246' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '138483'
                WHERE ordernumber = 'P180918134304798' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '329353'
                WHERE ordernumber = 'P180918134505940' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '276000'
                WHERE ordernumber = 'P180918134634642' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421612'
                WHERE ordernumber = 'P730918134930439' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '273410'
                WHERE ordernumber = 'P180918135156713' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420128'
                WHERE ordernumber = 'P420918140020597' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421614'
                WHERE ordernumber = 'P180918140521633' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421616'
                WHERE ordernumber = 'P180918141731335' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421615'
                WHERE ordernumber = 'P180918141827989' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421617'
                WHERE ordernumber = 'P730918141953281' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '300569'
                WHERE ordernumber = 'P180918142005336' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421618'
                WHERE ordernumber = 'P420918142346679' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353508'
                WHERE ordernumber = 'P200918142604617' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '341156'
                WHERE ordernumber = 'P180918142612908' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '103719'
                WHERE ordernumber = 'P710918143126794' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421621'
                WHERE ordernumber = 'P420918143133686' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421620'
                WHERE ordernumber = 'P710918143438757' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420437'
                WHERE ordernumber = 'P200918143528694' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421623'
                WHERE ordernumber = 'P180918143734618' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391920'
                WHERE ordernumber = 'P200918144125184' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '293741'
                WHERE ordernumber = 'P180918144418901' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421624'
                WHERE ordernumber = 'P200918145336803' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421626'
                WHERE ordernumber = 'P180918145441985' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '344831'
                WHERE ordernumber = 'P180918145912264' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421628'
                WHERE ordernumber = 'P200918150256771' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '408727'
                WHERE ordernumber = 'P420918150413436' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421629'
                WHERE ordernumber = 'P180918150610312' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421631'
                WHERE ordernumber = 'P710918150816966' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421633'
                WHERE ordernumber = 'P420918151128940' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '250073'
                WHERE ordernumber = 'P180918151419637' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '121498'
                WHERE ordernumber = 'P200918151739289' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '31916'
                WHERE ordernumber = 'P200918151818994' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421634'
                WHERE ordernumber = 'P180918151932480' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421635'
                WHERE ordernumber = 'P180918153019996' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421636'
                WHERE ordernumber = 'P180918153300994' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421638'
                WHERE ordernumber = 'P180918153858751' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421639'
                WHERE ordernumber = 'P180918154023147' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421637'
                WHERE ordernumber = 'P710918154121255' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '413187'
                WHERE ordernumber = 'P420918154408435' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '94987'
                WHERE ordernumber = 'P190918154533929' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421640'
                WHERE ordernumber = 'P710918154802753' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421642'
                WHERE ordernumber = 'P190918154806998' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421641'
                WHERE ordernumber = 'P730918154930585' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421645'
                WHERE ordernumber = 'P200918160039922' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421644'
                WHERE ordernumber = 'P710918160136357' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '399293'
                WHERE ordernumber = 'P190918160151203' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421375'
                WHERE ordernumber = 'P180918160627801' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421646'
                WHERE ordernumber = 'P200918160807715' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421647'
                WHERE ordernumber = 'P420918160846175' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421648'
                WHERE ordernumber = 'P180918161122736' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421649'
                WHERE ordernumber = 'P190918161126483' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421375'
                WHERE ordernumber = 'P180918161157616' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '97731'
                WHERE ordernumber = 'P200918161914620' 
            
2024-09-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421650'
                WHERE ordernumber = 'P730918162642128' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421651'
                WHERE ordernumber = 'P730918162720155' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421653'
                WHERE ordernumber = 'P190918163218707' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421656'
                WHERE ordernumber = 'P180918163607901' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421654'
                WHERE ordernumber = 'P710918163629114' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289490'
                WHERE ordernumber = 'P200918163808118' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421658'
                WHERE ordernumber = 'P190918164412118' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402201'
                WHERE ordernumber = 'P420918164507886' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354533'
                WHERE ordernumber = 'P190918164532234' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '1940'
                WHERE ordernumber = 'P710918164536897' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421659'
                WHERE ordernumber = 'P200918164621172' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '332683'
                WHERE ordernumber = 'P180918165025696' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421660'
                WHERE ordernumber = 'P190918165250567' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421660'
                WHERE ordernumber = 'P190918165347875' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421661'
                WHERE ordernumber = 'P730918165727856' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421660'
                WHERE ordernumber = 'P180918165924437' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287227'
                WHERE ordernumber = 'P180918170312536' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421662'
                WHERE ordernumber = 'P180918170436165' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421664'
                WHERE ordernumber = 'P200918170842461' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421663'
                WHERE ordernumber = 'P730918170927527' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421665'
                WHERE ordernumber = 'P730918171214462' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385502'
                WHERE ordernumber = 'P200918171407145' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391920'
                WHERE ordernumber = 'P200918171510274' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421666'
                WHERE ordernumber = 'P420918171901733' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391920'
                WHERE ordernumber = 'P200918172123592' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421668'
                WHERE ordernumber = 'P180918172150761' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414912'
                WHERE ordernumber = 'P200918172421603' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421669'
                WHERE ordernumber = 'P420918172426891' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388070'
                WHERE ordernumber = 'P180918172635115' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391920'
                WHERE ordernumber = 'P200918172743981' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391920'
                WHERE ordernumber = 'P200918172950301' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '168576'
                WHERE ordernumber = 'P200918173138644' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421671'
                WHERE ordernumber = 'P710918173149698' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421672'
                WHERE ordernumber = 'P420918173253292' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421673'
                WHERE ordernumber = 'P180918173419297' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '262437'
                WHERE ordernumber = 'P180918173527845' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341317'
                WHERE ordernumber = 'P180918174120366' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418452'
                WHERE ordernumber = 'P180918174329866' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81097'
                WHERE ordernumber = 'P200918174421898' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118258'
                WHERE ordernumber = 'P180918174845188' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421675'
                WHERE ordernumber = 'P730918174956253' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421676'
                WHERE ordernumber = 'P180918175012565' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421677'
                WHERE ordernumber = 'P180918175127516' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374877'
                WHERE ordernumber = 'P420918175317218' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421678'
                WHERE ordernumber = 'P180918175419772' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421680'
                WHERE ordernumber = 'P180918175641998' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421679'
                WHERE ordernumber = 'P730918175648510' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421681'
                WHERE ordernumber = 'P200918175929552' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421682'
                WHERE ordernumber = 'P180918180148990' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415697'
                WHERE ordernumber = 'P180918180413784' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382581'
                WHERE ordernumber = 'P180918180542983' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394501'
                WHERE ordernumber = 'P420918180555953' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421685'
                WHERE ordernumber = 'P180918180715777' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421686'
                WHERE ordernumber = 'P730918180755228' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421684'
                WHERE ordernumber = 'P730918181016942' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337912'
                WHERE ordernumber = 'P710918181411329' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421688'
                WHERE ordernumber = 'P180918182149118' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '264756'
                WHERE ordernumber = 'P200918182202828' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247872'
                WHERE ordernumber = 'P190918182444695' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421494'
                WHERE ordernumber = 'P420918182704736' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421494'
                WHERE ordernumber = 'P420918182748188' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334547'
                WHERE ordernumber = 'P420918182840448' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '327453'
                WHERE ordernumber = 'P200918183223672' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '164997'
                WHERE ordernumber = 'P200918183748444' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '311852'
                WHERE ordernumber = 'P180918184235116' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421689'
                WHERE ordernumber = 'P200918184432607' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421690'
                WHERE ordernumber = 'P200918184919301' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421691'
                WHERE ordernumber = 'P190918185311697' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '210055'
                WHERE ordernumber = 'P190918190006354' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '311457'
                WHERE ordernumber = 'P200918190217366' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81699'
                WHERE ordernumber = 'P190918190642452' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421692'
                WHERE ordernumber = 'P730918190942982' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421693'
                WHERE ordernumber = 'P200918191525606' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421695'
                WHERE ordernumber = 'P190918191819171' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358060'
                WHERE ordernumber = 'P190918191915324' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421698'
                WHERE ordernumber = 'P200918192344159' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421697'
                WHERE ordernumber = 'P730918192602891' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421700'
                WHERE ordernumber = 'P190918192633537' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421699'
                WHERE ordernumber = 'P710918192733174' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94254'
                WHERE ordernumber = 'P190918192855958' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284184'
                WHERE ordernumber = 'P190918193745652' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421560'
                WHERE ordernumber = 'P710918193833812' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421702'
                WHERE ordernumber = 'P200918194357699' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421701'
                WHERE ordernumber = 'P190918194604874' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421703'
                WHERE ordernumber = 'P200918194838924' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239648'
                WHERE ordernumber = 'P190918194908581' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421102'
                WHERE ordernumber = 'P190918195059915' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283272'
                WHERE ordernumber = 'P190918195142911' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421704'
                WHERE ordernumber = 'P710918195622191' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100154'
                WHERE ordernumber = 'P630918200812221' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419720'
                WHERE ordernumber = 'P730918203917414' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390978'
                WHERE ordernumber = 'P710918211530262' 
            
2024-09-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421714'
                WHERE ordernumber = 'P710918215550557'