2023-12-26 01:00:02 -- 將會員中心id寫入data-lake
2023-12-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-12-25%';
        
2023-12-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348746'
                WHERE ordernumber = 'P181225110144276' 
            
2023-12-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354990'
                WHERE ordernumber = 'P421225110303204' 
            
2023-12-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354991'
                WHERE ordernumber = 'P201225110742837' 
            
2023-12-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354992'
                WHERE ordernumber = 'P181225110815193' 
            
2023-12-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '105214'
                WHERE ordernumber = 'P201225111203660' 
            
2023-12-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354995'
                WHERE ordernumber = 'P181225111615826' 
            
2023-12-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354704'
                WHERE ordernumber = 'P421225111638558' 
            
2023-12-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '327219'
                WHERE ordernumber = 'P181225111707832' 
            
2023-12-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '327219'
                WHERE ordernumber = 'P181225111733331' 
            
2023-12-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354996'
                WHERE ordernumber = 'P201225111735206' 
            
2023-12-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '315315'
                WHERE ordernumber = 'P191225111739264' 
            
2023-12-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354998'
                WHERE ordernumber = 'P181225111934731' 
            
2023-12-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '262483'
                WHERE ordernumber = 'P191225112031377' 
            
2023-12-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355000'
                WHERE ordernumber = 'P181225112259770' 
            
2023-12-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355002'
                WHERE ordernumber = 'P181225112407742' 
            
2023-12-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355003'
                WHERE ordernumber = 'P181225112554235' 
            
2023-12-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355004'
                WHERE ordernumber = 'P181225113021621' 
            
2023-12-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '291682'
                WHERE ordernumber = 'P421225113523427' 
            
2023-12-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355006'
                WHERE ordernumber = 'P191225113818162' 
            
2023-12-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355007'
                WHERE ordernumber = 'P181225113902933' 
            
2023-12-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '98135'
                WHERE ordernumber = 'P201225114035297' 
            
2023-12-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355008'
                WHERE ordernumber = 'P201225114305632' 
            
2023-12-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '328198'
                WHERE ordernumber = 'P421225114749445' 
            
2023-12-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '96007'
                WHERE ordernumber = 'P191225114821929' 
            
2023-12-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '329786'
                WHERE ordernumber = 'P421225114842595' 
            
2023-12-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355012'
                WHERE ordernumber = 'P181225115011255' 
            
2023-12-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355005'
                WHERE ordernumber = 'P421225115051480' 
            
2023-12-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '330934'
                WHERE ordernumber = 'P201225115107958' 
            
2023-12-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354950'
                WHERE ordernumber = 'P191225115401873' 
            
2023-12-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354950'
                WHERE ordernumber = 'P191225115459257' 
            
2023-12-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354950'
                WHERE ordernumber = 'P191225115639117' 
            
2023-12-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '90938'
                WHERE ordernumber = 'P201225115700629' 
            
2023-12-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355014'
                WHERE ordernumber = 'P201225115804957' 
            
2023-12-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354159'
                WHERE ordernumber = 'P181225115821332' 
            
2023-12-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353257'
                WHERE ordernumber = 'P191225115933363' 
            
2023-12-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355014'
                WHERE ordernumber = 'P201225120044468' 
            
2023-12-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355017'
                WHERE ordernumber = 'P201225120454928' 
            
2023-12-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '242842'
                WHERE ordernumber = 'P201225120539562' 
            
2023-12-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '216067'
                WHERE ordernumber = 'P181225120728647' 
            
2023-12-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '291267'
                WHERE ordernumber = 'P201225121425740' 
            
2023-12-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355023'
                WHERE ordernumber = 'P421225121537709' 
            
2023-12-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355024'
                WHERE ordernumber = 'P181225121922122' 
            
