2024-08-14 01:00:01 -- 將會員中心id寫入data-lake
2024-08-14 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-08-13%';
        
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '384779'
                WHERE ordernumber = 'P630813102525580' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407727'
                WHERE ordernumber = 'P200813110301830' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389064'
                WHERE ordernumber = 'P180813110325884' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407810'
                WHERE ordernumber = 'P190813110416146' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407812'
                WHERE ordernumber = 'P180813110533971' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406328'
                WHERE ordernumber = 'P190813110541825' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407813'
                WHERE ordernumber = 'P180813110707779' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '363919'
                WHERE ordernumber = 'P420813110917676' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407816'
                WHERE ordernumber = 'P180813111011990' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '290257'
                WHERE ordernumber = 'P420813111416355' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407819'
                WHERE ordernumber = 'P200813111428900' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407822'
                WHERE ordernumber = 'P190813111539509' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407820'
                WHERE ordernumber = 'P180813111559242' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '285886'
                WHERE ordernumber = 'P190813112003851' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '230115'
                WHERE ordernumber = 'P190813112112687' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398160'
                WHERE ordernumber = 'P420813112252309' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407824'
                WHERE ordernumber = 'P180813112427402' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407826'
                WHERE ordernumber = 'P180813113134516' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '297714'
                WHERE ordernumber = 'P420813113158868' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '239376'
                WHERE ordernumber = 'P180813113244507' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407827'
                WHERE ordernumber = 'P420813113426611' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407830'
                WHERE ordernumber = 'P180813113756844' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407835'
                WHERE ordernumber = 'P200813114713480' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '404268'
                WHERE ordernumber = 'P180813115754909' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391928'
                WHERE ordernumber = 'P190813115837651' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407844'
                WHERE ordernumber = 'P200813120325219' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407845'
                WHERE ordernumber = 'P420813120357338' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407846'
                WHERE ordernumber = 'P420813120503333' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407847'
                WHERE ordernumber = 'P180813120651740' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407848'
                WHERE ordernumber = 'P190813120725254' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '243161'
                WHERE ordernumber = 'P180813121043508' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407854'
                WHERE ordernumber = 'P180813121729486' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '271180'
                WHERE ordernumber = 'P180813121819863' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407855'
                WHERE ordernumber = 'P200813122026769' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407856'
                WHERE ordernumber = 'P180813122042410' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '44959'
                WHERE ordernumber = 'P420813122054642' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377600'
                WHERE ordernumber = 'P180813122518294' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407858'
                WHERE ordernumber = 'P200813122634453' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407859'
                WHERE ordernumber = 'P180813122905622' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '135897'
                WHERE ordernumber = 'P180813123412351' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '295357'
                WHERE ordernumber = 'P200813123849356' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '246060'
                WHERE ordernumber = 'P180813124314624' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '86200'
                WHERE ordernumber = 'P180813124712500' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '88490'
                WHERE ordernumber = 'P200813124732234' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '125656'
                WHERE ordernumber = 'P200813125244607' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '236174'
                WHERE ordernumber = 'P180813125350444' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '265237'
                WHERE ordernumber = 'P630813125724427' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '313065'
                WHERE ordernumber = 'P180813130605649' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '331702'
                WHERE ordernumber = 'P420813130757826' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407874'
                WHERE ordernumber = 'P200813130810147' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407877'
                WHERE ordernumber = 'P200813131226337' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '336215'
                WHERE ordernumber = 'P420813131432389' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '285602'
                WHERE ordernumber = 'P180813131611521' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407879'
                WHERE ordernumber = 'P200813131824772' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '315543'
                WHERE ordernumber = 'P200813132532619' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '399476'
                WHERE ordernumber = 'P630813133402683' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '288310'
                WHERE ordernumber = 'P180813134202807' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '242008'
                WHERE ordernumber = 'P200813134208584' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407886'
                WHERE ordernumber = 'P420813135024748' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407888'
                WHERE ordernumber = 'P180813135227349' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '245582'
                WHERE ordernumber = 'P180813135527963' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390966'
                WHERE ordernumber = 'P200813140238950' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '315602'
                WHERE ordernumber = 'P420813140742510' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407893'
                WHERE ordernumber = 'P180813141106714' 
            
