2024-03-27 01:00:02 -- 將會員中心id寫入data-lake
2024-03-27 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-03-26%';
        
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100756'
                WHERE ordernumber = 'P190326110222866' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '270513'
                WHERE ordernumber = 'P200326110313832' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380903'
                WHERE ordernumber = 'P420326110446912' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '120908'
                WHERE ordernumber = 'P180326110454679' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383161'
                WHERE ordernumber = 'P420326110641584' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '122935'
                WHERE ordernumber = 'P200326110830169' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '108272'
                WHERE ordernumber = 'P180326111114975' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383163'
                WHERE ordernumber = 'P180326111312536' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383165'
                WHERE ordernumber = 'P180326111527513' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112386'
                WHERE ordernumber = 'P190326111625140' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383166'
                WHERE ordernumber = 'P180326111646699' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353242'
                WHERE ordernumber = 'P180326111721150' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245786'
                WHERE ordernumber = 'P180326111934477' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214179'
                WHERE ordernumber = 'P180326112048959' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383167'
                WHERE ordernumber = 'P190326112141501' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '89746'
                WHERE ordernumber = 'P180326112254553' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383169'
                WHERE ordernumber = 'P180326113021164' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228918'
                WHERE ordernumber = 'P180326113450892' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383171'
                WHERE ordernumber = 'P190326113602171' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371971'
                WHERE ordernumber = 'P200326114154569' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '166311'
                WHERE ordernumber = 'P200326114404517' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '229589'
                WHERE ordernumber = 'P180326114421425' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '111709'
                WHERE ordernumber = 'P180326115101360' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351303'
                WHERE ordernumber = 'P420326115139623' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380459'
                WHERE ordernumber = 'P420326115231925' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '329671'
                WHERE ordernumber = 'P180326115413173' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383172'
                WHERE ordernumber = 'P420326115500355' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383174'
                WHERE ordernumber = 'P420326120114578' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '57765'
                WHERE ordernumber = 'P180326120323959' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277031'
                WHERE ordernumber = 'P180326120936655' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339542'
                WHERE ordernumber = 'P420326121035220' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383176'
                WHERE ordernumber = 'P180326121151217' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383177'
                WHERE ordernumber = 'P180326121702196' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383178'
                WHERE ordernumber = 'P190326121744927' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382414'
                WHERE ordernumber = 'P190326121902712' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93266'
                WHERE ordernumber = 'P180326121935972' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383179'
                WHERE ordernumber = 'P420326122159206' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '163987'
                WHERE ordernumber = 'P420326122227615' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94592'
                WHERE ordernumber = 'P180326122524655' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383180'
                WHERE ordernumber = 'P200326122601423' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383181'
                WHERE ordernumber = 'P420326123032946' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383182'
                WHERE ordernumber = 'P180326123339991' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383183'
                WHERE ordernumber = 'P420326123422384' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300420'
                WHERE ordernumber = 'P590326123749799' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '149101'
                WHERE ordernumber = 'P200326123759779' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286100'
                WHERE ordernumber = 'P180326124237766' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348545'
                WHERE ordernumber = 'P420326124949785' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '86200'
                WHERE ordernumber = 'P180326125130972' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380077'
                WHERE ordernumber = 'P200326125923648' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378316'
                WHERE ordernumber = 'P420326130041442' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '217089'
                WHERE ordernumber = 'P180326130231410' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235986'
                WHERE ordernumber = 'P200326130638754' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350645'
                WHERE ordernumber = 'P180326131954143' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383186'
                WHERE ordernumber = 'P180326132019251' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '232805'
                WHERE ordernumber = 'P180326132332304' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352793'
                WHERE ordernumber = 'P200326133030248' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383189'
                WHERE ordernumber = 'P420326133812232' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383190'
                WHERE ordernumber = 'P200326133925216' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350741'
                WHERE ordernumber = 'P200326134035367' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383192'
                WHERE ordernumber = 'P190326134319955' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383193'
                WHERE ordernumber = 'P180326134610443' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352460'
                WHERE ordernumber = 'P200326134627367' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383193'
                WHERE ordernumber = 'P180326135413990' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342900'
                WHERE ordernumber = 'P180326135949836' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383197'
                WHERE ordernumber = 'P190326140647422' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383198'
                WHERE ordernumber = 'P200326140826977' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162779'
                WHERE ordernumber = 'P420326141029570' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383199'
                WHERE ordernumber = 'P200326141155601' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381201'
                WHERE ordernumber = 'P420326141157163' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383075'
                WHERE ordernumber = 'P190326142255668' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '201580'
                WHERE ordernumber = 'P200326142422965' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '376195'
                WHERE ordernumber = 'P190326142623126' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '209493'
                WHERE ordernumber = 'P180326143500679' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '167252'
                WHERE ordernumber = 'P180326143753748' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383201'
                WHERE ordernumber = 'P190326143756721' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99048'
                WHERE ordernumber = 'P420326144735338' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353461'
                WHERE ordernumber = 'P420326144830283' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383188'
                WHERE ordernumber = 'P590326145057560' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '292306'
                WHERE ordernumber = 'P200326145529815' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383203'
                WHERE ordernumber = 'P180326145624951' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '292306'
                WHERE ordernumber = 'P200326145907286' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287688'
                WHERE ordernumber = 'P200326150053459' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '292306'
                WHERE ordernumber = 'P200326150151833' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303145'
                WHERE ordernumber = 'P200326150504290' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282746'
                WHERE ordernumber = 'P180326150630933' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383205'
                WHERE ordernumber = 'P190326150819559' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356445'
                WHERE ordernumber = 'P180326152023823' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383208'
                WHERE ordernumber = 'P420326152203485' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383209'
                WHERE ordernumber = 'P190326152354918' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '260398'
                WHERE ordernumber = 'P200326152739501' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '216276'
                WHERE ordernumber = 'P180326153132766' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383210'
                WHERE ordernumber = 'P180326153651429' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302614'
                WHERE ordernumber = 'P200326154910900' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '311329'
                WHERE ordernumber = 'P180326155423456' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383212'
                WHERE ordernumber = 'P190326155517935' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '316185'
                WHERE ordernumber = 'P420326155811319' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383213'
                WHERE ordernumber = 'P180326160249615' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380065'
                WHERE ordernumber = 'P200326160424500' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383213'
                WHERE ordernumber = 'P180326160440290' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354447'
                WHERE ordernumber = 'P420326160812427' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383214'
                WHERE ordernumber = 'P180326160935282' 
            
