2024-08-10 01:00:02 -- 將會員中心id寫入data-lake
2024-08-10 01:00:02 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-08-09%';
        
2024-08-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '132169'
                WHERE ordernumber = 'P190809110204334' 
            
2024-08-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406568'
                WHERE ordernumber = 'P180809110218516' 
            
2024-08-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '67043'
                WHERE ordernumber = 'P200809110301478' 
            
2024-08-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406570'
                WHERE ordernumber = 'P420809110414808' 
            
2024-08-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '153983'
                WHERE ordernumber = 'P180809110553368' 
            
2024-08-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '314085'
                WHERE ordernumber = 'P200809110838725' 
            
2024-08-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '93642'
                WHERE ordernumber = 'P420809110859394' 
            
2024-08-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406571'
                WHERE ordernumber = 'P180809110941613' 
            
2024-08-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100574'
                WHERE ordernumber = 'P200809111406716' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401564'
                WHERE ordernumber = 'P200809111600591' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '119802'
                WHERE ordernumber = 'P180809111823738' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101496'
                WHERE ordernumber = 'P200809111840872' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '373133'
                WHERE ordernumber = 'P420809111840658' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '226904'
                WHERE ordernumber = 'P180809111931807' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406577'
                WHERE ordernumber = 'P200809112015970' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406578'
                WHERE ordernumber = 'P180809112217201' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '44400'
                WHERE ordernumber = 'P180809112350889' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309166'
                WHERE ordernumber = 'P190809112415882' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '153983'
                WHERE ordernumber = 'P180809112619254' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406582'
                WHERE ordernumber = 'P180809112847231' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406583'
                WHERE ordernumber = 'P200809113054705' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339179'
                WHERE ordernumber = 'P420809113251219' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '122923'
                WHERE ordernumber = 'P180809113427607' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '265758'
                WHERE ordernumber = 'P180809113528300' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405211'
                WHERE ordernumber = 'P200809113640313' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350706'
                WHERE ordernumber = 'P420809113734791' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405211'
                WHERE ordernumber = 'P200809113753170' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350706'
                WHERE ordernumber = 'P420809114156195' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '142569'
                WHERE ordernumber = 'P200809114411513' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405635'
                WHERE ordernumber = 'P200809114615620' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '263960'
                WHERE ordernumber = 'P200809114803163' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396005'
                WHERE ordernumber = 'P200809115248769' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '255220'
                WHERE ordernumber = 'P180809115422678' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '264596'
                WHERE ordernumber = 'P190809115532529' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '50777'
                WHERE ordernumber = 'P200809115540343' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281090'
                WHERE ordernumber = 'P180809115602281' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '317718'
                WHERE ordernumber = 'P420809115621769' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404972'
                WHERE ordernumber = 'P420809115804905' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '203417'
                WHERE ordernumber = 'P190809115948454' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406592'
                WHERE ordernumber = 'P180809120358809' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406593'
                WHERE ordernumber = 'P190809120445959' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406591'
                WHERE ordernumber = 'P420809120600714' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240498'
                WHERE ordernumber = 'P200809120727801' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406596'
                WHERE ordernumber = 'P180809121036171' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404441'
                WHERE ordernumber = 'P420809121851541' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '255220'
                WHERE ordernumber = 'P180809122018450' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '331085'
                WHERE ordernumber = 'P420809122211324' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '236884'
                WHERE ordernumber = 'P180809122238336' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404441'
                WHERE ordernumber = 'P420809122340188' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406600'
                WHERE ordernumber = 'P180809122449492' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '148128'
                WHERE ordernumber = 'P200809122520524' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300112'
                WHERE ordernumber = 'P420809122631120' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406598'
                WHERE ordernumber = 'P180809122750661' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '218522'
                WHERE ordernumber = 'P180809123056462' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380016'
                WHERE ordernumber = 'P200809123131260' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406602'
                WHERE ordernumber = 'P180809123228128' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406603'
                WHERE ordernumber = 'P420809123819674' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '88024'
                WHERE ordernumber = 'P190809124118650' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406604'
                WHERE ordernumber = 'P180809124239816' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406606'
                WHERE ordernumber = 'P200809124556703' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406465'
                WHERE ordernumber = 'P180809125024378' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303031'
                WHERE ordernumber = 'P180809125128857' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406609'
                WHERE ordernumber = 'P200809125138790' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305075'
                WHERE ordernumber = 'P200809125317514' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '57435'
                WHERE ordernumber = 'P180809125405149' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406610'
                WHERE ordernumber = 'P200809125455611' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406612'
                WHERE ordernumber = 'P180809125749547' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406614'
                WHERE ordernumber = 'P200809125836195' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406617'
                WHERE ordernumber = 'P420809130119144' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404534'
                WHERE ordernumber = 'P180809130127182' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406614'
                WHERE ordernumber = 'P200809130308264' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279244'
                WHERE ordernumber = 'P180809130341709' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391721'
                WHERE ordernumber = 'P200809130419358' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406619'
                WHERE ordernumber = 'P180809130552857' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397034'
                WHERE ordernumber = 'P420809130957937' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385324'
                WHERE ordernumber = 'P420809131106338' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406622'
                WHERE ordernumber = 'P180809131410328' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406623'
                WHERE ordernumber = 'P420809132125708' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388008'
                WHERE ordernumber = 'P180809132840220' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406624'
                WHERE ordernumber = 'P200809132920513' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406625'
                WHERE ordernumber = 'P200809133113519' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406628'
                WHERE ordernumber = 'P420809133448276' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '294578'
                WHERE ordernumber = 'P420809133627781' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406630'
                WHERE ordernumber = 'P200809133658715' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406634'
                WHERE ordernumber = 'P420809135040274' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248360'
                WHERE ordernumber = 'P180809135252117' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406637'
                WHERE ordernumber = 'P200809135301592' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406641'
                WHERE ordernumber = 'P420809140501416' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406641'
                WHERE ordernumber = 'P420809140558405' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406642'
                WHERE ordernumber = 'P180809140638774' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406439'
                WHERE ordernumber = 'P420809141017548' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406647'
                WHERE ordernumber = 'P180809141136775' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406646'
                WHERE ordernumber = 'P200809141142275' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406648'
                WHERE ordernumber = 'P180809141323267' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301962'
                WHERE ordernumber = 'P420809141649284' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406650'
                WHERE ordernumber = 'P180809141825476' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406647'
                WHERE ordernumber = 'P190809141839675' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406654'
                WHERE ordernumber = 'P180809142041457' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379594'
                WHERE ordernumber = 'P190809142225434' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406657'
                WHERE ordernumber = 'P190809142504820' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '360253'
                WHERE ordernumber = 'P180809143951119' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406662'
                WHERE ordernumber = 'P180809144215680' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352385'
                WHERE ordernumber = 'P190809144252152' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352385'
                WHERE ordernumber = 'P190809144455479' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406663'
                WHERE ordernumber = 'P200809144519194' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '126504'
                WHERE ordernumber = 'P180809144906486' 
            
