2024-07-05 01:00:03 -- 將會員中心id寫入data-lake
2024-07-05 01:00:03 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-07-04%';
        
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399629'
                WHERE ordernumber = 'P630704104626483' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393231'
                WHERE ordernumber = 'P420704110015452' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '223140'
                WHERE ordernumber = 'P200704110246191' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399632'
                WHERE ordernumber = 'P420704111053941' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '254140'
                WHERE ordernumber = 'P190704111306575' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399633'
                WHERE ordernumber = 'P180704111737250' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '218749'
                WHERE ordernumber = 'P190704111845740' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '326650'
                WHERE ordernumber = 'P180704112016838' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '155901'
                WHERE ordernumber = 'P420704112144480' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399634'
                WHERE ordernumber = 'P200704112237817' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '364203'
                WHERE ordernumber = 'P180704112339937' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399635'
                WHERE ordernumber = 'P200704112344562' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399637'
                WHERE ordernumber = 'P190704112546505' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399637'
                WHERE ordernumber = 'P190704112645344' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '118048'
                WHERE ordernumber = 'P200704113426664' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378996'
                WHERE ordernumber = 'P180704113746458' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399640'
                WHERE ordernumber = 'P180704114119280' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399640'
                WHERE ordernumber = 'P180704114140193' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99620'
                WHERE ordernumber = 'P190704114414917' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '229200'
                WHERE ordernumber = 'P190704114456803' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99620'
                WHERE ordernumber = 'P190704114730881' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '125871'
                WHERE ordernumber = 'P180704114736920' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399641'
                WHERE ordernumber = 'P420704114858717' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399642'
                WHERE ordernumber = 'P420704115119339' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399641'
                WHERE ordernumber = 'P420704115153332' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399643'
                WHERE ordernumber = 'P180704115229368' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399645'
                WHERE ordernumber = 'P180704115602590' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399646'
                WHERE ordernumber = 'P190704115645467' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344219'
                WHERE ordernumber = 'P180704115910394' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399647'
                WHERE ordernumber = 'P420704115925972' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282596'
                WHERE ordernumber = 'P180704121754580' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399648'
                WHERE ordernumber = 'P200704122113326' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '329680'
                WHERE ordernumber = 'P420704122158795' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81134'
                WHERE ordernumber = 'P180704122258852' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399649'
                WHERE ordernumber = 'P200704122708862' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399650'
                WHERE ordernumber = 'P180704122950436' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '270895'
                WHERE ordernumber = 'P200704123104404' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '166122'
                WHERE ordernumber = 'P190704123241387' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '136507'
                WHERE ordernumber = 'P200704123437335' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '296280'
                WHERE ordernumber = 'P180704123524478' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '280077'
                WHERE ordernumber = 'P180704123723794' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399652'
                WHERE ordernumber = 'P180704124716553' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399653'
                WHERE ordernumber = 'P420704124746479' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386742'
                WHERE ordernumber = 'P180704124908639' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399654'
                WHERE ordernumber = 'P190704125213431' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394350'
                WHERE ordernumber = 'P190704125234779' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399655'
                WHERE ordernumber = 'P180704125507362' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313500'
                WHERE ordernumber = 'P180704125700479' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310921'
                WHERE ordernumber = 'P180704125759346' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399656'
                WHERE ordernumber = 'P180704130204961' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '321917'
                WHERE ordernumber = 'P180704130513665' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396702'
                WHERE ordernumber = 'P420704130926428' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '279074'
                WHERE ordernumber = 'P180704130927347' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399657'
                WHERE ordernumber = 'P200704131759991' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '254453'
                WHERE ordernumber = 'P200704131914765' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '56458'
                WHERE ordernumber = 'P200704132140647' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '104143'
                WHERE ordernumber = 'P190704132238415' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '195487'
                WHERE ordernumber = 'P200704132304497' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393522'
                WHERE ordernumber = 'P180704132756610' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399658'
                WHERE ordernumber = 'P200704135032261' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '286632'
                WHERE ordernumber = 'P180704135217434' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399659'
                WHERE ordernumber = 'P420704135729548' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397894'
                WHERE ordernumber = 'P420704135821363' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399660'
                WHERE ordernumber = 'P420704135943736' 
            
