2024-01-05 01:00:02 -- 將會員中心id寫入data-lake
2024-01-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-01-04%';
        
2024-01-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '276826'
                WHERE ordernumber = 'P180104110152259' 
            
2024-01-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '358655'
                WHERE ordernumber = 'P420104110739217' 
            
2024-01-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '358656'
                WHERE ordernumber = 'P200104110824220' 
            
2024-01-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '358654'
                WHERE ordernumber = 'P180104110836227' 
            
2024-01-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '358660'
                WHERE ordernumber = 'P180104111132853' 
            
2024-01-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '98729'
                WHERE ordernumber = 'P200104111236667' 
            
2024-01-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '268802'
                WHERE ordernumber = 'P180104111359483' 
            
2024-01-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '282425'
                WHERE ordernumber = 'P180104111448630' 
            
2024-01-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99718'
                WHERE ordernumber = 'P200104111539358' 
            
2024-01-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '195092'
                WHERE ordernumber = 'P420104111557994' 
            
2024-01-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '351437'
                WHERE ordernumber = 'P180104111716356' 
            
2024-01-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '358662'
                WHERE ordernumber = 'P190104111731956' 
            
2024-01-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '358663'
                WHERE ordernumber = 'P200104111843843' 
            
2024-01-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '97019'
                WHERE ordernumber = 'P180104111902826' 
            
2024-01-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '358665'
                WHERE ordernumber = 'P190104111937342' 
            
2024-01-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '358666'
                WHERE ordernumber = 'P420104111949774' 
            
2024-01-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '276044'
                WHERE ordernumber = 'P200104112017422' 
            
2024-01-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '358668'
                WHERE ordernumber = 'P190104112758691' 
            
2024-01-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '358669'
                WHERE ordernumber = 'P180104112926212' 
            
2024-01-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '316900'
                WHERE ordernumber = 'P190104112946830' 
            
2024-01-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355927'
                WHERE ordernumber = 'P200104113141674' 
            
2024-01-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '230115'
                WHERE ordernumber = 'P180104113241635' 
            
2024-01-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '94642'
                WHERE ordernumber = 'P180104113400806' 
            
2024-01-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '358673'
                WHERE ordernumber = 'P190104113703455' 
            
2024-01-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '291171'
                WHERE ordernumber = 'P180104113838937' 
            
2024-01-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '223476'
                WHERE ordernumber = 'P180104113941540' 
            
2024-01-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P200104114212536' 
            
2024-01-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '358676'
                WHERE ordernumber = 'P200104114702496' 
            
2024-01-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '85633'
                WHERE ordernumber = 'P190104114726683' 
            
2024-01-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '108232'
                WHERE ordernumber = 'P190104114923317' 
            
2024-01-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '358032'
                WHERE ordernumber = 'P180104115234663' 
            
2024-01-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '358032'
                WHERE ordernumber = 'P180104115328781' 
            
2024-01-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '120473'
                WHERE ordernumber = 'P200104122451956' 
            
2024-01-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '358687'
                WHERE ordernumber = 'P200104122640909' 
            
2024-01-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '358688'
                WHERE ordernumber = 'P180104122654133' 
            
2024-01-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '62458'
                WHERE ordernumber = 'P200104122831287' 
            
2024-01-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '358690'
                WHERE ordernumber = 'P180104122840715' 
            
2024-01-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348972'
                WHERE ordernumber = 'P180104123138990' 
            
2024-01-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '356670'
                WHERE ordernumber = 'P420104123218628' 
            
2024-01-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '358692'
                WHERE ordernumber = 'P200104123315381' 
            
2024-01-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '358693'
                WHERE ordernumber = 'P180104123318969' 
            
2024-01-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '342149'
                WHERE ordernumber = 'P180104123452262' 
            
2024-01-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '358694'
                WHERE ordernumber = 'P420104123735790' 
            