2024-08-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '405391'
                WHERE ordernumber = 'P420813141409216' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364538'
                WHERE ordernumber = 'P420813141547887' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350190'
                WHERE ordernumber = 'P180813141754881' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407895'
                WHERE ordernumber = 'P420813142009672' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '158000'
                WHERE ordernumber = 'P200813142030679' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404774'
                WHERE ordernumber = 'P200813142147734' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407901'
                WHERE ordernumber = 'P200813142927903' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394934'
                WHERE ordernumber = 'P420813143905384' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407903'
                WHERE ordernumber = 'P420813144031261' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407120'
                WHERE ordernumber = 'P200813144201476' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '333455'
                WHERE ordernumber = 'P420813144325729' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407120'
                WHERE ordernumber = 'P200813144509317' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407907'
                WHERE ordernumber = 'P420813144925554' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407120'
                WHERE ordernumber = 'P200813145346773' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407910'
                WHERE ordernumber = 'P200813145510342' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '64196'
                WHERE ordernumber = 'P180813145759767' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407914'
                WHERE ordernumber = 'P200813145929570' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399804'
                WHERE ordernumber = 'P180813145929743' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '330312'
                WHERE ordernumber = 'P180813150044711' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385758'
                WHERE ordernumber = 'P420813150132191' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354200'
                WHERE ordernumber = 'P200813150435279' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407917'
                WHERE ordernumber = 'P180813150812727' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407924'
                WHERE ordernumber = 'P180813151331199' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242787'
                WHERE ordernumber = 'P200813151502506' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334464'
                WHERE ordernumber = 'P200813152233454' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407934'
                WHERE ordernumber = 'P420813152806399' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394594'
                WHERE ordernumber = 'P180813153238816' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407938'
                WHERE ordernumber = 'P180813153400443' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407823'
                WHERE ordernumber = 'P180813153528952' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407939'
                WHERE ordernumber = 'P420813153606460' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407940'
                WHERE ordernumber = 'P190813153620306' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '260283'
                WHERE ordernumber = 'P180813153707851' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397064'
                WHERE ordernumber = 'P200813154128964' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407948'
                WHERE ordernumber = 'P200813154636840' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407946'
                WHERE ordernumber = 'P420813154703782' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352716'
                WHERE ordernumber = 'P420813154819606' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '224548'
                WHERE ordernumber = 'P200813155001752' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401227'
                WHERE ordernumber = 'P180813155801975' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '236423'
                WHERE ordernumber = 'P180813160326582' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283924'
                WHERE ordernumber = 'P180813160907614' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283924'
                WHERE ordernumber = 'P180813161007499' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249250'
                WHERE ordernumber = 'P200813161212905' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407956'
                WHERE ordernumber = 'P420813161312172' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '138022'
                WHERE ordernumber = 'P180813161355651' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407957'
                WHERE ordernumber = 'P420813161500899' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407958'
                WHERE ordernumber = 'P180813161617396' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242439'
                WHERE ordernumber = 'P200813161639637' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407957'
                WHERE ordernumber = 'P420813161644518' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '326248'
                WHERE ordernumber = 'P190813161648437' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '41701'
                WHERE ordernumber = 'P180813161714603' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '165876'
                WHERE ordernumber = 'P200813161850131' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407957'
                WHERE ordernumber = 'P420813162120790' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407961'
                WHERE ordernumber = 'P180813162522601' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '250390'
                WHERE ordernumber = 'P180813163106169' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407966'
                WHERE ordernumber = 'P420813163504821' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334469'
                WHERE ordernumber = 'P180813163545578' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356460'
                WHERE ordernumber = 'P420813164026720' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371964'
                WHERE ordernumber = 'P420813164432503' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285610'
                WHERE ordernumber = 'P180813164514936' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377470'
                WHERE ordernumber = 'P200813164833931' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276760'
                WHERE ordernumber = 'P420813165600676' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '225396'
                WHERE ordernumber = 'P180813165652139' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374458'
                WHERE ordernumber = 'P590813171130177' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366196'
                WHERE ordernumber = 'P180813171433394' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407975'
                WHERE ordernumber = 'P420813171445115' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340663'
                WHERE ordernumber = 'P200813171539750' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407977'
                WHERE ordernumber = 'P180813171724916' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385513'
                WHERE ordernumber = 'P200813171913241' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235585'
                WHERE ordernumber = 'P200813172039216' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237076'
                WHERE ordernumber = 'P420813172144641' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '121498'
                WHERE ordernumber = 'P200813172337157' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98077'
                WHERE ordernumber = 'P200813172424716' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '119225'
                WHERE ordernumber = 'P190813172949258' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '166466'
                WHERE ordernumber = 'P180813173132723' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '67298'
                WHERE ordernumber = 'P200813173615539' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313957'
                WHERE ordernumber = 'P200813173653521' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407986'
                WHERE ordernumber = 'P190813173732854' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407988'
                WHERE ordernumber = 'P200813174022434' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '261980'
                WHERE ordernumber = 'P200813174306564' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406959'
                WHERE ordernumber = 'P180813174444515' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '294508'
                WHERE ordernumber = 'P200813174509215' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407993'
                WHERE ordernumber = 'P180813174703713' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407995'
                WHERE ordernumber = 'P420813174909297' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407997'
                WHERE ordernumber = 'P180813175440497' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160711'
                WHERE ordernumber = 'P200813175444838' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407998'
                WHERE ordernumber = 'P180813175920287' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '211269'
                WHERE ordernumber = 'P180813180146816' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408001'
                WHERE ordernumber = 'P180813180533540' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241326'
                WHERE ordernumber = 'P180813181203211' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408006'
                WHERE ordernumber = 'P420813181505383' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408007'
                WHERE ordernumber = 'P190813181720234' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408008'
                WHERE ordernumber = 'P190813181825126' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277592'
                WHERE ordernumber = 'P200813181919887' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408010'
                WHERE ordernumber = 'P190813182000183' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408011'
                WHERE ordernumber = 'P420813182506787' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408012'
                WHERE ordernumber = 'P180813182524491' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353667'
                WHERE ordernumber = 'P420813182657275' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '217661'
                WHERE ordernumber = 'P180813182742782' 
            
