2024-07-09 01:00:02 -- 將會員中心id寫入data-lake
2024-07-09 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-07-08%';
        
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400324'
                WHERE ordernumber = 'P630708104836130' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240347'
                WHERE ordernumber = 'P630708105814462' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '143539'
                WHERE ordernumber = 'P420708110014473' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400325'
                WHERE ordernumber = 'P630708110423708' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '253710'
                WHERE ordernumber = 'P180708111707679' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400327'
                WHERE ordernumber = 'P630708111843774' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400328'
                WHERE ordernumber = 'P630708112122705' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247164'
                WHERE ordernumber = 'P200708112243186' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349042'
                WHERE ordernumber = 'P420708112255755' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97952'
                WHERE ordernumber = 'P200708112419755' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400330'
                WHERE ordernumber = 'P420708113106309' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400331'
                WHERE ordernumber = 'P420708113221265' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389788'
                WHERE ordernumber = 'P420708113648881' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81970'
                WHERE ordernumber = 'P180708113835920' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400332'
                WHERE ordernumber = 'P180708114110500' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400333'
                WHERE ordernumber = 'P180708114553468' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235865'
                WHERE ordernumber = 'P630708114835781' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P190708115241700' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400335'
                WHERE ordernumber = 'P180708115404232' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400336'
                WHERE ordernumber = 'P630708115603717' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400334'
                WHERE ordernumber = 'P190708115649238' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400334'
                WHERE ordernumber = 'P190708115717370' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P200708115843609' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400317'
                WHERE ordernumber = 'P200708115937302' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296345'
                WHERE ordernumber = 'P180708120001539' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '142556'
                WHERE ordernumber = 'P200708120036224' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400337'
                WHERE ordernumber = 'P180708120351970' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '258070'
                WHERE ordernumber = 'P200708120850724' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '363084'
                WHERE ordernumber = 'P420708120955930' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '123629'
                WHERE ordernumber = 'P200708121127629' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399471'
                WHERE ordernumber = 'P200708122433821' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400342'
                WHERE ordernumber = 'P200708122901601' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '133915'
                WHERE ordernumber = 'P180708122906702' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400303'
                WHERE ordernumber = 'P180708123117670' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400303'
                WHERE ordernumber = 'P180708123209886' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301918'
                WHERE ordernumber = 'P420708123242773' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '63815'
                WHERE ordernumber = 'P190708123729342' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399967'
                WHERE ordernumber = 'P190708123916892' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400347'
                WHERE ordernumber = 'P200708124015117' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400346'
                WHERE ordernumber = 'P420708124026572' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400348'
                WHERE ordernumber = 'P420708124154301' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398160'
                WHERE ordernumber = 'P420708125123511' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400350'
                WHERE ordernumber = 'P420708130119281' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '312204'
                WHERE ordernumber = 'P180708130952795' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400352'
                WHERE ordernumber = 'P200708131348386' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96489'
                WHERE ordernumber = 'P420708131426402' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400354'
                WHERE ordernumber = 'P190708132158142' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400355'
                WHERE ordernumber = 'P200708132423946' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400356'
                WHERE ordernumber = 'P180708133125823' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400357'
                WHERE ordernumber = 'P200708133337230' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '115097'
                WHERE ordernumber = 'P180708133437169' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103407'
                WHERE ordernumber = 'P190708133557276' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399580'
                WHERE ordernumber = 'P420708134205327' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400358'
                WHERE ordernumber = 'P200708134324868' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304662'
                WHERE ordernumber = 'P200708134452244' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '336933'
                WHERE ordernumber = 'P420708135802879' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286460'
                WHERE ordernumber = 'P180708140430435' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338623'
                WHERE ordernumber = 'P180708140532661' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400361'
                WHERE ordernumber = 'P180708140855327' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296572'
                WHERE ordernumber = 'P200708141610140' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400363'
                WHERE ordernumber = 'P180708141854432' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341905'
                WHERE ordernumber = 'P180708142450919' 
            
