2024-08-23 01:00:02 -- 將會員中心id寫入data-lake
2024-08-23 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-22%';
        
2024-08-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '209114'
                WHERE ordernumber = 'P180822110120370' 
            
2024-08-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '411937'
                WHERE ordernumber = 'P180822110343770' 
            
2024-08-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '228727'
                WHERE ordernumber = 'P190822110355591' 
            
2024-08-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '411939'
                WHERE ordernumber = 'P180822110612263' 
            
2024-08-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100049'
                WHERE ordernumber = 'P200822110635480' 
            
2024-08-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100049'
                WHERE ordernumber = 'P200822110737925' 
            
2024-08-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '25'
                WHERE ordernumber = 'P190822110920800' 
            
2024-08-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '411944'
                WHERE ordernumber = 'P180822110943647' 
            
2024-08-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '270182'
                WHERE ordernumber = 'P180822111220542' 
            
2024-08-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348775'
                WHERE ordernumber = 'P200822111254344' 
            
2024-08-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '411947'
                WHERE ordernumber = 'P190822111310919' 
            
2024-08-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '411949'
                WHERE ordernumber = 'P190822111437480' 
            
2024-08-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '411948'
                WHERE ordernumber = 'P180822111608789' 
            
2024-08-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '335629'
                WHERE ordernumber = 'P200822111635903' 
            
2024-08-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '411952'
                WHERE ordernumber = 'P180822111726524' 
            
2024-08-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '114385'
                WHERE ordernumber = 'P180822111831971' 
            
2024-08-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '266584'
                WHERE ordernumber = 'P420822111857623' 
            
2024-08-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '104695'
                WHERE ordernumber = 'P190822112501278' 
            
2024-08-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '154617'
                WHERE ordernumber = 'P200822112539493' 
            
2024-08-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '106026'
                WHERE ordernumber = 'P180822112645915' 
            
2024-08-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '411957'
                WHERE ordernumber = 'P190822112801458' 
            
2024-08-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '97359'
                WHERE ordernumber = 'P200822113003487' 
            
2024-08-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '305270'
                WHERE ordernumber = 'P180822113136610' 
            
2024-08-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '411961'
                WHERE ordernumber = 'P180822113331994' 
            
2024-08-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381429'
                WHERE ordernumber = 'P180822113947227' 
            
2024-08-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '411970'
                WHERE ordernumber = 'P190822114144253' 
            
2024-08-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100637'
                WHERE ordernumber = 'P200822114351774' 
            
2024-08-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '214465'
                WHERE ordernumber = 'P190822114352341' 
            
2024-08-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '214465'
                WHERE ordernumber = 'P190822114536846' 
            
