2024-11-02 01:00:01 -- 將會員中心id寫入data-lake
2024-11-02 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-11-01%';
        
2024-11-02 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '94231'
                WHERE ordernumber = 'P201101110252549' 
            
2024-11-02 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '254076'
                WHERE ordernumber = 'P201101110347162' 
            
2024-11-02 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '165380'
                WHERE ordernumber = 'P771101111005770' 
            
2024-11-02 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '326819'
                WHERE ordernumber = 'P181101111224234' 
            
2024-11-02 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '269457'
                WHERE ordernumber = 'P181101111811448' 
            
2024-11-02 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '386821'
                WHERE ordernumber = 'P201101113348586' 
            
2024-11-02 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '428439'
                WHERE ordernumber = 'P421101113536995' 
            
2024-11-02 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '93776'
                WHERE ordernumber = 'P181101113916271' 
            
2024-11-02 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '314983'
                WHERE ordernumber = 'P191101113945496' 
            
2024-11-02 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '428437'
                WHERE ordernumber = 'P421101114114564' 
            
2024-11-02 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '428438'
                WHERE ordernumber = 'P191101114121670' 
            
2024-11-02 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '428435'
                WHERE ordernumber = 'P421101114247806' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348545'
                WHERE ordernumber = 'P421101114330115' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349339'
                WHERE ordernumber = 'P201101114351149' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427223'
                WHERE ordernumber = 'P421101114947929' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428441'
                WHERE ordernumber = 'P421101115119761' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '344213'
                WHERE ordernumber = 'P421101115352472' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428445'
                WHERE ordernumber = 'P201101115831267' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426568'
                WHERE ordernumber = 'P181101120638352' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428446'
                WHERE ordernumber = 'P191101120942272' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '104419'
                WHERE ordernumber = 'P181101121301326' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '296861'
                WHERE ordernumber = 'P201101121614467' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428448'
                WHERE ordernumber = 'P181101121729391' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428447'
                WHERE ordernumber = 'P181101121935207' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '273696'
                WHERE ordernumber = 'P201101122151795' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428450'
                WHERE ordernumber = 'P771101122226303' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428232'
                WHERE ordernumber = 'P201101122317640' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428449'
                WHERE ordernumber = 'P181101122943805' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378099'
                WHERE ordernumber = 'P421101122951231' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428453'
                WHERE ordernumber = 'P201101122952754' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428454'
                WHERE ordernumber = 'P201101123116585' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428429'
                WHERE ordernumber = 'P201101123220272' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378099'
                WHERE ordernumber = 'P421101123408288' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428456'
                WHERE ordernumber = 'P421101123630830' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428455'
                WHERE ordernumber = 'P181101123815157' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428457'
                WHERE ordernumber = 'P421101123953879' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '345735'
                WHERE ordernumber = 'P421101124113650' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428459'
                WHERE ordernumber = 'P421101124444596' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428458'
                WHERE ordernumber = 'P181101124507177' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427794'
                WHERE ordernumber = 'P771101125015733' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428463'
                WHERE ordernumber = 'P421101125201409' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428460'
                WHERE ordernumber = 'P181101125345854' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428462'
                WHERE ordernumber = 'P181101125612482' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428464'
                WHERE ordernumber = 'P771101125941602' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113917'
                WHERE ordernumber = 'P181101130038292' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '66860'
                WHERE ordernumber = 'P191101130054302' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428466'
                WHERE ordernumber = 'P591101130622227' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428465'
                WHERE ordernumber = 'P181101130733677' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '116456'
                WHERE ordernumber = 'P181101131015802' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '95002'
                WHERE ordernumber = 'P181101131959573' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '306298'
                WHERE ordernumber = 'P181101132034823' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423406'
                WHERE ordernumber = 'P421101132227900' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428467'
                WHERE ordernumber = 'P181101132828884' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '240295'
                WHERE ordernumber = 'P181101133230957' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428469'
                WHERE ordernumber = 'P421101133542902' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428470'
                WHERE ordernumber = 'P201101134047687' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428471'
                WHERE ordernumber = 'P201101134316347' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426896'
                WHERE ordernumber = 'P181101134343191' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '290096'
                WHERE ordernumber = 'P771101134358837' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '400880'
                WHERE ordernumber = 'P201101134646366' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428473'
                WHERE ordernumber = 'P201101135324308' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '7373'
                WHERE ordernumber = 'P181101140045436' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100658'
                WHERE ordernumber = 'P201101140510168' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428475'
                WHERE ordernumber = 'P201101140822812' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428476'
                WHERE ordernumber = 'P421101141216154' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428477'
                WHERE ordernumber = 'P421101141835534' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428478'
                WHERE ordernumber = 'P201101142201921' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '108588'
                WHERE ordernumber = 'P421101142810706' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '278656'
                WHERE ordernumber = 'P771101143001744' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428480'
                WHERE ordernumber = 'P201101143015244' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '110093'
                WHERE ordernumber = 'P201101143312431' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '293682'
                WHERE ordernumber = 'P771101143811716' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355435'
                WHERE ordernumber = 'P201101144034192' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428481'
                WHERE ordernumber = 'P421101144055735' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428482'
                WHERE ordernumber = 'P181101144522372' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391040'
                WHERE ordernumber = 'P181101144632916' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287312'
                WHERE ordernumber = 'P191101144843237' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428483'
                WHERE ordernumber = 'P181101145242825' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428485'
                WHERE ordernumber = 'P191101145524273' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '226148'
                WHERE ordernumber = 'P191101150142909' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '341135'
                WHERE ordernumber = 'P181101150239492' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428486'
                WHERE ordernumber = 'P771101150325633' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385258'
                WHERE ordernumber = 'P181101150330514' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379516'
                WHERE ordernumber = 'P421101151328217' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '303332'
                WHERE ordernumber = 'P181101151948344' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '363219'
                WHERE ordernumber = 'P421101152658526' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '173533'
                WHERE ordernumber = 'P191101152928322' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '194883'
                WHERE ordernumber = 'P771101153624159' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428489'
                WHERE ordernumber = 'P201101153706444' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428491'
                WHERE ordernumber = 'P191101154146182' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '11462'
                WHERE ordernumber = 'P191101154350996' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428490'
                WHERE ordernumber = 'P181101154455386' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391338'
                WHERE ordernumber = 'P191101154623493' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '281405'
                WHERE ordernumber = 'P771101155316316' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '121463'
                WHERE ordernumber = 'P201101155325576' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428495'
                WHERE ordernumber = 'P191101155829578' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428496'
                WHERE ordernumber = 'P201101160139293' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '279066'
                WHERE ordernumber = 'P191101160649478' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427223'
                WHERE ordernumber = 'P421101161407211' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '97870'
                WHERE ordernumber = 'P181101161729422' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '308957'
                WHERE ordernumber = 'P421101161733507' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '88092'
                WHERE ordernumber = 'P191101161936222' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '154281'
                WHERE ordernumber = 'P771101162323370' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428501'
                WHERE ordernumber = 'P421101162350495' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428500'
                WHERE ordernumber = 'P771101162553213' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428230'
                WHERE ordernumber = 'P191101162613119' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '104421'
                WHERE ordernumber = 'P201101164016861' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '399851'
                WHERE ordernumber = 'P631101170016777' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385996'
                WHERE ordernumber = 'P201101170524451' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '347176'
                WHERE ordernumber = 'P421101171041471' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '98980'
                WHERE ordernumber = 'P201101171344469' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428506'
                WHERE ordernumber = 'P201101172323340' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428504'
                WHERE ordernumber = 'P201101172534161' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428505'
                WHERE ordernumber = 'P771101172623173' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428507'
                WHERE ordernumber = 'P191101173037307' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '101822'
                WHERE ordernumber = 'P191101173438396' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428508'
                WHERE ordernumber = 'P771101173511282' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428509'
                WHERE ordernumber = 'P191101173617703' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '277657'
                WHERE ordernumber = 'P201101173808207' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377569'
                WHERE ordernumber = 'P421101174651143' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '254791'
                WHERE ordernumber = 'P421101174729126' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388942'
                WHERE ordernumber = 'P771101174839703' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428511'
                WHERE ordernumber = 'P201101175022612' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '366264'
                WHERE ordernumber = 'P181101175042999' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '366264'
                WHERE ordernumber = 'P181101175110423' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113282'
                WHERE ordernumber = 'P771101175650564' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428514'
                WHERE ordernumber = 'P201101175654462' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428513'
                WHERE ordernumber = 'P181101175723329' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428512'
                WHERE ordernumber = 'P181101180006231' 
            
