2024-05-30 01:00:01 -- 將會員中心id寫入data-lake
2024-05-30 01:00:01 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-05-29%';
        
2024-05-30 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '138937'
                WHERE ordernumber = 'P200529110230478' 
            
2024-05-30 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '192556'
                WHERE ordernumber = 'P190529110234919' 
            
2024-05-30 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '392755'
                WHERE ordernumber = 'P190529110426180' 
            
2024-05-30 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '392757'
                WHERE ordernumber = 'P200529110519391' 
            
2024-05-30 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '392758'
                WHERE ordernumber = 'P190529110647129' 
            
2024-05-30 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '392759'
                WHERE ordernumber = 'P180529110714961' 
            
2024-05-30 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '392761'
                WHERE ordernumber = 'P180529110848544' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392762'
                WHERE ordernumber = 'P190529110959582' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392764'
                WHERE ordernumber = 'P200529111213996' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '311758'
                WHERE ordernumber = 'P190529111324505' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378591'
                WHERE ordernumber = 'P180529111523398' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392741'
                WHERE ordernumber = 'P180529111728367' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392741'
                WHERE ordernumber = 'P180529111733697' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392765'
                WHERE ordernumber = 'P190529111737457' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378591'
                WHERE ordernumber = 'P180529111855508' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '340667'
                WHERE ordernumber = 'P190529112003377' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '260280'
                WHERE ordernumber = 'P180529112028449' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '164099'
                WHERE ordernumber = 'P200529112439915' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '164099'
                WHERE ordernumber = 'P200529112524782' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381202'
                WHERE ordernumber = 'P190529112848696' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392769'
                WHERE ordernumber = 'P200529113054847' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389123'
                WHERE ordernumber = 'P200529113351837' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '260961'
                WHERE ordernumber = 'P200529113835127' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '257909'
                WHERE ordernumber = 'P200529114011525' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '281268'
                WHERE ordernumber = 'P200529114325854' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '225805'
                WHERE ordernumber = 'P180529114938719' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392775'
                WHERE ordernumber = 'P420529115217653' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '352813'
                WHERE ordernumber = 'P190529115441215' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348816'
                WHERE ordernumber = 'P200529115716926' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392778'
                WHERE ordernumber = 'P420529115906569' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '126002'
                WHERE ordernumber = 'P180529120057227' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354202'
                WHERE ordernumber = 'P200529120444225' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '247064'
                WHERE ordernumber = 'P200529120924494' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392781'
                WHERE ordernumber = 'P180529121026842' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392782'
                WHERE ordernumber = 'P630529121209845' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392780'
                WHERE ordernumber = 'P790529121417981' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387559'
                WHERE ordernumber = 'P200529121439400' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '155800'
                WHERE ordernumber = 'P630529121455303' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283649'
                WHERE ordernumber = 'P630529121755975' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '96146'
                WHERE ordernumber = 'P180529121810456' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392787'
                WHERE ordernumber = 'P630529122050484' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388632'
                WHERE ordernumber = 'P200529122738707' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '361473'
                WHERE ordernumber = 'P200529123006142' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392792'
                WHERE ordernumber = 'P180529123821604' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392791'
                WHERE ordernumber = 'P420529123824851' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '383210'
                WHERE ordernumber = 'P180529124426951' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392794'
                WHERE ordernumber = 'P420529124742469' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392796'
                WHERE ordernumber = 'P180529124752277' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '81113'
                WHERE ordernumber = 'P200529124848620' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '101375'
                WHERE ordernumber = 'P190529125120947' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '288868'
                WHERE ordernumber = 'P180529125232819' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '258782'
                WHERE ordernumber = 'P180529125315934' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392797'
                WHERE ordernumber = 'P180529125521613' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392798'
                WHERE ordernumber = 'P200529125641901' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392799'
                WHERE ordernumber = 'P180529125817482' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '244313'
                WHERE ordernumber = 'P200529130058798' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '317887'
                WHERE ordernumber = 'P420529130622431' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '172599'
                WHERE ordernumber = 'P180529130819170' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389260'
                WHERE ordernumber = 'P200529130841598' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392800'
                WHERE ordernumber = 'P710529131015361' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '314908'
                WHERE ordernumber = 'P420529131055501' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392801'
                WHERE ordernumber = 'P790529131205905' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392802'
                WHERE ordernumber = 'P200529133238787' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '335163'
                WHERE ordernumber = 'P200529133835126' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287103'
                WHERE ordernumber = 'P180529134310643' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '156524'
                WHERE ordernumber = 'P180529140522716' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392809'
                WHERE ordernumber = 'P180529140843721' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392810'
                WHERE ordernumber = 'P180529140947475' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392811'
                WHERE ordernumber = 'P190529141932796' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390247'
                WHERE ordernumber = 'P200529141941887' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392812'
                WHERE ordernumber = 'P200529142045337' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '241711'
                WHERE ordernumber = 'P180529142102943' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '273823'
                WHERE ordernumber = 'P420529142335623' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392814'
                WHERE ordernumber = 'P420529142448732' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392815'
                WHERE ordernumber = 'P200529142453288' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '112848'
                WHERE ordernumber = 'P200529142526781' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392816'
                WHERE ordernumber = 'P790529142846697' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391203'
                WHERE ordernumber = 'P790529143212243' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '136864'
                WHERE ordernumber = 'P180529143257497' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392817'
                WHERE ordernumber = 'P180529143449846' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '127085'
                WHERE ordernumber = 'P200529143726429' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391338'
                WHERE ordernumber = 'P190529143924724' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392820'
                WHERE ordernumber = 'P420529144005605' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392818'
                WHERE ordernumber = 'P790529144106250' 
            