2024-01-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350995'
                WHERE ordernumber = 'P200104123757710' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358695'
                WHERE ordernumber = 'P180104123806740' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301837'
                WHERE ordernumber = 'P420104123853111' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338218'
                WHERE ordernumber = 'P200104124000232' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338218'
                WHERE ordernumber = 'P200104124052882' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81433'
                WHERE ordernumber = 'P200104124129313' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353469'
                WHERE ordernumber = 'P180104124317869' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358696'
                WHERE ordernumber = 'P180104124442331' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284083'
                WHERE ordernumber = 'P200104124541381' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358697'
                WHERE ordernumber = 'P200104124635964' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279309'
                WHERE ordernumber = 'P180104125044753' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349895'
                WHERE ordernumber = 'P200104125059608' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358698'
                WHERE ordernumber = 'P200104125135203' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '222172'
                WHERE ordernumber = 'P200104125250408' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358699'
                WHERE ordernumber = 'P180104125304450' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358702'
                WHERE ordernumber = 'P200104125340674' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350836'
                WHERE ordernumber = 'P180104125632954' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358703'
                WHERE ordernumber = 'P180104125749317' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358704'
                WHERE ordernumber = 'P420104130131776' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358705'
                WHERE ordernumber = 'P180104130153416' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306676'
                WHERE ordernumber = 'P180104130257185' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354066'
                WHERE ordernumber = 'P180104130721583' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358709'
                WHERE ordernumber = 'P180104130836925' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278230'
                WHERE ordernumber = 'P200104131014672' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358710'
                WHERE ordernumber = 'P420104131126271' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '132564'
                WHERE ordernumber = 'P200104131442523' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358714'
                WHERE ordernumber = 'P180104131524967' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '155223'
                WHERE ordernumber = 'P200104131534230' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358716'
                WHERE ordernumber = 'P200104131759987' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358717'
                WHERE ordernumber = 'P180104131946782' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354066'
                WHERE ordernumber = 'P180104132032690' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358719'
                WHERE ordernumber = 'P180104132152243' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '253683'
                WHERE ordernumber = 'P200104132332755' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358722'
                WHERE ordernumber = 'P420104132347323' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358723'
                WHERE ordernumber = 'P200104132539291' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358731'
                WHERE ordernumber = 'P180104134400226' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282598'
                WHERE ordernumber = 'P200104134911629' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358402'
                WHERE ordernumber = 'P200104135107132' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358737'
                WHERE ordernumber = 'P180104135308688' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358738'
                WHERE ordernumber = 'P180104135459169' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240225'
                WHERE ordernumber = 'P180104140250262' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '67370'
                WHERE ordernumber = 'P200104140437696' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '246611'
                WHERE ordernumber = 'P180104140606179' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276052'
                WHERE ordernumber = 'P180104140712415' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '136864'
                WHERE ordernumber = 'P180104140828967' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358744'
                WHERE ordernumber = 'P420104141124404' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358745'
                WHERE ordernumber = 'P180104141506849' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214691'
                WHERE ordernumber = 'P190104141802927' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '82639'
                WHERE ordernumber = 'P420104141959425' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343373'
                WHERE ordernumber = 'P180104142235774' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343373'
                WHERE ordernumber = 'P190104142403369' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '84622'
                WHERE ordernumber = 'P190104142456752' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242134'
                WHERE ordernumber = 'P190104142548977' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '86100'
                WHERE ordernumber = 'P180104142709195' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358757'
                WHERE ordernumber = 'P200104143106572' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358758'
                WHERE ordernumber = 'P180104143139969' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '257979'
                WHERE ordernumber = 'P180104143342173' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358760'
                WHERE ordernumber = 'P420104143415401' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358768'
                WHERE ordernumber = 'P420104144803994' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358770'
                WHERE ordernumber = 'P420104144931998' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358771'
                WHERE ordernumber = 'P180104145354617' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '95695'
                WHERE ordernumber = 'P200104145533860' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358772'
                WHERE ordernumber = 'P180104145640287' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358774'
                WHERE ordernumber = 'P180104150045561' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358775'
                WHERE ordernumber = 'P190104150117748' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358777'
                WHERE ordernumber = 'P200104150419651' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358780'
                WHERE ordernumber = 'P180104150647294' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358782'
                WHERE ordernumber = 'P200104150719122' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358784'
                WHERE ordernumber = 'P420104151036320' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358786'
                WHERE ordernumber = 'P180104151146877' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358787'
                WHERE ordernumber = 'P180104151346703' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341887'
                WHERE ordernumber = 'P180104151754347' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315642'
                WHERE ordernumber = 'P180104152243976' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315642'
                WHERE ordernumber = 'P180104152418921' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358791'
                WHERE ordernumber = 'P180104152524528' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '135376'
                WHERE ordernumber = 'P180104152657407' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113752'
                WHERE ordernumber = 'P180104152737353' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '75879'
                WHERE ordernumber = 'P200104152843667' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358793'
                WHERE ordernumber = 'P180104152930401' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358792'
                WHERE ordernumber = 'P420104152941356' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357472'
                WHERE ordernumber = 'P190104153221800' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357472'
                WHERE ordernumber = 'P190104153316643' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358795'
                WHERE ordernumber = 'P180104153328735' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358798'
                WHERE ordernumber = 'P180104154210440' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358799'
                WHERE ordernumber = 'P180104154320801' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358042'
                WHERE ordernumber = 'P200104154325136' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358800'
                WHERE ordernumber = 'P180104154423440' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358801'
                WHERE ordernumber = 'P190104154535123' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352265'
                WHERE ordernumber = 'P200104154546556' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352265'
                WHERE ordernumber = 'P200104154616897' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358802'
                WHERE ordernumber = 'P180104154636849' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358803'
                WHERE ordernumber = 'P420104154839934' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358804'
                WHERE ordernumber = 'P180104155054963' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358804'
                WHERE ordernumber = 'P180104155141834' 
            
