2024-05-07 01:00:02 -- 將會員中心id寫入data-lake
2024-05-07 01:00:02 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-05-06%';
        
2024-05-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '320246'
                WHERE ordernumber = 'P180506110220382' 
            
2024-05-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388607'
                WHERE ordernumber = 'P630506110308925' 
            
2024-05-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386056'
                WHERE ordernumber = 'P180506110334359' 
            
2024-05-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381143'
                WHERE ordernumber = 'P420506110519592' 
            
2024-05-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '294795'
                WHERE ordernumber = 'P200506110647875' 
            
2024-05-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388610'
                WHERE ordernumber = 'P200506110651236' 
            
2024-05-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '169193'
                WHERE ordernumber = 'P180506110810565' 
            
2024-05-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388611'
                WHERE ordernumber = 'P180506110914694' 
            
2024-05-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388612'
                WHERE ordernumber = 'P180506111049112' 
            
2024-05-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '164261'
                WHERE ordernumber = 'P180506111124790' 
            
2024-05-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '312737'
                WHERE ordernumber = 'P180506112139168' 
            
2024-05-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388614'
                WHERE ordernumber = 'P180506112259187' 
            
2024-05-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388615'
                WHERE ordernumber = 'P630506112415797' 
            
2024-05-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '66860'
                WHERE ordernumber = 'P180506112620977' 
            
2024-05-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382581'
                WHERE ordernumber = 'P180506112724549' 
            
2024-05-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '384207'
                WHERE ordernumber = 'P630506112823695' 
            
2024-05-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '346955'
                WHERE ordernumber = 'P200506113213497' 
            
2024-05-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388618'
                WHERE ordernumber = 'P200506114016614' 
            
2024-05-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379562'
                WHERE ordernumber = 'P180506114050194' 
            
2024-05-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287357'
                WHERE ordernumber = 'P200506114923527' 
            
2024-05-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388619'
                WHERE ordernumber = 'P200506115159185' 
            
2024-05-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '269628'
                WHERE ordernumber = 'P180506115608804' 
            
2024-05-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '305395'
                WHERE ordernumber = 'P200506120339865' 
            
2024-05-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '102966'
                WHERE ordernumber = 'P180506120524818' 
            
2024-05-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '262063'
                WHERE ordernumber = 'P420506121333483' 
            
2024-05-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '311893'
                WHERE ordernumber = 'P420506121454256' 
            
2024-05-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '115574'
                WHERE ordernumber = 'P180506122128869' 
            
2024-05-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '115574'
                WHERE ordernumber = 'P180506122237946' 
            
