2024-03-05 01:00:02 -- 將會員中心id寫入data-lake
2024-03-05 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-03-04%';
        
2024-03-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379999'
                WHERE ordernumber = 'P200304110306811' 
            
2024-03-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '83927'
                WHERE ordernumber = 'P180304110332989' 
            
2024-03-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '376546'
                WHERE ordernumber = 'P180304110530329' 
            
2024-03-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '115343'
                WHERE ordernumber = 'P200304110538154' 
            
2024-03-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380001'
                WHERE ordernumber = 'P200304110759726' 
            
2024-03-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380004'
                WHERE ordernumber = 'P180304110945598' 
            
2024-03-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380003'
                WHERE ordernumber = 'P590304111117721' 
            
2024-03-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '307749'
                WHERE ordernumber = 'P180304111146625' 
            
2024-03-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380005'
                WHERE ordernumber = 'P590304111617449' 
            
2024-03-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '346189'
                WHERE ordernumber = 'P200304111649265' 
            
2024-03-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380006'
                WHERE ordernumber = 'P200304111810909' 
            
2024-03-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '318092'
                WHERE ordernumber = 'P420304112001791' 
            
2024-03-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380007'
                WHERE ordernumber = 'P590304112104734' 
            
2024-03-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380008'
                WHERE ordernumber = 'P200304112254980' 
            
2024-03-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380009'
                WHERE ordernumber = 'P180304112336439' 
            
2024-03-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350772'
                WHERE ordernumber = 'P420304112512269' 
            
2024-03-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '293280'
                WHERE ordernumber = 'P180304112633451' 
            
2024-03-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380010'
                WHERE ordernumber = 'P420304113044258' 
            
2024-03-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378564'
                WHERE ordernumber = 'P180304113947985' 
            
2024-03-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380011'
                WHERE ordernumber = 'P190304120547945' 
            
2024-03-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380012'
                WHERE ordernumber = 'P190304120757517' 
            
2024-03-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379963'
                WHERE ordernumber = 'P180304121021390' 
            
2024-03-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '284514'
                WHERE ordernumber = 'P200304121740967' 
            
2024-03-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380014'
                WHERE ordernumber = 'P180304121917421' 
            
2024-03-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380013'
                WHERE ordernumber = 'P420304121926565' 
            
