2024-03-03 01:00:01 -- 將會員中心id寫入data-lake
2024-03-03 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-03-02%';
        
2024-03-03 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '371977'
                WHERE ordernumber = 'P420302103039204' 
            
2024-03-03 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '224581'
                WHERE ordernumber = 'P180302110429388' 
            
2024-03-03 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '316340'
                WHERE ordernumber = 'P180302110606823' 
            
2024-03-03 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '379683'
                WHERE ordernumber = 'P590302110839418' 
            
2024-03-03 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '379684'
                WHERE ordernumber = 'P180302110918867' 
            
2024-03-03 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '378112'
                WHERE ordernumber = 'P420302110949635' 
            
2024-03-03 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '231264'
                WHERE ordernumber = 'P180302111003288' 
            
2024-03-03 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '354422'
                WHERE ordernumber = 'P180302111325482' 
            
2024-03-03 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '277586'
                WHERE ordernumber = 'P200302111355660' 
            
2024-03-03 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '379685'
                WHERE ordernumber = 'P200302111507993' 
            
2024-03-03 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '232171'
                WHERE ordernumber = 'P180302111547134' 
            
2024-03-03 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '277586'
                WHERE ordernumber = 'P200302111611807' 
            
2024-03-03 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '232171'
                WHERE ordernumber = 'P180302111815762' 
            
2024-03-03 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '256175'
                WHERE ordernumber = 'P180302112157894' 
            
2024-03-03 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '378985'
                WHERE ordernumber = 'P180302112444217' 
            
2024-03-03 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '348437'
                WHERE ordernumber = 'P190302113937428' 
            
2024-03-03 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '379688'
                WHERE ordernumber = 'P190302114016927' 
            
2024-03-03 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '339004'
                WHERE ordernumber = 'P180302114405769' 
            
2024-03-03 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '379689'
                WHERE ordernumber = 'P190302114653891' 
            
2024-03-03 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '299361'
                WHERE ordernumber = 'P190302114755940' 
            
2024-03-03 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '379691'
                WHERE ordernumber = 'P180302120409163' 
            
2024-03-03 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '167202'
                WHERE ordernumber = 'P180302121216735' 
            
2024-03-03 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '379693'
                WHERE ordernumber = 'P420302122443553' 
            
2024-03-03 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '356331'
                WHERE ordernumber = 'P180302122941212' 
            
2024-03-03 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '375458'
                WHERE ordernumber = 'P180302123225672' 
            
2024-03-03 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '276095'
                WHERE ordernumber = 'P200302123633207' 
            
2024-03-03 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '334590'
                WHERE ordernumber = 'P420302124300585' 
            
2024-03-03 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '379696'
                WHERE ordernumber = 'P180302124327647' 
            