2024-01-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '157035'
                WHERE ordernumber = 'P200104155157367' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358806'
                WHERE ordernumber = 'P200104155427604' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343425'
                WHERE ordernumber = 'P180104155516355' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358805'
                WHERE ordernumber = 'P200104155529277' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '234424'
                WHERE ordernumber = 'P180104155628180' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '181598'
                WHERE ordernumber = 'P200104160015211' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81029'
                WHERE ordernumber = 'P200104160140132' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313813'
                WHERE ordernumber = 'P200104160506646' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358812'
                WHERE ordernumber = 'P200104160926282' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '215170'
                WHERE ordernumber = 'P180104161403772' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358817'
                WHERE ordernumber = 'P200104161602973' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358818'
                WHERE ordernumber = 'P180104161733668' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81975'
                WHERE ordernumber = 'P180104161902607' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '224370'
                WHERE ordernumber = 'P180104161952113' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358820'
                WHERE ordernumber = 'P180104162049428' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '26'
                WHERE ordernumber = 'P200104162216945' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98721'
                WHERE ordernumber = 'P180104162525842' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358822'
                WHERE ordernumber = 'P200104162755935' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '247775'
                WHERE ordernumber = 'P180104163002261' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358824'
                WHERE ordernumber = 'P420104163018575' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358823'
                WHERE ordernumber = 'P200104163031356' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358825'
                WHERE ordernumber = 'P200104163345328' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '182042'
                WHERE ordernumber = 'P200104163434933' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358827'
                WHERE ordernumber = 'P200104163601280' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358828'
                WHERE ordernumber = 'P200104163650675' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '234321'
                WHERE ordernumber = 'P420104163719894' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358831'
                WHERE ordernumber = 'P200104164253775' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '256865'
                WHERE ordernumber = 'P200104164514338' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358833'
                WHERE ordernumber = 'P420104164516276' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '155005'
                WHERE ordernumber = 'P200104164555794' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '309611'
                WHERE ordernumber = 'P200104165242971' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358837'
                WHERE ordernumber = 'P420104165308498' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352297'
                WHERE ordernumber = 'P200104165356860' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358838'
                WHERE ordernumber = 'P180104165512989' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358840'
                WHERE ordernumber = 'P200104165839967' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '189178'
                WHERE ordernumber = 'P180104170030978' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358843'
                WHERE ordernumber = 'P420104170149484' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304814'
                WHERE ordernumber = 'P200104170518211' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304814'
                WHERE ordernumber = 'P200104170616752' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358846'
                WHERE ordernumber = 'P420104170820463' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347176'
                WHERE ordernumber = 'P420104171017408' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '189178'
                WHERE ordernumber = 'P180104171247185' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98376'
                WHERE ordernumber = 'P190104171344724' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358850'
                WHERE ordernumber = 'P200104171453729' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358849'
                WHERE ordernumber = 'P420104171458272' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '271204'
                WHERE ordernumber = 'P180104171533384' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358851'
                WHERE ordernumber = 'P420104171648985' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '80996'
                WHERE ordernumber = 'P180104171657585' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358852'
                WHERE ordernumber = 'P180104171813822' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '154808'
                WHERE ordernumber = 'P180104172223461' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287531'
                WHERE ordernumber = 'P200104172418196' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358855'
                WHERE ordernumber = 'P200104172809988' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281701'
                WHERE ordernumber = 'P180104172856500' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358856'
                WHERE ordernumber = 'P180104173117880' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236923'
                WHERE ordernumber = 'P180104173245360' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '7087'
                WHERE ordernumber = 'P180104173825207' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358861'
                WHERE ordernumber = 'P180104174116465' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358860'
                WHERE ordernumber = 'P200104174128171' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '213314'
                WHERE ordernumber = 'P180104174646915' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358863'
                WHERE ordernumber = 'P420104174835649' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100700'
                WHERE ordernumber = 'P180104174856502' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358866'
                WHERE ordernumber = 'P200104175004677' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358469'
                WHERE ordernumber = 'P200104175056542' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302111'
                WHERE ordernumber = 'P200104175338206' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358868'
                WHERE ordernumber = 'P200104175457191' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358870'
                WHERE ordernumber = 'P200104175751250' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '71724'
                WHERE ordernumber = 'P180104180109754' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '315387'
                WHERE ordernumber = 'P420104180144442' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358874'
                WHERE ordernumber = 'P180104180250270' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '93448'
                WHERE ordernumber = 'P200104180547712' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '101876'
                WHERE ordernumber = 'P180104180601645' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358875'
                WHERE ordernumber = 'P420104180653967' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '239833'
                WHERE ordernumber = 'P180104181047732' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358878'
                WHERE ordernumber = 'P420104181123427' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358879'
                WHERE ordernumber = 'P200104181226163' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358880'
                WHERE ordernumber = 'P180104181338546' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358881'
                WHERE ordernumber = 'P180104181506805' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '83929'
                WHERE ordernumber = 'P180104182057840' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358883'
                WHERE ordernumber = 'P180104182237422' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358885'
                WHERE ordernumber = 'P420104182523763' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358886'
                WHERE ordernumber = 'P180104182635281' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358886'
                WHERE ordernumber = 'P180104182847384' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343834'
                WHERE ordernumber = 'P200104182953633' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358888'
                WHERE ordernumber = 'P200104183113555' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358890'
                WHERE ordernumber = 'P420104183218235' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358891'
                WHERE ordernumber = 'P420104183329674' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236240'
                WHERE ordernumber = 'P180104183430940' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355710'
                WHERE ordernumber = 'P420104183454753' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358894'
                WHERE ordernumber = 'P200104183620953' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357949'
                WHERE ordernumber = 'P190104183627948' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358895'
                WHERE ordernumber = 'P200104183750228' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358884'
                WHERE ordernumber = 'P190104183837840' 
            