2024-05-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '383769'
                WHERE ordernumber = 'P420506123410478' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388622'
                WHERE ordernumber = 'P180506123513942' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388624'
                WHERE ordernumber = 'P180506124049710' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388625'
                WHERE ordernumber = 'P190506124300570' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '170667'
                WHERE ordernumber = 'P630506124403686' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '261147'
                WHERE ordernumber = 'P200506124459554' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385619'
                WHERE ordernumber = 'P420506124715986' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '333118'
                WHERE ordernumber = 'P630506124726873' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388627'
                WHERE ordernumber = 'P200506124806116' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344084'
                WHERE ordernumber = 'P200506125103897' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388628'
                WHERE ordernumber = 'P420506125348701' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388627'
                WHERE ordernumber = 'P200506125547737' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388629'
                WHERE ordernumber = 'P420506125722443' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388630'
                WHERE ordernumber = 'P180506125837988' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278470'
                WHERE ordernumber = 'P180506130614268' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388632'
                WHERE ordernumber = 'P200506130819349' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388633'
                WHERE ordernumber = 'P180506130916205' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388634'
                WHERE ordernumber = 'P180506131205415' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388635'
                WHERE ordernumber = 'P630506131358537' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388636'
                WHERE ordernumber = 'P180506131651786' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388637'
                WHERE ordernumber = 'P630506131929800' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '142266'
                WHERE ordernumber = 'P190506132805159' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381698'
                WHERE ordernumber = 'P630506132825356' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '231626'
                WHERE ordernumber = 'P190506132940340' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '232879'
                WHERE ordernumber = 'P200506133130177' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '288868'
                WHERE ordernumber = 'P190506133745974' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228555'
                WHERE ordernumber = 'P190506133903950' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388640'
                WHERE ordernumber = 'P630506133912609' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388642'
                WHERE ordernumber = 'P180506133952402' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388641'
                WHERE ordernumber = 'P200506134000477' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '236956'
                WHERE ordernumber = 'P630506134816692' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306524'
                WHERE ordernumber = 'P180506135154792' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388647'
                WHERE ordernumber = 'P180506135649744' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388648'
                WHERE ordernumber = 'P200506135857429' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388644'
                WHERE ordernumber = 'P180506140020873' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388649'
                WHERE ordernumber = 'P180506140316278' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388654'
                WHERE ordernumber = 'P200506141424960' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388037'
                WHERE ordernumber = 'P180506141608215' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386143'
                WHERE ordernumber = 'P790506141812595' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388655'
                WHERE ordernumber = 'P420506142037339' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388656'
                WHERE ordernumber = 'P200506142402567' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '266126'
                WHERE ordernumber = 'P180506142624800' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388657'
                WHERE ordernumber = 'P420506142947761' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '317716'
                WHERE ordernumber = 'P180506143327865' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388658'
                WHERE ordernumber = 'P180506143608582' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388659'
                WHERE ordernumber = 'P180506143832475' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345773'
                WHERE ordernumber = 'P180506143957203' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '155698'
                WHERE ordernumber = 'P200506144210771' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388660'
                WHERE ordernumber = 'P190506144310169' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366123'
                WHERE ordernumber = 'P420506144712472' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '46268'
                WHERE ordernumber = 'P630506144713476' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388661'
                WHERE ordernumber = 'P200506144716744' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388662'
                WHERE ordernumber = 'P190506144747280' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '136084'
                WHERE ordernumber = 'P200506145002871' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344831'
                WHERE ordernumber = 'P190506145136951' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300132'
                WHERE ordernumber = 'P180506150343272' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388665'
                WHERE ordernumber = 'P200506151438932' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388666'
                WHERE ordernumber = 'P190506151553840' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388667'
                WHERE ordernumber = 'P180506152515635' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388667'
                WHERE ordernumber = 'P180506152619987' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388668'
                WHERE ordernumber = 'P180506152835425' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '206558'
                WHERE ordernumber = 'P180506153149591' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388670'
                WHERE ordernumber = 'P180506153815228' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302568'
                WHERE ordernumber = 'P180506153910901' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386211'
                WHERE ordernumber = 'P200506154428173' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285022'
                WHERE ordernumber = 'P180506154510239' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388669'
                WHERE ordernumber = 'P630506154955908' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388674'
                WHERE ordernumber = 'P200506155731396' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388675'
                WHERE ordernumber = 'P180506160646176' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '316185'
                WHERE ordernumber = 'P420506160738337' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '369737'
                WHERE ordernumber = 'P180506160824798' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285070'
                WHERE ordernumber = 'P180506161054586' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342370'
                WHERE ordernumber = 'P200506161231844' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334015'
                WHERE ordernumber = 'P200506161322756' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345567'
                WHERE ordernumber = 'P180506161405870' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345567'
                WHERE ordernumber = 'P180506161508735' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388678'
                WHERE ordernumber = 'P420506161720335' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388679'
                WHERE ordernumber = 'P200506161857180' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388680'
                WHERE ordernumber = 'P420506162107957' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238609'
                WHERE ordernumber = 'P190506162117322' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388683'
                WHERE ordernumber = 'P630506162315190' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '243900'
                WHERE ordernumber = 'P200506162342572' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388682'
                WHERE ordernumber = 'P180506162359365' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '236671'
                WHERE ordernumber = 'P190506162814700' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388686'
                WHERE ordernumber = 'P200506162819381' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '236671'
                WHERE ordernumber = 'P190506162831802' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388412'
                WHERE ordernumber = 'P420506163108878' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '141284'
                WHERE ordernumber = 'P200506163208441' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388687'
                WHERE ordernumber = 'P200506163431720' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '321217'
                WHERE ordernumber = 'P420506163452854' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388412'
                WHERE ordernumber = 'P420506163902806' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388688'
                WHERE ordernumber = 'P180506163926713' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388690'
                WHERE ordernumber = 'P420506164154269' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388691'
                WHERE ordernumber = 'P420506164359804' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '111127'
                WHERE ordernumber = 'P180506164542638' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '218897'
                WHERE ordernumber = 'P200506164849864' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388692'
                WHERE ordernumber = 'P180506165110289' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '153148'
                WHERE ordernumber = 'P180506165315830' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388694'
                WHERE ordernumber = 'P420506165543917' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388693'
                WHERE ordernumber = 'P790506165925831' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388695'
                WHERE ordernumber = 'P180506170636164' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '265093'
                WHERE ordernumber = 'P180506170844738' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '293946'
                WHERE ordernumber = 'P180506171013822' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388697'
                WHERE ordernumber = 'P420506171330615' 
            
