2024-10-25 01:00:02 -- 將會員中心id寫入data-lake
2024-10-25 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-10-24%';
        
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '209851'
                WHERE ordernumber = 'P421024110225710' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '307996'
                WHERE ordernumber = 'P181024110919426' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426068'
                WHERE ordernumber = 'P771024111059612' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '305444'
                WHERE ordernumber = 'P421024111358680' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '411711'
                WHERE ordernumber = 'P181024111710658' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '405596'
                WHERE ordernumber = 'P421024112916766' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427196'
                WHERE ordernumber = 'P191024113206632' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427342'
                WHERE ordernumber = 'P771024113621826' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '272613'
                WHERE ordernumber = 'P421024114742221' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '208426'
                WHERE ordernumber = 'P181024114901417' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '208426'
                WHERE ordernumber = 'P181024114918388' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385241'
                WHERE ordernumber = 'P191024115024585' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '208426'
                WHERE ordernumber = 'P181024115333877' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425233'
                WHERE ordernumber = 'P421024115559247' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427344'
                WHERE ordernumber = 'P191024115706404' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427343'
                WHERE ordernumber = 'P191024115810418' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427237'
                WHERE ordernumber = 'P181024120350937' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427347'
                WHERE ordernumber = 'P731024121301826' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427348'
                WHERE ordernumber = 'P771024121336919' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427348'
                WHERE ordernumber = 'P771024121336919' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P201024122315859' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '162853'
                WHERE ordernumber = 'P771024122400681' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283322'
                WHERE ordernumber = 'P201024122928163' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427349'
                WHERE ordernumber = 'P711024123707239' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '339483'
                WHERE ordernumber = 'P421024123757436' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P181024125759124' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427350'
                WHERE ordernumber = 'P421024130406524' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427351'
                WHERE ordernumber = 'P201024130503956' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392414'
                WHERE ordernumber = 'P731024130743275' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '192556'
                WHERE ordernumber = 'P181024130813585' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99641'
                WHERE ordernumber = 'P181024130956987' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427353'
                WHERE ordernumber = 'P181024131133966' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427354'
                WHERE ordernumber = 'P731024131149569' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421124'
                WHERE ordernumber = 'P421024131648363' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '281267'
                WHERE ordernumber = 'P181024131815507' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '341317'
                WHERE ordernumber = 'P181024132152472' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427357'
                WHERE ordernumber = 'P201024132240220' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '166561'
                WHERE ordernumber = 'P201024132355791' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427360'
                WHERE ordernumber = 'P181024132418320' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427358'
                WHERE ordernumber = 'P711024132543818' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425886'
                WHERE ordernumber = 'P181024132848507' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427363'
                WHERE ordernumber = 'P181024134235872' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '325593'
                WHERE ordernumber = 'P181024134403544' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '133830'
                WHERE ordernumber = 'P181024134645797' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427362'
                WHERE ordernumber = 'P181024134824694' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427333'
                WHERE ordernumber = 'P421024134938308' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427364'
                WHERE ordernumber = 'P181024135038755' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427366'
                WHERE ordernumber = 'P201024135326876' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423983'
                WHERE ordernumber = 'P731024140015927' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427368'
                WHERE ordernumber = 'P181024140757479' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '101861'
                WHERE ordernumber = 'P191024140833115' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426275'
                WHERE ordernumber = 'P181024141056268' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354790'
                WHERE ordernumber = 'P191024141409271' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427370'
                WHERE ordernumber = 'P711024141643593' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427373'
                WHERE ordernumber = 'P711024142018316' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '90938'
                WHERE ordernumber = 'P201024142118884' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427303'
                WHERE ordernumber = 'P421024142242797' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390927'
                WHERE ordernumber = 'P181024142401574' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427375'
                WHERE ordernumber = 'P201024142519332' 
            
