2023-11-26 01:00:02 -- 將會員中心id寫入data-lake
2023-11-26 01:00:02 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2023-11-25%';
        
2023-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '317784'
                WHERE ordernumber = 'P421125102556731' 
            
2023-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '342469'
                WHERE ordernumber = 'P421125103744642' 
            
2023-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '290079'
                WHERE ordernumber = 'P421125103842838' 
            
2023-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '343297'
                WHERE ordernumber = 'P421125104056624' 
            
2023-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349159'
                WHERE ordernumber = 'P421125105306280' 
            
2023-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349161'
                WHERE ordernumber = 'P421125105723127' 
            
2023-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349158'
                WHERE ordernumber = 'P181125110633503' 
            
2023-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349158'
                WHERE ordernumber = 'P181125110835169' 
            
2023-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '285049'
                WHERE ordernumber = 'P421125110910297' 
            
2023-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349163'
                WHERE ordernumber = 'P191125110944636' 
            
2023-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349164'
                WHERE ordernumber = 'P421125111059224' 
            
2023-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349165'
                WHERE ordernumber = 'P181125111100227' 
            
2023-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '346338'
                WHERE ordernumber = 'P191125111249507' 
            
2023-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '281760'
                WHERE ordernumber = 'P181125111354755' 
            
2023-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '340965'
                WHERE ordernumber = 'P201125111405430' 
            
2023-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '317216'
                WHERE ordernumber = 'P201125111554277' 
            
2023-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '346338'
                WHERE ordernumber = 'P191125111748890' 
            
2023-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '308583'
                WHERE ordernumber = 'P201125111749320' 
            
2023-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '212515'
                WHERE ordernumber = 'P181125112401541' 
            
2023-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '211643'
                WHERE ordernumber = 'P181125112539285' 
            
2023-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349166'
                WHERE ordernumber = 'P181125112817921' 
            
2023-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '241017'
                WHERE ordernumber = 'P191125113010868' 
            
2023-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349167'
                WHERE ordernumber = 'P201125113439241' 
            
2023-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '32953'
                WHERE ordernumber = 'P201125113548891' 
            
2023-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '81680'
                WHERE ordernumber = 'P181125113713430' 
            
2023-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '241193'
                WHERE ordernumber = 'P181125113816245' 
            