2024-08-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '297547'
                WHERE ordernumber = 'P190822114648915' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411974'
                WHERE ordernumber = 'P180822115100218' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '95037'
                WHERE ordernumber = 'P190822115148176' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411977'
                WHERE ordernumber = 'P180822115330119' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411977'
                WHERE ordernumber = 'P180822115742838' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356084'
                WHERE ordernumber = 'P180822115946690' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '236180'
                WHERE ordernumber = 'P180822120021665' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411979'
                WHERE ordernumber = 'P200822120133993' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411980'
                WHERE ordernumber = 'P180822120423710' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409804'
                WHERE ordernumber = 'P180822120612838' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409804'
                WHERE ordernumber = 'P180822120652677' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411982'
                WHERE ordernumber = 'P190822120706222' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307820'
                WHERE ordernumber = 'P180822120817501' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411985'
                WHERE ordernumber = 'P180822121110601' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411987'
                WHERE ordernumber = 'P180822121336648' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411989'
                WHERE ordernumber = 'P180822121508876' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98694'
                WHERE ordernumber = 'P420822121655649' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411990'
                WHERE ordernumber = 'P180822121733674' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '222483'
                WHERE ordernumber = 'P180822122259791' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411993'
                WHERE ordernumber = 'P420822122519239' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103507'
                WHERE ordernumber = 'P200822122527610' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411739'
                WHERE ordernumber = 'P180822122532276' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411994'
                WHERE ordernumber = 'P200822122637264' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411995'
                WHERE ordernumber = 'P180822122758489' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '256505'
                WHERE ordernumber = 'P180822122913134' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386624'
                WHERE ordernumber = 'P180822123015231' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305067'
                WHERE ordernumber = 'P180822123128847' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305067'
                WHERE ordernumber = 'P180822123335640' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411999'
                WHERE ordernumber = 'P200822123405809' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412000'
                WHERE ordernumber = 'P180822123804874' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412002'
                WHERE ordernumber = 'P420822123856257' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412003'
                WHERE ordernumber = 'P180822123951313' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399638'
                WHERE ordernumber = 'P180822124118301' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412008'
                WHERE ordernumber = 'P180822124303186' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412007'
                WHERE ordernumber = 'P200822124336209' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '220220'
                WHERE ordernumber = 'P180822124435785' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412009'
                WHERE ordernumber = 'P200822124612919' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392009'
                WHERE ordernumber = 'P180822124634703' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388814'
                WHERE ordernumber = 'P420822124705552' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412012'
                WHERE ordernumber = 'P180822125007213' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237392'
                WHERE ordernumber = 'P180822125325726' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412013'
                WHERE ordernumber = 'P420822125348749' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388814'
                WHERE ordernumber = 'P420822124705552' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388814'
                WHERE ordernumber = 'P420822124705552' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118407'
                WHERE ordernumber = 'P180822125658726' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394323'
                WHERE ordernumber = 'P180822125847401' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '254880'
                WHERE ordernumber = 'P180822125956498' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412019'
                WHERE ordernumber = 'P200822130121454' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412020'
                WHERE ordernumber = 'P180822130206388' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '86113'
                WHERE ordernumber = 'P180822131031971' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410429'
                WHERE ordernumber = 'P420822131518848' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412028'
                WHERE ordernumber = 'P420822131838831' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412030'
                WHERE ordernumber = 'P200822132027967' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412033'
                WHERE ordernumber = 'P180822132410681' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412034'
                WHERE ordernumber = 'P180822132604736' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394547'
                WHERE ordernumber = 'P180822133226228' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334965'
                WHERE ordernumber = 'P420822133232807' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412041'
                WHERE ordernumber = 'P180822133353661' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412044'
                WHERE ordernumber = 'P420822133636240' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384549'
                WHERE ordernumber = 'P630822133640917' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412038'
                WHERE ordernumber = 'P190822133931166' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410846'
                WHERE ordernumber = 'P180822133945626' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412039'
                WHERE ordernumber = 'P190822134045555' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412049'
                WHERE ordernumber = 'P180822134129843' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412050'
                WHERE ordernumber = 'P200822134213689' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '225050'
                WHERE ordernumber = 'P190822134234140' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412048'
                WHERE ordernumber = 'P190822134343315' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412052'
                WHERE ordernumber = 'P200822134357708' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '246488'
                WHERE ordernumber = 'P200822134515520' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112443'
                WHERE ordernumber = 'P200822134847898' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '280009'
                WHERE ordernumber = 'P180822134958495' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391561'
                WHERE ordernumber = 'P180822135132520' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291653'
                WHERE ordernumber = 'P200822135319878' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239241'
                WHERE ordernumber = 'P180822140036506' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412061'
                WHERE ordernumber = 'P420822140212879' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412062'
                WHERE ordernumber = 'P180822140304687' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412061'
                WHERE ordernumber = 'P420822140403849' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412064'
                WHERE ordernumber = 'P420822140707546' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410881'
                WHERE ordernumber = 'P200822140740757' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410881'
                WHERE ordernumber = 'P200822140834129' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412067'
                WHERE ordernumber = 'P200822141004899' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249469'
                WHERE ordernumber = 'P200822141135874' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '269419'
                WHERE ordernumber = 'P190822141403259' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412070'
                WHERE ordernumber = 'P180822141533706' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '125486'
                WHERE ordernumber = 'P200822142105280' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412078'
                WHERE ordernumber = 'P190822142303933' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412079'
                WHERE ordernumber = 'P180822142414857' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275812'
                WHERE ordernumber = 'P180822142645992' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284082'
                WHERE ordernumber = 'P180822142804872' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299213'
                WHERE ordernumber = 'P420822142820466' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '320529'
                WHERE ordernumber = 'P180822143059808' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404300'
                WHERE ordernumber = 'P420822143525450' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412088'
                WHERE ordernumber = 'P180822143640943' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412091'
                WHERE ordernumber = 'P180822143752579' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412093'
                WHERE ordernumber = 'P190822144115542' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412095'
                WHERE ordernumber = 'P180822144500581' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '268338'
                WHERE ordernumber = 'P190822144528902' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '333490'
                WHERE ordernumber = 'P420822144551878' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388725'
                WHERE ordernumber = 'P180822144608787' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412097'
                WHERE ordernumber = 'P190822144740613' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '212111'
                WHERE ordernumber = 'P190822144836690' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412100'
                WHERE ordernumber = 'P420822145034557' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412103'
                WHERE ordernumber = 'P420822145248773' 
            
