2023-12-27 01:00:02 -- 將會員中心id寫入data-lake
2023-12-27 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 '2023-12-26%';
        
2023-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '257892'
                WHERE ordernumber = 'P201226110356571' 
            
2023-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355306'
                WHERE ordernumber = 'P201226110441916' 
            
2023-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '276194'
                WHERE ordernumber = 'P201226110922504' 
            
2023-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '268183'
                WHERE ordernumber = 'P201226111015931' 
            
2023-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '138084'
                WHERE ordernumber = 'P201226111629493' 
            
2023-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355309'
                WHERE ordernumber = 'P181226111919778' 
            
2023-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355310'
                WHERE ordernumber = 'P191226112253497' 
            
2023-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355311'
                WHERE ordernumber = 'P181226112420626' 
            
2023-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355312'
                WHERE ordernumber = 'P201226112625146' 
            
2023-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '342259'
                WHERE ordernumber = 'P201226112721856' 
            
2023-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355313'
                WHERE ordernumber = 'P421226112838760' 
            
2023-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '98980'
                WHERE ordernumber = 'P201226113252727' 
            
2023-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355315'
                WHERE ordernumber = 'P181226113304201' 
            
2023-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354675'
                WHERE ordernumber = 'P181226113647949' 
            
2023-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '212720'
                WHERE ordernumber = 'P191226113749137' 
            
2023-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '98841'
                WHERE ordernumber = 'P201226114615831' 
            
2023-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348733'
                WHERE ordernumber = 'P181226115435152' 
            
2023-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '132549'
                WHERE ordernumber = 'P181226115657352' 
            
2023-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355322'
                WHERE ordernumber = 'P201226120008428' 
            
2023-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '351205'
                WHERE ordernumber = 'P201226120528153' 
            
2023-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287688'
                WHERE ordernumber = 'P201226120759469' 
            
2023-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '337520'
                WHERE ordernumber = 'P181226121919692' 
            
2023-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '135801'
                WHERE ordernumber = 'P201226122311962' 
            
2023-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '136583'
                WHERE ordernumber = 'P201226122448799' 
            
2023-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P191226122746957' 
            
2023-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '306282'
                WHERE ordernumber = 'P201226122829900' 
            
2023-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '273510'
                WHERE ordernumber = 'P201226123029171' 
            
2023-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355333'
                WHERE ordernumber = 'P421226123243610' 
            
2023-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '93731'
                WHERE ordernumber = 'P191226123414472' 
            
2023-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '297814'
                WHERE ordernumber = 'P421226123424464' 
            
2023-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355335'
                WHERE ordernumber = 'P201226123718268' 
            
2023-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355336'
                WHERE ordernumber = 'P421226123759847' 
            
2023-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355337'
                WHERE ordernumber = 'P421226123937235' 
            
2023-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '338126'
                WHERE ordernumber = 'P421226124040141' 
            
