2024-05-20 01:00:02 -- 將會員中心id寫入data-lake
2024-05-20 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-05-19%';
        
2024-05-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390742'
                WHERE ordernumber = 'P420519104108209' 
            
2024-05-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390743'
                WHERE ordernumber = 'P420519105322975' 
            
2024-05-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '140324'
                WHERE ordernumber = 'P200519110203922' 
            
2024-05-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '309876'
                WHERE ordernumber = 'P200519110340510' 
            
2024-05-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '65115'
                WHERE ordernumber = 'P200519110705484' 
            
2024-05-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '383273'
                WHERE ordernumber = 'P180519110943141' 
            
2024-05-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390745'
                WHERE ordernumber = 'P190519111602492' 
            
2024-05-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '275764'
                WHERE ordernumber = 'P420519111940134' 
            
2024-05-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '231343'
                WHERE ordernumber = 'P180519112324725' 
            
2024-05-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378495'
                WHERE ordernumber = 'P190519112416659' 
            
2024-05-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390746'
                WHERE ordernumber = 'P420519112420839' 
            
2024-05-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390747'
                WHERE ordernumber = 'P190519112929693' 
            
2024-05-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '209572'
                WHERE ordernumber = 'P180519113057456' 
            
2024-05-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390748'
                WHERE ordernumber = 'P420519113327327' 
            
2024-05-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390749'
                WHERE ordernumber = 'P180519113451623' 
            
2024-05-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390750'
                WHERE ordernumber = 'P190519113600490' 
            
2024-05-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '210593'
                WHERE ordernumber = 'P180519114434614' 
            
2024-05-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '115230'
                WHERE ordernumber = 'P180519114651816' 
            
2024-05-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390751'
                WHERE ordernumber = 'P420519114815780' 
            
2024-05-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '161965'
                WHERE ordernumber = 'P200519114845922' 
            
2024-05-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390752'
                WHERE ordernumber = 'P420519115419254' 
            
2024-05-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390753'
                WHERE ordernumber = 'P200519115545450' 
            
2024-05-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390754'
                WHERE ordernumber = 'P590519115743292' 
            
2024-05-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390755'
                WHERE ordernumber = 'P190519120153621' 
            
2024-05-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '269333'
                WHERE ordernumber = 'P200519120639448' 
            
2024-05-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '269333'
                WHERE ordernumber = 'P200519120646960' 
            
2024-05-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '230029'
                WHERE ordernumber = 'P420519120729154' 
            
2024-05-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390756'
                WHERE ordernumber = 'P180519121124521' 
            
2024-05-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387322'
                WHERE ordernumber = 'P200519121209225' 
            
2024-05-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287900'
                WHERE ordernumber = 'P190519121506403' 
            
2024-05-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390758'
                WHERE ordernumber = 'P190519121650973' 
            
2024-05-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390757'
                WHERE ordernumber = 'P180519121651964' 
            