2024-03-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '333134'
                WHERE ordernumber = 'P200304121930130' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '169'
                WHERE ordernumber = 'P180304122800677' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380015'
                WHERE ordernumber = 'P420304123138615' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302317'
                WHERE ordernumber = 'P420304123347332' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '268446'
                WHERE ordernumber = 'P200304123449488' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '261718'
                WHERE ordernumber = 'P420304123641326' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378069'
                WHERE ordernumber = 'P190304123856134' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380016'
                WHERE ordernumber = 'P200304124051791' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '7011'
                WHERE ordernumber = 'P590304124345724' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380017'
                WHERE ordernumber = 'P180304124348219' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380019'
                WHERE ordernumber = 'P180304124608433' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380022'
                WHERE ordernumber = 'P420304125210232' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242005'
                WHERE ordernumber = 'P200304125259442' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380027'
                WHERE ordernumber = 'P200304130349710' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '327941'
                WHERE ordernumber = 'P180304130751869' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380028'
                WHERE ordernumber = 'P200304131012213' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380030'
                WHERE ordernumber = 'P590304131221569' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362076'
                WHERE ordernumber = 'P420304131242212' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380031'
                WHERE ordernumber = 'P200304131417456' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380032'
                WHERE ordernumber = 'P420304131545928' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302825'
                WHERE ordernumber = 'P200304131554705' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97950'
                WHERE ordernumber = 'P200304131851712' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380033'
                WHERE ordernumber = 'P180304132506653' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379719'
                WHERE ordernumber = 'P180304133134540' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380034'
                WHERE ordernumber = 'P200304133230640' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380037'
                WHERE ordernumber = 'P420304133636309' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380036'
                WHERE ordernumber = 'P180304133754549' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '167396'
                WHERE ordernumber = 'P180304134027131' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380038'
                WHERE ordernumber = 'P200304134137487' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380039'
                WHERE ordernumber = 'P180304134356555' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380038'
                WHERE ordernumber = 'P200304134415165' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370681'
                WHERE ordernumber = 'P180304134657867' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346685'
                WHERE ordernumber = 'P200304134709559' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '74563'
                WHERE ordernumber = 'P420304135057389' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380043'
                WHERE ordernumber = 'P200304135735625' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378799'
                WHERE ordernumber = 'P200304135814664' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380045'
                WHERE ordernumber = 'P590304135934233' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380044'
                WHERE ordernumber = 'P420304140013362' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351381'
                WHERE ordernumber = 'P200304140201814' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380049'
                WHERE ordernumber = 'P180304140255944' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380042'
                WHERE ordernumber = 'P590304140319147' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380050'
                WHERE ordernumber = 'P590304140751285' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289933'
                WHERE ordernumber = 'P200304141055321' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '91003'
                WHERE ordernumber = 'P180304141110964' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380052'
                WHERE ordernumber = 'P200304141400434' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289933'
                WHERE ordernumber = 'P200304141504616' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '109704'
                WHERE ordernumber = 'P180304141803144' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '192556'
                WHERE ordernumber = 'P190304142512748' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380055'
                WHERE ordernumber = 'P190304142915633' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380057'
                WHERE ordernumber = 'P180304143512376' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '20358'
                WHERE ordernumber = 'P180304144016455' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380058'
                WHERE ordernumber = 'P180304144332281' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '135443'
                WHERE ordernumber = 'P180304144524312' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81113'
                WHERE ordernumber = 'P200304144832199' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379470'
                WHERE ordernumber = 'P200304145607340' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343936'
                WHERE ordernumber = 'P420304145906192' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380059'
                WHERE ordernumber = 'P180304145946189' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353474'
                WHERE ordernumber = 'P200304145958394' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380062'
                WHERE ordernumber = 'P420304150226860' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380063'
                WHERE ordernumber = 'P200304150521910' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372499'
                WHERE ordernumber = 'P420304150606374' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344544'
                WHERE ordernumber = 'P200304150727767' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291133'
                WHERE ordernumber = 'P200304151024663' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368550'
                WHERE ordernumber = 'P190304151105699' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380064'
                WHERE ordernumber = 'P180304151140301' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '114186'
                WHERE ordernumber = 'P200304151148256' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276791'
                WHERE ordernumber = 'P200304151412727' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380068'
                WHERE ordernumber = 'P200304152641371' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380069'
                WHERE ordernumber = 'P190304153456456' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '88985'
                WHERE ordernumber = 'P180304153741417' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '269714'
                WHERE ordernumber = 'P420304153930586' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380070'
                WHERE ordernumber = 'P180304153946450' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '123028'
                WHERE ordernumber = 'P200304154041488' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378003'
                WHERE ordernumber = 'P180304154105189' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '104675'
                WHERE ordernumber = 'P190304154134883' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314569'
                WHERE ordernumber = 'P190304154310148' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380048'
                WHERE ordernumber = 'P180304154601466' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380048'
                WHERE ordernumber = 'P180304154624205' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380071'
                WHERE ordernumber = 'P190304154649992' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '329834'
                WHERE ordernumber = 'P190304154821322' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380072'
                WHERE ordernumber = 'P420304154930665' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '108997'
                WHERE ordernumber = 'P200304155235612' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380062'
                WHERE ordernumber = 'P420304160059453' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '158197'
                WHERE ordernumber = 'P200304160110452' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97529'
                WHERE ordernumber = 'P590304160237607' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271209'
                WHERE ordernumber = 'P420304160302675' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380074'
                WHERE ordernumber = 'P190304160318562' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355717'
                WHERE ordernumber = 'P190304160421279' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '376254'
                WHERE ordernumber = 'P190304160527604' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380076'
                WHERE ordernumber = 'P180304161641570' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380077'
                WHERE ordernumber = 'P200304161912390' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380079'
                WHERE ordernumber = 'P200304162222425' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380081'
                WHERE ordernumber = 'P180304162551269' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343585'
                WHERE ordernumber = 'P180304162829434' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343585'
                WHERE ordernumber = 'P180304163036325' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380082'
                WHERE ordernumber = 'P420304163113411' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380084'
                WHERE ordernumber = 'P420304163238617' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380085'
                WHERE ordernumber = 'P200304163415579' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379813'
                WHERE ordernumber = 'P180304163552235' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380086'
                WHERE ordernumber = 'P420304163721647' 
            