2023-12-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '198885'
                WHERE ordernumber = 'P201225122026883' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '320024'
                WHERE ordernumber = 'P181225122319976' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355025'
                WHERE ordernumber = 'P201225122327142' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354128'
                WHERE ordernumber = 'P181225122705747' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241196'
                WHERE ordernumber = 'P181225122858980' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355027'
                WHERE ordernumber = 'P181225122954176' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245310'
                WHERE ordernumber = 'P181225123152558' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275166'
                WHERE ordernumber = 'P201225123255514' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355033'
                WHERE ordernumber = 'P181225123658919' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P201225123731242' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299775'
                WHERE ordernumber = 'P181225124608478' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355035'
                WHERE ordernumber = 'P181225124757275' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P181225124901463' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355039'
                WHERE ordernumber = 'P181225125431356' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355042'
                WHERE ordernumber = 'P181225125803590' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '196319'
                WHERE ordernumber = 'P201225125812203' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355043'
                WHERE ordernumber = 'P201225125955878' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '131857'
                WHERE ordernumber = 'P181225130039166' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355044'
                WHERE ordernumber = 'P181225130321762' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289359'
                WHERE ordernumber = 'P201225130346216' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271209'
                WHERE ordernumber = 'P421225130542263' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271209'
                WHERE ordernumber = 'P421225130639198' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355045'
                WHERE ordernumber = 'P181225130755406' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355048'
                WHERE ordernumber = 'P201225131146606' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '288900'
                WHERE ordernumber = 'P201225131447975' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96065'
                WHERE ordernumber = 'P201225131740352' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355055'
                WHERE ordernumber = 'P181225133051936' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '165124'
                WHERE ordernumber = 'P421225133329293' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276562'
                WHERE ordernumber = 'P191225133341894' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '165124'
                WHERE ordernumber = 'P421225133432722' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355057'
                WHERE ordernumber = 'P201225133445159' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355059'
                WHERE ordernumber = 'P421225133718379' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355014'
                WHERE ordernumber = 'P201225133803183' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351655'
                WHERE ordernumber = 'P191225134009697' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100515'
                WHERE ordernumber = 'P191225134252290' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353989'
                WHERE ordernumber = 'P181225134254581' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355066'
                WHERE ordernumber = 'P191225134413662' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237070'
                WHERE ordernumber = 'P201225134704559' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '129132'
                WHERE ordernumber = 'P181225134853840' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355072'
                WHERE ordernumber = 'P201225135459192' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355073'
                WHERE ordernumber = 'P421225135628241' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297233'
                WHERE ordernumber = 'P421225135837905' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '233613'
                WHERE ordernumber = 'P181225140203399' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '95122'
                WHERE ordernumber = 'P181225140302158' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354129'
                WHERE ordernumber = 'P201225140443413' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354277'
                WHERE ordernumber = 'P201225141317589' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355079'
                WHERE ordernumber = 'P201225141436931' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355080'
                WHERE ordernumber = 'P201225141543789' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355082'
                WHERE ordernumber = 'P201225141741699' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355081'
                WHERE ordernumber = 'P181225141742728' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97441'
                WHERE ordernumber = 'P201225141815598' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355081'
                WHERE ordernumber = 'P181225141828452' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '121498'
                WHERE ordernumber = 'P201225142007997' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355084'
                WHERE ordernumber = 'P181225142102919' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '266483'
                WHERE ordernumber = 'P201225142343198' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355086'
                WHERE ordernumber = 'P181225142440259' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355088'
                WHERE ordernumber = 'P181225142642813' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355090'
                WHERE ordernumber = 'P181225142743502' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355091'
                WHERE ordernumber = 'P201225142842638' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355092'
                WHERE ordernumber = 'P181225142858221' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355094'
                WHERE ordernumber = 'P191225143119151' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355096'
                WHERE ordernumber = 'P421225143233982' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355097'
                WHERE ordernumber = 'P181225143516129' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341983'
                WHERE ordernumber = 'P421225144114693' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343958'
                WHERE ordernumber = 'P421225144721626' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346461'
                WHERE ordernumber = 'P181225144910819' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355104'
                WHERE ordernumber = 'P181225145108883' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355105'
                WHERE ordernumber = 'P191225145130615' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '166284'
                WHERE ordernumber = 'P191225145237858' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355106'
                WHERE ordernumber = 'P181225145241902' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '258581'
                WHERE ordernumber = 'P201225145705475' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282014'
                WHERE ordernumber = 'P181225145921908' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '129909'
                WHERE ordernumber = 'P181225150425992' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '260972'
                WHERE ordernumber = 'P201225150934801' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275603'
                WHERE ordernumber = 'P181225151023270' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289518'
                WHERE ordernumber = 'P201225151108630' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343537'
                WHERE ordernumber = 'P181225152713935' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98356'
                WHERE ordernumber = 'P201225153041419' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355120'
                WHERE ordernumber = 'P181225153325316' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '265672'
                WHERE ordernumber = 'P181225153833610' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353894'
                WHERE ordernumber = 'P181225154032941' 
            