2023-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '138938'
                WHERE ordernumber = 'P181125114937377' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349169'
                WHERE ordernumber = 'P181125115227269' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349170'
                WHERE ordernumber = 'P201125115454655' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '225019'
                WHERE ordernumber = 'P191125115521523' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349171'
                WHERE ordernumber = 'P181125115904528' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349172'
                WHERE ordernumber = 'P201125120001845' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349173'
                WHERE ordernumber = 'P191125120045155' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349174'
                WHERE ordernumber = 'P191125120523468' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '136185'
                WHERE ordernumber = 'P421125120746739' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346191'
                WHERE ordernumber = 'P421125121305507' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '117609'
                WHERE ordernumber = 'P181125121414242' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309489'
                WHERE ordernumber = 'P181125121630651' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349176'
                WHERE ordernumber = 'P421125121703907' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '288246'
                WHERE ordernumber = 'P181125122014430' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240484'
                WHERE ordernumber = 'P181125122150470' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '209310'
                WHERE ordernumber = 'P181125123047246' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275522'
                WHERE ordernumber = 'P191125123157542' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238534'
                WHERE ordernumber = 'P181125123246988' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349179'
                WHERE ordernumber = 'P421125123805268' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '90169'
                WHERE ordernumber = 'P201125124016248' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349181'
                WHERE ordernumber = 'P201125124358783' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113014'
                WHERE ordernumber = 'P181125125018812' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349185'
                WHERE ordernumber = 'P181125125724506' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '217048'
                WHERE ordernumber = 'P181125125920612' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349186'
                WHERE ordernumber = 'P421125125931928' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349187'
                WHERE ordernumber = 'P191125130155412' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349190'
                WHERE ordernumber = 'P421125130659145' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349191'
                WHERE ordernumber = 'P191125130759729' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '332956'
                WHERE ordernumber = 'P421125130807473' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349192'
                WHERE ordernumber = 'P191125130856572' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349193'
                WHERE ordernumber = 'P201125131021242' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '209145'
                WHERE ordernumber = 'P201125131109530' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348674'
                WHERE ordernumber = 'P191125131202772' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343392'
                WHERE ordernumber = 'P181125131457506' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97074'
                WHERE ordernumber = 'P201125131724148' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349194'
                WHERE ordernumber = 'P201125132018900' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343392'
                WHERE ordernumber = 'P181125132141344' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349195'
                WHERE ordernumber = 'P421125132204768' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343392'
                WHERE ordernumber = 'P181125132556764' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277595'
                WHERE ordernumber = 'P421125132735501' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112101'
                WHERE ordernumber = 'P191125132933348' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349196'
                WHERE ordernumber = 'P201125133035322' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349198'
                WHERE ordernumber = 'P181125133449832' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349199'
                WHERE ordernumber = 'P421125133639245' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349200'
                WHERE ordernumber = 'P181125133721779' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '288768'
                WHERE ordernumber = 'P421125133759492' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349201'
                WHERE ordernumber = 'P181125133821570' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '322291'
                WHERE ordernumber = 'P201125133925801' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301384'
                WHERE ordernumber = 'P181125134234595' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349202'
                WHERE ordernumber = 'P181125134445433' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349203'
                WHERE ordernumber = 'P181125134711842' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275283'
                WHERE ordernumber = 'P201125134849712' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '259984'
                WHERE ordernumber = 'P181125135204295' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349204'
                WHERE ordernumber = 'P421125135327658' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '255137'
                WHERE ordernumber = 'P201125135446593' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349206'
                WHERE ordernumber = 'P201125135923537' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349207'
                WHERE ordernumber = 'P181125140117475' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '209646'
                WHERE ordernumber = 'P181125140153915' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349208'
                WHERE ordernumber = 'P181125140400976' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349209'
                WHERE ordernumber = 'P181125140643200' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343762'
                WHERE ordernumber = 'P421125140757735' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349210'
                WHERE ordernumber = 'P181125140949544' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349211'
                WHERE ordernumber = 'P181125141045811' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302037'
                WHERE ordernumber = 'P201125141115756' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349212'
                WHERE ordernumber = 'P421125141225277' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349213'
                WHERE ordernumber = 'P181125141423669' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349215'
                WHERE ordernumber = 'P201125141440679' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '127964'
                WHERE ordernumber = 'P201125141622488' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349216'
                WHERE ordernumber = 'P201125141713635' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349217'
                WHERE ordernumber = 'P421125141824317' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100451'
                WHERE ordernumber = 'P191125141914536' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302037'
                WHERE ordernumber = 'P201125141954612' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349219'
                WHERE ordernumber = 'P181125142016307' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349222'
                WHERE ordernumber = 'P181125142415194' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '236193'
                WHERE ordernumber = 'P181125143116727' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349224'
                WHERE ordernumber = 'P191125143227765' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349225'
                WHERE ordernumber = 'P181125143303514' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113706'
                WHERE ordernumber = 'P181125143419598' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249330'
                WHERE ordernumber = 'P181125143757734' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349228'
                WHERE ordernumber = 'P181125143854329' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349229'
                WHERE ordernumber = 'P201125143930996' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349230'
                WHERE ordernumber = 'P181125144007434' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '154612'
                WHERE ordernumber = 'P201125144024839' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '161768'
                WHERE ordernumber = 'P181125144043494' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '84781'
                WHERE ordernumber = 'P181125144405343' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214266'
                WHERE ordernumber = 'P191125144411894' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340089'
                WHERE ordernumber = 'P421125144820391' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271915'
                WHERE ordernumber = 'P201125145717601' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '319567'
                WHERE ordernumber = 'P201125145814448' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349234'
                WHERE ordernumber = 'P421125151113986' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307744'
                WHERE ordernumber = 'P181125152003238' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349238'
                WHERE ordernumber = 'P201125152200141' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346551'
                WHERE ordernumber = 'P191125152219958' 
            