2024-08-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412104'
                WHERE ordernumber = 'P180822145445457' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '268338'
                WHERE ordernumber = 'P190822145505148' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '311320'
                WHERE ordernumber = 'P200822145628914' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '124738'
                WHERE ordernumber = 'P190822145702937' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '247096'
                WHERE ordernumber = 'P190822150140580' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '291043'
                WHERE ordernumber = 'P200822150458541' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412113'
                WHERE ordernumber = 'P190822150515577' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412116'
                WHERE ordernumber = 'P200822151118791' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412118'
                WHERE ordernumber = 'P190822151319229' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395964'
                WHERE ordernumber = 'P200822151328350' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410581'
                WHERE ordernumber = 'P190822151558923' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407550'
                WHERE ordernumber = 'P200822151607286' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412121'
                WHERE ordernumber = 'P420822151641676' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342207'
                WHERE ordernumber = 'P420822151928598' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401722'
                WHERE ordernumber = 'P200822152001176' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412129'
                WHERE ordernumber = 'P190822152352572' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412057'
                WHERE ordernumber = 'P190822152638629' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339922'
                WHERE ordernumber = 'P420822152705212' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412133'
                WHERE ordernumber = 'P190822152849891' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412135'
                WHERE ordernumber = 'P190822153125331' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412139'
                WHERE ordernumber = 'P420822153436120' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342207'
                WHERE ordernumber = 'P420822153657430' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278936'
                WHERE ordernumber = 'P420822153932337' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412141'
                WHERE ordernumber = 'P420822154236894' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412143'
                WHERE ordernumber = 'P180822154520371' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '88442'
                WHERE ordernumber = 'P190822154632881' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412148'
                WHERE ordernumber = 'P190822154741870' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412150'
                WHERE ordernumber = 'P420822154910948' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '331576'
                WHERE ordernumber = 'P180822155109603' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412152'
                WHERE ordernumber = 'P180822155423830' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '34444'
                WHERE ordernumber = 'P180822155740244' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '224698'
                WHERE ordernumber = 'P420822155750527' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412122'
                WHERE ordernumber = 'P180822160056113' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407316'
                WHERE ordernumber = 'P200822160130784' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407316'
                WHERE ordernumber = 'P200822160211832' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '229637'
                WHERE ordernumber = 'P200822160326183' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412163'
                WHERE ordernumber = 'P180822160718803' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412164'
                WHERE ordernumber = 'P420822160751689' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99850'
                WHERE ordernumber = 'P190822160846401' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '334881'
                WHERE ordernumber = 'P420822161003538' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412166'
                WHERE ordernumber = 'P190822161212225' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412167'
                WHERE ordernumber = 'P180822161457716' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412109'
                WHERE ordernumber = 'P420822161813736' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412171'
                WHERE ordernumber = 'P200822162107491' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '216647'
                WHERE ordernumber = 'P180822162308404' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '250155'
                WHERE ordernumber = 'P180822162414934' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '84349'
                WHERE ordernumber = 'P180822162607942' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347354'
                WHERE ordernumber = 'P180822163043433' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347354'
                WHERE ordernumber = 'P180822163054268' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301149'
                WHERE ordernumber = 'P420822163129895' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '104695'
                WHERE ordernumber = 'P180822163150898' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '329129'
                WHERE ordernumber = 'P200822163322407' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412177'
                WHERE ordernumber = 'P190822163426577' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412178'
                WHERE ordernumber = 'P180822163508750' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354457'
                WHERE ordernumber = 'P420822163747968' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275250'
                WHERE ordernumber = 'P200822164337578' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412184'
                WHERE ordernumber = 'P190822164338817' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288772'
                WHERE ordernumber = 'P180822164420903' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412187'
                WHERE ordernumber = 'P180822164636966' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '123947'
                WHERE ordernumber = 'P180822165013257' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '320337'
                WHERE ordernumber = 'P190822165045950' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '159345'
                WHERE ordernumber = 'P200822165106397' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411564'
                WHERE ordernumber = 'P180822165242910' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388841'
                WHERE ordernumber = 'P190822165602493' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411564'
                WHERE ordernumber = 'P180822165657305' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402114'
                WHERE ordernumber = 'P200822165721844' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282342'
                WHERE ordernumber = 'P180822165759827' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377273'
                WHERE ordernumber = 'P180822165910611' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '89714'
                WHERE ordernumber = 'P190822165956322' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412193'
                WHERE ordernumber = 'P420822170129659' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406753'
                WHERE ordernumber = 'P420822170215422' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412196'
                WHERE ordernumber = 'P180822170407228' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '295570'
                WHERE ordernumber = 'P200822170413942' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412197'
                WHERE ordernumber = 'P180822170547228' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '130948'
                WHERE ordernumber = 'P420822170813851' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412199'
                WHERE ordernumber = 'P420822170957726' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '162115'
                WHERE ordernumber = 'P180822171101932' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412200'
                WHERE ordernumber = 'P200822171305523' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '162115'
                WHERE ordernumber = 'P180822171332446' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '162115'
                WHERE ordernumber = 'P180822171413502' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '133842'
                WHERE ordernumber = 'P630822171623271' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412202'
                WHERE ordernumber = 'P200822172036733' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412203'
                WHERE ordernumber = 'P180822172052725' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406018'
                WHERE ordernumber = 'P200822172312258' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412205'
                WHERE ordernumber = 'P180822172410581' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404822'
                WHERE ordernumber = 'P200822172509170' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411619'
                WHERE ordernumber = 'P420822172620506' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386588'
                WHERE ordernumber = 'P180822172659807' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '327912'
                WHERE ordernumber = 'P420822172942132' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412209'
                WHERE ordernumber = 'P180822173016843' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '218140'
                WHERE ordernumber = 'P180822173206474' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '233083'
                WHERE ordernumber = 'P190822173213120' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412212'
                WHERE ordernumber = 'P180822173455358' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '273486'
                WHERE ordernumber = 'P180822173647659' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230104'
                WHERE ordernumber = 'P180822173808983' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '161497'
                WHERE ordernumber = 'P420822174148667' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412216'
                WHERE ordernumber = 'P180822174149963' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351452'
                WHERE ordernumber = 'P420822174625888' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412222'
                WHERE ordernumber = 'P200822174800450' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '215272'
                WHERE ordernumber = 'P180822175435387' 
            
