2024-08-04 01:00:03 -- 將會員中心id寫入data-lake
2024-08-04 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-08-03%';
        
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397381'
                WHERE ordernumber = 'P630803101030536' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400596'
                WHERE ordernumber = 'P630803102234737' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '133090'
                WHERE ordernumber = 'P630803103234550' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401065'
                WHERE ordernumber = 'P630803105805801' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353309'
                WHERE ordernumber = 'P180803110301735' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401702'
                WHERE ordernumber = 'P420803110317201' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374096'
                WHERE ordernumber = 'P420803110405149' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382784'
                WHERE ordernumber = 'P190803110413589' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350079'
                WHERE ordernumber = 'P190803110511239' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '141652'
                WHERE ordernumber = 'P180803110708568' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400810'
                WHERE ordernumber = 'P630803110856890' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '244620'
                WHERE ordernumber = 'P180803111008412' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401702'
                WHERE ordernumber = 'P420803111155742' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338734'
                WHERE ordernumber = 'P200803111205654' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404923'
                WHERE ordernumber = 'P180803111559618' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400572'
                WHERE ordernumber = 'P180803111753844' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '272723'
                WHERE ordernumber = 'P190803111927232' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282306'
                WHERE ordernumber = 'P180803111933488' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374096'
                WHERE ordernumber = 'P420803111940538' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404946'
                WHERE ordernumber = 'P180803112125522' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386094'
                WHERE ordernumber = 'P420803112141127' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404206'
                WHERE ordernumber = 'P420803112312475' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '44347'
                WHERE ordernumber = 'P180803112316423' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '225010'
                WHERE ordernumber = 'P590803112716352' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '44347'
                WHERE ordernumber = 'P180803112717799' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404948'
                WHERE ordernumber = 'P420803112719480' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P190803112809993' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396663'
                WHERE ordernumber = 'P190803112914140' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404952'
                WHERE ordernumber = 'P180803113419391' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '88568'
                WHERE ordernumber = 'P200803113619949' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404953'
                WHERE ordernumber = 'P180803113651646' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238136'
                WHERE ordernumber = 'P200803113750690' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403964'
                WHERE ordernumber = 'P180803114014219' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368596'
                WHERE ordernumber = 'P420803114049883' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '116050'
                WHERE ordernumber = 'P190803114114448' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340467'
                WHERE ordernumber = 'P180803114152398' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404956'
                WHERE ordernumber = 'P180803114342712' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404957'
                WHERE ordernumber = 'P180803114438769' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404954'
                WHERE ordernumber = 'P180803114654422' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345773'
                WHERE ordernumber = 'P180803114838800' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404958'
                WHERE ordernumber = 'P420803114852461' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404960'
                WHERE ordernumber = 'P420803115738598' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94055'
                WHERE ordernumber = 'P420803120603388' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '244872'
                WHERE ordernumber = 'P180803120905240' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '273047'
                WHERE ordernumber = 'P180803121137720' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404969'
                WHERE ordernumber = 'P630803121802810' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302814'
                WHERE ordernumber = 'P200803121950855' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404970'
                WHERE ordernumber = 'P200803122450681' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277934'
                WHERE ordernumber = 'P190803123126344' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '290554'
                WHERE ordernumber = 'P630803123258367' 
            