2024-07-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399662'
                WHERE ordernumber = 'P420704140118332' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399661'
                WHERE ordernumber = 'P180704140131547' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399663'
                WHERE ordernumber = 'P180704140558648' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '167584'
                WHERE ordernumber = 'P420704140609376' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399664'
                WHERE ordernumber = 'P180704141452127' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399666'
                WHERE ordernumber = 'P180704141549906' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399665'
                WHERE ordernumber = 'P190704141636823' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399668'
                WHERE ordernumber = 'P180704141831253' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '259324'
                WHERE ordernumber = 'P180704142510654' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372351'
                WHERE ordernumber = 'P190704142522290' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399670'
                WHERE ordernumber = 'P420704142912821' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399671'
                WHERE ordernumber = 'P180704144028179' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '54573'
                WHERE ordernumber = 'P180704144257170' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394335'
                WHERE ordernumber = 'P420704144411824' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '66735'
                WHERE ordernumber = 'P190704144542150' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399673'
                WHERE ordernumber = 'P200704144928533' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '224662'
                WHERE ordernumber = 'P180704144957945' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399674'
                WHERE ordernumber = 'P630704145248885' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399675'
                WHERE ordernumber = 'P190704145251203' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '157986'
                WHERE ordernumber = 'P630704145352137' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399676'
                WHERE ordernumber = 'P190704145459629' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399677'
                WHERE ordernumber = 'P200704145700901' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '104992'
                WHERE ordernumber = 'P200704150058423' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '365821'
                WHERE ordernumber = 'P190704150219114' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393960'
                WHERE ordernumber = 'P420704150841132' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '299702'
                WHERE ordernumber = 'P420704150932495' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388932'
                WHERE ordernumber = 'P630704151229631' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399678'
                WHERE ordernumber = 'P180704151304111' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399680'
                WHERE ordernumber = 'P630704151804670' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351537'
                WHERE ordernumber = 'P180704152045765' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399681'
                WHERE ordernumber = 'P420704152121330' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '356111'
                WHERE ordernumber = 'P420704152726636' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399682'
                WHERE ordernumber = 'P190704153013795' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399683'
                WHERE ordernumber = 'P420704153318705' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399684'
                WHERE ordernumber = 'P180704153451343' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '249754'
                WHERE ordernumber = 'P180704153941210' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '235626'
                WHERE ordernumber = 'P180704154209872' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399685'
                WHERE ordernumber = 'P200704154244150' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399686'
                WHERE ordernumber = 'P420704154329880' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '268279'
                WHERE ordernumber = 'P200704154936440' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399687'
                WHERE ordernumber = 'P630704155023561' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '369186'
                WHERE ordernumber = 'P420704155116775' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399688'
                WHERE ordernumber = 'P200704155256705' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '62458'
                WHERE ordernumber = 'P200704155409483' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399689'
                WHERE ordernumber = 'P630704155536632' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399690'
                WHERE ordernumber = 'P180704155724610' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '296176'
                WHERE ordernumber = 'P180704155818387' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399691'
                WHERE ordernumber = 'P180704155924264' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '277459'
                WHERE ordernumber = 'P200704160142527' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399693'
                WHERE ordernumber = 'P180704160319539' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '273211'
                WHERE ordernumber = 'P190704160341818' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '316663'
                WHERE ordernumber = 'P420704160620586' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '137872'
                WHERE ordernumber = 'P190704160758531' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399694'
                WHERE ordernumber = 'P180704160833772' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '93413'
                WHERE ordernumber = 'P420704161207927' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399697'
                WHERE ordernumber = 'P180704161232740' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399698'
                WHERE ordernumber = 'P180704161631670' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '187767'
                WHERE ordernumber = 'P200704161637413' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '333103'
                WHERE ordernumber = 'P420704161717228' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399699'
                WHERE ordernumber = 'P180704161827726' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '137282'
                WHERE ordernumber = 'P190704162154270' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399700'
                WHERE ordernumber = 'P180704162247740' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '88949'
                WHERE ordernumber = 'P200704162425716' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399701'
                WHERE ordernumber = 'P420704162618902' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399702'
                WHERE ordernumber = 'P630704163157330' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '246461'
                WHERE ordernumber = 'P180704163413546' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '266005'
                WHERE ordernumber = 'P190704163548593' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '387858'
                WHERE ordernumber = 'P200704163957870' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399704'
                WHERE ordernumber = 'P180704164119783' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399705'
                WHERE ordernumber = 'P630704164608543' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '156758'
                WHERE ordernumber = 'P190704164636190' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399706'
                WHERE ordernumber = 'P190704164853635' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '100450'
                WHERE ordernumber = 'P180704165217292' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398871'
                WHERE ordernumber = 'P420704165332636' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '100450'
                WHERE ordernumber = 'P180704165454194' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '161128'
                WHERE ordernumber = 'P590704165500371' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399708'
                WHERE ordernumber = 'P420704165847625' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399709'
                WHERE ordernumber = 'P180704170059978' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399710'
                WHERE ordernumber = 'P190704170413894' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399711'
                WHERE ordernumber = 'P420704170648555' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399712'
                WHERE ordernumber = 'P630704170731708' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399711'
                WHERE ordernumber = 'P420704170849851' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399713'
                WHERE ordernumber = 'P190704171213736' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399714'
                WHERE ordernumber = 'P200704171750522' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '215503'
                WHERE ordernumber = 'P420704171804156' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399715'
                WHERE ordernumber = 'P200704171909339' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399716'
                WHERE ordernumber = 'P200704172159878' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399717'
                WHERE ordernumber = 'P420704172607641' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '101538'
                WHERE ordernumber = 'P180704172640537' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399718'
                WHERE ordernumber = 'P200704172902613' 
            
