2024-07-14 01:00:03 -- 將會員中心id寫入data-lake
2024-07-14 01:00:03 -- 
            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-13%';
        
2024-07-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401038'
                WHERE ordernumber = 'P630713100600775' 
            
2024-07-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401039'
                WHERE ordernumber = 'P630713100925673' 
            
2024-07-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401041'
                WHERE ordernumber = 'P630713103617212' 
            
2024-07-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401042'
                WHERE ordernumber = 'P630713103834143' 
            
2024-07-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392765'
                WHERE ordernumber = 'P180713110222815' 
            
2024-07-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401043'
                WHERE ordernumber = 'P180713110329803' 
            
2024-07-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401044'
                WHERE ordernumber = 'P420713110516320' 
            
2024-07-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394866'
                WHERE ordernumber = 'P200713110830724' 
            
2024-07-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401045'
                WHERE ordernumber = 'P200713111148574' 
            
2024-07-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401046'
                WHERE ordernumber = 'P180713111212721' 
            
2024-07-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '320695'
                WHERE ordernumber = 'P420713111227237' 
            
2024-07-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401047'
                WHERE ordernumber = 'P200713111338691' 
            
2024-07-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '88985'
                WHERE ordernumber = 'P180713111535632' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '308457'
                WHERE ordernumber = 'P190713111548699' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '1704'
                WHERE ordernumber = 'P630713111651490' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '121900'
                WHERE ordernumber = 'P200713111731201' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96308'
                WHERE ordernumber = 'P200713111916628' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401048'
                WHERE ordernumber = 'P630713112108677' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '241583'
                WHERE ordernumber = 'P180713112141429' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401049'
                WHERE ordernumber = 'P190713112301993' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401050'
                WHERE ordernumber = 'P420713112436886' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '216932'
                WHERE ordernumber = 'P420713112631184' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '376557'
                WHERE ordernumber = 'P180713112711315' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401051'
                WHERE ordernumber = 'P180713112757731' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401052'
                WHERE ordernumber = 'P420713112816329' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401054'
                WHERE ordernumber = 'P180713113001136' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401055'
                WHERE ordernumber = 'P200713113127416' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401056'
                WHERE ordernumber = 'P200713113626872' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401057'
                WHERE ordernumber = 'P420713113852970' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401058'
                WHERE ordernumber = 'P180713114112822' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401059'
                WHERE ordernumber = 'P180713114539714' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400137'
                WHERE ordernumber = 'P190713114648331' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401060'
                WHERE ordernumber = 'P180713114753430' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401061'
                WHERE ordernumber = 'P420713115058373' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '368596'
                WHERE ordernumber = 'P420713115257330' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401063'
                WHERE ordernumber = 'P630713115624513' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '309442'
                WHERE ordernumber = 'P180713115914615' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401064'
                WHERE ordernumber = 'P630713115935196' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '32451'
                WHERE ordernumber = 'P420713120054418' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401065'
                WHERE ordernumber = 'P630713120244302' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401066'
                WHERE ordernumber = 'P200713120250535' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401067'
                WHERE ordernumber = 'P630713120438240' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349196'
                WHERE ordernumber = 'P200713120601492' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401068'
                WHERE ordernumber = 'P180713120924372' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401069'
                WHERE ordernumber = 'P180713121816316' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386445'
                WHERE ordernumber = 'P420713121838630' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386830'
                WHERE ordernumber = 'P190713121855754' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '327698'
                WHERE ordernumber = 'P200713122101721' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313332'
                WHERE ordernumber = 'P200713122240947' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '65830'
                WHERE ordernumber = 'P200713122344503' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '82781'
                WHERE ordernumber = 'P180713122421643' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401071'
                WHERE ordernumber = 'P420713122623552' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400930'
                WHERE ordernumber = 'P420713122744197' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400930'
                WHERE ordernumber = 'P420713122825438' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236805'
                WHERE ordernumber = 'P200713122956879' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180713123010264' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401074'
                WHERE ordernumber = 'P630713123506529' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401075'
                WHERE ordernumber = 'P630713123605206' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401076'
                WHERE ordernumber = 'P180713123652133' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '311531'
                WHERE ordernumber = 'P180713124603525' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401078'
                WHERE ordernumber = 'P420713124834478' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401079'
                WHERE ordernumber = 'P420713125050713' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401081'
                WHERE ordernumber = 'P180713125210527' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401082'
                WHERE ordernumber = 'P190713125223429' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401083'
                WHERE ordernumber = 'P200713125319266' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401084'
                WHERE ordernumber = 'P200713125520804' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401086'
                WHERE ordernumber = 'P420713125832673' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401085'
                WHERE ordernumber = 'P630713125901539' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372305'
                WHERE ordernumber = 'P200713125903473' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401087'
                WHERE ordernumber = 'P630713130128436' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401088'
                WHERE ordernumber = 'P630713130253992' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '137433'
                WHERE ordernumber = 'P200713130559260' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401089'
                WHERE ordernumber = 'P420713130749405' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401090'
                WHERE ordernumber = 'P180713131020822' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '234157'
                WHERE ordernumber = 'P200713131027903' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401091'
                WHERE ordernumber = 'P190713131139186' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401000'
                WHERE ordernumber = 'P200713131307253' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287880'
                WHERE ordernumber = 'P190713131333520' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399061'
                WHERE ordernumber = 'P180713131429159' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '138293'
                WHERE ordernumber = 'P190713131505871' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400378'
                WHERE ordernumber = 'P180713131719361' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '123038'
                WHERE ordernumber = 'P630713131850427' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397203'
                WHERE ordernumber = 'P630713131947741' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '258964'
                WHERE ordernumber = 'P200713132147538' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '72774'
                WHERE ordernumber = 'P200713132415536' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '218050'
                WHERE ordernumber = 'P180713132508565' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401093'
                WHERE ordernumber = 'P420713132704117' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '279381'
                WHERE ordernumber = 'P200713132818523' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401094'
                WHERE ordernumber = 'P630713132905783' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299858'
                WHERE ordernumber = 'P420713132943545' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401095'
                WHERE ordernumber = 'P180713133512651' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401096'
                WHERE ordernumber = 'P200713133602276' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353020'
                WHERE ordernumber = 'P190713133703546' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401097'
                WHERE ordernumber = 'P180713133716865' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401099'
                WHERE ordernumber = 'P190713135144310' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401100'
                WHERE ordernumber = 'P200713135243227' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366142'
                WHERE ordernumber = 'P180713135644807' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382354'
                WHERE ordernumber = 'P420713135716912' 
            