2024-08-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '290291'
                WHERE ordernumber = 'P200803123430240' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404973'
                WHERE ordernumber = 'P420803123757673' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403218'
                WHERE ordernumber = 'P180803123928658' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403218'
                WHERE ordernumber = 'P180803124009639' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '271195'
                WHERE ordernumber = 'P180803124055912' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404975'
                WHERE ordernumber = 'P180803124329355' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404941'
                WHERE ordernumber = 'P180803124430729' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404941'
                WHERE ordernumber = 'P180803124507338' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '118211'
                WHERE ordernumber = 'P180803124719427' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '219653'
                WHERE ordernumber = 'P200803124741790' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404976'
                WHERE ordernumber = 'P420803124921823' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404978'
                WHERE ordernumber = 'P420803125146358' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404983'
                WHERE ordernumber = 'P420803125538525' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384133'
                WHERE ordernumber = 'P630803130005185' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '77098'
                WHERE ordernumber = 'P200803130700436' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404986'
                WHERE ordernumber = 'P420803130848942' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404986'
                WHERE ordernumber = 'P420803130957164' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404161'
                WHERE ordernumber = 'P420803131426927' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '235014'
                WHERE ordernumber = 'P200803131659203' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '84727'
                WHERE ordernumber = 'P180803131746472' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '93028'
                WHERE ordernumber = 'P200803131814869' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404990'
                WHERE ordernumber = 'P420803132046252' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '120318'
                WHERE ordernumber = 'P180803132341175' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344831'
                WHERE ordernumber = 'P180803132528624' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404991'
                WHERE ordernumber = 'P420803132615236' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404992'
                WHERE ordernumber = 'P180803132756246' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '179702'
                WHERE ordernumber = 'P420803132759711' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404993'
                WHERE ordernumber = 'P200803132820391' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389551'
                WHERE ordernumber = 'P180803133056927' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '239481'
                WHERE ordernumber = 'P180803133229225' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404994'
                WHERE ordernumber = 'P180803133440937' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '118451'
                WHERE ordernumber = 'P180803133534905' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388725'
                WHERE ordernumber = 'P180803133608459' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '71450'
                WHERE ordernumber = 'P180803134211853' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404997'
                WHERE ordernumber = 'P420803134325850' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '204771'
                WHERE ordernumber = 'P190803134418320' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '116449'
                WHERE ordernumber = 'P200803135039624' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403257'
                WHERE ordernumber = 'P180803135554456' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '285557'
                WHERE ordernumber = 'P200803135612963' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405000'
                WHERE ordernumber = 'P180803140415512' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '375219'
                WHERE ordernumber = 'P180803140549905' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236935'
                WHERE ordernumber = 'P180803140859844' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '247164'
                WHERE ordernumber = 'P200803140909368' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '166603'
                WHERE ordernumber = 'P180803141152851' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405002'
                WHERE ordernumber = 'P180803141324639' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405003'
                WHERE ordernumber = 'P180803141609283' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98145'
                WHERE ordernumber = 'P200803141637875' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378725'
                WHERE ordernumber = 'P180803141702789' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '280371'
                WHERE ordernumber = 'P420803141846691' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405007'
                WHERE ordernumber = 'P180803142148282' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '258806'
                WHERE ordernumber = 'P180803142259618' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '248549'
                WHERE ordernumber = 'P180803142407975' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98774'
                WHERE ordernumber = 'P200803142746817' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351741'
                WHERE ordernumber = 'P180803142752619' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '324813'
                WHERE ordernumber = 'P180803143255163' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405010'
                WHERE ordernumber = 'P200803143613177' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405011'
                WHERE ordernumber = 'P420803143535697' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '294123'
                WHERE ordernumber = 'P200803144051589' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305069'
                WHERE ordernumber = 'P180803144127160' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405013'
                WHERE ordernumber = 'P200803144146735' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405014'
                WHERE ordernumber = 'P180803144301504' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340612'
                WHERE ordernumber = 'P180803144532125' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345357'
                WHERE ordernumber = 'P180803144839887' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405016'
                WHERE ordernumber = 'P180803145010770' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392057'
                WHERE ordernumber = 'P180803145120953' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '375162'
                WHERE ordernumber = 'P180803145221556' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405017'
                WHERE ordernumber = 'P420803145249669' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '244343'
                WHERE ordernumber = 'P200803145420455' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405019'
                WHERE ordernumber = 'P420803145502877' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404909'
                WHERE ordernumber = 'P420803145649837' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288248'
                WHERE ordernumber = 'P180803150137906' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405022'
                WHERE ordernumber = 'P180803150347345' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402032'
                WHERE ordernumber = 'P420803150951306' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384980'
                WHERE ordernumber = 'P200803151149274' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383965'
                WHERE ordernumber = 'P190803151441369' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99144'
                WHERE ordernumber = 'P200803151533525' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405024'
                WHERE ordernumber = 'P180803151930646' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402093'
                WHERE ordernumber = 'P420803152225157' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '101976'
                WHERE ordernumber = 'P180803152357267' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404915'
                WHERE ordernumber = 'P200803152537585' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387384'
                WHERE ordernumber = 'P420803152748194' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '232336'
                WHERE ordernumber = 'P180803153016412' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405031'
                WHERE ordernumber = 'P420803153025268' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405032'
                WHERE ordernumber = 'P420803153210792' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404186'
                WHERE ordernumber = 'P190803153517226' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405033'
                WHERE ordernumber = 'P420803153611221' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393625'
                WHERE ordernumber = 'P190803153851706' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405034'
                WHERE ordernumber = 'P420803153853217' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '159648'
                WHERE ordernumber = 'P200803154020427' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405036'
                WHERE ordernumber = 'P190803154142460' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405037'
                WHERE ordernumber = 'P420803154318939' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405039'
                WHERE ordernumber = 'P180803154437496' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405040'
                WHERE ordernumber = 'P420803154519425' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405041'
                WHERE ordernumber = 'P180803154547523' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405039'
                WHERE ordernumber = 'P180803154624203' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '78136'
                WHERE ordernumber = 'P180803155016255' 
            
