2024-01-16 01:00:02 -- 將會員中心id寫入data-lake
2024-01-16 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-01-15%';
        
2024-01-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '361927'
                WHERE ordernumber = 'P180115110244928' 
            
2024-01-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '352217'
                WHERE ordernumber = 'P420115110619237' 
            
2024-01-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283036'
                WHERE ordernumber = 'P180115110825801' 
            
2024-01-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283493'
                WHERE ordernumber = 'P180115110911715' 
            
2024-01-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '188976'
                WHERE ordernumber = 'P190115111005365' 
            
2024-01-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '351872'
                WHERE ordernumber = 'P180115111037392' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366577'
                WHERE ordernumber = 'P180115111211400' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366578'
                WHERE ordernumber = 'P200115111230127' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364923'
                WHERE ordernumber = 'P190115111239399' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '121498'
                WHERE ordernumber = 'P200115111325729' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '329610'
                WHERE ordernumber = 'P420115111456725' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366580'
                WHERE ordernumber = 'P190115111632567' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366581'
                WHERE ordernumber = 'P180115111645526' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366582'
                WHERE ordernumber = 'P200115111947121' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366584'
                WHERE ordernumber = 'P200115112105584' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366586'
                WHERE ordernumber = 'P180115112250267' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302362'
                WHERE ordernumber = 'P420115112311304' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366588'
                WHERE ordernumber = 'P200115112319952' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '41940'
                WHERE ordernumber = 'P200115112417992' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245652'
                WHERE ordernumber = 'P200115112503545' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279247'
                WHERE ordernumber = 'P180115113036618' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '335158'
                WHERE ordernumber = 'P420115113045928' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359232'
                WHERE ordernumber = 'P190115113104868' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '80921'
                WHERE ordernumber = 'P200115113104710' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '158809'
                WHERE ordernumber = 'P180115113326784' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '243579'
                WHERE ordernumber = 'P200115113353139' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366591'
                WHERE ordernumber = 'P200115113641669' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '231253'
                WHERE ordernumber = 'P180115114100349' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '329662'
                WHERE ordernumber = 'P420115114124894' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '318525'
                WHERE ordernumber = 'P180115114310135' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '232018'
                WHERE ordernumber = 'P200115114437155' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366595'
                WHERE ordernumber = 'P180115114442363' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281598'
                WHERE ordernumber = 'P200115114619899' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353829'
                WHERE ordernumber = 'P420115114620421' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349559'
                WHERE ordernumber = 'P180115114628551' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '223757'
                WHERE ordernumber = 'P190115114630360' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313158'
                WHERE ordernumber = 'P420115114757233' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366599'
                WHERE ordernumber = 'P190115115238387' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '360404'
                WHERE ordernumber = 'P180115115358930' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271209'
                WHERE ordernumber = 'P420115115618376' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '206676'
                WHERE ordernumber = 'P420115115912866' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '66435'
                WHERE ordernumber = 'P180115120114530' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366602'
                WHERE ordernumber = 'P190115120146534' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '335218'
                WHERE ordernumber = 'P180115120336615' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366606'
                WHERE ordernumber = 'P190115120539151' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366607'
                WHERE ordernumber = 'P420115120557974' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366611'
                WHERE ordernumber = 'P420115121033372' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366613'
                WHERE ordernumber = 'P200115121128842' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366620'
                WHERE ordernumber = 'P200115121850278' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366619'
                WHERE ordernumber = 'P420115121944385' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334776'
                WHERE ordernumber = 'P420115122115960' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '25'
                WHERE ordernumber = 'P190115122520720' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '108873'
                WHERE ordernumber = 'P180115122647238' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '321877'
                WHERE ordernumber = 'P420115122712773' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94949'
                WHERE ordernumber = 'P180115122917927' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296985'
                WHERE ordernumber = 'P200115123012982' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366630'
                WHERE ordernumber = 'P420115123047196' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '190364'
                WHERE ordernumber = 'P180115123613548' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214728'
                WHERE ordernumber = 'P180115123805921' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366636'
                WHERE ordernumber = 'P200115124020918' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366637'
                WHERE ordernumber = 'P180115124031818' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366637'
                WHERE ordernumber = 'P180115124146709' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '133729'
                WHERE ordernumber = 'P200115124243938' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249357'
                WHERE ordernumber = 'P200115124441796' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '127788'
                WHERE ordernumber = 'P180115124549331' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366646'
                WHERE ordernumber = 'P420115124827309' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '90647'
                WHERE ordernumber = 'P200115125049509' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366650'
                WHERE ordernumber = 'P420115125138629' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287965'
                WHERE ordernumber = 'P200115125256399' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366651'
                WHERE ordernumber = 'P420115125316903' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281598'
                WHERE ordernumber = 'P200115125410316' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366657'
                WHERE ordernumber = 'P180115125732325' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366659'
                WHERE ordernumber = 'P180115125839787' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366667'
                WHERE ordernumber = 'P180115130840896' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357611'
                WHERE ordernumber = 'P180115131516521' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353740'
                WHERE ordernumber = 'P200115131839287' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334388'
                WHERE ordernumber = 'P190115131911324' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366676'
                WHERE ordernumber = 'P180115132153854' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366677'
                WHERE ordernumber = 'P180115132309396' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96618'
                WHERE ordernumber = 'P190115132447230' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366678'
                WHERE ordernumber = 'P180115132628838' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366680'
                WHERE ordernumber = 'P180115132907798' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366681'
                WHERE ordernumber = 'P200115133036634' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366683'
                WHERE ordernumber = 'P180115133446712' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '255391'
                WHERE ordernumber = 'P180115133553477' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '212317'
                WHERE ordernumber = 'P180115133703600' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366687'
                WHERE ordernumber = 'P200115133907490' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338247'
                WHERE ordernumber = 'P180115134000965' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366688'
                WHERE ordernumber = 'P180115134254863' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '236129'
                WHERE ordernumber = 'P200115134310476' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '319506'
                WHERE ordernumber = 'P420115134334889' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366685'
                WHERE ordernumber = 'P180115134410465' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '95915'
                WHERE ordernumber = 'P180115134500686' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366697'
                WHERE ordernumber = 'P200115134727895' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282822'
                WHERE ordernumber = 'P200115134818859' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348746'
                WHERE ordernumber = 'P180115135038124' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '166541'
                WHERE ordernumber = 'P190115135041657' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238986'
                WHERE ordernumber = 'P180115135435531' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '206583'
                WHERE ordernumber = 'P190115135618823' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366704'
                WHERE ordernumber = 'P200115140002895' 
            