2024-03-03 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '290308'
                WHERE ordernumber = 'P200302124559388' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '260890'
                WHERE ordernumber = 'P180302125409183' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '1112'
                WHERE ordernumber = 'P180302125536871' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '327936'
                WHERE ordernumber = 'P200302130150839' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '336710'
                WHERE ordernumber = 'P180302130335883' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '298283'
                WHERE ordernumber = 'P420302130517165' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379698'
                WHERE ordernumber = 'P420302131024642' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '344631'
                WHERE ordernumber = 'P420302131234827' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379699'
                WHERE ordernumber = 'P180302131344630' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353651'
                WHERE ordernumber = 'P200302131447450' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '343385'
                WHERE ordernumber = 'P180302131506870' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379694'
                WHERE ordernumber = 'P590302132245293' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '298121'
                WHERE ordernumber = 'P180302132919289' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '72166'
                WHERE ordernumber = 'P420302133200459' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379701'
                WHERE ordernumber = 'P180302133640887' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '359804'
                WHERE ordernumber = 'P420302134152936' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379703'
                WHERE ordernumber = 'P180302134230112' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379704'
                WHERE ordernumber = 'P420302134443498' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379705'
                WHERE ordernumber = 'P180302134603952' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379706'
                WHERE ordernumber = 'P180302135050668' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '368824'
                WHERE ordernumber = 'P200302135520355' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '245591'
                WHERE ordernumber = 'P180302135632179' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379710'
                WHERE ordernumber = 'P200302135645670' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '95283'
                WHERE ordernumber = 'P200302135812324' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379711'
                WHERE ordernumber = 'P180302135953294' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379713'
                WHERE ordernumber = 'P190302140050326' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379712'
                WHERE ordernumber = 'P420302140051505' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '306373'
                WHERE ordernumber = 'P190302140405724' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '250676'
                WHERE ordernumber = 'P200302140442593' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379715'
                WHERE ordernumber = 'P180302140731858' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379707'
                WHERE ordernumber = 'P420302140814661' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379716'
                WHERE ordernumber = 'P180302140851470' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379707'
                WHERE ordernumber = 'P420302140909407' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '316459'
                WHERE ordernumber = 'P180302141132669' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379714'
                WHERE ordernumber = 'P590302141313936' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379717'
                WHERE ordernumber = 'P200302141357688' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '289287'
                WHERE ordernumber = 'P190302141531519' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379718'
                WHERE ordernumber = 'P180302141630700' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379720'
                WHERE ordernumber = 'P420302141939147' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379719'
                WHERE ordernumber = 'P190302142111556' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379722'
                WHERE ordernumber = 'P200302142237964' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379723'
                WHERE ordernumber = 'P180302142328386' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379723'
                WHERE ordernumber = 'P180302142634628' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379725'
                WHERE ordernumber = 'P420302143142873' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379726'
                WHERE ordernumber = 'P420302143250991' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379430'
                WHERE ordernumber = 'P180302143702967' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '209083'
                WHERE ordernumber = 'P420302144201183' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '220427'
                WHERE ordernumber = 'P200302144527695' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377262'
                WHERE ordernumber = 'P420302144926557' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '294187'
                WHERE ordernumber = 'P200302145559426' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '116372'
                WHERE ordernumber = 'P180302145737489' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379729'
                WHERE ordernumber = 'P180302145910485' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '312679'
                WHERE ordernumber = 'P200302145913314' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354412'
                WHERE ordernumber = 'P190302150105895' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379731'
                WHERE ordernumber = 'P180302150828119' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379732'
                WHERE ordernumber = 'P420302150913698' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283444'
                WHERE ordernumber = 'P190302151225412' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '341364'
                WHERE ordernumber = 'P200302151349787' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379733'
                WHERE ordernumber = 'P180302151555600' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379735'
                WHERE ordernumber = 'P190302151723648' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '358771'
                WHERE ordernumber = 'P180302152515669' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379736'
                WHERE ordernumber = 'P190302152529809' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379737'
                WHERE ordernumber = 'P180302152618992' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379738'
                WHERE ordernumber = 'P420302153004191' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379739'
                WHERE ordernumber = 'P180302153027338' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379740'
                WHERE ordernumber = 'P190302153313159' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379742'
                WHERE ordernumber = 'P420302154234955' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379743'
                WHERE ordernumber = 'P180302154651472' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '62550'
                WHERE ordernumber = 'P180302154757818' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283250'
                WHERE ordernumber = 'P190302155012210' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379745'
                WHERE ordernumber = 'P590302155502477' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379747'
                WHERE ordernumber = 'P180302155613553' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379746'
                WHERE ordernumber = 'P190302155731411' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '267164'
                WHERE ordernumber = 'P180302155813823' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '245075'
                WHERE ordernumber = 'P200302160058657' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '320606'
                WHERE ordernumber = 'P180302160104412' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379748'
                WHERE ordernumber = 'P200302160232226' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379750'
                WHERE ordernumber = 'P420302160824507' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379751'
                WHERE ordernumber = 'P180302161128313' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371056'
                WHERE ordernumber = 'P420302161152216' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '105590'
                WHERE ordernumber = 'P180302161807874' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379755'
                WHERE ordernumber = 'P180302161943762' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '312854'
                WHERE ordernumber = 'P200302162036764' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379752'
                WHERE ordernumber = 'P180302162039678' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '112568'
                WHERE ordernumber = 'P180302162418114' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353514'
                WHERE ordernumber = 'P190302162629171' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '112568'
                WHERE ordernumber = 'P180302162704218' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '97446'
                WHERE ordernumber = 'P190302162812428' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '94256'
                WHERE ordernumber = 'P180302162923369' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379758'
                WHERE ordernumber = 'P420302163724776' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '345891'
                WHERE ordernumber = 'P180302163826468' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349895'
                WHERE ordernumber = 'P200302164010684' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379759'
                WHERE ordernumber = 'P180302164146871' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '218323'
                WHERE ordernumber = 'P190302164252353' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379760'
                WHERE ordernumber = 'P190302164359569' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '244313'
                WHERE ordernumber = 'P180302164402703' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '123995'
                WHERE ordernumber = 'P190302164442678' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '239817'
                WHERE ordernumber = 'P200302164601282' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '244313'
                WHERE ordernumber = 'P180302164629121' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '340415'
                WHERE ordernumber = 'P200302164644359' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '135534'
                WHERE ordernumber = 'P420302165133616' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379762'
                WHERE ordernumber = 'P200302165359539' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379764'
                WHERE ordernumber = 'P180302165731935' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '306884'
                WHERE ordernumber = 'P190302170138498' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '317056'
                WHERE ordernumber = 'P200302170327442' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '273535'
                WHERE ordernumber = 'P190302170335198' 
            