2024-05-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388698'
                WHERE ordernumber = 'P420506171832752' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354432'
                WHERE ordernumber = 'P180506171906527' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388699'
                WHERE ordernumber = 'P420506173643651' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382105'
                WHERE ordernumber = 'P420506173811315' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '309053'
                WHERE ordernumber = 'P180506174209665' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388699'
                WHERE ordernumber = 'P420506174355604' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '240185'
                WHERE ordernumber = 'P180506175004184' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378799'
                WHERE ordernumber = 'P420506175213174' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '364942'
                WHERE ordernumber = 'P200506175954837' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '269846'
                WHERE ordernumber = 'P180506180418256' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388703'
                WHERE ordernumber = 'P200506180841722' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388704'
                WHERE ordernumber = 'P180506180904188' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287924'
                WHERE ordernumber = 'P180506180953293' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388705'
                WHERE ordernumber = 'P180506181518772' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '254652'
                WHERE ordernumber = 'P180506181709177' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388705'
                WHERE ordernumber = 'P180506182026381' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388706'
                WHERE ordernumber = 'P180506182153818' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388707'
                WHERE ordernumber = 'P180506182257523' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '312061'
                WHERE ordernumber = 'P420506182348674' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359375'
                WHERE ordernumber = 'P180506182442969' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386620'
                WHERE ordernumber = 'P180506183028799' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '258574'
                WHERE ordernumber = 'P200506183041221' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388708'
                WHERE ordernumber = 'P180506183223940' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388709'
                WHERE ordernumber = 'P180506183405762' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388710'
                WHERE ordernumber = 'P190506183426218' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '271998'
                WHERE ordernumber = 'P190506183527175' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388712'
                WHERE ordernumber = 'P180506183639432' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306875'
                WHERE ordernumber = 'P190506183711633' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '264533'
                WHERE ordernumber = 'P420506183938254' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '264533'
                WHERE ordernumber = 'P420506184009183' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388709'
                WHERE ordernumber = 'P180506184014766' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388714'
                WHERE ordernumber = 'P190506184118287' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '29738'
                WHERE ordernumber = 'P420506184229861' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388716'
                WHERE ordernumber = 'P200506184440292' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388711'
                WHERE ordernumber = 'P190506184548621' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388713'
                WHERE ordernumber = 'P190506184640950' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276019'
                WHERE ordernumber = 'P190506185209586' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388717'
                WHERE ordernumber = 'P420506185328359' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388711'
                WHERE ordernumber = 'P190506185406241' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388718'
                WHERE ordernumber = 'P190506185845287' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388719'
                WHERE ordernumber = 'P200506190006763' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '280624'
                WHERE ordernumber = 'P200506190128599' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388721'
                WHERE ordernumber = 'P790506190423781' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97197'
                WHERE ordernumber = 'P200506191847718' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388725'
                WHERE ordernumber = 'P190506191923111' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388726'
                WHERE ordernumber = 'P420506192720476' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299818'
                WHERE ordernumber = 'P200506192805847' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355043'
                WHERE ordernumber = 'P200506193006958' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388727'
                WHERE ordernumber = 'P420506193649905' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388728'
                WHERE ordernumber = 'P190506193655299' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372351'
                WHERE ordernumber = 'P190506194517972' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388729'
                WHERE ordernumber = 'P790506195313672' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388730'
                WHERE ordernumber = 'P420506195745767' 
            
2024-05-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388737'
                WHERE ordernumber = 'P790506214526993'