2024-05-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '229132'
                WHERE ordernumber = 'P190529144423218' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392822'
                WHERE ordernumber = 'P180529144451426' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238188'
                WHERE ordernumber = 'P200529144718986' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242563'
                WHERE ordernumber = 'P200529144728118' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289840'
                WHERE ordernumber = 'P630529144901925' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337912'
                WHERE ordernumber = 'P780529145039553' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392823'
                WHERE ordernumber = 'P180529145124388' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337912'
                WHERE ordernumber = 'P780529145324661' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392821'
                WHERE ordernumber = 'P180529145450885' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389112'
                WHERE ordernumber = 'P200529145719640' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392827'
                WHERE ordernumber = 'P790529145732718' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392828'
                WHERE ordernumber = 'P420529145749133' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392826'
                WHERE ordernumber = 'P790529145817793' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381969'
                WHERE ordernumber = 'P420529145950743' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364142'
                WHERE ordernumber = 'P200529150329865' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392829'
                WHERE ordernumber = 'P790529150615718' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392813'
                WHERE ordernumber = 'P180529150721825' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392831'
                WHERE ordernumber = 'P420529150730952' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384129'
                WHERE ordernumber = 'P190529151036720' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367983'
                WHERE ordernumber = 'P420529151126867' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384129'
                WHERE ordernumber = 'P180529151324959' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392832'
                WHERE ordernumber = 'P790529151542472' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389128'
                WHERE ordernumber = 'P190529151804952' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '123629'
                WHERE ordernumber = 'P200529151954486' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392830'
                WHERE ordernumber = 'P790529152206812' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235417'
                WHERE ordernumber = 'P200529152256537' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235417'
                WHERE ordernumber = 'P200529152432635' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392833'
                WHERE ordernumber = 'P180529152557476' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238722'
                WHERE ordernumber = 'P200529152624384' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346351'
                WHERE ordernumber = 'P180529152916625' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392834'
                WHERE ordernumber = 'P420529153018479' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392835'
                WHERE ordernumber = 'P200529153045285' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392836'
                WHERE ordernumber = 'P200529153158132' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '213846'
                WHERE ordernumber = 'P180529153717706' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '333591'
                WHERE ordernumber = 'P200529154047338' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392837'
                WHERE ordernumber = 'P190529154106778' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378791'
                WHERE ordernumber = 'P180529154219244' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390006'
                WHERE ordernumber = 'P190529154404760' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302746'
                WHERE ordernumber = 'P420529154534215' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392841'
                WHERE ordernumber = 'P200529155207425' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '166339'
                WHERE ordernumber = 'P790529155208716' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392844'
                WHERE ordernumber = 'P200529155713566' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392845'
                WHERE ordernumber = 'P420529160001320' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392846'
                WHERE ordernumber = 'P710529160150280' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392847'
                WHERE ordernumber = 'P790529160348754' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358732'
                WHERE ordernumber = 'P790529160706584' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392842'
                WHERE ordernumber = 'P420529160919599' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '243438'
                WHERE ordernumber = 'P180529161006557' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392848'
                WHERE ordernumber = 'P790529161137844' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275250'
                WHERE ordernumber = 'P200529161206380' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '171629'
                WHERE ordernumber = 'P190529161418275' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392850'
                WHERE ordernumber = 'P180529161459798' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392853'
                WHERE ordernumber = 'P200529161735234' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392849'
                WHERE ordernumber = 'P180529161844182' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392849'
                WHERE ordernumber = 'P180529161847758' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392851'
                WHERE ordernumber = 'P420529161909229' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392855'
                WHERE ordernumber = 'P200529162044490' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '84859'
                WHERE ordernumber = 'P180529162302983' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301300'
                WHERE ordernumber = 'P180529162626271' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347676'
                WHERE ordernumber = 'P180529162731940' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392857'
                WHERE ordernumber = 'P630529162812549' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392859'
                WHERE ordernumber = 'P180529162850492' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392858'
                WHERE ordernumber = 'P200529162951252' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337605'
                WHERE ordernumber = 'P420529163519676' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392838'
                WHERE ordernumber = 'P180529163601397' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343932'
                WHERE ordernumber = 'P190529163617404' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392861'
                WHERE ordernumber = 'P420529163825494' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392862'
                WHERE ordernumber = 'P790529164439117' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392864'
                WHERE ordernumber = 'P790529164930471' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382958'
                WHERE ordernumber = 'P190529165418523' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368622'
                WHERE ordernumber = 'P420529165742417' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392865'
                WHERE ordernumber = 'P790529165834510' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392866'
                WHERE ordernumber = 'P790529165907835' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392868'
                WHERE ordernumber = 'P630529170007811' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '221669'
                WHERE ordernumber = 'P200529170139822' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392869'
                WHERE ordernumber = 'P200529170341276' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392871'
                WHERE ordernumber = 'P200529170530134' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '216873'
                WHERE ordernumber = 'P180529170615770' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350209'
                WHERE ordernumber = 'P200529170629809' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '232257'
                WHERE ordernumber = 'P420529170812426' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392873'
                WHERE ordernumber = 'P180529171102657' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341238'
                WHERE ordernumber = 'P180529171156990' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '219343'
                WHERE ordernumber = 'P180529171347309' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341238'
                WHERE ordernumber = 'P180529171503924' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388090'
                WHERE ordernumber = 'P180529171612672' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392878'
                WHERE ordernumber = 'P420529171725770' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '104455'
                WHERE ordernumber = 'P180529172000669' 
            