2024-03-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339363'
                WHERE ordernumber = 'P420304163924860' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '376952'
                WHERE ordernumber = 'P200304164124639' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380087'
                WHERE ordernumber = 'P200304164327891' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '249498'
                WHERE ordernumber = 'P180304164706481' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380088'
                WHERE ordernumber = 'P190304164748689' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379615'
                WHERE ordernumber = 'P200304165457280' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379615'
                WHERE ordernumber = 'P200304165536748' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '257130'
                WHERE ordernumber = 'P180304165744485' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379682'
                WHERE ordernumber = 'P590304171037560' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283039'
                WHERE ordernumber = 'P180304172020851' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380092'
                WHERE ordernumber = 'P190304172519890' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380093'
                WHERE ordernumber = 'P200304172815545' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380095'
                WHERE ordernumber = 'P420304173028114' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '365105'
                WHERE ordernumber = 'P180304173131658' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380094'
                WHERE ordernumber = 'P180304173437783' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '375417'
                WHERE ordernumber = 'P180304173854161' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '316706'
                WHERE ordernumber = 'P190304174104265' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380097'
                WHERE ordernumber = 'P190304174218537' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '289794'
                WHERE ordernumber = 'P200304174621901' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380098'
                WHERE ordernumber = 'P200304174905252' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380099'
                WHERE ordernumber = 'P200304175151649' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380100'
                WHERE ordernumber = 'P420304175327953' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '265946'
                WHERE ordernumber = 'P590304175925691' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380103'
                WHERE ordernumber = 'P190304180035916' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380104'
                WHERE ordernumber = 'P200304180107760' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380102'
                WHERE ordernumber = 'P590304180356796' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '311254'
                WHERE ordernumber = 'P180304180654242' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380105'
                WHERE ordernumber = 'P200304181023792' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380106'
                WHERE ordernumber = 'P200304181157873' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114397'
                WHERE ordernumber = 'P190304181157647' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '117532'
                WHERE ordernumber = 'P190304181438337' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380107'
                WHERE ordernumber = 'P180304182114981' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277598'
                WHERE ordernumber = 'P190304182127747' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '336514'
                WHERE ordernumber = 'P200304182249338' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380108'
                WHERE ordernumber = 'P190304182438188' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380109'
                WHERE ordernumber = 'P190304182721669' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '329885'
                WHERE ordernumber = 'P420304182936309' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283871'
                WHERE ordernumber = 'P180304183035789' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380110'
                WHERE ordernumber = 'P200304183357373' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380111'
                WHERE ordernumber = 'P190304184727846' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380112'
                WHERE ordernumber = 'P200304184824627' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380113'
                WHERE ordernumber = 'P190304184933260' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '169372'
                WHERE ordernumber = 'P190304185604225' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '373107'
                WHERE ordernumber = 'P420304185845477' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380116'
                WHERE ordernumber = 'P420304190219574' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302490'
                WHERE ordernumber = 'P190304190515759' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278840'
                WHERE ordernumber = 'P190304190907839' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287743'
                WHERE ordernumber = 'P200304191148874' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379036'
                WHERE ordernumber = 'P420304191716497' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350465'
                WHERE ordernumber = 'P190304192911173' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380118'
                WHERE ordernumber = 'P190304193456883' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '258546'
                WHERE ordernumber = 'P200304193634859' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '106191'
                WHERE ordernumber = 'P190304194001804' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306076'
                WHERE ordernumber = 'P200304194804694' 
            
2024-03-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '285576'
                WHERE ordernumber = 'P190304195756407'