2024-01-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353245'
                WHERE ordernumber = 'P180115140153823' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81113'
                WHERE ordernumber = 'P200115140257545' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366710'
                WHERE ordernumber = 'P420115140614581' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366708'
                WHERE ordernumber = 'P200115140711769' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236129'
                WHERE ordernumber = 'P200115141000719' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366714'
                WHERE ordernumber = 'P190115141001174' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '254447'
                WHERE ordernumber = 'P200115141058288' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '363869'
                WHERE ordernumber = 'P180115141200831' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362078'
                WHERE ordernumber = 'P200115141204643' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366718'
                WHERE ordernumber = 'P190115141235613' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P200115141319541' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366719'
                WHERE ordernumber = 'P190115141408576' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366720'
                WHERE ordernumber = 'P180115141418818' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366721'
                WHERE ordernumber = 'P200115141438304' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366718'
                WHERE ordernumber = 'P180115141522987' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '162059'
                WHERE ordernumber = 'P180115141630503' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366723'
                WHERE ordernumber = 'P190115141713862' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '341550'
                WHERE ordernumber = 'P200115141837701' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '336922'
                WHERE ordernumber = 'P180115142034499' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284523'
                WHERE ordernumber = 'P180115142151283' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366727'
                WHERE ordernumber = 'P200115142407242' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366728'
                WHERE ordernumber = 'P180115142622477' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '255733'
                WHERE ordernumber = 'P180115142833367' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '268103'
                WHERE ordernumber = 'P420115143103150' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366729'
                WHERE ordernumber = 'P190115143103607' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '291898'
                WHERE ordernumber = 'P200115143212927' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366730'
                WHERE ordernumber = 'P420115143220579' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366731'
                WHERE ordernumber = 'P180115143254622' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366732'
                WHERE ordernumber = 'P190115143427700' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '320424'
                WHERE ordernumber = 'P200115143440119' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '159536'
                WHERE ordernumber = 'P180115143515866' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356736'
                WHERE ordernumber = 'P420115143526409' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342021'
                WHERE ordernumber = 'P200115143759345' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342021'
                WHERE ordernumber = 'P200115143841322' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '320225'
                WHERE ordernumber = 'P190115143920534' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '316681'
                WHERE ordernumber = 'P420115143951736' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366736'
                WHERE ordernumber = 'P420115144021409' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366740'
                WHERE ordernumber = 'P180115144117726' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '72166'
                WHERE ordernumber = 'P420115144134382' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366740'
                WHERE ordernumber = 'P180115144229374' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356919'
                WHERE ordernumber = 'P190115144344406' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '365131'
                WHERE ordernumber = 'P420115144347768' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '279525'
                WHERE ordernumber = 'P180115144408634' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366741'
                WHERE ordernumber = 'P420115144432447' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288772'
                WHERE ordernumber = 'P190115144844762' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288772'
                WHERE ordernumber = 'P190115145013785' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366743'
                WHERE ordernumber = 'P180115145037623' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366745'
                WHERE ordernumber = 'P180115145330800' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366747'
                WHERE ordernumber = 'P180115145736689' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302505'
                WHERE ordernumber = 'P180115150130618' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344831'
                WHERE ordernumber = 'P180115150242573' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '169341'
                WHERE ordernumber = 'P180115150359632' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350407'
                WHERE ordernumber = 'P190115150648500' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '328655'
                WHERE ordernumber = 'P420115150653522' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366750'
                WHERE ordernumber = 'P180115150741690' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366750'
                WHERE ordernumber = 'P180115150821381' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '112178'
                WHERE ordernumber = 'P180115151534242' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '112178'
                WHERE ordernumber = 'P190115151800257' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366759'
                WHERE ordernumber = 'P200115151844468' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420'
                WHERE ordernumber = 'P180115151913511' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '263983'
                WHERE ordernumber = 'P190115152153264' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366764'
                WHERE ordernumber = 'P420115152237564' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366765'
                WHERE ordernumber = 'P180115152340614' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '363804'
                WHERE ordernumber = 'P180115152521527' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '291320'
                WHERE ordernumber = 'P190115152615584' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366773'
                WHERE ordernumber = 'P180115153219614' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366774'
                WHERE ordernumber = 'P180115153327608' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '364639'
                WHERE ordernumber = 'P180115153536788' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366776'
                WHERE ordernumber = 'P180115153942888' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '326670'
                WHERE ordernumber = 'P420115154014519' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103190'
                WHERE ordernumber = 'P180115154305531' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366779'
                WHERE ordernumber = 'P180115154458352' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366781'
                WHERE ordernumber = 'P180115154702599' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '286305'
                WHERE ordernumber = 'P190115154747709' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366784'
                WHERE ordernumber = 'P180115154918217' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '131846'
                WHERE ordernumber = 'P200115155047258' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '131846'
                WHERE ordernumber = 'P200115155123833' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351331'
                WHERE ordernumber = 'P190115155247983' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '104145'
                WHERE ordernumber = 'P180115155427889' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '336537'
                WHERE ordernumber = 'P180115155608749' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366636'
                WHERE ordernumber = 'P200115155707497' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366787'
                WHERE ordernumber = 'P180115155707425' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366788'
                WHERE ordernumber = 'P420115155833743' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366791'
                WHERE ordernumber = 'P200115155858532' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366795'
                WHERE ordernumber = 'P180115160331262' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '207694'
                WHERE ordernumber = 'P200115160342640' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366797'
                WHERE ordernumber = 'P420115160443864' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '162046'
                WHERE ordernumber = 'P190115160633675' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '242588'
                WHERE ordernumber = 'P200115160738515' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340795'
                WHERE ordernumber = 'P180115161053537' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366800'
                WHERE ordernumber = 'P180115161416600' 
            