2024-07-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399719'
                WHERE ordernumber = 'P420704172943891' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '161831'
                WHERE ordernumber = 'P630704173114766' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399720'
                WHERE ordernumber = 'P190704173203464' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399721'
                WHERE ordernumber = 'P630704173509894' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399722'
                WHERE ordernumber = 'P180704173634250' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '249249'
                WHERE ordernumber = 'P420704173647726' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399723'
                WHERE ordernumber = 'P190704173913554' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '78891'
                WHERE ordernumber = 'P180704174454712' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399725'
                WHERE ordernumber = 'P200704174618671' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '97827'
                WHERE ordernumber = 'P190704174654332' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399726'
                WHERE ordernumber = 'P180704174837116' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '360375'
                WHERE ordernumber = 'P420704175205133' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399729'
                WHERE ordernumber = 'P180704175211970' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399730'
                WHERE ordernumber = 'P420704175538740' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '261287'
                WHERE ordernumber = 'P180704175544945' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399731'
                WHERE ordernumber = 'P190704175559178' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '173637'
                WHERE ordernumber = 'P190704175912194' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399732'
                WHERE ordernumber = 'P200704175942345' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399733'
                WHERE ordernumber = 'P180704180104286' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399734'
                WHERE ordernumber = 'P190704180142444' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399735'
                WHERE ordernumber = 'P180704180236598' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '331945'
                WHERE ordernumber = 'P190704180356823' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '215833'
                WHERE ordernumber = 'P190704180504360' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '216353'
                WHERE ordernumber = 'P190704180625776' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399736'
                WHERE ordernumber = 'P180704180953588' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399737'
                WHERE ordernumber = 'P190704181038284' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '307381'
                WHERE ordernumber = 'P180704181105799' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '260398'
                WHERE ordernumber = 'P200704181138938' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399738'
                WHERE ordernumber = 'P420704181711448' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399739'
                WHERE ordernumber = 'P200704181830635' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '309039'
                WHERE ordernumber = 'P420704182033440' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399740'
                WHERE ordernumber = 'P190704182039483' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399741'
                WHERE ordernumber = 'P180704182135720' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399681'
                WHERE ordernumber = 'P420704182154517' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399742'
                WHERE ordernumber = 'P630704182220567' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '268938'
                WHERE ordernumber = 'P190704182247796' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399743'
                WHERE ordernumber = 'P180704182544375' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399744'
                WHERE ordernumber = 'P190704182741560' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399745'
                WHERE ordernumber = 'P420704183221505' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399746'
                WHERE ordernumber = 'P200704183353710' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '397351'
                WHERE ordernumber = 'P420704183514578' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '251919'
                WHERE ordernumber = 'P200704183558424' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '310908'
                WHERE ordernumber = 'P180704183629852' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399749'
                WHERE ordernumber = 'P180704184013468' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399750'
                WHERE ordernumber = 'P420704184131439' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '396102'
                WHERE ordernumber = 'P200704184137342' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '179524'
                WHERE ordernumber = 'P180704184249523' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399628'
                WHERE ordernumber = 'P180704184359843' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399751'
                WHERE ordernumber = 'P630704184821973' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399748'
                WHERE ordernumber = 'P420704185035221' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399752'
                WHERE ordernumber = 'P200704185109185' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '212370'
                WHERE ordernumber = 'P190704185350305' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399753'
                WHERE ordernumber = 'P190704185535456' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399609'
                WHERE ordernumber = 'P200704185615985' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '387619'
                WHERE ordernumber = 'P200704185736334' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399754'
                WHERE ordernumber = 'P630704185826762' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399755'
                WHERE ordernumber = 'P200704190018630' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399756'
                WHERE ordernumber = 'P630704190105313' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399757'
                WHERE ordernumber = 'P190704190226906' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '319357'
                WHERE ordernumber = 'P190704190646842' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399758'
                WHERE ordernumber = 'P190704190844700' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399759'
                WHERE ordernumber = 'P630704191213852' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '262762'
                WHERE ordernumber = 'P190704191414614' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '341550'
                WHERE ordernumber = 'P200704191824395' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399761'
                WHERE ordernumber = 'P200704191945455' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '93028'
                WHERE ordernumber = 'P200704192210666' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399762'
                WHERE ordernumber = 'P200704192453995' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351050'
                WHERE ordernumber = 'P190704192803779' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399764'
                WHERE ordernumber = 'P200704192912728' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399765'
                WHERE ordernumber = 'P190704193001155' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399766'
                WHERE ordernumber = 'P190704193157563' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399767'
                WHERE ordernumber = 'P200704193308403' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399768'
                WHERE ordernumber = 'P190704193433276' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399769'
                WHERE ordernumber = 'P190704193635754' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '323770'
                WHERE ordernumber = 'P200704193711484' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399770'
                WHERE ordernumber = 'P190704193814311' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '344838'
                WHERE ordernumber = 'P190704193926527' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '397536'
                WHERE ordernumber = 'P190704194030940' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '110751'
                WHERE ordernumber = 'P190704194442858' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399772'
                WHERE ordernumber = 'P630704194736882' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399773'
                WHERE ordernumber = 'P200704194754273' 
            
2024-07-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '358902'
                WHERE ordernumber = 'P190704195203402' 
            
2024-07-05 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '399775'
                WHERE ordernumber = 'P200704195317811' 
            
2024-07-05 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '399777'
                WHERE ordernumber = 'P630704210639367' 
            
2024-07-05 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '399778'
                WHERE ordernumber = 'P630704211311213' 
            
2024-07-05 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '399780'
                WHERE ordernumber = 'P630704211920913' 
            
2024-07-05 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '399781'
                WHERE ordernumber = 'P630704212336929'