2024-05-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390759'
                WHERE ordernumber = 'P420519121925389' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390760'
                WHERE ordernumber = 'P420519122044593' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390761'
                WHERE ordernumber = 'P180519122125772' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390761'
                WHERE ordernumber = 'P180519122151124' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '153642'
                WHERE ordernumber = 'P180519122710539' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '127611'
                WHERE ordernumber = 'P180519122855886' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382707'
                WHERE ordernumber = 'P420519123006371' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390764'
                WHERE ordernumber = 'P180519123543363' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378768'
                WHERE ordernumber = 'P200519123735821' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390736'
                WHERE ordernumber = 'P180519123850173' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390766'
                WHERE ordernumber = 'P420519124240556' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390767'
                WHERE ordernumber = 'P420519124345651' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390765'
                WHERE ordernumber = 'P180519124447651' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287900'
                WHERE ordernumber = 'P190519124645741' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390768'
                WHERE ordernumber = 'P790519124826916' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390769'
                WHERE ordernumber = 'P420519124853706' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390770'
                WHERE ordernumber = 'P420519125107805' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390771'
                WHERE ordernumber = 'P190519125412968' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383862'
                WHERE ordernumber = 'P180519125634950' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390772'
                WHERE ordernumber = 'P190519125921551' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383862'
                WHERE ordernumber = 'P180519130042618' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390773'
                WHERE ordernumber = 'P200519130600485' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390774'
                WHERE ordernumber = 'P420519130950281' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389804'
                WHERE ordernumber = 'P420519131323881' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '220338'
                WHERE ordernumber = 'P180519131340918' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390775'
                WHERE ordernumber = 'P420519132022139' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286415'
                WHERE ordernumber = 'P200519132205381' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390776'
                WHERE ordernumber = 'P180519132542726' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237681'
                WHERE ordernumber = 'P180519132857895' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365090'
                WHERE ordernumber = 'P420519132928807' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '329966'
                WHERE ordernumber = 'P180519133034369' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '204771'
                WHERE ordernumber = 'P420519133044481' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '89096'
                WHERE ordernumber = 'P200519133133575' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390777'
                WHERE ordernumber = 'P630519133318510' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '137581'
                WHERE ordernumber = 'P180519133326354' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390780'
                WHERE ordernumber = 'P420519133824990' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390781'
                WHERE ordernumber = 'P190519134131929' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '165237'
                WHERE ordernumber = 'P200519134446665' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390782'
                WHERE ordernumber = 'P180519134512125' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315402'
                WHERE ordernumber = 'P200519134925977' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370294'
                WHERE ordernumber = 'P630519134959745' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162082'
                WHERE ordernumber = 'P180519135049740' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '171032'
                WHERE ordernumber = 'P420519135258409' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390785'
                WHERE ordernumber = 'P200519135504259' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '133368'
                WHERE ordernumber = 'P630519135527825' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390786'
                WHERE ordernumber = 'P200519135737230' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390787'
                WHERE ordernumber = 'P630519135923999' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390060'
                WHERE ordernumber = 'P420519135940595' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390788'
                WHERE ordernumber = 'P190519140022471' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305849'
                WHERE ordernumber = 'P180519140024991' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390784'
                WHERE ordernumber = 'P200519140040285' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390789'
                WHERE ordernumber = 'P420519140106302' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390790'
                WHERE ordernumber = 'P190519140249952' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390753'
                WHERE ordernumber = 'P200519140649429' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94666'
                WHERE ordernumber = 'P200519140806575' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390791'
                WHERE ordernumber = 'P190519141123344' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '115196'
                WHERE ordernumber = 'P180519141144131' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390792'
                WHERE ordernumber = 'P420519141333403' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '255211'
                WHERE ordernumber = 'P420519141650388' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390793'
                WHERE ordernumber = 'P420519141801503' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390793'
                WHERE ordernumber = 'P420519142225447' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390794'
                WHERE ordernumber = 'P420519142317238' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390795'
                WHERE ordernumber = 'P200519142519645' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342488'
                WHERE ordernumber = 'P420519142855187' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390796'
                WHERE ordernumber = 'P420519143710912' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '195703'
                WHERE ordernumber = 'P180519143825885' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '137825'
                WHERE ordernumber = 'P420519143949491' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390797'
                WHERE ordernumber = 'P630519144352539' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390798'
                WHERE ordernumber = 'P180519144411160' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '58075'
                WHERE ordernumber = 'P630519144540180' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '157229'
                WHERE ordernumber = 'P200519144603272' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103365'
                WHERE ordernumber = 'P180519144606289' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390799'
                WHERE ordernumber = 'P180519144741341' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390800'
                WHERE ordernumber = 'P180519145009502' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390802'
                WHERE ordernumber = 'P420519145319522' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '67118'
                WHERE ordernumber = 'P420519145838161' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390805'
                WHERE ordernumber = 'P190519150048926' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390807'
                WHERE ordernumber = 'P420519150122918' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390803'
                WHERE ordernumber = 'P790519150207428' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309272'
                WHERE ordernumber = 'P180519150323775' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390808'
                WHERE ordernumber = 'P420519150512181' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '67118'
                WHERE ordernumber = 'P420519150557400' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '84778'
                WHERE ordernumber = 'P180519150700780' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390811'
                WHERE ordernumber = 'P420519151227532' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '137593'
                WHERE ordernumber = 'P190519151248729' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390813'
                WHERE ordernumber = 'P420519151322798' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390815'
                WHERE ordernumber = 'P190519151434609' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390814'
                WHERE ordernumber = 'P790519151538436' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '114727'
                WHERE ordernumber = 'P200519151800520' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390816'
                WHERE ordernumber = 'P420519151844733' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390818'
                WHERE ordernumber = 'P630519152007503' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '67118'
                WHERE ordernumber = 'P420519152116888' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390820'
                WHERE ordernumber = 'P200519152536725' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '154540'
                WHERE ordernumber = 'P790519153014542' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390821'
                WHERE ordernumber = 'P790519153401780' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390822'
                WHERE ordernumber = 'P790519153926618' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390823'
                WHERE ordernumber = 'P200519154008557' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390819'
                WHERE ordernumber = 'P420519154314872' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390824'
                WHERE ordernumber = 'P200519154519953' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390825'
                WHERE ordernumber = 'P420519154657998' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390826'
                WHERE ordernumber = 'P180519154849885' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390827'
                WHERE ordernumber = 'P420519155303443' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '77040'
                WHERE ordernumber = 'P200519155414225' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387665'
                WHERE ordernumber = 'P420519155454141' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390830'
                WHERE ordernumber = 'P790519155737316' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390832'
                WHERE ordernumber = 'P420519155756170' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390833'
                WHERE ordernumber = 'P420519155948809' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380469'
                WHERE ordernumber = 'P420519160439255' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390836'
                WHERE ordernumber = 'P200519161023739' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390837'
                WHERE ordernumber = 'P420519161037883' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390839'
                WHERE ordernumber = 'P200519161515887' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390840'
                WHERE ordernumber = 'P180519162026466' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390841'
                WHERE ordernumber = 'P420519162421351' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100706'
                WHERE ordernumber = 'P180519163429737' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390843'
                WHERE ordernumber = 'P190519163706725' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390842'
                WHERE ordernumber = 'P200519163711597' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '141799'
                WHERE ordernumber = 'P200519164124167' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390845'
                WHERE ordernumber = 'P200519165031504' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387541'
                WHERE ordernumber = 'P420519165421314' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '234151'
                WHERE ordernumber = 'P200519165805453' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390846'
                WHERE ordernumber = 'P790519165852719' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '280479'
                WHERE ordernumber = 'P200519165930803' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384691'
                WHERE ordernumber = 'P180519165949556' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383114'
                WHERE ordernumber = 'P420519170003627' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390847'
                WHERE ordernumber = 'P420519170128878' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343585'
                WHERE ordernumber = 'P180519170214705' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390848'
                WHERE ordernumber = 'P420519170219295' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389415'
                WHERE ordernumber = 'P180519170501848' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '231921'
                WHERE ordernumber = 'P200519170735931' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390850'
                WHERE ordernumber = 'P420519170927716' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '259189'
                WHERE ordernumber = 'P190519171225941' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390851'
                WHERE ordernumber = 'P420519172018333' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94264'
                WHERE ordernumber = 'P200519172212392' 
            