2024-05-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389740'
                WHERE ordernumber = 'P420529172030219' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '62420'
                WHERE ordernumber = 'P710529172047193' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392879'
                WHERE ordernumber = 'P200529172202579' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392880'
                WHERE ordernumber = 'P180529172248578' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392879'
                WHERE ordernumber = 'P200529172248887' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '298739'
                WHERE ordernumber = 'P200529172438837' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '26394'
                WHERE ordernumber = 'P180529172522580' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283963'
                WHERE ordernumber = 'P200529172947312' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392882'
                WHERE ordernumber = 'P200529173029192' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '163646'
                WHERE ordernumber = 'P420529173232113' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392884'
                WHERE ordernumber = 'P180529173327738' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '375005'
                WHERE ordernumber = 'P180529173400339' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392883'
                WHERE ordernumber = 'P790529173417415' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '316319'
                WHERE ordernumber = 'P180529174052987' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390513'
                WHERE ordernumber = 'P790529174113669' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '318317'
                WHERE ordernumber = 'P420529174120851' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392720'
                WHERE ordernumber = 'P200529174404733' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392887'
                WHERE ordernumber = 'P180529174418118' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391737'
                WHERE ordernumber = 'P420529174508341' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '293584'
                WHERE ordernumber = 'P190529174528640' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392888'
                WHERE ordernumber = 'P190529174701605' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '40163'
                WHERE ordernumber = 'P180529175220857' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385876'
                WHERE ordernumber = 'P200529175351403' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '240978'
                WHERE ordernumber = 'P180529175358391' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392890'
                WHERE ordernumber = 'P200529175831211' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81074'
                WHERE ordernumber = 'P200529175952795' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392892'
                WHERE ordernumber = 'P790529180312358' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390223'
                WHERE ordernumber = 'P200529180420175' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392894'
                WHERE ordernumber = 'P190529180631614' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '139551'
                WHERE ordernumber = 'P190529180824271' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382775'
                WHERE ordernumber = 'P420529181340991' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '317789'
                WHERE ordernumber = 'P190529181453198' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392895'
                WHERE ordernumber = 'P180529181526168' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '229014'
                WHERE ordernumber = 'P180529181835912' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94055'
                WHERE ordernumber = 'P200529182214506' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392896'
                WHERE ordernumber = 'P630529182630975' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392897'
                WHERE ordernumber = 'P200529182815473' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287188'
                WHERE ordernumber = 'P190529183135637' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '92273'
                WHERE ordernumber = 'P200529183259732' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '206401'
                WHERE ordernumber = 'P790529183648632' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392899'
                WHERE ordernumber = 'P630529185542685' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392110'
                WHERE ordernumber = 'P630529185640335' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392900'
                WHERE ordernumber = 'P180529185749164' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379191'
                WHERE ordernumber = 'P200529185910216' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392901'
                WHERE ordernumber = 'P710529190141227' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '141878'
                WHERE ordernumber = 'P200529190243679' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '101457'
                WHERE ordernumber = 'P200529191527164' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '248048'
                WHERE ordernumber = 'P190529191623816' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392902'
                WHERE ordernumber = 'P630529191725940' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385398'
                WHERE ordernumber = 'P200529191942578' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392906'
                WHERE ordernumber = 'P200529192352949' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392905'
                WHERE ordernumber = 'P790529192354417' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '105669'
                WHERE ordernumber = 'P200529192507922' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392908'
                WHERE ordernumber = 'P200529192614920' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392909'
                WHERE ordernumber = 'P190529192704841' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392910'
                WHERE ordernumber = 'P200529192900557' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '309791'
                WHERE ordernumber = 'P200529193037464' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103635'
                WHERE ordernumber = 'P190529193043634' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390733'
                WHERE ordernumber = 'P420529193124515' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392646'
                WHERE ordernumber = 'P630529193125647' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392911'
                WHERE ordernumber = 'P630529193141175' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '92196'
                WHERE ordernumber = 'P190529193204967' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392343'
                WHERE ordernumber = 'P200529193917642' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384374'
                WHERE ordernumber = 'P190529194121495' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392913'
                WHERE ordernumber = 'P200529194127258' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81580'
                WHERE ordernumber = 'P190529194227690' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392914'
                WHERE ordernumber = 'P190529194425802' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392915'
                WHERE ordernumber = 'P630529195045986' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392916'
                WHERE ordernumber = 'P190529195209847' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392916'
                WHERE ordernumber = 'P190529195313582' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392916'
                WHERE ordernumber = 'P190529195519462' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '229676'
                WHERE ordernumber = 'P710529202441315' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392920'
                WHERE ordernumber = 'P790529204007257' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392922'
                WHERE ordernumber = 'P630529205039490' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392924'
                WHERE ordernumber = 'P710529210800744' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392925'
                WHERE ordernumber = 'P710529211620255' 
            
2024-05-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392928'
                WHERE ordernumber = 'P710529213359378'