2024-08-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398584'
                WHERE ordernumber = 'P180803155536304' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405046'
                WHERE ordernumber = 'P200803155636514' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405047'
                WHERE ordernumber = 'P420803155918814' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '97667'
                WHERE ordernumber = 'P200803160211387' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405049'
                WHERE ordernumber = 'P420803160323370' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405051'
                WHERE ordernumber = 'P200803160617316' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '159481'
                WHERE ordernumber = 'P200803160714707' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403811'
                WHERE ordernumber = 'P420803160824446' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '167650'
                WHERE ordernumber = 'P420803161019205' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '204748'
                WHERE ordernumber = 'P190803161052176' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '315575'
                WHERE ordernumber = 'P420803161235529' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '309469'
                WHERE ordernumber = 'P420803161322362' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358771'
                WHERE ordernumber = 'P180803161442734' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395302'
                WHERE ordernumber = 'P180803161809353' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '227698'
                WHERE ordernumber = 'P180803161902882' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352938'
                WHERE ordernumber = 'P420803162044591' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '380634'
                WHERE ordernumber = 'P420803162128574' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381734'
                WHERE ordernumber = 'P200803162141193' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '7748'
                WHERE ordernumber = 'P420803162235213' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405055'
                WHERE ordernumber = 'P420803162335420' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405056'
                WHERE ordernumber = 'P190803162500676' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '134192'
                WHERE ordernumber = 'P420803163051316' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '225963'
                WHERE ordernumber = 'P200803163714925' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405059'
                WHERE ordernumber = 'P200803163928757' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405060'
                WHERE ordernumber = 'P200803164020943' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '103407'
                WHERE ordernumber = 'P180803164117610' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405060'
                WHERE ordernumber = 'P200803164228122' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '226652'
                WHERE ordernumber = 'P200803164435121' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '280256'
                WHERE ordernumber = 'P180803164549998' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404177'
                WHERE ordernumber = 'P420803164718680' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '313873'
                WHERE ordernumber = 'P200803164732599' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '165882'
                WHERE ordernumber = 'P180803164841746' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405062'
                WHERE ordernumber = 'P420803164849646' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405063'
                WHERE ordernumber = 'P200803165158436' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405065'
                WHERE ordernumber = 'P420803165529922' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405066'
                WHERE ordernumber = 'P180803165841507' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399932'
                WHERE ordernumber = 'P420803170125131' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405067'
                WHERE ordernumber = 'P180803170135569' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405068'
                WHERE ordernumber = 'P180803170250202' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '220701'
                WHERE ordernumber = 'P180803170349182' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405069'
                WHERE ordernumber = 'P200803170507237' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405070'
                WHERE ordernumber = 'P180803170522904' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405071'
                WHERE ordernumber = 'P180803170645741' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '242767'
                WHERE ordernumber = 'P180803170740956' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '1775'
                WHERE ordernumber = 'P180803170925429' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405073'
                WHERE ordernumber = 'P420803171317936' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381589'
                WHERE ordernumber = 'P420803171353620' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405075'
                WHERE ordernumber = 'P180803171411304' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405076'
                WHERE ordernumber = 'P180803171517347' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405077'
                WHERE ordernumber = 'P420803171719902' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '356865'
                WHERE ordernumber = 'P200803171813141' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405079'
                WHERE ordernumber = 'P420803171820434' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405080'
                WHERE ordernumber = 'P420803171924328' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405081'
                WHERE ordernumber = 'P420803172242322' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377708'
                WHERE ordernumber = 'P180803172251385' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405082'
                WHERE ordernumber = 'P420803172509753' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '65739'
                WHERE ordernumber = 'P200803172523352' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405083'
                WHERE ordernumber = 'P420803172628776' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405085'
                WHERE ordernumber = 'P420803172714334' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405086'
                WHERE ordernumber = 'P420803172810909' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '375005'
                WHERE ordernumber = 'P180803172840851' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405088'
                WHERE ordernumber = 'P200803173030659' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405089'
                WHERE ordernumber = 'P200803173132636' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '242622'
                WHERE ordernumber = 'P180803173140922' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405093'
                WHERE ordernumber = 'P420803173547980' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '29379'
                WHERE ordernumber = 'P200803173553127' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '389855'
                WHERE ordernumber = 'P200803173649452' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405094'
                WHERE ordernumber = 'P420803173708671' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384646'
                WHERE ordernumber = 'P200803173826527' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '305261'
                WHERE ordernumber = 'P200803173918424' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405095'
                WHERE ordernumber = 'P420803174123660' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405096'
                WHERE ordernumber = 'P180803174209555' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '346050'
                WHERE ordernumber = 'P200803174515254' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405097'
                WHERE ordernumber = 'P420803174524245' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '301117'
                WHERE ordernumber = 'P200803174955884' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405098'
                WHERE ordernumber = 'P420803175101561' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396045'
                WHERE ordernumber = 'P200803175257611' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '99193'
                WHERE ordernumber = 'P180803175536500' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405100'
                WHERE ordernumber = 'P200803175707878' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405099'
                WHERE ordernumber = 'P190803175737397' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405101'
                WHERE ordernumber = 'P200803175837815' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377898'
                WHERE ordernumber = 'P630803180054731' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405102'
                WHERE ordernumber = 'P200803180219189' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405103'
                WHERE ordernumber = 'P200803180716549' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405104'
                WHERE ordernumber = 'P420803180838117' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '196808'
                WHERE ordernumber = 'P180803180854365' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404632'
                WHERE ordernumber = 'P590803180945129' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '278985'
                WHERE ordernumber = 'P180803180946185' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405106'
                WHERE ordernumber = 'P420803181024229' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '252639'
                WHERE ordernumber = 'P180803181243852' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405108'
                WHERE ordernumber = 'P180803181353263' 
            
