2024-11-08 01:00:02 -- 將會員中心id寫入data-lake
2024-11-08 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-11-07%';
        
2024-11-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '412019'
                WHERE ordernumber = 'P201107110337972' 
            
2024-11-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P421107110346703' 
            
2024-11-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380886'
                WHERE ordernumber = 'P181107111118588' 
            
2024-11-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429243'
                WHERE ordernumber = 'P201107111126641' 
            
2024-11-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387669'
                WHERE ordernumber = 'P421107112308323' 
            
2024-11-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420012'
                WHERE ordernumber = 'P421107112413964' 
            
2024-11-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350846'
                WHERE ordernumber = 'P201107112428965' 
            
2024-11-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '110061'
                WHERE ordernumber = 'P201107113248155' 
            
2024-11-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429244'
                WHERE ordernumber = 'P771107113545677' 
            
2024-11-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '228555'
                WHERE ordernumber = 'P181107113903533' 
            
2024-11-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100793'
                WHERE ordernumber = 'P201107114153876' 
            
2024-11-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99853'
                WHERE ordernumber = 'P191107114156601' 
            
2024-11-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '399816'
                WHERE ordernumber = 'P421107114323547' 
            
2024-11-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429245'
                WHERE ordernumber = 'P181107114346184' 
            
2024-11-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '369813'
                WHERE ordernumber = 'P201107114439631' 
            
2024-11-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429246'
                WHERE ordernumber = 'P181107114933882' 
            
2024-11-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391678'
                WHERE ordernumber = 'P181107115345764' 
            
2024-11-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '269118'
                WHERE ordernumber = 'P201107120000430' 
            
2024-11-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429248'
                WHERE ordernumber = 'P201107120840957' 
            
2024-11-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396508'
                WHERE ordernumber = 'P181107120912488' 
            
2024-11-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429250'
                WHERE ordernumber = 'P201107121023286' 
            
2024-11-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '168988'
                WHERE ordernumber = 'P191107121312302' 
            
2024-11-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429250'
                WHERE ordernumber = 'P201107121434528' 
            
2024-11-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429252'
                WHERE ordernumber = 'P201107121554786' 
            
2024-11-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '329313'
                WHERE ordernumber = 'P181107121909820' 
            
2024-11-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '319052'
                WHERE ordernumber = 'P201107122024995' 
            
2024-11-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429254'
                WHERE ordernumber = 'P421107122227857' 
            
2024-11-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427010'
                WHERE ordernumber = 'P201107122512565' 
            
2024-11-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '414912'
                WHERE ordernumber = 'P421107122643123' 
            
2024-11-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429253'
                WHERE ordernumber = 'P181107122827332' 
            
2024-11-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P181107123005201' 
            
2024-11-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '241970'
                WHERE ordernumber = 'P201107123554831' 
            
2024-11-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '278230'
                WHERE ordernumber = 'P591107123931811' 
            
2024-11-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429257'
                WHERE ordernumber = 'P181107124205138' 
            
2024-11-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429258'
                WHERE ordernumber = 'P421107124422538' 
            
