2024-11-07 01:00:01 -- 將會員中心id寫入data-lake
2024-11-07 01:00:01 -- 
            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-06%';
        
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429131'
                WHERE ordernumber = 'P421106110508613' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '417940'
                WHERE ordernumber = 'P191106110524477' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '239130'
                WHERE ordernumber = 'P181106110647821' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '368762'
                WHERE ordernumber = 'P421106110658752' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '240974'
                WHERE ordernumber = 'P191106110707451' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421735'
                WHERE ordernumber = 'P201106110958952' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428868'
                WHERE ordernumber = 'P201106111044205' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428690'
                WHERE ordernumber = 'P191106111047444' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429132'
                WHERE ordernumber = 'P421106111243562' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429133'
                WHERE ordernumber = 'P421106111551695' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429134'
                WHERE ordernumber = 'P201106111648268' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429135'
                WHERE ordernumber = 'P201106111836152' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429136'
                WHERE ordernumber = 'P201106111957125' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '384940'
                WHERE ordernumber = 'P201106112119727' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '246405'
                WHERE ordernumber = 'P181106112140460' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '245281'
                WHERE ordernumber = 'P201106112700590' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429138'
                WHERE ordernumber = 'P181106112859387' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429137'
                WHERE ordernumber = 'P181106113001932' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429140'
                WHERE ordernumber = 'P181106113154948' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '383239'
                WHERE ordernumber = 'P181106113248795' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '218728'
                WHERE ordernumber = 'P201106113532496' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '351008'
                WHERE ordernumber = 'P181106113942637' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429139'
                WHERE ordernumber = 'P181106114119406' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429142'
                WHERE ordernumber = 'P421106114437501' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429143'
                WHERE ordernumber = 'P421106114834242' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '237288'
                WHERE ordernumber = 'P201106115327180' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '279829'
                WHERE ordernumber = 'P201106115409887' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '295422'
                WHERE ordernumber = 'P201106115518383' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429145'
                WHERE ordernumber = 'P181106115552637' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429146'
                WHERE ordernumber = 'P421106115616696' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '284418'
                WHERE ordernumber = 'P201106115619968' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429144'
                WHERE ordernumber = 'P181106115707742' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429147'
                WHERE ordernumber = 'P181106115840350' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429149'
                WHERE ordernumber = 'P181106120144499' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '293405'
                WHERE ordernumber = 'P191106120158902' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429150'
                WHERE ordernumber = 'P421106120208987' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429151'
                WHERE ordernumber = 'P421106120318152' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429152'
                WHERE ordernumber = 'P421106120401255' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '46092'
                WHERE ordernumber = 'P181106120410818' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429153'
                WHERE ordernumber = 'P421106120446804' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429154'
                WHERE ordernumber = 'P421106120721628' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429155'
                WHERE ordernumber = 'P421106120916213' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429156'
                WHERE ordernumber = 'P421106121423740' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429157'
                WHERE ordernumber = 'P181106121538764' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P201106121653198' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429159'
                WHERE ordernumber = 'P181106122157387' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429163'
                WHERE ordernumber = 'P201106125002143' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427206'
                WHERE ordernumber = 'P771106125524412' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '280172'
                WHERE ordernumber = 'P181106125559158' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429164'
                WHERE ordernumber = 'P181106125936132' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429166'
                WHERE ordernumber = 'P201106130029255' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427073'
                WHERE ordernumber = 'P201106130617945' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '161590'
                WHERE ordernumber = 'P771106131000239' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429167'
                WHERE ordernumber = 'P421106131208746' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '275266'
                WHERE ordernumber = 'P181106131438719' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429168'
                WHERE ordernumber = 'P771106131917846' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '335730'
                WHERE ordernumber = 'P421106131924423' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '302675'
                WHERE ordernumber = 'P771106132321309' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '331533'
                WHERE ordernumber = 'P181106132500484' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '313481'
                WHERE ordernumber = 'P181106132718928' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429171'
                WHERE ordernumber = 'P771106132816597' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429172'
                WHERE ordernumber = 'P771106132959361' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '286318'
                WHERE ordernumber = 'P771106133137229' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '316185'
                WHERE ordernumber = 'P421106134205965' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429174'
                WHERE ordernumber = 'P421106135038984' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '317251'
                WHERE ordernumber = 'P631106135641738' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429176'
                WHERE ordernumber = 'P201106140248530' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390416'
                WHERE ordernumber = 'P181106140549274' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '245473'
                WHERE ordernumber = 'P181106140634381' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429177'
                WHERE ordernumber = 'P421106143318851' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '368739'
                WHERE ordernumber = 'P181106144351637' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386512'
                WHERE ordernumber = 'P201106144351856' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407903'
                WHERE ordernumber = 'P421106144458417' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421985'
                WHERE ordernumber = 'P181106144936336' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '104455'
                WHERE ordernumber = 'P191106145112459' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '104455'
                WHERE ordernumber = 'P191106145442433' 
            