2024-07-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100061'
                WHERE ordernumber = 'P180708143246992' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400364'
                WHERE ordernumber = 'P420708143320987' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400365'
                WHERE ordernumber = 'P420708143516195' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400366'
                WHERE ordernumber = 'P420708143617292' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400367'
                WHERE ordernumber = 'P180708143802223' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398146'
                WHERE ordernumber = 'P630708144035992' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342030'
                WHERE ordernumber = 'P200708144242654' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99817'
                WHERE ordernumber = 'P180708144337395' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400369'
                WHERE ordernumber = 'P180708144532166' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '135376'
                WHERE ordernumber = 'P190708144608789' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400370'
                WHERE ordernumber = 'P200708150522527' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400371'
                WHERE ordernumber = 'P180708150643142' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '130789'
                WHERE ordernumber = 'P180708151033604' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392979'
                WHERE ordernumber = 'P420708151118308' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400372'
                WHERE ordernumber = 'P190708151128600' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400373'
                WHERE ordernumber = 'P420708151844642' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380305'
                WHERE ordernumber = 'P190708151856937' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400374'
                WHERE ordernumber = 'P190708152125886' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389248'
                WHERE ordernumber = 'P200708152957393' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114640'
                WHERE ordernumber = 'P630708153107560' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400375'
                WHERE ordernumber = 'P200708153224549' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '164904'
                WHERE ordernumber = 'P420708153543958' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '121900'
                WHERE ordernumber = 'P420708153725567' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400377'
                WHERE ordernumber = 'P190708154333989' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400380'
                WHERE ordernumber = 'P200708154958779' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399413'
                WHERE ordernumber = 'P190708155332991' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400381'
                WHERE ordernumber = 'P190708155827331' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400382'
                WHERE ordernumber = 'P200708160017610' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '323598'
                WHERE ordernumber = 'P420708160436718' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400383'
                WHERE ordernumber = 'P180708161203742' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400384'
                WHERE ordernumber = 'P200708161307599' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281666'
                WHERE ordernumber = 'P180708162016257' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '67650'
                WHERE ordernumber = 'P200708162352660' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400385'
                WHERE ordernumber = 'P190708163125719' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400385'
                WHERE ordernumber = 'P190708163138574' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '158635'
                WHERE ordernumber = 'P180708163428774' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392970'
                WHERE ordernumber = 'P420708164132306' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '217365'
                WHERE ordernumber = 'P200708164332162' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '123995'
                WHERE ordernumber = 'P190708164902710' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400387'
                WHERE ordernumber = 'P200708165032850' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400389'
                WHERE ordernumber = 'P180708165630818' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400388'
                WHERE ordernumber = 'P630708165644255' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400390'
                WHERE ordernumber = 'P180708165804959' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400391'
                WHERE ordernumber = 'P180708170056421' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400392'
                WHERE ordernumber = 'P200708170437850' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400393'
                WHERE ordernumber = 'P180708170626982' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386438'
                WHERE ordernumber = 'P180708171353822' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '308520'
                WHERE ordernumber = 'P200708171520498' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400395'
                WHERE ordernumber = 'P420708172052703' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400397'
                WHERE ordernumber = 'P200708172538241' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '375964'
                WHERE ordernumber = 'P200708172800713' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397861'
                WHERE ordernumber = 'P190708173054157' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400399'
                WHERE ordernumber = 'P190708173617377' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '108089'
                WHERE ordernumber = 'P200708173718436' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400400'
                WHERE ordernumber = 'P420708173952172' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400401'
                WHERE ordernumber = 'P420708174131561' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '243898'
                WHERE ordernumber = 'P200708174509499' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238978'
                WHERE ordernumber = 'P180708174656549' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '324420'
                WHERE ordernumber = 'P200708174757932' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343549'
                WHERE ordernumber = 'P200708174844830' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400403'
                WHERE ordernumber = 'P420708174909653' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '95365'
                WHERE ordernumber = 'P200708175404197' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '95365'
                WHERE ordernumber = 'P200708175438912' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400404'
                WHERE ordernumber = 'P420708175716207' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400406'
                WHERE ordernumber = 'P420708180626988' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400407'
                WHERE ordernumber = 'P180708181105779' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400408'
                WHERE ordernumber = 'P190708181130432' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396249'
                WHERE ordernumber = 'P180708181158873' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389301'
                WHERE ordernumber = 'P200708181315706' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400409'
                WHERE ordernumber = 'P180708181534543' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400410'
                WHERE ordernumber = 'P420708181851395' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399563'
                WHERE ordernumber = 'P200708181905442' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399563'
                WHERE ordernumber = 'P200708182024590' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '164298'
                WHERE ordernumber = 'P180708182122761' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352316'
                WHERE ordernumber = 'P200708182222362' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400412'
                WHERE ordernumber = 'P180708182624691' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '122128'
                WHERE ordernumber = 'P200708182936326' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400413'
                WHERE ordernumber = 'P630708183519936' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400414'
                WHERE ordernumber = 'P420708184014798' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400415'
                WHERE ordernumber = 'P180708184026947' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387534'
                WHERE ordernumber = 'P180708184120983' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400415'
                WHERE ordernumber = 'P180708184504665' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '319905'
                WHERE ordernumber = 'P180708184628840' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394994'
                WHERE ordernumber = 'P420708185224476' 
            
2024-07-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400418'
                WHERE ordernumber = 'P200708191150232' 
            
2024-07-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400419'
                WHERE ordernumber = 'P190708191537371' 
            
2024-07-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '391255'
                WHERE ordernumber = 'P200708191543564' 
            
2024-07-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '285581'
                WHERE ordernumber = 'P200708191735374' 
            
2024-07-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '380678'
                WHERE ordernumber = 'P200708191920836' 
            
2024-07-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399835'
                WHERE ordernumber = 'P190708192324121' 
            
2024-07-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '101457'
                WHERE ordernumber = 'P200708192657712' 
            
2024-07-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '54414'
                WHERE ordernumber = 'P190708192809781' 
            
2024-07-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400421'
                WHERE ordernumber = 'P200708194440310' 
            
2024-07-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400423'
                WHERE ordernumber = 'P190708194625867' 
            
2024-07-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400422'
                WHERE ordernumber = 'P200708194713662' 
            
2024-07-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '282597'
                WHERE ordernumber = 'P200708194815477' 
            
2024-07-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '332662'
                WHERE ordernumber = 'P190708194906513' 
            
2024-07-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '182079'
                WHERE ordernumber = 'P200708194913975' 
            
2024-07-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '137870'
                WHERE ordernumber = 'P200708195122558' 
            
2024-07-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400424'
                WHERE ordernumber = 'P190708195157229' 
            
2024-07-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '291037'
                WHERE ordernumber = 'P630708195724629' 
            
2024-07-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400425'
                WHERE ordernumber = 'P200708195808869'