2024-01-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238603'
                WHERE ordernumber = 'P420115161430928' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354965'
                WHERE ordernumber = 'P180115161519862' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366803'
                WHERE ordernumber = 'P180115161621471' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366804'
                WHERE ordernumber = 'P190115161701116' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366805'
                WHERE ordernumber = 'P180115161736762' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '196997'
                WHERE ordernumber = 'P180115162028907' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366809'
                WHERE ordernumber = 'P420115162332969' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '98128'
                WHERE ordernumber = 'P200115162450488' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '312991'
                WHERE ordernumber = 'P420115162500201' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355562'
                WHERE ordernumber = 'P180115162550831' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '152022'
                WHERE ordernumber = 'P200115162627823' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '328697'
                WHERE ordernumber = 'P180115163115138' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '292775'
                WHERE ordernumber = 'P180115163341500' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '238530'
                WHERE ordernumber = 'P200115163737494' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '236963'
                WHERE ordernumber = 'P200115163841799' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '234939'
                WHERE ordernumber = 'P180115163841461' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350897'
                WHERE ordernumber = 'P200115164029908' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '219229'
                WHERE ordernumber = 'P180115164054629' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349239'
                WHERE ordernumber = 'P180115164244583' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366825'
                WHERE ordernumber = 'P180115164625730' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '339061'
                WHERE ordernumber = 'P200115164747847' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366827'
                WHERE ordernumber = 'P420115164822961' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366831'
                WHERE ordernumber = 'P180115165127816' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366832'
                WHERE ordernumber = 'P420115165235788' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366833'
                WHERE ordernumber = 'P200115165344113' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '278444'
                WHERE ordernumber = 'P180115165354446' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '245116'
                WHERE ordernumber = 'P180115165838353' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366837'
                WHERE ordernumber = 'P180115170012197' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366840'
                WHERE ordernumber = 'P180115170424961' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366842'
                WHERE ordernumber = 'P180115170717990' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366845'
                WHERE ordernumber = 'P180115170859735' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '240336'
                WHERE ordernumber = 'P180115171044264' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366847'
                WHERE ordernumber = 'P180115171212274' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '272195'
                WHERE ordernumber = 'P180115171325340' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366849'
                WHERE ordernumber = 'P200115171341347' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '206596'
                WHERE ordernumber = 'P180115171414734' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '231706'
                WHERE ordernumber = 'P180115171515821' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366850'
                WHERE ordernumber = 'P420115171545288' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366852'
                WHERE ordernumber = 'P180115171623478' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '342300'
                WHERE ordernumber = 'P180115171658620' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366855'
                WHERE ordernumber = 'P180115172029903' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366854'
                WHERE ordernumber = 'P200115172039391' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '59627'
                WHERE ordernumber = 'P180115172324344' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '282746'
                WHERE ordernumber = 'P180115172434579' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366857'
                WHERE ordernumber = 'P420115172927196' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '121996'
                WHERE ordernumber = 'P180115173102399' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366861'
                WHERE ordernumber = 'P180115173250191' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366862'
                WHERE ordernumber = 'P420115173431674' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '93654'
                WHERE ordernumber = 'P200115173502902' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '209597'
                WHERE ordernumber = 'P180115173506167' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '324564'
                WHERE ordernumber = 'P200115173824662' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '288667'
                WHERE ordernumber = 'P200115174024487' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366863'
                WHERE ordernumber = 'P180115174025348' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '62377'
                WHERE ordernumber = 'P180115174202934' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '217012'
                WHERE ordernumber = 'P200115174954755' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366865'
                WHERE ordernumber = 'P180115175328194' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366865'
                WHERE ordernumber = 'P180115175359129' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366868'
                WHERE ordernumber = 'P200115175522345' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366869'
                WHERE ordernumber = 'P180115175555704' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '143853'
                WHERE ordernumber = 'P180115175754340' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366871'
                WHERE ordernumber = 'P200115175829241' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '233032'
                WHERE ordernumber = 'P180115175856609' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '270147'
                WHERE ordernumber = 'P200115180424226' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '270147'
                WHERE ordernumber = 'P200115180613319' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366877'
                WHERE ordernumber = 'P180115180624457' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '226438'
                WHERE ordernumber = 'P200115181000978' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366533'
                WHERE ordernumber = 'P180115181321351' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '296122'
                WHERE ordernumber = 'P180115181559297' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352682'
                WHERE ordernumber = 'P200115181641767' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '215182'
                WHERE ordernumber = 'P180115181723374' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366880'
                WHERE ordernumber = 'P200115181756286' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '319075'
                WHERE ordernumber = 'P420115181953959' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366882'
                WHERE ordernumber = 'P200115182100988' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366883'
                WHERE ordernumber = 'P200115182212522' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366885'
                WHERE ordernumber = 'P180115182441306' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366888'
                WHERE ordernumber = 'P180115182749744' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353128'
                WHERE ordernumber = 'P200115182903515' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '325559'
                WHERE ordernumber = 'P180115182957282' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '210936'
                WHERE ordernumber = 'P200115183117352' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '266185'
                WHERE ordernumber = 'P180115183330520' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '235594'
                WHERE ordernumber = 'P200115183516758' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '296980'
                WHERE ordernumber = 'P420115183633781' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366893'
                WHERE ordernumber = 'P200115183733305' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '87107'
                WHERE ordernumber = 'P180115183833256' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366897'
                WHERE ordernumber = 'P180115184157215' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366898'
                WHERE ordernumber = 'P180115184331660' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '217365'
                WHERE ordernumber = 'P200115184340537' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366900'
                WHERE ordernumber = 'P180115184449446' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366901'
                WHERE ordernumber = 'P200115184541990' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '140036'
                WHERE ordernumber = 'P190115184621664' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '168151'
                WHERE ordernumber = 'P200115184811973' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366903'
                WHERE ordernumber = 'P190115184840508' 
            