2024-08-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412223'
                WHERE ordernumber = 'P200822175515769' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '215272'
                WHERE ordernumber = 'P180822175555996' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412224'
                WHERE ordernumber = 'P190822175635229' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412090'
                WHERE ordernumber = 'P200822175928160' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412090'
                WHERE ordernumber = 'P200822180010129' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '315671'
                WHERE ordernumber = 'P200822180115880' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412227'
                WHERE ordernumber = 'P420822180138965' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412228'
                WHERE ordernumber = 'P420822180349253' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412229'
                WHERE ordernumber = 'P420822180516393' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412230'
                WHERE ordernumber = 'P200822180823582' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412231'
                WHERE ordernumber = 'P190822180905403' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '301149'
                WHERE ordernumber = 'P420822180934902' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '288825'
                WHERE ordernumber = 'P200822181142310' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '297586'
                WHERE ordernumber = 'P420822181206780' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412233'
                WHERE ordernumber = 'P180822181435438' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412238'
                WHERE ordernumber = 'P420822182029399' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412232'
                WHERE ordernumber = 'P180822182118601' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412239'
                WHERE ordernumber = 'P180822182527465' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '247871'
                WHERE ordernumber = 'P180822182736717' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412244'
                WHERE ordernumber = 'P200822182936808' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '591'
                WHERE ordernumber = 'P180822182924502' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412245'
                WHERE ordernumber = 'P420822183043330' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '78664'
                WHERE ordernumber = 'P180822183306644' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '306150'
                WHERE ordernumber = 'P180822183358854' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412248'
                WHERE ordernumber = 'P200822183528554' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412244'
                WHERE ordernumber = 'P200822183642215' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412249'
                WHERE ordernumber = 'P180822183711818' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412251'
                WHERE ordernumber = 'P200822183815915' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352691'
                WHERE ordernumber = 'P180822183835956' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '81113'
                WHERE ordernumber = 'P200822183912469' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412252'
                WHERE ordernumber = 'P180822184040532' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412254'
                WHERE ordernumber = 'P180822184245727' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412258'
                WHERE ordernumber = 'P180822184456597' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403761'
                WHERE ordernumber = 'P190822184722948' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '101291'
                WHERE ordernumber = 'P420822185321166' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '64067'
                WHERE ordernumber = 'P200822185347660' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412263'
                WHERE ordernumber = 'P190822185424459' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412262'
                WHERE ordernumber = 'P180822185704475' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '298614'
                WHERE ordernumber = 'P420822185738270' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '147285'
                WHERE ordernumber = 'P200822190143956' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412267'
                WHERE ordernumber = 'P190822190220838' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412271'
                WHERE ordernumber = 'P200822190410862' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412270'
                WHERE ordernumber = 'P180822190424740' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412272'
                WHERE ordernumber = 'P200822190543368' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '292461'
                WHERE ordernumber = 'P190822190820753' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '108019'
                WHERE ordernumber = 'P200822191944904' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410293'
                WHERE ordernumber = 'P190822192148714' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412280'
                WHERE ordernumber = 'P190822192300774' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '213702'
                WHERE ordernumber = 'P190822192340363' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '206879'
                WHERE ordernumber = 'P190822192425761' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '152824'
                WHERE ordernumber = 'P190822192824336' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '98228'
                WHERE ordernumber = 'P200822193035764' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '64196'
                WHERE ordernumber = 'P190822193921565' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '69376'
                WHERE ordernumber = 'P190822194120736' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '389372'
                WHERE ordernumber = 'P200822194222229' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '123194'
                WHERE ordernumber = 'P190822194410431' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412287'
                WHERE ordernumber = 'P190822194815252' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '100714'
                WHERE ordernumber = 'P190822194908609' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '311852'
                WHERE ordernumber = 'P190822195114606' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '390504'
                WHERE ordernumber = 'P200822195152287' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '100714'
                WHERE ordernumber = 'P190822195214611' 
            
2024-08-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412293'
                WHERE ordernumber = 'P190822195450400'