2023-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355339'
                WHERE ordernumber = 'P201226124129454' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306440'
                WHERE ordernumber = 'P201226124223571' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '114174'
                WHERE ordernumber = 'P191226124850775' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '267840'
                WHERE ordernumber = 'P421226125107153' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '318866'
                WHERE ordernumber = 'P191226125109916' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355341'
                WHERE ordernumber = 'P191226125420241' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355342'
                WHERE ordernumber = 'P201226125454923' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '270523'
                WHERE ordernumber = 'P201226125814659' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284317'
                WHERE ordernumber = 'P191226130301347' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354517'
                WHERE ordernumber = 'P191226130520746' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355344'
                WHERE ordernumber = 'P191226130701363' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '246575'
                WHERE ordernumber = 'P201226130823994' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '135736'
                WHERE ordernumber = 'P201226131014467' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354960'
                WHERE ordernumber = 'P421226131121786' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355346'
                WHERE ordernumber = 'P421226131314712' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '229589'
                WHERE ordernumber = 'P191226131759864' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355349'
                WHERE ordernumber = 'P191226133010260' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355354'
                WHERE ordernumber = 'P191226134809451' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355356'
                WHERE ordernumber = 'P201226134815253' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355357'
                WHERE ordernumber = 'P191226134950408' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348946'
                WHERE ordernumber = 'P201226135408257' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355359'
                WHERE ordernumber = 'P191226135557537' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355358'
                WHERE ordernumber = 'P421226135805512' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349196'
                WHERE ordernumber = 'P201226140623988' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309980'
                WHERE ordernumber = 'P191226140636567' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355363'
                WHERE ordernumber = 'P201226140911224' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286509'
                WHERE ordernumber = 'P201226141307442' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355365'
                WHERE ordernumber = 'P201226141456265' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286509'
                WHERE ordernumber = 'P201226141741530' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355366'
                WHERE ordernumber = 'P191226141812423' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355367'
                WHERE ordernumber = 'P201226141830667' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338431'
                WHERE ordernumber = 'P201226141915793' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355371'
                WHERE ordernumber = 'P181226142944744' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228858'
                WHERE ordernumber = 'P201226143032576' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355372'
                WHERE ordernumber = 'P181226143044306' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240225'
                WHERE ordernumber = 'P181226143125187' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301501'
                WHERE ordernumber = 'P201226143142890' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355375'
                WHERE ordernumber = 'P201226143401585' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355377'
                WHERE ordernumber = 'P201226143622661' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P191226143812789' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '28872'
                WHERE ordernumber = 'P421226143835438' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P191226144127342' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P191226144346116' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P191226144516221' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247927'
                WHERE ordernumber = 'P181226144627815' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P191226144835934' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '132149'
                WHERE ordernumber = 'P181226145149657' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P191226145214915' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355381'
                WHERE ordernumber = 'P181226145351382' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P191226145708598' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '157366'
                WHERE ordernumber = 'P201226145908860' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352578'
                WHERE ordernumber = 'P201226150033276' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '164139'
                WHERE ordernumber = 'P201226150336396' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355384'
                WHERE ordernumber = 'P201226150557756' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230984'
                WHERE ordernumber = 'P201226150625642' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '115591'
                WHERE ordernumber = 'P201226150851512' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354429'
                WHERE ordernumber = 'P201226151245641' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355387'
                WHERE ordernumber = 'P181226152107407' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353647'
                WHERE ordernumber = 'P181226152340706' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '272846'
                WHERE ordernumber = 'P201226152731523' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355390'
                WHERE ordernumber = 'P181226152841792' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287197'
                WHERE ordernumber = 'P181226153743340' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287179'
                WHERE ordernumber = 'P421226153912296' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339700'
                WHERE ordernumber = 'P421226154140460' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355389'
                WHERE ordernumber = 'P191226154141273' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355389'
                WHERE ordernumber = 'P191226154209530' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355395'
                WHERE ordernumber = 'P181226154338588' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314823'
                WHERE ordernumber = 'P181226154544374' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '246575'
                WHERE ordernumber = 'P201226154630425' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353478'
                WHERE ordernumber = 'P201226154820804' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355398'
                WHERE ordernumber = 'P201226154923541' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355397'
                WHERE ordernumber = 'P181226154941572' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355389'
                WHERE ordernumber = 'P191226155036325' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '105984'
                WHERE ordernumber = 'P181226155045556' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355389'
                WHERE ordernumber = 'P191226155124323' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355400'
                WHERE ordernumber = 'P181226155355955' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355401'
                WHERE ordernumber = 'P201226155745984' 
            