2023-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349236'
                WHERE ordernumber = 'P201125152220429' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349239'
                WHERE ordernumber = 'P181125152245149' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349239'
                WHERE ordernumber = 'P181125152400554' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349239'
                WHERE ordernumber = 'P181125152439820' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '137625'
                WHERE ordernumber = 'P421125152612719' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '253445'
                WHERE ordernumber = 'P421125152738851' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349236'
                WHERE ordernumber = 'P201125152856944' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349240'
                WHERE ordernumber = 'P421125153226927' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '55263'
                WHERE ordernumber = 'P181125153235792' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337605'
                WHERE ordernumber = 'P421125153349480' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '55263'
                WHERE ordernumber = 'P181125153355148' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299579'
                WHERE ordernumber = 'P191125153511259' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349243'
                WHERE ordernumber = 'P421125153527879' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99003'
                WHERE ordernumber = 'P201125153954228' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '258332'
                WHERE ordernumber = 'P201125154044848' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '329178'
                WHERE ordernumber = 'P201125154159361' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '291634'
                WHERE ordernumber = 'P191125154236306' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343751'
                WHERE ordernumber = 'P181125154501566' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '138782'
                WHERE ordernumber = 'P201125154834778' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349245'
                WHERE ordernumber = 'P181125154934226' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349247'
                WHERE ordernumber = 'P421125155117865' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349246'
                WHERE ordernumber = 'P421125155132377' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349248'
                WHERE ordernumber = 'P201125155331207' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349250'
                WHERE ordernumber = 'P421125155408579' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349249'
                WHERE ordernumber = 'P421125155508579' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '329410'
                WHERE ordernumber = 'P201125155527478' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349251'
                WHERE ordernumber = 'P181125155646405' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349252'
                WHERE ordernumber = 'P201125155759196' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '240384'
                WHERE ordernumber = 'P201125160049693' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349255'
                WHERE ordernumber = 'P201125160221578' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349254'
                WHERE ordernumber = 'P421125160226118' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349256'
                WHERE ordernumber = 'P201125160324459' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '319399'
                WHERE ordernumber = 'P201125160428956' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '319399'
                WHERE ordernumber = 'P201125160503956' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349257'
                WHERE ordernumber = 'P421125160526639' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349258'
                WHERE ordernumber = 'P201125160627462' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349255'
                WHERE ordernumber = 'P201125160731980' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '222823'
                WHERE ordernumber = 'P191125160802278' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349259'
                WHERE ordernumber = 'P421125160859822' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '294305'
                WHERE ordernumber = 'P191125161006852' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349260'
                WHERE ordernumber = 'P421125161048175' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349261'
                WHERE ordernumber = 'P181125161124257' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349262'
                WHERE ordernumber = 'P421125161437948' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349263'
                WHERE ordernumber = 'P421125161539969' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349264'
                WHERE ordernumber = 'P421125161849618' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349265'
                WHERE ordernumber = 'P191125161905981' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349266'
                WHERE ordernumber = 'P421125162148836' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '167796'
                WHERE ordernumber = 'P191125162201203' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349268'
                WHERE ordernumber = 'P201125162254704' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349267'
                WHERE ordernumber = 'P421125162301878' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349269'
                WHERE ordernumber = 'P421125162412588' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '113411'
                WHERE ordernumber = 'P201125162413406' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349270'
                WHERE ordernumber = 'P421125162514861' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304288'
                WHERE ordernumber = 'P181125162537872' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304288'
                WHERE ordernumber = 'P181125162717258' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349271'
                WHERE ordernumber = 'P181125162858486' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '271914'
                WHERE ordernumber = 'P201125162904295' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349272'
                WHERE ordernumber = 'P181125163003516' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349273'
                WHERE ordernumber = 'P421125163033519' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275118'
                WHERE ordernumber = 'P181125163112419' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349274'
                WHERE ordernumber = 'P421125163144266' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349275'
                WHERE ordernumber = 'P421125163300716' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349277'
                WHERE ordernumber = 'P421125163340160' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349276'
                WHERE ordernumber = 'P191125163405534' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '327282'
                WHERE ordernumber = 'P421125163436739' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349278'
                WHERE ordernumber = 'P201125163632186' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349279'
                WHERE ordernumber = 'P191125163728639' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349281'
                WHERE ordernumber = 'P421125163759344' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349282'
                WHERE ordernumber = 'P181125164024731' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '135715'
                WHERE ordernumber = 'P201125164049167' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349283'
                WHERE ordernumber = 'P181125164253865' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '248196'
                WHERE ordernumber = 'P201125164402323' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349284'
                WHERE ordernumber = 'P421125164456565' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349285'
                WHERE ordernumber = 'P201125164602227' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349286'
                WHERE ordernumber = 'P181125164626742' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349287'
                WHERE ordernumber = 'P421125164956515' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '171492'
                WHERE ordernumber = 'P201125165105400' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '273210'
                WHERE ordernumber = 'P181125165338492' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '273210'
                WHERE ordernumber = 'P191125165430434' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '273210'
                WHERE ordernumber = 'P181125165520352' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349290'
                WHERE ordernumber = 'P191125165547146' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '119332'
                WHERE ordernumber = 'P181125165644376' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349291'
                WHERE ordernumber = 'P191125165807362' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349292'
                WHERE ordernumber = 'P181125165853131' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349293'
                WHERE ordernumber = 'P201125165904939' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349292'
                WHERE ordernumber = 'P181125165928786' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '203934'
                WHERE ordernumber = 'P181125170202263' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349294'
                WHERE ordernumber = 'P191125170527854' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '307091'
                WHERE ordernumber = 'P181125170546169' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349296'
                WHERE ordernumber = 'P421125171014800' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349295'
                WHERE ordernumber = 'P201125171125893' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340830'
                WHERE ordernumber = 'P181125171321331' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349297'
                WHERE ordernumber = 'P421125171359593' 
            
