2023-12-22 01:00:02 -- 將會員中心id寫入data-lake
2023-12-22 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-21%';
        
2023-12-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353869'
                WHERE ordernumber = 'P201221110036643' 
            
2023-12-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '313744'
                WHERE ordernumber = 'P421221110231438' 
            
2023-12-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '346545'
                WHERE ordernumber = 'P181221110307407' 
            
2023-12-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '98132'
                WHERE ordernumber = 'P191221110512634' 
            
2023-12-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '299665'
                WHERE ordernumber = 'P421221110619786' 
            
2023-12-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '121695'
                WHERE ordernumber = 'P191221110825196' 
            
2023-12-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '284057'
                WHERE ordernumber = 'P201221110933708' 
            
2023-12-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '347340'
                WHERE ordernumber = 'P191221111252513' 
            
2023-12-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '328311'
                WHERE ordernumber = 'P181221111359337' 
            
2023-12-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '87078'
                WHERE ordernumber = 'P181221111511370' 
            
2023-12-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '237921'
                WHERE ordernumber = 'P201221112004164' 
            
2023-12-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '223476'
                WHERE ordernumber = 'P191221112254276' 
            
2023-12-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353914'
                WHERE ordernumber = 'P421221112333880' 
            
2023-12-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '301307'
                WHERE ordernumber = 'P191221112340752' 
            
2023-12-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '259574'
                WHERE ordernumber = 'P201221112539289' 
            
2023-12-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353916'
                WHERE ordernumber = 'P201221112823735' 
            
2023-12-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353917'
                WHERE ordernumber = 'P191221112848837' 
            
2023-12-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '313927'
                WHERE ordernumber = 'P191221113026215' 
            
2023-12-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353915'
                WHERE ordernumber = 'P421221113202516' 
            
2023-12-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353920'
                WHERE ordernumber = 'P191221113304387' 
            
2023-12-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348746'
                WHERE ordernumber = 'P181221113823244' 
            
2023-12-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '157035'
                WHERE ordernumber = 'P201221114043823' 
            
2023-12-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '237028'
                WHERE ordernumber = 'P201221114120336' 
            
2023-12-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '343002'
                WHERE ordernumber = 'P421221114237772' 
            
2023-12-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '343232'
                WHERE ordernumber = 'P181221114412768' 
            
2023-12-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353926'
                WHERE ordernumber = 'P191221114855249' 
            
2023-12-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '245310'
                WHERE ordernumber = 'P191221115011378' 
            
2023-12-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '336575'
                WHERE ordernumber = 'P421221115355966' 
            
2023-12-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353931'
                WHERE ordernumber = 'P201221115420440' 
            
2023-12-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '337605'
                WHERE ordernumber = 'P421221115600354' 
            
2023-12-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '121498'
                WHERE ordernumber = 'P421221120833268' 
            
2023-12-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '344439'
                WHERE ordernumber = 'P181221121040926' 
            
2023-12-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353936'
                WHERE ordernumber = 'P191221121104654' 
            
2023-12-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '229560'
                WHERE ordernumber = 'P191221121304954' 
            
2023-12-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353938'
                WHERE ordernumber = 'P421221122011856' 
            
2023-12-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '269120'
                WHERE ordernumber = 'P191221122345752' 
            
2023-12-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '118407'
                WHERE ordernumber = 'P191221123013474' 
            
2023-12-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '334129'
                WHERE ordernumber = 'P191221123123680' 
            