2023-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355402'
                WHERE ordernumber = 'P201226155851918' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '320213'
                WHERE ordernumber = 'P421226155951414' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '314528'
                WHERE ordernumber = 'P181226160457766' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '165645'
                WHERE ordernumber = 'P421226161010880' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355404'
                WHERE ordernumber = 'P181226161016552' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '207841'
                WHERE ordernumber = 'P181226161312658' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '303366'
                WHERE ordernumber = 'P181226161536592' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355406'
                WHERE ordernumber = 'P181226161719190' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '207841'
                WHERE ordernumber = 'P181226161848729' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '318982'
                WHERE ordernumber = 'P181226162345562' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350875'
                WHERE ordernumber = 'P191226162535657' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '178334'
                WHERE ordernumber = 'P201226162548545' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '251499'
                WHERE ordernumber = 'P201226162726773' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355413'
                WHERE ordernumber = 'P181226162844238' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99205'
                WHERE ordernumber = 'P201226163606908' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '220701'
                WHERE ordernumber = 'P181226163804459' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355417'
                WHERE ordernumber = 'P201226164046342' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355420'
                WHERE ordernumber = 'P201226164605744' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355422'
                WHERE ordernumber = 'P201226164914347' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '116366'
                WHERE ordernumber = 'P201226165000371' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354770'
                WHERE ordernumber = 'P181226165229988' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355423'
                WHERE ordernumber = 'P201226165619216' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355424'
                WHERE ordernumber = 'P181226170011409' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355425'
                WHERE ordernumber = 'P421226170215510' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '331499'
                WHERE ordernumber = 'P201226170331351' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299257'
                WHERE ordernumber = 'P201226170636198' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355426'
                WHERE ordernumber = 'P201226170822673' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '318267'
                WHERE ordernumber = 'P201226171033899' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '255121'
                WHERE ordernumber = 'P181226171136943' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355428'
                WHERE ordernumber = 'P201226171226532' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355429'
                WHERE ordernumber = 'P421226171638333' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355430'
                WHERE ordernumber = 'P421226171817464' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313481'
                WHERE ordernumber = 'P181226172037358' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352731'
                WHERE ordernumber = 'P421226172046241' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351077'
                WHERE ordernumber = 'P201226172326219' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347176'
                WHERE ordernumber = 'P421226172558308' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '290667'
                WHERE ordernumber = 'P181226173437812' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245400'
                WHERE ordernumber = 'P201226173655628' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355433'
                WHERE ordernumber = 'P201226173801411' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355435'
                WHERE ordernumber = 'P201226173944380' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '293077'
                WHERE ordernumber = 'P181226174003200' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '309861'
                WHERE ordernumber = 'P181226174214837' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '254176'
                WHERE ordernumber = 'P201226175005234' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '254176'
                WHERE ordernumber = 'P201226175028326' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '269765'
                WHERE ordernumber = 'P421226175218613' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '168325'
                WHERE ordernumber = 'P201226175257385' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '316679'
                WHERE ordernumber = 'P201226180316578' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '316679'
                WHERE ordernumber = 'P201226180434255' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '123771'
                WHERE ordernumber = 'P181226180509292' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355444'
                WHERE ordernumber = 'P421226180742212' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '252254'
                WHERE ordernumber = 'P201226181624254' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345232'
                WHERE ordernumber = 'P421226183411503' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351056'
                WHERE ordernumber = 'P191226183453669' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100706'
                WHERE ordernumber = 'P181226183706868' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237882'
                WHERE ordernumber = 'P201226183709358' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '159425'
                WHERE ordernumber = 'P201226184028141' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '167291'
                WHERE ordernumber = 'P201226184136191' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355449'
                WHERE ordernumber = 'P181226184219459' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355451'
                WHERE ordernumber = 'P181226184425286' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355450'
                WHERE ordernumber = 'P191226184429271' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355351'
                WHERE ordernumber = 'P201226185953401' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355351'
                WHERE ordernumber = 'P201226190049833' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355455'
                WHERE ordernumber = 'P191226190217661' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355456'
                WHERE ordernumber = 'P201226190242254' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '241097'
                WHERE ordernumber = 'P201226190308807' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '135372'
                WHERE ordernumber = 'P201226190343749' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355456'
                WHERE ordernumber = 'P201226190515480' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100218'
                WHERE ordernumber = 'P191226190545318' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355460'
                WHERE ordernumber = 'P201226192122785' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354267'
                WHERE ordernumber = 'P191226192511282' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351928'
                WHERE ordernumber = 'P421226192615739' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '158709'
                WHERE ordernumber = 'P201226192902636' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '121004'
                WHERE ordernumber = 'P191226193020357' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355462'
                WHERE ordernumber = 'P421226193138350' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355464'
                WHERE ordernumber = 'P421226193431484' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '209842'
                WHERE ordernumber = 'P191226194155762' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355465'
                WHERE ordernumber = 'P201226194418968' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355466'
                WHERE ordernumber = 'P201226194521300' 
            
2023-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355468'
                WHERE ordernumber = 'P191226194758148' 
            
2023-12-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355470'
                WHERE ordernumber = 'P201226195911149'