2023-11-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346661'
                WHERE ordernumber = 'P421125171534150' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349298'
                WHERE ordernumber = 'P191125171652375' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349299'
                WHERE ordernumber = 'P181125172000218' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349300'
                WHERE ordernumber = 'P191125172310132' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '293808'
                WHERE ordernumber = 'P201125172857755' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349237'
                WHERE ordernumber = 'P191125172926890' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349302'
                WHERE ordernumber = 'P421125172927750' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349303'
                WHERE ordernumber = 'P421125173038508' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349304'
                WHERE ordernumber = 'P181125173044716' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349305'
                WHERE ordernumber = 'P421125173205661' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349307'
                WHERE ordernumber = 'P421125173315455' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349308'
                WHERE ordernumber = 'P421125173436168' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '54863'
                WHERE ordernumber = 'P421125173744193' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349309'
                WHERE ordernumber = 'P191125173822867' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '343469'
                WHERE ordernumber = 'P431125174348389' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349310'
                WHERE ordernumber = 'P421125174448432' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349312'
                WHERE ordernumber = 'P191125174632179' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '117667'
                WHERE ordernumber = 'P181125174810185' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349313'
                WHERE ordernumber = 'P201125175452172' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349314'
                WHERE ordernumber = 'P201125175645408' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349315'
                WHERE ordernumber = 'P421125175822851' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '261033'
                WHERE ordernumber = 'P201125175955166' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '319559'
                WHERE ordernumber = 'P421125180044280' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349317'
                WHERE ordernumber = 'P181125180327840' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349318'
                WHERE ordernumber = 'P191125180332518' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '80893'
                WHERE ordernumber = 'P201125180618478' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349319'
                WHERE ordernumber = 'P191125180702237' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '183462'
                WHERE ordernumber = 'P421125181014340' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349321'
                WHERE ordernumber = 'P181125181242359' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349320'
                WHERE ordernumber = 'P191125181419338' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '232868'
                WHERE ordernumber = 'P181125181627646' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '347063'
                WHERE ordernumber = 'P191125181643348' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349322'
                WHERE ordernumber = 'P181125181718690' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '225029'
                WHERE ordernumber = 'P201125181957564' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '88957'
                WHERE ordernumber = 'P201125182817396' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349326'
                WHERE ordernumber = 'P191125183538632' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '323066'
                WHERE ordernumber = 'P181125183559852' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '314354'
                WHERE ordernumber = 'P191125183953490' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349328'
                WHERE ordernumber = 'P421125184401162' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349330'
                WHERE ordernumber = 'P421125184602129' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349331'
                WHERE ordernumber = 'P421125184927970' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '344454'
                WHERE ordernumber = 'P421125185211551' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '305820'
                WHERE ordernumber = 'P201125185326890' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '283454'
                WHERE ordernumber = 'P191125185333486' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '225737'
                WHERE ordernumber = 'P191125185424833' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349332'
                WHERE ordernumber = 'P201125185630309' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '16306'
                WHERE ordernumber = 'P191125190256801' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349333'
                WHERE ordernumber = 'P421125190349969' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349334'
                WHERE ordernumber = 'P191125190435266' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349334'
                WHERE ordernumber = 'P191125190521492' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '293991'
                WHERE ordernumber = 'P201125190539815' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '235075'
                WHERE ordernumber = 'P191125190629658' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '300260'
                WHERE ordernumber = 'P191125190756117' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '219628'
                WHERE ordernumber = 'P191125190918446' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349335'
                WHERE ordernumber = 'P201125191135297' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349338'
                WHERE ordernumber = 'P421125192035228' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '122029'
                WHERE ordernumber = 'P191125192128704' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349339'
                WHERE ordernumber = 'P201125192131159' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '304079'
                WHERE ordernumber = 'P191125192216983' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349341'
                WHERE ordernumber = 'P191125193501885' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '133133'
                WHERE ordernumber = 'P191125193734412' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349342'
                WHERE ordernumber = 'P421125194307784' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '271302'
                WHERE ordernumber = 'P201125194424990' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349343'
                WHERE ordernumber = 'P201125194604551' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349344'
                WHERE ordernumber = 'P421125194822669' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '106183'
                WHERE ordernumber = 'P191125195719872' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '121933'
                WHERE ordernumber = 'P191125195915390' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '121933'
                WHERE ordernumber = 'P191125200019515' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349347'
                WHERE ordernumber = 'P201125200212347' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '347839'
                WHERE ordernumber = 'P191125200531385' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '258602'
                WHERE ordernumber = 'P431125200651327' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349348'
                WHERE ordernumber = 'P201125200722738' 
            
2023-11-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '258602'
                WHERE ordernumber = 'P431125200914943'