2023-11-30 01:00:02 -- 將會員中心id寫入data-lake
2023-11-30 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 '2023-11-29%';
        
2023-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349867'
                WHERE ordernumber = 'P201129110258219' 
            
2023-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '125430'
                WHERE ordernumber = 'P181129110326593' 
            
2023-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349868'
                WHERE ordernumber = 'P181129110532708' 
            
2023-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '301962'
                WHERE ordernumber = 'P421129110623312' 
            
2023-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '162606'
                WHERE ordernumber = 'P191129110630795' 
            
2023-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '71796'
                WHERE ordernumber = 'P181129110750892' 
            
2023-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '225561'
                WHERE ordernumber = 'P181129111210150' 
            
2023-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '93882'
                WHERE ordernumber = 'P201129111325349' 
            
2023-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '346443'
                WHERE ordernumber = 'P201129111638164' 
            
2023-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349869'
                WHERE ordernumber = 'P201129111745243' 
            
2023-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '342308'
                WHERE ordernumber = 'P191129112909534' 
            
2023-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '347704'
                WHERE ordernumber = 'P181129112930142' 
            
2023-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '282124'
                WHERE ordernumber = 'P191129114043844' 
            
2023-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '110374'
                WHERE ordernumber = 'P201129114617738' 
            
2023-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349871'
                WHERE ordernumber = 'P421129114851573' 
            
2023-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '229786'
                WHERE ordernumber = 'P201129115056718' 
            
2023-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349873'
                WHERE ordernumber = 'P421129115624708' 
            
2023-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '234818'
                WHERE ordernumber = 'P191129120017867' 
            
2023-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '259867'
                WHERE ordernumber = 'P421129120217231' 
            
2023-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349875'
                WHERE ordernumber = 'P421129120403702' 
            
2023-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '219133'
                WHERE ordernumber = 'P201129120434503' 
            
2023-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '125425'
                WHERE ordernumber = 'P421129120633261' 
            
2023-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '87195'
                WHERE ordernumber = 'P191129120741272' 
            
2023-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P191129121323945' 
            
2023-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '103028'
                WHERE ordernumber = 'P201129121623764' 
            
2023-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '301178'
                WHERE ordernumber = 'P201129122119336' 
            
2023-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349877'
                WHERE ordernumber = 'P201129122223532' 
            
2023-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349879'
                WHERE ordernumber = 'P201129122651236' 
            
2023-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349880'
                WHERE ordernumber = 'P201129122729990' 
            
2023-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349881'
                WHERE ordernumber = 'P421129122846120' 
            
2023-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '161247'
                WHERE ordernumber = 'P421129123002670' 
            
2023-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349882'
                WHERE ordernumber = 'P201129123014219' 
            
2023-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349883'
                WHERE ordernumber = 'P191129123045964' 
            
2023-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349884'
                WHERE ordernumber = 'P421129123132496' 
            
2023-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '78501'
                WHERE ordernumber = 'P201129123222625' 
            
2023-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '240957'
                WHERE ordernumber = 'P191129123234506' 
            