2024-07-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345359'
                WHERE ordernumber = 'P200713140248276' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P180713140317637' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352120'
                WHERE ordernumber = 'P180713140445510' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401102'
                WHERE ordernumber = 'P420713140609907' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '283209'
                WHERE ordernumber = 'P180713140738252' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401103'
                WHERE ordernumber = 'P420713140742374' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '390387'
                WHERE ordernumber = 'P420713140914269' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401104'
                WHERE ordernumber = 'P200713141045260' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388269'
                WHERE ordernumber = 'P180713141106179' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401105'
                WHERE ordernumber = 'P420713141239948' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401106'
                WHERE ordernumber = 'P200713141325591' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401108'
                WHERE ordernumber = 'P200713141515273' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '231741'
                WHERE ordernumber = 'P420713141643898' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401109'
                WHERE ordernumber = 'P180713141842709' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401110'
                WHERE ordernumber = 'P180713142132748' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401111'
                WHERE ordernumber = 'P180713142313997' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '385363'
                WHERE ordernumber = 'P420713142426643' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '319963'
                WHERE ordernumber = 'P630713142508420' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401112'
                WHERE ordernumber = 'P180713143131684' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401113'
                WHERE ordernumber = 'P190713143317201' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '62550'
                WHERE ordernumber = 'P180713143511997' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '130447'
                WHERE ordernumber = 'P180713143714849' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '392245'
                WHERE ordernumber = 'P180713143949679' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401114'
                WHERE ordernumber = 'P420713144112750' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '321680'
                WHERE ordernumber = 'P180713144302670' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '295766'
                WHERE ordernumber = 'P200713144713399' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '390693'
                WHERE ordernumber = 'P190713144857324' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '387084'
                WHERE ordernumber = 'P420713145200126' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401116'
                WHERE ordernumber = 'P180713145831352' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401115'
                WHERE ordernumber = 'P200713145858147' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401117'
                WHERE ordernumber = 'P200713150015531' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401118'
                WHERE ordernumber = 'P190713150025796' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377884'
                WHERE ordernumber = 'P180713150124928' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '323649'
                WHERE ordernumber = 'P190713150144745' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '301501'
                WHERE ordernumber = 'P200713150205226' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401119'
                WHERE ordernumber = 'P200713150816513' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '378270'
                WHERE ordernumber = 'P180713151043666' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401120'
                WHERE ordernumber = 'P420713151054470' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '283241'
                WHERE ordernumber = 'P180713151219158' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '221131'
                WHERE ordernumber = 'P180713151306255' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401121'
                WHERE ordernumber = 'P180713151518265' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401122'
                WHERE ordernumber = 'P190713151547154' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401123'
                WHERE ordernumber = 'P180713151627129' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401124'
                WHERE ordernumber = 'P190713151704219' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401125'
                WHERE ordernumber = 'P180713151832516' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401126'
                WHERE ordernumber = 'P180713152000176' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401127'
                WHERE ordernumber = 'P190713152027285' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400345'
                WHERE ordernumber = 'P180713152234162' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400345'
                WHERE ordernumber = 'P180713152307768' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401128'
                WHERE ordernumber = 'P180713152548483' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401129'
                WHERE ordernumber = 'P420713152719366' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401131'
                WHERE ordernumber = 'P180713153138383' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401129'
                WHERE ordernumber = 'P420713153340463' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401133'
                WHERE ordernumber = 'P420713153544984' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '166182'
                WHERE ordernumber = 'P180713153733787' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388254'
                WHERE ordernumber = 'P420713153937654' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401135'
                WHERE ordernumber = 'P180713154036897' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401134'
                WHERE ordernumber = 'P200713154048537' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401136'
                WHERE ordernumber = 'P200713154150561' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401137'
                WHERE ordernumber = 'P180713154346609' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401139'
                WHERE ordernumber = 'P190713154606899' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401138'
                WHERE ordernumber = 'P180713154608908' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401142'
                WHERE ordernumber = 'P180713155115350' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401141'
                WHERE ordernumber = 'P630713155151551' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '119147'
                WHERE ordernumber = 'P630713155239326' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401143'
                WHERE ordernumber = 'P180713155316882' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401144'
                WHERE ordernumber = 'P630713155352488' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381827'
                WHERE ordernumber = 'P180713155442307' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401145'
                WHERE ordernumber = 'P180713155619608' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '129909'
                WHERE ordernumber = 'P180713155653522' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '237179'
                WHERE ordernumber = 'P200713160201983' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401146'
                WHERE ordernumber = 'P200713160341213' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '27752'
                WHERE ordernumber = 'P180713160454638' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401147'
                WHERE ordernumber = 'P180713160952409' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401149'
                WHERE ordernumber = 'P180713161251288' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '239385'
                WHERE ordernumber = 'P180713161542354' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396573'
                WHERE ordernumber = 'P200713161915687' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401150'
                WHERE ordernumber = 'P180713162132651' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '217525'
                WHERE ordernumber = 'P420713162425723' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401151'
                WHERE ordernumber = 'P630713162537828' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401152'
                WHERE ordernumber = 'P420713162629772' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401153'
                WHERE ordernumber = 'P420713162741880' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '339700'
                WHERE ordernumber = 'P420713162857956' 
            