2023-12-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353941'
                WHERE ordernumber = 'P201221123153288' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353942'
                WHERE ordernumber = 'P191221123330175' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353942'
                WHERE ordernumber = 'P191221123422231' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '220338'
                WHERE ordernumber = 'P191221124406202' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353947'
                WHERE ordernumber = 'P191221124713687' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237371'
                WHERE ordernumber = 'P201221125110509' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353952'
                WHERE ordernumber = 'P201221125220613' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353954'
                WHERE ordernumber = 'P191221125348840' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353955'
                WHERE ordernumber = 'P191221125532648' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352480'
                WHERE ordernumber = 'P191221125729868' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '329042'
                WHERE ordernumber = 'P191221125845895' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352813'
                WHERE ordernumber = 'P191221125929454' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '328300'
                WHERE ordernumber = 'P421221125937258' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '253635'
                WHERE ordernumber = 'P201221130147196' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353959'
                WHERE ordernumber = 'P191221130150977' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '111120'
                WHERE ordernumber = 'P201221130232741' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289301'
                WHERE ordernumber = 'P201221130456870' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353958'
                WHERE ordernumber = 'P191221130742858' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '215517'
                WHERE ordernumber = 'P201221131411669' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102338'
                WHERE ordernumber = 'P201221131651352' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '246901'
                WHERE ordernumber = 'P191221132405691' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347465'
                WHERE ordernumber = 'P191221132705247' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353965'
                WHERE ordernumber = 'P421221132844302' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353966'
                WHERE ordernumber = 'P191221133015378' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275106'
                WHERE ordernumber = 'P201221133054736' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '86200'
                WHERE ordernumber = 'P191221133146331' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353967'
                WHERE ordernumber = 'P191221133329520' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353968'
                WHERE ordernumber = 'P191221133518229' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353975'
                WHERE ordernumber = 'P191221134630780' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353974'
                WHERE ordernumber = 'P201221134641953' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278041'
                WHERE ordernumber = 'P201221134834748' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240201'
                WHERE ordernumber = 'P201221135407792' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353977'
                WHERE ordernumber = 'P191221135512240' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '243440'
                WHERE ordernumber = 'P191221135628995' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '144385'
                WHERE ordernumber = 'P201221135730158' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353979'
                WHERE ordernumber = 'P191221135757964' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353980'
                WHERE ordernumber = 'P201221135837530' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279309'
                WHERE ordernumber = 'P191221135958949' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353981'
                WHERE ordernumber = 'P191221140208390' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162530'
                WHERE ordernumber = 'P191221140337161' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353982'
                WHERE ordernumber = 'P421221140421545' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162530'
                WHERE ordernumber = 'P191221140552602' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353985'
                WHERE ordernumber = 'P201221140633189' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353986'
                WHERE ordernumber = 'P191221140644707' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '159872'
                WHERE ordernumber = 'P421221140720159' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '258792'
                WHERE ordernumber = 'P191221141145832' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353987'
                WHERE ordernumber = 'P191221141256999' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353989'
                WHERE ordernumber = 'P191221141505130' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353991'
                WHERE ordernumber = 'P201221142011207' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '216091'
                WHERE ordernumber = 'P191221142255898' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353989'
                WHERE ordernumber = 'P191221142406665' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353994'
                WHERE ordernumber = 'P191221142726710' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353995'
                WHERE ordernumber = 'P191221142907946' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '234101'
                WHERE ordernumber = 'P201221143557210' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '269152'
                WHERE ordernumber = 'P201221143723449' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352691'
                WHERE ordernumber = 'P191221143805562' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '133133'
                WHERE ordernumber = 'P191221144310299' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353998'
                WHERE ordernumber = 'P201221144333777' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '133133'
                WHERE ordernumber = 'P191221144539879' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '53077'
                WHERE ordernumber = 'P191221145513727' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306264'
                WHERE ordernumber = 'P191221145725836' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354002'
                WHERE ordernumber = 'P191221150131179' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334332'
                WHERE ordernumber = 'P421221150827245' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354004'
                WHERE ordernumber = 'P181221150959544' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354004'
                WHERE ordernumber = 'P181221151046832' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353694'
                WHERE ordernumber = 'P191221151053773' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '331519'
                WHERE ordernumber = 'P201221151349331' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '331519'
                WHERE ordernumber = 'P201221151435847' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354006'
                WHERE ordernumber = 'P191221151721616' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '63318'
                WHERE ordernumber = 'P201221151739675' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '105067'
                WHERE ordernumber = 'P181221151745464' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314753'
                WHERE ordernumber = 'P201221151816754' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354007'
                WHERE ordernumber = 'P191221151922365' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354009'
                WHERE ordernumber = 'P201221151953956' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354011'
                WHERE ordernumber = 'P201221152123998' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287234'
                WHERE ordernumber = 'P201221152303196' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354012'
                WHERE ordernumber = 'P181221152333279' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353984'
                WHERE ordernumber = 'P201221153233531' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '226774'
                WHERE ordernumber = 'P191221153440632' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354015'
                WHERE ordernumber = 'P421221153821319' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '105986'
                WHERE ordernumber = 'P191221153903617' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313813'
                WHERE ordernumber = 'P201221153936897' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354018'
                WHERE ordernumber = 'P201221154138207' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354017'
                WHERE ordernumber = 'P421221154149871' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354019'
                WHERE ordernumber = 'P201221154319843' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354020'
                WHERE ordernumber = 'P191221154416751' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94254'
                WHERE ordernumber = 'P181221154429898' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354021'
                WHERE ordernumber = 'P191221154615328' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354022'
                WHERE ordernumber = 'P181221154645706' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354023'
                WHERE ordernumber = 'P181221155125686' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '327941'
                WHERE ordernumber = 'P191221155751181' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '335639'
                WHERE ordernumber = 'P201221160021564' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281382'
                WHERE ordernumber = 'P191221160155686' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354027'
                WHERE ordernumber = 'P421221160904856' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240802'
                WHERE ordernumber = 'P191221161324243' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '316489'
                WHERE ordernumber = 'P191221161543361' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '329277'
                WHERE ordernumber = 'P201221161611920' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354029'
                WHERE ordernumber = 'P201221161917934' 
            