2024-01-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358884'
                WHERE ordernumber = 'P190104183908122' 
            
2024-01-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358899'
                WHERE ordernumber = 'P200104184324492' 
            
2024-01-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358885'
                WHERE ordernumber = 'P420104184907772' 
            
2024-01-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '334560'
                WHERE ordernumber = 'P200104184927513' 
            
2024-01-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358901'
                WHERE ordernumber = 'P200104185000900' 
            
2024-01-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358902'
                WHERE ordernumber = 'P190104185026539' 
            
2024-01-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351075'
                WHERE ordernumber = 'P420104185053358' 
            
2024-01-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358885'
                WHERE ordernumber = 'P420104185203971' 
            
2024-01-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358901'
                WHERE ordernumber = 'P200104185350410' 
            
2024-01-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358906'
                WHERE ordernumber = 'P190104185407135' 
            
2024-01-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '325069'
                WHERE ordernumber = 'P200104185545699' 
            
2024-01-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '251382'
                WHERE ordernumber = 'P200104190005337' 
            
2024-01-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '251382'
                WHERE ordernumber = 'P200104190107997' 
            
2024-01-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '219162'
                WHERE ordernumber = 'P190104190656708' 
            
2024-01-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '103668'
                WHERE ordernumber = 'P200104190939273' 
            
2024-01-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358231'
                WHERE ordernumber = 'P200104191146662' 
            
2024-01-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355470'
                WHERE ordernumber = 'P200104191245220' 
            
2024-01-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '356808'
                WHERE ordernumber = 'P190104191303717' 
            
2024-01-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '99642'
                WHERE ordernumber = 'P190104191616275' 
            
2024-01-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353292'
                WHERE ordernumber = 'P420104191616691' 
            
2024-01-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '237174'
                WHERE ordernumber = 'P200104191735616' 
            
2024-01-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '128547'
                WHERE ordernumber = 'P190104192439875' 
            
2024-01-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '232920'
                WHERE ordernumber = 'P190104192848650' 
            
2024-01-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '293625'
                WHERE ordernumber = 'P200104192950803' 
            
2024-01-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '306207'
                WHERE ordernumber = 'P190104193025232' 
            
2024-01-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358920'
                WHERE ordernumber = 'P190104193213412' 
            
2024-01-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358909'
                WHERE ordernumber = 'P200104193233303' 
            
2024-01-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '237429'
                WHERE ordernumber = 'P190104193631412' 
            
2024-01-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '283717'
                WHERE ordernumber = 'P190104194531855' 
            
2024-01-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '344622'
                WHERE ordernumber = 'P190104195053138' 
            
2024-01-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358927'
                WHERE ordernumber = 'P200104195750560' 
            
2024-01-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '344622'
                WHERE ordernumber = 'P190104195824137' 
            
2024-01-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '338443'
                WHERE ordernumber = 'P190104200150780' 
            
2024-01-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '338443'
                WHERE ordernumber = 'P190104200209387' 
            
2024-01-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '346532'
                WHERE ordernumber = 'P190104200346679'