2024-08-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406665'
                WHERE ordernumber = 'P190809145032474' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406666'
                WHERE ordernumber = 'P420809145157715' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406667'
                WHERE ordernumber = 'P190809145205702' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390059'
                WHERE ordernumber = 'P190809145325203' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406666'
                WHERE ordernumber = 'P420809145157715' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '185714'
                WHERE ordernumber = 'P190809145706619' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98155'
                WHERE ordernumber = 'P420809145721551' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '129714'
                WHERE ordernumber = 'P180809145851301' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '141930'
                WHERE ordernumber = 'P200809145948932' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '129714'
                WHERE ordernumber = 'P180809150046728' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406670'
                WHERE ordernumber = 'P190809150215381' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '321119'
                WHERE ordernumber = 'P420809150219144' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355636'
                WHERE ordernumber = 'P180809150246707' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406672'
                WHERE ordernumber = 'P180809150525622' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406673'
                WHERE ordernumber = 'P190809150540803' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '296332'
                WHERE ordernumber = 'P420809150637141' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301307'
                WHERE ordernumber = 'P190809150834668' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406645'
                WHERE ordernumber = 'P200809150935541' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406674'
                WHERE ordernumber = 'P420809151003863' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299129'
                WHERE ordernumber = 'P200809151031540' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406676'
                WHERE ordernumber = 'P200809151354899' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396983'
                WHERE ordernumber = 'P420809151623798' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406677'
                WHERE ordernumber = 'P200809151627688' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406679'
                WHERE ordernumber = 'P200809151932195' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386742'
                WHERE ordernumber = 'P190809151939127' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406679'
                WHERE ordernumber = 'P200809152122962' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401200'
                WHERE ordernumber = 'P190809152152473' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276453'
                WHERE ordernumber = 'P200809152205389' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406645'
                WHERE ordernumber = 'P200809152353663' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406680'
                WHERE ordernumber = 'P200809152515576' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406645'
                WHERE ordernumber = 'P200809152727342' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98539'
                WHERE ordernumber = 'P190809152808825' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98539'
                WHERE ordernumber = 'P190809152929970' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '279114'
                WHERE ordernumber = 'P190809153005581' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238142'
                WHERE ordernumber = 'P200809153040543' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406686'
                WHERE ordernumber = 'P200809153307767' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '124083'
                WHERE ordernumber = 'P190809153431255' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '328300'
                WHERE ordernumber = 'P420809153647463' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100925'
                WHERE ordernumber = 'P200809154118358' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100925'
                WHERE ordernumber = 'P200809154133621' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406688'
                WHERE ordernumber = 'P200809154401684' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '338319'
                WHERE ordernumber = 'P190809154928479' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '328335'
                WHERE ordernumber = 'P200809155156428' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406689'
                WHERE ordernumber = 'P190809155233455' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '234207'
                WHERE ordernumber = 'P200809155726167' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406690'
                WHERE ordernumber = 'P190809155733119' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406691'
                WHERE ordernumber = 'P190809155830713' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406692'
                WHERE ordernumber = 'P200809160059167' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381812'
                WHERE ordernumber = 'P420809160521361' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '303878'
                WHERE ordernumber = 'P200809160642725' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '289545'
                WHERE ordernumber = 'P200809160846462' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405786'
                WHERE ordernumber = 'P180809160930778' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406700'
                WHERE ordernumber = 'P420809161302808' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '168325'
                WHERE ordernumber = 'P200809161536491' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '115139'
                WHERE ordernumber = 'P190809161616728' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406703'
                WHERE ordernumber = 'P190809161731190' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406704'
                WHERE ordernumber = 'P190809161840154' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342052'
                WHERE ordernumber = 'P190809162030371' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406705'
                WHERE ordernumber = 'P200809162038366' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '296213'
                WHERE ordernumber = 'P180809162333779' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406706'
                WHERE ordernumber = 'P420809162705601' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406710'
                WHERE ordernumber = 'P190809163149288' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378727'
                WHERE ordernumber = 'P180809163849138' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '292445'
                WHERE ordernumber = 'P200809163853601' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406719'
                WHERE ordernumber = 'P190809164034749' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301962'
                WHERE ordernumber = 'P420809164455211' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '93821'
                WHERE ordernumber = 'P190809164507753' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406722'
                WHERE ordernumber = 'P180809165108490' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406724'
                WHERE ordernumber = 'P190809165321473' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '138492'
                WHERE ordernumber = 'P180809165420555' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406726'
                WHERE ordernumber = 'P420809165530399' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406727'
                WHERE ordernumber = 'P180809165534132' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '121766'
                WHERE ordernumber = 'P180809165845474' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406729'
                WHERE ordernumber = 'P190809165959963' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406731'
                WHERE ordernumber = 'P180809170045133' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406732'
                WHERE ordernumber = 'P190809170130207' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406730'
                WHERE ordernumber = 'P420809170210782' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276562'
                WHERE ordernumber = 'P190809170242603' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406735'
                WHERE ordernumber = 'P200809170446739' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '298632'
                WHERE ordernumber = 'P200809170559592' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406736'
                WHERE ordernumber = 'P190809170612159' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401789'
                WHERE ordernumber = 'P190809170727431' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '221617'
                WHERE ordernumber = 'P200809170738747' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406737'
                WHERE ordernumber = 'P190809170856237' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402745'
                WHERE ordernumber = 'P200809171427121' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230874'
                WHERE ordernumber = 'P190809171626291' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406738'
                WHERE ordernumber = 'P420809171704878' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '216385'
                WHERE ordernumber = 'P190809171713345' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '124768'
                WHERE ordernumber = 'P200809172724989' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406739'
                WHERE ordernumber = 'P200809172950887' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '291869'
                WHERE ordernumber = 'P200809173117756' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406741'
                WHERE ordernumber = 'P190809173328302' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306877'
                WHERE ordernumber = 'P200809173540696' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393528'
                WHERE ordernumber = 'P200809173907242' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406746'
                WHERE ordernumber = 'P420809174039846' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379015'
                WHERE ordernumber = 'P190809174054768' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406746'
                WHERE ordernumber = 'P420809174221758' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400934'
                WHERE ordernumber = 'P590809174548304' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '251088'
                WHERE ordernumber = 'P200809174926947' 
            