2024-11-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396477'
                WHERE ordernumber = 'P421101180259211' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428517'
                WHERE ordernumber = 'P421101180443770' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428516'
                WHERE ordernumber = 'P201101180443350' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427068'
                WHERE ordernumber = 'P181101180517198' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '323537'
                WHERE ordernumber = 'P201101180637810' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349116'
                WHERE ordernumber = 'P191101180656995' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400886'
                WHERE ordernumber = 'P421101180902653' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '324599'
                WHERE ordernumber = 'P181101181113650' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302977'
                WHERE ordernumber = 'P591101181344885' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '156496'
                WHERE ordernumber = 'P201101181513405' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428518'
                WHERE ordernumber = 'P771101181533290' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428519'
                WHERE ordernumber = 'P181101181714522' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426525'
                WHERE ordernumber = 'P201101181759462' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271965'
                WHERE ordernumber = 'P421101181814656' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428520'
                WHERE ordernumber = 'P771101181849932' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '75542'
                WHERE ordernumber = 'P181101181902777' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428521'
                WHERE ordernumber = 'P421101182020869' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428522'
                WHERE ordernumber = 'P421101182026199' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282921'
                WHERE ordernumber = 'P181101182141547' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428518'
                WHERE ordernumber = 'P771101182218242' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428523'
                WHERE ordernumber = 'P201101182420438' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428518'
                WHERE ordernumber = 'P771101182552513' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428409'
                WHERE ordernumber = 'P181101182647715' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '261745'
                WHERE ordernumber = 'P181101182734829' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428524'
                WHERE ordernumber = 'P201101183659534' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '117105'
                WHERE ordernumber = 'P181101183820489' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315404'
                WHERE ordernumber = 'P181101184025729' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354306'
                WHERE ordernumber = 'P771101184326663' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424877'
                WHERE ordernumber = 'P181101184740392' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428515'
                WHERE ordernumber = 'P631101185104440' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237231'
                WHERE ordernumber = 'P181101185326555' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364567'
                WHERE ordernumber = 'P181101185421937' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428138'
                WHERE ordernumber = 'P421101185713156' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428528'
                WHERE ordernumber = 'P771101190038907' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428529'
                WHERE ordernumber = 'P191101190203163' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214370'
                WHERE ordernumber = 'P191101190308469' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428530'
                WHERE ordernumber = 'P201101190311327' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381667'
                WHERE ordernumber = 'P421101190441543' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275274'
                WHERE ordernumber = 'P191101191145860' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428531'
                WHERE ordernumber = 'P771101191207496' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428532'
                WHERE ordernumber = 'P771101192003809' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '142539'
                WHERE ordernumber = 'P191101192350790' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428534'
                WHERE ordernumber = 'P771101192631505' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428535'
                WHERE ordernumber = 'P191101192642447' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428533'
                WHERE ordernumber = 'P771101192859118' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428536'
                WHERE ordernumber = 'P191101193143454' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428537'
                WHERE ordernumber = 'P771101193559924' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428538'
                WHERE ordernumber = 'P201101193742909' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296118'
                WHERE ordernumber = 'P771101193755685' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '127159'
                WHERE ordernumber = 'P191101194214112' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '294793'
                WHERE ordernumber = 'P201101194255752' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214465'
                WHERE ordernumber = 'P191101194741620' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428539'
                WHERE ordernumber = 'P201101195020952' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '111810'
                WHERE ordernumber = 'P191101195020565' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '156518'
                WHERE ordernumber = 'P191101195431340' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '330651'
                WHERE ordernumber = 'P191101195546361' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428541'
                WHERE ordernumber = 'P771101200613676' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428542'
                WHERE ordernumber = 'P771101200732589' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428544'
                WHERE ordernumber = 'P771101201608206' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428543'
                WHERE ordernumber = 'P771101201858633' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428543'
                WHERE ordernumber = 'P771101201945721' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428547'
                WHERE ordernumber = 'P771101204633494' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428549'
                WHERE ordernumber = 'P771101211304679' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428550'
                WHERE ordernumber = 'P631101211735824' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428549'
                WHERE ordernumber = 'P771101212205266' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428549'
                WHERE ordernumber = 'P771101213520641' 
            
2024-11-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428553'
                WHERE ordernumber = 'P771101215256793'