2024-01-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '303362'
                WHERE ordernumber = 'P200115184902947' 
            
2024-01-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '216067'
                WHERE ordernumber = 'P190115184934141' 
            
2024-01-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '366904'
                WHERE ordernumber = 'P200115185000626' 
            
2024-01-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '216067'
                WHERE ordernumber = 'P190115185012915' 
            
2024-01-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '366907'
                WHERE ordernumber = 'P190115185430140' 
            
2024-01-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '212612'
                WHERE ordernumber = 'P190115185741601' 
            
2024-01-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '166285'
                WHERE ordernumber = 'P190115185818896' 
            
2024-01-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '363475'
                WHERE ordernumber = 'P190115190053203' 
            
2024-01-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '288647'
                WHERE ordernumber = 'P190115190357233' 
            
2024-01-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '288647'
                WHERE ordernumber = 'P190115190547341' 
            
2024-01-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '366909'
                WHERE ordernumber = 'P190115191548568' 
            
2024-01-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '117304'
                WHERE ordernumber = 'P200115192454405' 
            
2024-01-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '366918'
                WHERE ordernumber = 'P200115192633646' 
            
2024-01-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '366142'
                WHERE ordernumber = 'P190115192716948' 
            
2024-01-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '366142'
                WHERE ordernumber = 'P190115192822167' 
            
2024-01-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '272857'
                WHERE ordernumber = 'P420115193212932' 
            
2024-01-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '366920'
                WHERE ordernumber = 'P200115193228863' 
            
2024-01-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '212202'
                WHERE ordernumber = 'P190115193307446' 
            
2024-01-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '297229'
                WHERE ordernumber = 'P420115193730750' 
            
2024-01-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '333126'
                WHERE ordernumber = 'P200115194022174' 
            
2024-01-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '360809'
                WHERE ordernumber = 'P200115194131375' 
            
2024-01-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '366927'
                WHERE ordernumber = 'P190115194255329' 
            
2024-01-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '334136'
                WHERE ordernumber = 'P200115194505799' 
            
2024-01-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '366932'
                WHERE ordernumber = 'P200115194815286' 
            
2024-01-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '366932'
                WHERE ordernumber = 'P200115194925554' 
            
2024-01-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '366936'
                WHERE ordernumber = 'P420115195255600' 
            
2024-01-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '365346'
                WHERE ordernumber = 'P190115195753905' 
            
2024-01-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '121695'
                WHERE ordernumber = 'P190115195910291'