2023-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '220663'
                WHERE ordernumber = 'P191221162202786' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '165066'
                WHERE ordernumber = 'P201221162222714' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313476'
                WHERE ordernumber = 'P191221162423299' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354032'
                WHERE ordernumber = 'P181221162500932' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313476'
                WHERE ordernumber = 'P191221162501691' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '226523'
                WHERE ordernumber = 'P201221162704677' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '76607'
                WHERE ordernumber = 'P181221162739398' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '78411'
                WHERE ordernumber = 'P191221163614353' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354035'
                WHERE ordernumber = 'P421221163716358' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354037'
                WHERE ordernumber = 'P191221164021174' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350270'
                WHERE ordernumber = 'P191221164442857' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353488'
                WHERE ordernumber = 'P201221164547676' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354039'
                WHERE ordernumber = 'P191221164624362' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354040'
                WHERE ordernumber = 'P421221164901350' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354042'
                WHERE ordernumber = 'P181221165251933' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337456'
                WHERE ordernumber = 'P421221165712799' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98301'
                WHERE ordernumber = 'P191221165939728' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353488'
                WHERE ordernumber = 'P201221170000330' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275250'
                WHERE ordernumber = 'P201221170411984' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '216067'
                WHERE ordernumber = 'P191221170946535' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100889'
                WHERE ordernumber = 'P191221171254948' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '241068'
                WHERE ordernumber = 'P201221171623318' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '263364'
                WHERE ordernumber = 'P191221171739221' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '267805'
                WHERE ordernumber = 'P201221171741668' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '291669'
                WHERE ordernumber = 'P201221172640873' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354046'
                WHERE ordernumber = 'P201221173029504' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350270'
                WHERE ordernumber = 'P191221173035768' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '133686'
                WHERE ordernumber = 'P181221173043830' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354048'
                WHERE ordernumber = 'P181221173302884' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354049'
                WHERE ordernumber = 'P191221173333301' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '183376'
                WHERE ordernumber = 'P181221173802468' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354051'
                WHERE ordernumber = 'P191221173959714' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '113389'
                WHERE ordernumber = 'P201221174016169' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98363'
                WHERE ordernumber = 'P201221174053252' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354053'
                WHERE ordernumber = 'P201221174221731' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349725'
                WHERE ordernumber = 'P191221174357904' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '159647'
                WHERE ordernumber = 'P201221174744895' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354056'
                WHERE ordernumber = 'P191221174839298' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354059'
                WHERE ordernumber = 'P201221175241888' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '316493'
                WHERE ordernumber = 'P201221175612925' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '326969'
                WHERE ordernumber = 'P201221175754837' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96948'
                WHERE ordernumber = 'P191221180018111' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '68976'
                WHERE ordernumber = 'P421221180303872' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '327313'
                WHERE ordernumber = 'P421221180528868' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '41896'
                WHERE ordernumber = 'P181221180618627' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354064'
                WHERE ordernumber = 'P181221182434481' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352772'
                WHERE ordernumber = 'P181221182512401' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '158200'
                WHERE ordernumber = 'P201221182601780' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354065'
                WHERE ordernumber = 'P201221182734340' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310350'
                WHERE ordernumber = 'P201221182828838' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354068'
                WHERE ordernumber = 'P191221182843784' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354069'
                WHERE ordernumber = 'P181221182932717' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '312876'
                WHERE ordernumber = 'P421221182941319' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '92943'
                WHERE ordernumber = 'P191221183004261' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354070'
                WHERE ordernumber = 'P201221183016791' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '111123'
                WHERE ordernumber = 'P191221183050316' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354071'
                WHERE ordernumber = 'P421221183219640' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354072'
                WHERE ordernumber = 'P191221183512185' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354074'
                WHERE ordernumber = 'P201221183800130' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '303362'
                WHERE ordernumber = 'P201221183847111' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '318306'
                WHERE ordernumber = 'P191221183852345' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354076'
                WHERE ordernumber = 'P201221183951756' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '101636'
                WHERE ordernumber = 'P191221184130129' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '164591'
                WHERE ordernumber = 'P201221184345954' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354078'
                WHERE ordernumber = 'P201221185354610' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304835'
                WHERE ordernumber = 'P191221185454189' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '338497'
                WHERE ordernumber = 'P421221185519350' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354079'
                WHERE ordernumber = 'P201221185628153' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354080'
                WHERE ordernumber = 'P191221185730206' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354081'
                WHERE ordernumber = 'P201221185827906' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349684'
                WHERE ordernumber = 'P191221185947341' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349684'
                WHERE ordernumber = 'P191221190017580' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348816'
                WHERE ordernumber = 'P201221190031820' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354082'
                WHERE ordernumber = 'P191221190403259' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342091'
                WHERE ordernumber = 'P191221191511703' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354085'
                WHERE ordernumber = 'P201221191653540' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237571'
                WHERE ordernumber = 'P201221191811554' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344826'
                WHERE ordernumber = 'P191221192330123' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '141393'
                WHERE ordernumber = 'P191221192618200' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114334'
                WHERE ordernumber = 'P191221193010753' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288639'
                WHERE ordernumber = 'P201221193213130' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283600'
                WHERE ordernumber = 'P191221193622461' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354088'
                WHERE ordernumber = 'P201221194330882' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '329340'
                WHERE ordernumber = 'P201221194714682' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '298192'
                WHERE ordernumber = 'P201221195029402' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '156106'
                WHERE ordernumber = 'P201221195448186' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275063'
                WHERE ordernumber = 'P421221200016785' 
            
2023-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '40753'
                WHERE ordernumber = 'P201221200507482'