2023-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348194'
                WHERE ordernumber = 'P191129123410707' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '308889'
                WHERE ordernumber = 'P191129124410950' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349885'
                WHERE ordernumber = 'P191129124713428' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349886'
                WHERE ordernumber = 'P421129124759630' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347539'
                WHERE ordernumber = 'P201129125040824' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349888'
                WHERE ordernumber = 'P191129125626611' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '152100'
                WHERE ordernumber = 'P191129130000387' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349889'
                WHERE ordernumber = 'P191129130251526' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349890'
                WHERE ordernumber = 'P191129130413450' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349891'
                WHERE ordernumber = 'P191129130549606' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343576'
                WHERE ordernumber = 'P421129130807925' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349892'
                WHERE ordernumber = 'P421129130854956' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349893'
                WHERE ordernumber = 'P421129130959374' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '262399'
                WHERE ordernumber = 'P201129131146945' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349895'
                WHERE ordernumber = 'P201129131436381' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349894'
                WHERE ordernumber = 'P191129131705376' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '206910'
                WHERE ordernumber = 'P191129132024767' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349896'
                WHERE ordernumber = 'P191129132346238' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349897'
                WHERE ordernumber = 'P191129132506429' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '254078'
                WHERE ordernumber = 'P191129132718981' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '90165'
                WHERE ordernumber = 'P201129133242887' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112057'
                WHERE ordernumber = 'P191129134538794' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112057'
                WHERE ordernumber = 'P191129134609379' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343198'
                WHERE ordernumber = 'P201129135201729' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349903'
                WHERE ordernumber = 'P191129140054529' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349905'
                WHERE ordernumber = 'P191129141420480' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340190'
                WHERE ordernumber = 'P191129141552852' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '308228'
                WHERE ordernumber = 'P201129141710711' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349904'
                WHERE ordernumber = 'P421129141736191' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349907'
                WHERE ordernumber = 'P421129141823621' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349908'
                WHERE ordernumber = 'P201129142216221' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '330671'
                WHERE ordernumber = 'P421129142243485' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99956'
                WHERE ordernumber = 'P201129142652865' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '142262'
                WHERE ordernumber = 'P191129142814185' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '223799'
                WHERE ordernumber = 'P201129142951596' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284471'
                WHERE ordernumber = 'P201129143304202' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349911'
                WHERE ordernumber = 'P201129143600179' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307336'
                WHERE ordernumber = 'P191129144442696' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '170523'
                WHERE ordernumber = 'P421129145839436' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349913'
                WHERE ordernumber = 'P191129150048734' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '223817'
                WHERE ordernumber = 'P191129150103367' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '170523'
                WHERE ordernumber = 'P421129150123585' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '74778'
                WHERE ordernumber = 'P201129150141574' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349914'
                WHERE ordernumber = 'P201129150747605' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '252044'
                WHERE ordernumber = 'P201129150937136' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286925'
                WHERE ordernumber = 'P201129151219536' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349915'
                WHERE ordernumber = 'P421129151312405' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '34609'
                WHERE ordernumber = 'P191129151859674' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349916'
                WHERE ordernumber = 'P191129152541253' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349918'
                WHERE ordernumber = 'P191129152928581' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287465'
                WHERE ordernumber = 'P191129153012437' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '165627'
                WHERE ordernumber = 'P201129153440686' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '128881'
                WHERE ordernumber = 'P191129153454904' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349921'
                WHERE ordernumber = 'P421129154028759' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349920'
                WHERE ordernumber = 'P191129154128578' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347408'
                WHERE ordernumber = 'P191129154355908' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '85271'
                WHERE ordernumber = 'P201129154458490' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349924'
                WHERE ordernumber = 'P191129154758923' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349925'
                WHERE ordernumber = 'P191129155128192' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349927'
                WHERE ordernumber = 'P191129155602302' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349928'
                WHERE ordernumber = 'P191129155741527' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349929'
                WHERE ordernumber = 'P191129155917979' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '317237'
                WHERE ordernumber = 'P191129160007677' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349927'
                WHERE ordernumber = 'P191129160223975' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285764'
                WHERE ordernumber = 'P191129160425340' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98567'
                WHERE ordernumber = 'P181129161520377' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '220663'
                WHERE ordernumber = 'P181129161850966' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349935'
                WHERE ordernumber = 'P421129162717246' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349932'
                WHERE ordernumber = 'P181129162819723' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349936'
                WHERE ordernumber = 'P181129162942525' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349937'
                WHERE ordernumber = 'P181129163142328' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349923'
                WHERE ordernumber = 'P181129163433196' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349938'
                WHERE ordernumber = 'P181129163627557' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275250'
                WHERE ordernumber = 'P201129163924881' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337318'
                WHERE ordernumber = 'P201129164646804' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '108330'
                WHERE ordernumber = 'P201129165041154' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '128944'
                WHERE ordernumber = 'P201129170549243' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '128944'
                WHERE ordernumber = 'P201129170652724' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349939'
                WHERE ordernumber = 'P201129170957523' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '267616'
                WHERE ordernumber = 'P191129171449674' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '326275'
                WHERE ordernumber = 'P201129171518743' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349651'
                WHERE ordernumber = 'P191129171829363' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349940'
                WHERE ordernumber = 'P191129172220600' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '166466'
                WHERE ordernumber = 'P191129172312445' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349559'
                WHERE ordernumber = 'P191129172456756' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349942'
                WHERE ordernumber = 'P421129172646143' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349944'
                WHERE ordernumber = 'P191129172929985' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '262008'
                WHERE ordernumber = 'P201129173109491' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349944'
                WHERE ordernumber = 'P191129173505664' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304511'
                WHERE ordernumber = 'P191129173601182' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100508'
                WHERE ordernumber = 'P191129173841358' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349946'
                WHERE ordernumber = 'P421129174423209' 
            
2023-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347398'
                WHERE ordernumber = 'P191129175348978' 
            
2023-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '273534'
                WHERE ordernumber = 'P201129182527999' 
            
2023-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '42922'
                WHERE ordernumber = 'P201129183057604' 
            
2023-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349950'
                WHERE ordernumber = 'P191129183927185' 
            
2023-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '208434'
                WHERE ordernumber = 'P201129184040116' 
            
2023-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '251715'
                WHERE ordernumber = 'P201129184332280' 
            
2023-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349951'
                WHERE ordernumber = 'P201129184438776' 
            
2023-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346016'
                WHERE ordernumber = 'P191129184452243' 
            
2023-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '285630'
                WHERE ordernumber = 'P191129184559195' 
            
2023-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349952'
                WHERE ordernumber = 'P201129185722616' 
            
2023-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349952'
                WHERE ordernumber = 'P201129185852821' 
            
2023-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349953'
                WHERE ordernumber = 'P201129190501988' 
            
2023-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346253'
                WHERE ordernumber = 'P201129190659173' 
            
2023-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349955'
                WHERE ordernumber = 'P201129191140666' 
            
2023-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348730'
                WHERE ordernumber = 'P191129191151580' 
            
2023-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '221941'
                WHERE ordernumber = 'P201129191210685' 
            
2023-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348730'
                WHERE ordernumber = 'P191129191303674' 
            
2023-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '319142'
                WHERE ordernumber = 'P421129191942842' 
            
2023-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344166'
                WHERE ordernumber = 'P191129192601441' 
            
2023-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349956'
                WHERE ordernumber = 'P201129193101867' 
            
2023-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349957'
                WHERE ordernumber = 'P201129193653388' 
            
2023-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238767'
                WHERE ordernumber = 'P191129193718250' 
            
2023-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349571'
                WHERE ordernumber = 'P201129193901300' 
            
2023-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94067'
                WHERE ordernumber = 'P191129194331390' 
            
2023-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349958'
                WHERE ordernumber = 'P191129195013306' 
            
2023-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230003'
                WHERE ordernumber = 'P191129195405643' 
            
2023-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103167'
                WHERE ordernumber = 'P201129200053786' 
            
2023-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349959'
                WHERE ordernumber = 'P201129200214999'