2024-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '238134'
                WHERE ordernumber = 'P200302171020288' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '250780'
                WHERE ordernumber = 'P200302171219710' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379661'
                WHERE ordernumber = 'P190302171316939' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378428'
                WHERE ordernumber = 'P180302171404288' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379765'
                WHERE ordernumber = 'P200302172050340' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247871'
                WHERE ordernumber = 'P190302172122195' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379766'
                WHERE ordernumber = 'P180302172415166' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379767'
                WHERE ordernumber = 'P190302172437237' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379769'
                WHERE ordernumber = 'P180302172544302' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379770'
                WHERE ordernumber = 'P180302172747305' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379771'
                WHERE ordernumber = 'P420302172827598' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379772'
                WHERE ordernumber = 'P190302172848209' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379774'
                WHERE ordernumber = 'P190302173359465' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379776'
                WHERE ordernumber = 'P180302174828122' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379778'
                WHERE ordernumber = 'P180302174907808' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379779'
                WHERE ordernumber = 'P180302175950845' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379781'
                WHERE ordernumber = 'P190302180051860' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379780'
                WHERE ordernumber = 'P420302180215126' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379782'
                WHERE ordernumber = 'P200302180318805' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379783'
                WHERE ordernumber = 'P420302180733142' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379784'
                WHERE ordernumber = 'P180302180805851' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379786'
                WHERE ordernumber = 'P180302181533772' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379785'
                WHERE ordernumber = 'P420302181555787' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '321837'
                WHERE ordernumber = 'P180302181931131' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '86113'
                WHERE ordernumber = 'P180302182002661' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379789'
                WHERE ordernumber = 'P180302182523507' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379790'
                WHERE ordernumber = 'P180302182817426' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379793'
                WHERE ordernumber = 'P180302183832858' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '161128'
                WHERE ordernumber = 'P590302184834499' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379795'
                WHERE ordernumber = 'P420302184857788' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379797'
                WHERE ordernumber = 'P190302190017247' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93821'
                WHERE ordernumber = 'P190302190319870' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344579'
                WHERE ordernumber = 'P200302190729574' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379798'
                WHERE ordernumber = 'P420302190822933' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379799'
                WHERE ordernumber = 'P190302191416931' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '141806'
                WHERE ordernumber = 'P190302191523333' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '137127'
                WHERE ordernumber = 'P190302191946173' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286713'
                WHERE ordernumber = 'P190302192102921' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379800'
                WHERE ordernumber = 'P190302192227396' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351673'
                WHERE ordernumber = 'P190302192629286' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '360375'
                WHERE ordernumber = 'P420302193234252' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365102'
                WHERE ordernumber = 'P200302193434728' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379802'
                WHERE ordernumber = 'P190302193441197' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379803'
                WHERE ordernumber = 'P590302194541327' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379804'
                WHERE ordernumber = 'P420302195203116' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379806'
                WHERE ordernumber = 'P190302195613465' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379807'
                WHERE ordernumber = 'P190302195706397' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378810'
                WHERE ordernumber = 'P420302200052331' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379808'
                WHERE ordernumber = 'P590302200754588' 
            
2024-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379811'
                WHERE ordernumber = 'P590302213246803'