2024-05-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390854'
                WHERE ordernumber = 'P200519172329801' 
            
2024-05-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390855'
                WHERE ordernumber = 'P420519172358223' 
            
2024-05-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '267019'
                WHERE ordernumber = 'P180519172503660' 
            
2024-05-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390856'
                WHERE ordernumber = 'P200519172730777' 
            
2024-05-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '243893'
                WHERE ordernumber = 'P420519172814574' 
            
2024-05-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '292297'
                WHERE ordernumber = 'P200519172851297' 
            
2024-05-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390857'
                WHERE ordernumber = 'P200519173014483' 
            
2024-05-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390858'
                WHERE ordernumber = 'P420519173427780' 
            
2024-05-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390859'
                WHERE ordernumber = 'P200519173721501' 
            
2024-05-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '244563'
                WHERE ordernumber = 'P790519174145326' 
            
2024-05-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390860'
                WHERE ordernumber = 'P180519174206829' 
            
2024-05-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390862'
                WHERE ordernumber = 'P200519175130656' 
            
2024-05-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347676'
                WHERE ordernumber = 'P180519175453128' 
            
2024-05-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385838'
                WHERE ordernumber = 'P630519175548384' 
            
2024-05-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390863'
                WHERE ordernumber = 'P180519175650890' 
            
2024-05-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390867'
                WHERE ordernumber = 'P420519181407753' 
            
2024-05-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '369186'
                WHERE ordernumber = 'P420519181550731' 
            
2024-05-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '24'
                WHERE ordernumber = 'P200519182226947' 
            
2024-05-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '235645'
                WHERE ordernumber = 'P180519182301295' 
            
2024-05-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390868'
                WHERE ordernumber = 'P200519182440266' 
            
2024-05-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390869'
                WHERE ordernumber = 'P420519183003739' 
            
2024-05-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '123639'
                WHERE ordernumber = 'P790519183554252' 
            
2024-05-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390870'
                WHERE ordernumber = 'P190519183820452' 
            
2024-05-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390871'
                WHERE ordernumber = 'P190519184517936' 
            
2024-05-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390861'
                WHERE ordernumber = 'P420519184712362' 
            
2024-05-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390872'
                WHERE ordernumber = 'P190519184717257' 
            
2024-05-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '368057'
                WHERE ordernumber = 'P190519185848888' 
            
2024-05-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390874'
                WHERE ordernumber = 'P190519190202789' 
            
2024-05-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '160130'
                WHERE ordernumber = 'P190519190735556' 
            
2024-05-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388542'
                WHERE ordernumber = 'P190519190857882' 
            
2024-05-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390876'
                WHERE ordernumber = 'P200519191237399' 
            
2024-05-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '291412'
                WHERE ordernumber = 'P190519191304966' 
            
2024-05-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390878'
                WHERE ordernumber = 'P420519191625352' 
            
2024-05-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390879'
                WHERE ordernumber = 'P200519191702592' 
            
2024-05-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305444'
                WHERE ordernumber = 'P420519192226744' 
            
2024-05-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390880'
                WHERE ordernumber = 'P200519192730926' 
            
2024-05-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '13609'
                WHERE ordernumber = 'P420519193339267' 
            
2024-05-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390882'
                WHERE ordernumber = 'P420519193747424' 
            
2024-05-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390883'
                WHERE ordernumber = 'P420519193943626' 
            
2024-05-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236777'
                WHERE ordernumber = 'P630519200850331' 
            
2024-05-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '279592'
                WHERE ordernumber = 'P630519203249310' 
            
2024-05-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390888'
                WHERE ordernumber = 'P790519210358524'