2024-03-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383215'
                WHERE ordernumber = 'P200326161201466' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383211'
                WHERE ordernumber = 'P180326161253714' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383211'
                WHERE ordernumber = 'P180326161256704' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '374449'
                WHERE ordernumber = 'P420326162228227' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382488'
                WHERE ordernumber = 'P420326162920650' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382488'
                WHERE ordernumber = 'P420326163043691' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102807'
                WHERE ordernumber = 'P180326163632116' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '167291'
                WHERE ordernumber = 'P200326163736273' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383220'
                WHERE ordernumber = 'P180326164808397' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '1592'
                WHERE ordernumber = 'P190326164819664' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383221'
                WHERE ordernumber = 'P180326165054702' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383221'
                WHERE ordernumber = 'P180326165132474' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383111'
                WHERE ordernumber = 'P200326165156814' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383222'
                WHERE ordernumber = 'P190326165158470' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '365173'
                WHERE ordernumber = 'P180326165558925' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282802'
                WHERE ordernumber = 'P200326165930599' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '217519'
                WHERE ordernumber = 'P200326170114499' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383087'
                WHERE ordernumber = 'P200326170216396' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383087'
                WHERE ordernumber = 'P200326170546765' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '364109'
                WHERE ordernumber = 'P200326171424753' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383226'
                WHERE ordernumber = 'P180326171638609' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '117308'
                WHERE ordernumber = 'P180326173443427' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '117308'
                WHERE ordernumber = 'P180326173540575' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301684'
                WHERE ordernumber = 'P190326174810388' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383228'
                WHERE ordernumber = 'P180326174955224' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383229'
                WHERE ordernumber = 'P190326175216593' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381733'
                WHERE ordernumber = 'P180326175243861' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383229'
                WHERE ordernumber = 'P190326175324203' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377529'
                WHERE ordernumber = 'P200326175355579' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '257823'
                WHERE ordernumber = 'P200326175550404' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230097'
                WHERE ordernumber = 'P190326175826456' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383230'
                WHERE ordernumber = 'P180326175924452' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '307064'
                WHERE ordernumber = 'P180326180402358' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383231'
                WHERE ordernumber = 'P190326180526515' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383234'
                WHERE ordernumber = 'P180326182147253' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '108330'
                WHERE ordernumber = 'P420326182149694' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383235'
                WHERE ordernumber = 'P200326182452481' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383235'
                WHERE ordernumber = 'P200326182904849' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379256'
                WHERE ordernumber = 'P180326183514643' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383236'
                WHERE ordernumber = 'P190326184625132' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383237'
                WHERE ordernumber = 'P420326184807634' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383238'
                WHERE ordernumber = 'P190326190642878' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '121529'
                WHERE ordernumber = 'P200326190703441' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '256465'
                WHERE ordernumber = 'P590326190751536' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '242246'
                WHERE ordernumber = 'P200326191052787' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '279987'
                WHERE ordernumber = 'P200326191328198' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '95172'
                WHERE ordernumber = 'P190326192315808' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383241'
                WHERE ordernumber = 'P190326193151111' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '243328'
                WHERE ordernumber = 'P190326193305378' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '101457'
                WHERE ordernumber = 'P200326193501681' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356453'
                WHERE ordernumber = 'P190326193827713' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383242'
                WHERE ordernumber = 'P420326193843586' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '219636'
                WHERE ordernumber = 'P190326193950879' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '289274'
                WHERE ordernumber = 'P200326194322266' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301837'
                WHERE ordernumber = 'P420326194833186' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '318743'
                WHERE ordernumber = 'P190326194926402' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '375102'
                WHERE ordernumber = 'P190326195116140' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '86113'
                WHERE ordernumber = 'P190326195323379' 
            
2024-03-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '250493'
                WHERE ordernumber = 'P420326195628592'