2024-08-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '341550'
                WHERE ordernumber = 'P200803181355285' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405109'
                WHERE ordernumber = 'P180803181505303' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405110'
                WHERE ordernumber = 'P180803181619733' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405111'
                WHERE ordernumber = 'P180803181741988' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '96047'
                WHERE ordernumber = 'P180803181928992' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '82504'
                WHERE ordernumber = 'P180803182131857' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405112'
                WHERE ordernumber = 'P420803182317429' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '271982'
                WHERE ordernumber = 'P180803182322386' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '397258'
                WHERE ordernumber = 'P200803182352837' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '62031'
                WHERE ordernumber = 'P590803182359754' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405113'
                WHERE ordernumber = 'P420803182516398' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405115'
                WHERE ordernumber = 'P420803182742241' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405116'
                WHERE ordernumber = 'P420803182900710' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405117'
                WHERE ordernumber = 'P180803182916286' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405118'
                WHERE ordernumber = 'P420803183018399' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405119'
                WHERE ordernumber = 'P200803183138325' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405120'
                WHERE ordernumber = 'P180803183401940' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '397258'
                WHERE ordernumber = 'P200803183609466' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '235451'
                WHERE ordernumber = 'P200803183843758' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405121'
                WHERE ordernumber = 'P420803183936217' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405027'
                WHERE ordernumber = 'P420803184233339' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368065'
                WHERE ordernumber = 'P200803184300643' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402971'
                WHERE ordernumber = 'P180803184330336' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '94624'
                WHERE ordernumber = 'P200803184630285' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405124'
                WHERE ordernumber = 'P180803184807792' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405093'
                WHERE ordernumber = 'P420803184858590' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405125'
                WHERE ordernumber = 'P420803185047212' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405124'
                WHERE ordernumber = 'P180803185134880' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405126'
                WHERE ordernumber = 'P200803185320278' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405127'
                WHERE ordernumber = 'P200803185435151' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405128'
                WHERE ordernumber = 'P190803185457651' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '313761'
                WHERE ordernumber = 'P200803185708312' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '67684'
                WHERE ordernumber = 'P420803185916727' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '384691'
                WHERE ordernumber = 'P190803190159289' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '387282'
                WHERE ordernumber = 'P420803190308750' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405131'
                WHERE ordernumber = 'P200803190359930' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '287721'
                WHERE ordernumber = 'P200803190621740' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '390490'
                WHERE ordernumber = 'P420803190659798' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '101791'
                WHERE ordernumber = 'P200803191046664' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '241446'
                WHERE ordernumber = 'P200803191347561' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '99149'
                WHERE ordernumber = 'P190803191657426' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '99149'
                WHERE ordernumber = 'P190803191736930' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400156'
                WHERE ordernumber = 'P200803191821619' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '383141'
                WHERE ordernumber = 'P200803191911467' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405133'
                WHERE ordernumber = 'P190803192128812' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405134'
                WHERE ordernumber = 'P200803192146663' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '345365'
                WHERE ordernumber = 'P200803192234317' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '356807'
                WHERE ordernumber = 'P190803192327518' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '138070'
                WHERE ordernumber = 'P190803192632489' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353805'
                WHERE ordernumber = 'P200803193539222' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '388265'
                WHERE ordernumber = 'P190803194056499' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '404691'
                WHERE ordernumber = 'P190803194126368' 
            
2024-08-04 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '184559'
                WHERE ordernumber = 'P190803194839761'