2023-12-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '33538'
                WHERE ordernumber = 'P181225154840738' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '329483'
                WHERE ordernumber = 'P191225154846250' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '95592'
                WHERE ordernumber = 'P201225154851732' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283536'
                WHERE ordernumber = 'P201225155109367' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '167719'
                WHERE ordernumber = 'P201225155551373' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346629'
                WHERE ordernumber = 'P181225155600859' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '246262'
                WHERE ordernumber = 'P181225155940173' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355090'
                WHERE ordernumber = 'P181225160555892' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355127'
                WHERE ordernumber = 'P181225160734575' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355128'
                WHERE ordernumber = 'P181225160948784' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100515'
                WHERE ordernumber = 'P181225161503631' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354675'
                WHERE ordernumber = 'P191225162613937' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '123673'
                WHERE ordernumber = 'P181225162656764' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355133'
                WHERE ordernumber = 'P191225162828980' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P191225162909811' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355134'
                WHERE ordernumber = 'P181225162916906' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355135'
                WHERE ordernumber = 'P181225162955240' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '243638'
                WHERE ordernumber = 'P181225163119882' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '147670'
                WHERE ordernumber = 'P191225163140501' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355136'
                WHERE ordernumber = 'P181225163252817' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '143144'
                WHERE ordernumber = 'P201225163437338' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '139381'
                WHERE ordernumber = 'P201225163648911' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '279244'
                WHERE ordernumber = 'P191225163828588' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '164920'
                WHERE ordernumber = 'P201225163914743' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '320008'
                WHERE ordernumber = 'P181225164131900' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355141'
                WHERE ordernumber = 'P181225164330666' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355142'
                WHERE ordernumber = 'P181225164603584' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355143'
                WHERE ordernumber = 'P181225164904538' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '307969'
                WHERE ordernumber = 'P421225165323422' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355148'
                WHERE ordernumber = 'P201225170350734' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '80996'
                WHERE ordernumber = 'P181225170451817' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '95813'
                WHERE ordernumber = 'P201225170610640' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '116319'
                WHERE ordernumber = 'P181225171108563' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355153'
                WHERE ordernumber = 'P201225171518894' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355154'
                WHERE ordernumber = 'P181225171537669' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355157'
                WHERE ordernumber = 'P181225172315437' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355158'
                WHERE ordernumber = 'P181225172512341' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355161'
                WHERE ordernumber = 'P201225172605827' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355157'
                WHERE ordernumber = 'P181225172617734' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355162'
                WHERE ordernumber = 'P181225172920440' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355163'
                WHERE ordernumber = 'P181225173632632' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276569'
                WHERE ordernumber = 'P181225173733933' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '279318'
                WHERE ordernumber = 'P421225173849730' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '242008'
                WHERE ordernumber = 'P201225173913891' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346903'
                WHERE ordernumber = 'P181225174024653' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '74094'
                WHERE ordernumber = 'P421225174049746' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '327416'
                WHERE ordernumber = 'P421225174516746' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355170'
                WHERE ordernumber = 'P181225174632970' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302708'
                WHERE ordernumber = 'P181225174735679' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355172'
                WHERE ordernumber = 'P181225174912769' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355173'
                WHERE ordernumber = 'P181225175026870' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355174'
                WHERE ordernumber = 'P421225175043953' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '279318'
                WHERE ordernumber = 'P421225175128461' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '212547'
                WHERE ordernumber = 'P181225175224384' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '234101'
                WHERE ordernumber = 'P201225175814531' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355177'
                WHERE ordernumber = 'P181225180221354' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '330947'
                WHERE ordernumber = 'P201225181231175' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '116943'
                WHERE ordernumber = 'P201225181551476' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355184'
                WHERE ordernumber = 'P201225181825956' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288954'
                WHERE ordernumber = 'P181225182331659' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97890'
                WHERE ordernumber = 'P181225182930248' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355188'
                WHERE ordernumber = 'P421225183103874' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355189'
                WHERE ordernumber = 'P181225183134218' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355192'
                WHERE ordernumber = 'P191225183444227' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288654'
                WHERE ordernumber = 'P181225183500635' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354625'
                WHERE ordernumber = 'P201225184617349' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354017'
                WHERE ordernumber = 'P421225184809338' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353810'
                WHERE ordernumber = 'P191225184902254' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '264540'
                WHERE ordernumber = 'P191225185035858' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '241726'
                WHERE ordernumber = 'P201225185056691' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '153378'
                WHERE ordernumber = 'P201225185548618' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98940'
                WHERE ordernumber = 'P201225185741739' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '259119'
                WHERE ordernumber = 'P201225185947559' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '329786'
                WHERE ordernumber = 'P421225190812679' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355202'
                WHERE ordernumber = 'P191225191035514' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355203'
                WHERE ordernumber = 'P201225191202726' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '87780'
                WHERE ordernumber = 'P191225191928924' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '338126'
                WHERE ordernumber = 'P421225192004468' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '76607'
                WHERE ordernumber = 'P191225192359838' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355167'
                WHERE ordernumber = 'P201225192703870' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '226129'
                WHERE ordernumber = 'P201225193135965' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '93655'
                WHERE ordernumber = 'P201225193311340' 
            
2023-12-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355208'
                WHERE ordernumber = 'P191225193327419' 
            
2023-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355210'
                WHERE ordernumber = 'P201225193942895' 
            
2023-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355212'
                WHERE ordernumber = 'P201225194437461' 
            
2023-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '130740'
                WHERE ordernumber = 'P191225194549842' 
            
2023-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355213'
                WHERE ordernumber = 'P421225194743151' 
            
2023-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355216'
                WHERE ordernumber = 'P201225194801388' 
            
2023-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '111880'
                WHERE ordernumber = 'P191225194831831' 
            
2023-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355219'
                WHERE ordernumber = 'P201225200204324' 
            
2023-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '345661'
                WHERE ordernumber = 'P201225200248451' 
            
2023-12-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '110046'
                WHERE ordernumber = 'P201225200427178'