2024-11-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353707'
                WHERE ordernumber = 'P421107124537568' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428663'
                WHERE ordernumber = 'P181107124604752' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429260'
                WHERE ordernumber = 'P421107125725624' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404263'
                WHERE ordernumber = 'P421107130131313' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429261'
                WHERE ordernumber = 'P421107130251649' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '288711'
                WHERE ordernumber = 'P421107130729544' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388930'
                WHERE ordernumber = 'P421107131209846' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429262'
                WHERE ordernumber = 'P771107131341699' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '325158'
                WHERE ordernumber = 'P201107131523116' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429264'
                WHERE ordernumber = 'P201107132237923' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237080'
                WHERE ordernumber = 'P201107133213974' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429264'
                WHERE ordernumber = 'P201107133407537' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429264'
                WHERE ordernumber = 'P201107133448562' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282667'
                WHERE ordernumber = 'P181107135136147' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392795'
                WHERE ordernumber = 'P181107140523360' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '270147'
                WHERE ordernumber = 'P201107140743845' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421894'
                WHERE ordernumber = 'P201107140900162' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429269'
                WHERE ordernumber = 'P421107141240201' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296519'
                WHERE ordernumber = 'P201107141609566' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429270'
                WHERE ordernumber = 'P201107141918678' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374267'
                WHERE ordernumber = 'P421107142238419' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429273'
                WHERE ordernumber = 'P201107142942786' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429274'
                WHERE ordernumber = 'P201107143608740' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '87774'
                WHERE ordernumber = 'P181107143945866' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429276'
                WHERE ordernumber = 'P201107144333692' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429277'
                WHERE ordernumber = 'P421107144813925' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429278'
                WHERE ordernumber = 'P181107144858760' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282047'
                WHERE ordernumber = 'P181107145005889' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429279'
                WHERE ordernumber = 'P421107145049606' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '274941'
                WHERE ordernumber = 'P181107150347751' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365314'
                WHERE ordernumber = 'P181107150919322' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426514'
                WHERE ordernumber = 'P421107151241162' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426331'
                WHERE ordernumber = 'P201107151402708' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '86200'
                WHERE ordernumber = 'P181107151547258' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429282'
                WHERE ordernumber = 'P421107151951272' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348500'
                WHERE ordernumber = 'P181107152223793' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429283'
                WHERE ordernumber = 'P421107153930932' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343888'
                WHERE ordernumber = 'P181107154106909' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365200'
                WHERE ordernumber = 'P421107154125520' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '280583'
                WHERE ordernumber = 'P181107154254234' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281545'
                WHERE ordernumber = 'P181107154433439' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429285'
                WHERE ordernumber = 'P201107155143911' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429285'
                WHERE ordernumber = 'P201107155248367' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '136325'
                WHERE ordernumber = 'P771107155332659' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411621'
                WHERE ordernumber = 'P201107155348248' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429286'
                WHERE ordernumber = 'P181107155846341' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429287'
                WHERE ordernumber = 'P181107160312472' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426237'
                WHERE ordernumber = 'P201107160544833' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426237'
                WHERE ordernumber = 'P201107161049667' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '295570'
                WHERE ordernumber = 'P201107161928832' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429288'
                WHERE ordernumber = 'P181107162837810' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429290'
                WHERE ordernumber = 'P201107163113836' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397006'
                WHERE ordernumber = 'P181107163116138' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429290'
                WHERE ordernumber = 'P201107163712378' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '104347'
                WHERE ordernumber = 'P201107163936943' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '219143'
                WHERE ordernumber = 'P181107163950571' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287298'
                WHERE ordernumber = 'P201107164042735' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429292'
                WHERE ordernumber = 'P771107164113264' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429294'
                WHERE ordernumber = 'P201107164259442' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429293'
                WHERE ordernumber = 'P421107164319176' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429291'
                WHERE ordernumber = 'P771107164326364' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429295'
                WHERE ordernumber = 'P771107164441475' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429296'
                WHERE ordernumber = 'P771107164656393' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429294'
                WHERE ordernumber = 'P201107165107312' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '141077'
                WHERE ordernumber = 'P771107165321847' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '141077'
                WHERE ordernumber = 'P771107165525828' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '124325'
                WHERE ordernumber = 'P181107165549207' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '295048'
                WHERE ordernumber = 'P421107165730494' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429297'
                WHERE ordernumber = 'P421107165939770' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429298'
                WHERE ordernumber = 'P201107165942363' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '266880'
                WHERE ordernumber = 'P181107170145368' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242563'
                WHERE ordernumber = 'P201107170216423' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '66860'
                WHERE ordernumber = 'P181107170521830' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162224'
                WHERE ordernumber = 'P201107171025625' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '363934'
                WHERE ordernumber = 'P191107171546744' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '157045'
                WHERE ordernumber = 'P421107171755528' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429301'
                WHERE ordernumber = 'P181107171822440' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429300'
                WHERE ordernumber = 'P201107171936787' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '217292'
                WHERE ordernumber = 'P191107172108607' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429302'
                WHERE ordernumber = 'P771107172426210' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287529'
                WHERE ordernumber = 'P191107172625600' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429303'
                WHERE ordernumber = 'P191107172825531' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429303'
                WHERE ordernumber = 'P191107173635929' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426349'
                WHERE ordernumber = 'P181107173648255' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429305'
                WHERE ordernumber = 'P201107173742390' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391019'
                WHERE ordernumber = 'P201107173955797' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429306'
                WHERE ordernumber = 'P421107174122632' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '133133'
                WHERE ordernumber = 'P181107174722893' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '256809'
                WHERE ordernumber = 'P191107174736838' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230746'
                WHERE ordernumber = 'P181107175103758' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429308'
                WHERE ordernumber = 'P201107175822255' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429304'
                WHERE ordernumber = 'P191107175827740' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101604'
                WHERE ordernumber = 'P201107175947258' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429309'
                WHERE ordernumber = 'P181107180253353' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429310'
                WHERE ordernumber = 'P771107181256785' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94993'
                WHERE ordernumber = 'P201107181300595' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101457'
                WHERE ordernumber = 'P201107181901979' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391342'
                WHERE ordernumber = 'P191107182609356' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '269118'
                WHERE ordernumber = 'P201107182950727' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428416'
                WHERE ordernumber = 'P201107183450168' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160617'
                WHERE ordernumber = 'P771107183451846' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428416'
                WHERE ordernumber = 'P201107183459301' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382495'
                WHERE ordernumber = 'P421107183733641' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429311'
                WHERE ordernumber = 'P421107184808696' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '121580'
                WHERE ordernumber = 'P771107185014491' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314574'
                WHERE ordernumber = 'P191107185203781' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429312'
                WHERE ordernumber = 'P201107185307529' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '89469'
                WHERE ordernumber = 'P191107190557496' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429313'
                WHERE ordernumber = 'P191107190808308' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429316'
                WHERE ordernumber = 'P201107191029718' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429317'
                WHERE ordernumber = 'P201107191501792' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403638'
                WHERE ordernumber = 'P201107192231233' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429318'
                WHERE ordernumber = 'P201107192927532' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '158635'
                WHERE ordernumber = 'P191107193212794' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '123884'
                WHERE ordernumber = 'P191107193645732' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289795'
                WHERE ordernumber = 'P201107193955444' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391255'
                WHERE ordernumber = 'P201107194729158' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390854'
                WHERE ordernumber = 'P201107194953423' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405248'
                WHERE ordernumber = 'P631107195925452' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334890'
                WHERE ordernumber = 'P591107204011594' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428091'
                WHERE ordernumber = 'P771107205316731' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429323'
                WHERE ordernumber = 'P771107205626347' 
            
2024-11-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427077'
                WHERE ordernumber = 'P631107213645351'