2024-07-14 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '234151'
                WHERE ordernumber = 'P200713163512149' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401156'
                WHERE ordernumber = 'P180713163524696' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401155'
                WHERE ordernumber = 'P190713163540931' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '113092'
                WHERE ordernumber = 'P180713164010655' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401158'
                WHERE ordernumber = 'P200713164214282' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '299923'
                WHERE ordernumber = 'P200713164404955' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401159'
                WHERE ordernumber = 'P200713164507368' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '334953'
                WHERE ordernumber = 'P420713164712506' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '381071'
                WHERE ordernumber = 'P200713164842114' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '90015'
                WHERE ordernumber = 'P630713165120380' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '343641'
                WHERE ordernumber = 'P180713165131469' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401160'
                WHERE ordernumber = 'P180713165317385' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401157'
                WHERE ordernumber = 'P180713165410797' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401161'
                WHERE ordernumber = 'P420713165758686' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401162'
                WHERE ordernumber = 'P200713170111800' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '396409'
                WHERE ordernumber = 'P630713170410977' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400634'
                WHERE ordernumber = 'P180713170732678' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '242814'
                WHERE ordernumber = 'P420713171017746' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '141664'
                WHERE ordernumber = 'P200713171050271' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '319987'
                WHERE ordernumber = 'P180713171642221' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '294521'
                WHERE ordernumber = 'P180713171851669' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401164'
                WHERE ordernumber = 'P420713171856810' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '237494'
                WHERE ordernumber = 'P180713171946301' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400264'
                WHERE ordernumber = 'P180713172232367' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '369737'
                WHERE ordernumber = 'P180713172328931' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '293407'
                WHERE ordernumber = 'P180713172435256' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401165'
                WHERE ordernumber = 'P180713172755190' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '334955'
                WHERE ordernumber = 'P200713173048347' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '393554'
                WHERE ordernumber = 'P420713173050749' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401167'
                WHERE ordernumber = 'P180713174156498' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401166'
                WHERE ordernumber = 'P630713174217846' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '144249'
                WHERE ordernumber = 'P200713174226463' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401167'
                WHERE ordernumber = 'P180713174309419' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401168'
                WHERE ordernumber = 'P190713174310752' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401169'
                WHERE ordernumber = 'P180713174650875' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401170'
                WHERE ordernumber = 'P200713174804313' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '397590'
                WHERE ordernumber = 'P180713175102541' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401171'
                WHERE ordernumber = 'P180713175253909' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401172'
                WHERE ordernumber = 'P190713175357355' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386528'
                WHERE ordernumber = 'P180713175434948' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401173'
                WHERE ordernumber = 'P180713175745967' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401174'
                WHERE ordernumber = 'P190713175849618' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '379617'
                WHERE ordernumber = 'P420713175924905' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '397894'
                WHERE ordernumber = 'P420713180021587' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '173590'
                WHERE ordernumber = 'P180713180227959' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401175'
                WHERE ordernumber = 'P420713180511118' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '286340'
                WHERE ordernumber = 'P420713180635150' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401176'
                WHERE ordernumber = 'P420713180803124' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401177'
                WHERE ordernumber = 'P180713180841654' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '78784'
                WHERE ordernumber = 'P180713181028470' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '348119'
                WHERE ordernumber = 'P420713181126238' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401178'
                WHERE ordernumber = 'P180713181218299' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351315'
                WHERE ordernumber = 'P180713181305243' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '187213'
                WHERE ordernumber = 'P200713181306765' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401179'
                WHERE ordernumber = 'P420713181350644' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401178'
                WHERE ordernumber = 'P180713181521751' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401180'
                WHERE ordernumber = 'P180713181807708' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401181'
                WHERE ordernumber = 'P180713182310621' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401182'
                WHERE ordernumber = 'P180713183102540' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401183'
                WHERE ordernumber = 'P200713183604588' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '279114'
                WHERE ordernumber = 'P180713183628198' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '162342'
                WHERE ordernumber = 'P420713183820512' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401185'
                WHERE ordernumber = 'P180713183932593' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401186'
                WHERE ordernumber = 'P420713184221884' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401187'
                WHERE ordernumber = 'P420713184512857' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401188'
                WHERE ordernumber = 'P420713184700418' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '216382'
                WHERE ordernumber = 'P180713184913710' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401190'
                WHERE ordernumber = 'P190713185528339' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401191'
                WHERE ordernumber = 'P180713185545373' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401189'
                WHERE ordernumber = 'P200713185645427' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '308537'
                WHERE ordernumber = 'P190713185713473' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '302182'
                WHERE ordernumber = 'P190713185914322' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '230443'
                WHERE ordernumber = 'P190713190048485' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '161113'
                WHERE ordernumber = 'P200713190354114' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '363002'
                WHERE ordernumber = 'P200713190552222' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '99135'
                WHERE ordernumber = 'P190713190614737' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401194'
                WHERE ordernumber = 'P200713190744426' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '110558'
                WHERE ordernumber = 'P190713192132779' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401195'
                WHERE ordernumber = 'P630713192306288' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '52558'
                WHERE ordernumber = 'P200713192525178' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '220200'
                WHERE ordernumber = 'P190713192801794' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '69992'
                WHERE ordernumber = 'P190713193002254' 
            