2024-08-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '251088'
                WHERE ordernumber = 'P200809174929148' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406749'
                WHERE ordernumber = 'P200809175037529' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406749'
                WHERE ordernumber = 'P200809175213810' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '343536'
                WHERE ordernumber = 'P190809175219551' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406750'
                WHERE ordernumber = 'P190809175413232' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406752'
                WHERE ordernumber = 'P190809175540683' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '81699'
                WHERE ordernumber = 'P190809175646371' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '87257'
                WHERE ordernumber = 'P180809175724438' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '242582'
                WHERE ordernumber = 'P190809175915668' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406753'
                WHERE ordernumber = 'P420809180624307' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '334547'
                WHERE ordernumber = 'P420809180734770' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '279618'
                WHERE ordernumber = 'P190809180738721' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '102438'
                WHERE ordernumber = 'P200809180938836' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '178850'
                WHERE ordernumber = 'P190809181040265' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402607'
                WHERE ordernumber = 'P190809181253943' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406754'
                WHERE ordernumber = 'P420809181312585' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406755'
                WHERE ordernumber = 'P200809181337745' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406756'
                WHERE ordernumber = 'P190809181524910' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398615'
                WHERE ordernumber = 'P200809181546600' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '287142'
                WHERE ordernumber = 'P190809182121497' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406757'
                WHERE ordernumber = 'P420809182628461' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406758'
                WHERE ordernumber = 'P190809182734115' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '380174'
                WHERE ordernumber = 'P590809183041690' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406759'
                WHERE ordernumber = 'P420809183053208' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397677'
                WHERE ordernumber = 'P190809183454330' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406760'
                WHERE ordernumber = 'P200809183755995' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406761'
                WHERE ordernumber = 'P190809183801613' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406760'
                WHERE ordernumber = 'P200809183829439' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406763'
                WHERE ordernumber = 'P190809183924437' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406762'
                WHERE ordernumber = 'P420809184126788' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '248726'
                WHERE ordernumber = 'P200809184300843' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396710'
                WHERE ordernumber = 'P630809184402380' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406765'
                WHERE ordernumber = 'P200809184419244' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '211672'
                WHERE ordernumber = 'P190809184512821' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '297993'
                WHERE ordernumber = 'P200809184538666' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383322'
                WHERE ordernumber = 'P190809184944926' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406766'
                WHERE ordernumber = 'P190809185141326' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '346792'
                WHERE ordernumber = 'P190809185358610' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '318181'
                WHERE ordernumber = 'P190809190001439' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406768'
                WHERE ordernumber = 'P190809190327383' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406769'
                WHERE ordernumber = 'P190809190525682' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '211415'
                WHERE ordernumber = 'P190809191404407' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406771'
                WHERE ordernumber = 'P200809191600995' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '239833'
                WHERE ordernumber = 'P190809191632141' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406773'
                WHERE ordernumber = 'P200809191800590' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404707'
                WHERE ordernumber = 'P190809192154659' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '163703'
                WHERE ordernumber = 'P190809192556979' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '371993'
                WHERE ordernumber = 'P190809192757974' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406775'
                WHERE ordernumber = 'P190809192915869' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406776'
                WHERE ordernumber = 'P200809193030936' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '124068'
                WHERE ordernumber = 'P190809193046619' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '124068'
                WHERE ordernumber = 'P190809193330679' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397912'
                WHERE ordernumber = 'P200809193644351' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406781'
                WHERE ordernumber = 'P200809193812397' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406785'
                WHERE ordernumber = 'P200809195216536' 
            
2024-08-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406715'
                WHERE ordernumber = 'P200809195825724'