2024-11-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429181'
                WHERE ordernumber = 'P201106150926268' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '49338'
                WHERE ordernumber = 'P191106151022186' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282723'
                WHERE ordernumber = 'P191106151455417' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '290220'
                WHERE ordernumber = 'P181106152334463' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429182'
                WHERE ordernumber = 'P421106152632941' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '85369'
                WHERE ordernumber = 'P421106152706252' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '85369'
                WHERE ordernumber = 'P421106152739602' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355659'
                WHERE ordernumber = 'P181106152900703' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103922'
                WHERE ordernumber = 'P181106153353190' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341045'
                WHERE ordernumber = 'P201106154008902' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '328134'
                WHERE ordernumber = 'P181106154426726' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429184'
                WHERE ordernumber = 'P771106160710341' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302505'
                WHERE ordernumber = 'P181106160802664' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429185'
                WHERE ordernumber = 'P421106161029619' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P181106161301602' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374382'
                WHERE ordernumber = 'P771106161412828' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '260675'
                WHERE ordernumber = 'P201106161503871' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353461'
                WHERE ordernumber = 'P421106161822992' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429188'
                WHERE ordernumber = 'P201106162257789' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '325137'
                WHERE ordernumber = 'P201106162350984' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429188'
                WHERE ordernumber = 'P201106162443313' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429186'
                WHERE ordernumber = 'P771106162443358' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429190'
                WHERE ordernumber = 'P771106162931604' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429191'
                WHERE ordernumber = 'P201106162939935' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406463'
                WHERE ordernumber = 'P181106163145719' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '268585'
                WHERE ordernumber = 'P201106163815164' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297594'
                WHERE ordernumber = 'P181106164127751' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '330603'
                WHERE ordernumber = 'P181106164320886' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429193'
                WHERE ordernumber = 'P201106165110401' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '335123'
                WHERE ordernumber = 'P181106165640205' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429194'
                WHERE ordernumber = 'P181106170253818' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428151'
                WHERE ordernumber = 'P201106170357142' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '258030'
                WHERE ordernumber = 'P201106170450263' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429197'
                WHERE ordernumber = 'P771106170713194' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428068'
                WHERE ordernumber = 'P421106170729611' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '141131'
                WHERE ordernumber = 'P201106170731154' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429199'
                WHERE ordernumber = 'P771106170937787' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287156'
                WHERE ordernumber = 'P181106172153851' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '80892'
                WHERE ordernumber = 'P181106172515394' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429203'
                WHERE ordernumber = 'P771106172845918' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344318'
                WHERE ordernumber = 'P421106172855156' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429205'
                WHERE ordernumber = 'P201106173002615' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429204'
                WHERE ordernumber = 'P771106173048663' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '133024'
                WHERE ordernumber = 'P201106173143119' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429205'
                WHERE ordernumber = 'P201106173429395' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429207'
                WHERE ordernumber = 'P421106173741500' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429208'
                WHERE ordernumber = 'P181106173957309' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429208'
                WHERE ordernumber = 'P181106174028111' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429209'
                WHERE ordernumber = 'P181106174207533' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429209'
                WHERE ordernumber = 'P181106174211354' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429206'
                WHERE ordernumber = 'P201106174617449' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279995'
                WHERE ordernumber = 'P181106175008861' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429211'
                WHERE ordernumber = 'P421106175441576' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '80681'
                WHERE ordernumber = 'P181106180015790' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348116'
                WHERE ordernumber = 'P181106180513392' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97110'
                WHERE ordernumber = 'P631106180608185' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '204691'
                WHERE ordernumber = 'P181106181504722' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '273951'
                WHERE ordernumber = 'P201106182306665' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '136521'
                WHERE ordernumber = 'P181106182352706' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344155'
                WHERE ordernumber = 'P181106183007787' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428124'
                WHERE ordernumber = 'P421106183321803' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101457'
                WHERE ordernumber = 'P201106183538368' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429214'
                WHERE ordernumber = 'P421106184151547' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429215'
                WHERE ordernumber = 'P201106184829672' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '270129'
                WHERE ordernumber = 'P191106185136815' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429217'
                WHERE ordernumber = 'P191106185419553' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424461'
                WHERE ordernumber = 'P191106185753285' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429218'
                WHERE ordernumber = 'P201106185847577' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245580'
                WHERE ordernumber = 'P191106185920164' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429220'
                WHERE ordernumber = 'P191106190249481' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424461'
                WHERE ordernumber = 'P191106190406434' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '111371'
                WHERE ordernumber = 'P191106190918704' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306488'
                WHERE ordernumber = 'P201106190919930' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429221'
                WHERE ordernumber = 'P201106191136801' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313332'
                WHERE ordernumber = 'P201106192307233' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429222'
                WHERE ordernumber = 'P191106192409663' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309221'
                WHERE ordernumber = 'P201106193136234' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402607'
                WHERE ordernumber = 'P191106193350458' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429224'
                WHERE ordernumber = 'P191106194232860' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427582'
                WHERE ordernumber = 'P631106201452485' 
            
2024-11-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '246050'
                WHERE ordernumber = 'P631106203233537'