2024-07-14 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401196'
                WHERE ordernumber = 'P190713193137235' 
            
2024-07-14 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '168742'
                WHERE ordernumber = 'P190713193234132' 
            
2024-07-14 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '401198'
                WHERE ordernumber = 'P190713193346894' 
            
2024-07-14 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '401197'
                WHERE ordernumber = 'P200713193439819' 
            
2024-07-14 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '401199'
                WHERE ordernumber = 'P190713193507852' 
            
2024-07-14 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '401200'
                WHERE ordernumber = 'P190713193721920' 
            
2024-07-14 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '401201'
                WHERE ordernumber = 'P190713193851414' 
            
2024-07-14 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '370699'
                WHERE ordernumber = 'P190713194145688' 
            
2024-07-14 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '397954'
                WHERE ordernumber = 'P200713194221945' 
            
2024-07-14 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '401202'
                WHERE ordernumber = 'P190713194252522' 
            
2024-07-14 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '400589'
                WHERE ordernumber = 'P190713194458901' 
            
2024-07-14 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '401203'
                WHERE ordernumber = 'P190713194747413' 
            
2024-07-14 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '401204'
                WHERE ordernumber = 'P190713194841823' 
            
2024-07-14 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '286464'
                WHERE ordernumber = 'P190713194906335' 
            
2024-07-14 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '370356'
                WHERE ordernumber = 'P190713195241478' 
            
2024-07-14 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '75630'
                WHERE ordernumber = 'P200713195431465' 
            
2024-07-14 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '401206'
                WHERE ordernumber = 'P190713195601348'