2024-08-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350384'
                WHERE ordernumber = 'P180813183001584' 
            
2024-08-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '216840'
                WHERE ordernumber = 'P200813183154628' 
            
2024-08-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408014'
                WHERE ordernumber = 'P420813183245565' 
            
2024-08-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '271242'
                WHERE ordernumber = 'P200813183302765' 
            
2024-08-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '216840'
                WHERE ordernumber = 'P200813183340199' 
            
2024-08-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408016'
                WHERE ordernumber = 'P200813183613651' 
            
2024-08-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408017'
                WHERE ordernumber = 'P180813183742944' 
            
2024-08-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408018'
                WHERE ordernumber = 'P190813183854287' 
            
2024-08-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '263701'
                WHERE ordernumber = 'P200813184214689' 
            
2024-08-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '161338'
                WHERE ordernumber = 'P200813184342344' 
            
2024-08-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378067'
                WHERE ordernumber = 'P420813184418730' 
            
2024-08-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406496'
                WHERE ordernumber = 'P200813184627393' 
            
2024-08-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '294398'
                WHERE ordernumber = 'P200813184845478' 
            
2024-08-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408021'
                WHERE ordernumber = 'P200813185046773' 
            
2024-08-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408023'
                WHERE ordernumber = 'P190813185932349' 
            
2024-08-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '246154'
                WHERE ordernumber = 'P420813190054136' 
            
2024-08-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408024'
                WHERE ordernumber = 'P420813190206283' 
            
2024-08-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340376'
                WHERE ordernumber = 'P200813190208664' 
            
2024-08-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408026'
                WHERE ordernumber = 'P200813190344696' 
            
2024-08-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408027'
                WHERE ordernumber = 'P200813190450523' 
            
2024-08-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408028'
                WHERE ordernumber = 'P200813190835861' 
            
2024-08-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99872'
                WHERE ordernumber = 'P190813191231972' 
            
2024-08-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408028'
                WHERE ordernumber = 'P200813191349302' 
            
2024-08-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408031'
                WHERE ordernumber = 'P200813191542501' 
            
2024-08-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408030'
                WHERE ordernumber = 'P190813191547340' 
            
2024-08-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '289986'
                WHERE ordernumber = 'P200813191633873' 
            
2024-08-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408033'
                WHERE ordernumber = 'P190813191701796' 
            
2024-08-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408031'
                WHERE ordernumber = 'P200813191716111' 
            
2024-08-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '375458'
                WHERE ordernumber = 'P190813192013422' 
            
2024-08-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '226172'
                WHERE ordernumber = 'P200813192118698' 
            
2024-08-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337508'
                WHERE ordernumber = 'P190813192651944' 
            
2024-08-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408041'
                WHERE ordernumber = 'P190813192902868' 
            
2024-08-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380155'
                WHERE ordernumber = 'P190813193005866' 
            
2024-08-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313384'
                WHERE ordernumber = 'P190813194455441' 
            
2024-08-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408046'
                WHERE ordernumber = 'P200813194628797' 
            
2024-08-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408047'
                WHERE ordernumber = 'P200813194744825' 
            
2024-08-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389417'
                WHERE ordernumber = 'P630813195002861' 
            
2024-08-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391402'
                WHERE ordernumber = 'P190813195137301' 
            
2024-08-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391402'
                WHERE ordernumber = 'P190813195327483' 
            
2024-08-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408048'
                WHERE ordernumber = 'P200813195453928' 
            
2024-08-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '162872'
                WHERE ordernumber = 'P630813202559346'