2024-10-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '236477'
                WHERE ordernumber = 'P421024142713182' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427378'
                WHERE ordernumber = 'P201024142959266' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427376'
                WHERE ordernumber = 'P421024143017760' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298155'
                WHERE ordernumber = 'P771024143232196' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427380'
                WHERE ordernumber = 'P201024143419671' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427379'
                WHERE ordernumber = 'P771024143626543' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '294261'
                WHERE ordernumber = 'P421024144156390' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '110093'
                WHERE ordernumber = 'P201024144705456' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427382'
                WHERE ordernumber = 'P181024145056770' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427383'
                WHERE ordernumber = 'P421024145211536' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427384'
                WHERE ordernumber = 'P731024145519645' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '26344'
                WHERE ordernumber = 'P191024145722396' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427386'
                WHERE ordernumber = 'P421024145849237' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399135'
                WHERE ordernumber = 'P181024150141644' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427388'
                WHERE ordernumber = 'P181024151128721' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427387'
                WHERE ordernumber = 'P771024151413623' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '219994'
                WHERE ordernumber = 'P181024151715622' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353063'
                WHERE ordernumber = 'P181024151812516' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '326963'
                WHERE ordernumber = 'P201024153334559' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '308233'
                WHERE ordernumber = 'P201024153433248' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427391'
                WHERE ordernumber = 'P181024153501410' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427393'
                WHERE ordernumber = 'P731024153639945' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427392'
                WHERE ordernumber = 'P181024153929323' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '336729'
                WHERE ordernumber = 'P771024153949306' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427395'
                WHERE ordernumber = 'P181024154215162' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344253'
                WHERE ordernumber = 'P191024154542985' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427396'
                WHERE ordernumber = 'P181024154551135' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427396'
                WHERE ordernumber = 'P181024154628219' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '158000'
                WHERE ordernumber = 'P771024154721598' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427397'
                WHERE ordernumber = 'P191024154820585' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427397'
                WHERE ordernumber = 'P191024154833713' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '232251'
                WHERE ordernumber = 'P181024154923311' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '204807'
                WHERE ordernumber = 'P181024155047913' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427398'
                WHERE ordernumber = 'P711024155228342' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427400'
                WHERE ordernumber = 'P771024155333716' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427399'
                WHERE ordernumber = 'P191024155450625' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427401'
                WHERE ordernumber = 'P421024161435330' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '186441'
                WHERE ordernumber = 'P201024162200910' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424129'
                WHERE ordernumber = 'P181024163429732' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '265237'
                WHERE ordernumber = 'P201024163534858' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427402'
                WHERE ordernumber = 'P201024163649693' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425983'
                WHERE ordernumber = 'P421024163751918' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240937'
                WHERE ordernumber = 'P181024163755308' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427403'
                WHERE ordernumber = 'P421024165746561' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P181024165814976' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400869'
                WHERE ordernumber = 'P421024165925737' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427405'
                WHERE ordernumber = 'P181024170222204' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '121498'
                WHERE ordernumber = 'P201024170525579' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410961'
                WHERE ordernumber = 'P181024171611867' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427408'
                WHERE ordernumber = 'P201024171822850' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276353'
                WHERE ordernumber = 'P201024172604551' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378510'
                WHERE ordernumber = 'P181024172646701' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378510'
                WHERE ordernumber = 'P181024172716716' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424106'
                WHERE ordernumber = 'P181024173450906' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '165544'
                WHERE ordernumber = 'P421024174841248' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427412'
                WHERE ordernumber = 'P181024175318331' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '243770'
                WHERE ordernumber = 'P181024180206349' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427413'
                WHERE ordernumber = 'P421024180247127' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427414'
                WHERE ordernumber = 'P181024180616751' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421658'
                WHERE ordernumber = 'P181024180738272' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '280167'
                WHERE ordernumber = 'P181024181439836' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427415'
                WHERE ordernumber = 'P181024181705743' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379847'
                WHERE ordernumber = 'P181024181840393' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427416'
                WHERE ordernumber = 'P201024182443159' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299086'
                WHERE ordernumber = 'P181024182837290' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345307'
                WHERE ordernumber = 'P181024183028817' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427418'
                WHERE ordernumber = 'P771024183620449' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426426'
                WHERE ordernumber = 'P201024183908976' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427419'
                WHERE ordernumber = 'P181024184750332' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426728'
                WHERE ordernumber = 'P631024184805711' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427422'
                WHERE ordernumber = 'P191024185258234' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427421'
                WHERE ordernumber = 'P191024185356265' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427423'
                WHERE ordernumber = 'P191024185446770' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427425'
                WHERE ordernumber = 'P711024185521857' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427424'
                WHERE ordernumber = 'P191024185543475' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427426'
                WHERE ordernumber = 'P191024185715763' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425438'
                WHERE ordernumber = 'P731024190005747' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241296'
                WHERE ordernumber = 'P191024190158599' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427428'
                WHERE ordernumber = 'P191024190744354' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427427'
                WHERE ordernumber = 'P771024190850452' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '328345'
                WHERE ordernumber = 'P191024190902724' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427429'
                WHERE ordernumber = 'P771024191320767' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276213'
                WHERE ordernumber = 'P191024191723729' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101191'
                WHERE ordernumber = 'P191024192105894' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313838'
                WHERE ordernumber = 'P191024193336442' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277250'
                WHERE ordernumber = 'P201024193437562' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427433'
                WHERE ordernumber = 'P201024193637559' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427433'
                WHERE ordernumber = 'P201024194011891' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160406'
                WHERE ordernumber = 'P191024194710684' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387796'
                WHERE ordernumber = 'P201024195000122' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427434'
                WHERE ordernumber = 'P191024195016747' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283490'
                WHERE ordernumber = 'P771024200555125' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427441'
                WHERE ordernumber = 'P731024201501919' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427442'
                WHERE ordernumber = 'P731024202021963' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388574'
                WHERE ordernumber = 'P711024202057232' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427440'
                WHERE ordernumber = 'P731024202610683' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340600'
                WHERE ordernumber = 'P591024203617427' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '185950'
                WHERE ordernumber = 'P771024210220699' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423159'
                WHERE ordernumber = 'P711024210359128' 
            
2024-10-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427445'
                WHERE ordernumber = 'P711024212143653'