2024-01-26 01:00:02 -- 將會員中心id寫入data-lake
2024-01-26 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-25%';
        
2024-01-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '341667'
                WHERE ordernumber = 'P420125110336539' 
            
2024-01-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '273583'
                WHERE ordernumber = 'P200125110340760' 
            
2024-01-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371882'
                WHERE ordernumber = 'P420125110634827' 
            
2024-01-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371877'
                WHERE ordernumber = 'P180125110810396' 
            
2024-01-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '269429'
                WHERE ordernumber = 'P190125110821707' 
            
2024-01-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '248796'
                WHERE ordernumber = 'P180125110919158' 
            
2024-01-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371884'
                WHERE ordernumber = 'P420125111116504' 
            
2024-01-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '286276'
                WHERE ordernumber = 'P180125111419886' 
            
2024-01-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371883'
                WHERE ordernumber = 'P180125111540383' 
            
2024-01-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '217480'
                WHERE ordernumber = 'P180125111641737' 
            
2024-01-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '72166'
                WHERE ordernumber = 'P420125111742921' 
            
2024-01-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371885'
                WHERE ordernumber = 'P190125111757861' 
            
2024-01-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '356230'
                WHERE ordernumber = 'P200125111838124' 
            
2024-01-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '362790'
                WHERE ordernumber = 'P420125112058282' 
            
2024-01-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '132448'
                WHERE ordernumber = 'P180125112134536' 
            
2024-01-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371887'
                WHERE ordernumber = 'P420125112213576' 
            
2024-01-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '335643'
                WHERE ordernumber = 'P200125112307793' 
            
2024-01-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371889'
                WHERE ordernumber = 'P420125112323353' 
            
2024-01-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371890'
                WHERE ordernumber = 'P420125112440235' 
            
2024-01-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '204807'
                WHERE ordernumber = 'P190125112551380' 
            
2024-01-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '118377'
                WHERE ordernumber = 'P180125112629663' 
            
2024-01-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '305471'
                WHERE ordernumber = 'P200125112737496' 
            
2024-01-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '286715'
                WHERE ordernumber = 'P200125112838573' 
            
2024-01-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '129715'
                WHERE ordernumber = 'P190125112846581' 
            
2024-01-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371891'
                WHERE ordernumber = 'P420125112847643' 
            
2024-01-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '286715'
                WHERE ordernumber = 'P200125112929310' 
            
2024-01-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '366602'
                WHERE ordernumber = 'P190125113009683' 
            
2024-01-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '302812'
                WHERE ordernumber = 'P200125113354992' 
            
2024-01-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '341978'
                WHERE ordernumber = 'P200125113611815' 
            
2024-01-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371737'
                WHERE ordernumber = 'P200125113712763' 
            
2024-01-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '337234'
                WHERE ordernumber = 'P200125114111548' 
            
2024-01-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '345881'
                WHERE ordernumber = 'P200125114244843' 
            
2024-01-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '331574'
                WHERE ordernumber = 'P420125114301818' 
            
2024-01-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371899'
                WHERE ordernumber = 'P420125114958516' 
            
2024-01-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371905'
                WHERE ordernumber = 'P200125115821472' 
            
2024-01-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '296856'
                WHERE ordernumber = 'P420125120008533' 
            
2024-01-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '316840'
                WHERE ordernumber = 'P200125120024614' 
            
2024-01-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '296855'
                WHERE ordernumber = 'P420125120157634' 
            
2024-01-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371906'
                WHERE ordernumber = 'P200125120447114' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371908'
                WHERE ordernumber = 'P420125120509490' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371907'
                WHERE ordernumber = 'P420125120628805' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337596'
                WHERE ordernumber = 'P200125120723767' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '208646'
                WHERE ordernumber = 'P420125120735276' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371910'
                WHERE ordernumber = 'P420125120844664' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241465'
                WHERE ordernumber = 'P180125120854279' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285398'
                WHERE ordernumber = 'P200125121020556' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371912'
                WHERE ordernumber = 'P200125121133277' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348875'
                WHERE ordernumber = 'P420125121139800' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '320706'
                WHERE ordernumber = 'P180125121510889' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354159'
                WHERE ordernumber = 'P180125122746468' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '232257'
                WHERE ordernumber = 'P200125122831996' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281382'
                WHERE ordernumber = 'P180125122833747' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '308151'
                WHERE ordernumber = 'P420125122944615' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371915'
                WHERE ordernumber = 'P420125123228385' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '243405'
                WHERE ordernumber = 'P200125123400580' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315897'
                WHERE ordernumber = 'P420125123625448' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371919'
                WHERE ordernumber = 'P200125123756541' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '246112'
                WHERE ordernumber = 'P180125123934773' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249219'
                WHERE ordernumber = 'P180125124125710' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371920'
                WHERE ordernumber = 'P420125124131735' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358110'
                WHERE ordernumber = 'P200125124227766' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371923'
                WHERE ordernumber = 'P200125124356805' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371922'
                WHERE ordernumber = 'P420125124400531' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356099'
                WHERE ordernumber = 'P180125124449523' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314019'
                WHERE ordernumber = 'P200125124501758' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364987'
                WHERE ordernumber = 'P180125124753717' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371924'
                WHERE ordernumber = 'P420125124822167' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355504'
                WHERE ordernumber = 'P190125124839574' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371926'
                WHERE ordernumber = 'P200125125250386' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289954'
                WHERE ordernumber = 'P180125125418644' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '243779'
                WHERE ordernumber = 'P200125125515783' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '108055'
                WHERE ordernumber = 'P180125125635614' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '280957'
                WHERE ordernumber = 'P420125125840953' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81113'
                WHERE ordernumber = 'P200125130013745' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371929'
                WHERE ordernumber = 'P180125130026532' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '66860'
                WHERE ordernumber = 'P190125130122690' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '256105'
                WHERE ordernumber = 'P200125130153572' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371930'
                WHERE ordernumber = 'P420125130217566' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371931'
                WHERE ordernumber = 'P200125130327118' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371932'
                WHERE ordernumber = 'P200125130437227' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364660'
                WHERE ordernumber = 'P420125130526298' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '90938'
                WHERE ordernumber = 'P200125130539347' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371933'
                WHERE ordernumber = 'P420125130628147' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371935'
                WHERE ordernumber = 'P200125130657760' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371940'
                WHERE ordernumber = 'P420125131638708' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180125131806129' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '111412'
                WHERE ordernumber = 'P180125131949114' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '178946'
                WHERE ordernumber = 'P420125132707127' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371946'
                WHERE ordernumber = 'P420125133117334' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371948'
                WHERE ordernumber = 'P180125133258226' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P190125133609770' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '208650'
                WHERE ordernumber = 'P180125133632955' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347636'
                WHERE ordernumber = 'P200125133935167' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '91230'
                WHERE ordernumber = 'P180125134114712' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371950'
                WHERE ordernumber = 'P420125134200678' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '369375'
                WHERE ordernumber = 'P200125134225766' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367184'
                WHERE ordernumber = 'P420125134302621' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371951'
                WHERE ordernumber = 'P200125134319331' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367184'
                WHERE ordernumber = 'P420125134353306' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371952'
                WHERE ordernumber = 'P200125134456664' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371954'
                WHERE ordernumber = 'P420125134526764' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349895'
                WHERE ordernumber = 'P200125134546982' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366602'
                WHERE ordernumber = 'P190125134618303' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371955'
                WHERE ordernumber = 'P420125134647282' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '215507'
                WHERE ordernumber = 'P200125134903179' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '273432'
                WHERE ordernumber = 'P200125140205222' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230088'
                WHERE ordernumber = 'P190125140423474' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '369253'
                WHERE ordernumber = 'P200125140817941' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371961'
                WHERE ordernumber = 'P200125141057879' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '211206'
                WHERE ordernumber = 'P180125141126847' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371956'
                WHERE ordernumber = 'P180125141331643' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '125995'
                WHERE ordernumber = 'P180125141633233' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '192200'
                WHERE ordernumber = 'P200125142025943' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371964'
                WHERE ordernumber = 'P420125142352357' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371969'
                WHERE ordernumber = 'P180125142418808' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '272140'
                WHERE ordernumber = 'P180125142510973' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371964'
                WHERE ordernumber = 'P420125142520716' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371971'
                WHERE ordernumber = 'P200125142821321' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100750'
                WHERE ordernumber = 'P190125143116252' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358345'
                WHERE ordernumber = 'P200125143156575' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '84659'
                WHERE ordernumber = 'P180125143202740' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99638'
                WHERE ordernumber = 'P180125143301776' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '159321'
                WHERE ordernumber = 'P200125143630445' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371973'
                WHERE ordernumber = 'P420125143642984' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '159321'
                WHERE ordernumber = 'P200125143745117' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282860'
                WHERE ordernumber = 'P180125143803378' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '83903'
                WHERE ordernumber = 'P200125144435865' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '157070'
                WHERE ordernumber = 'P180125144702694' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371977'
                WHERE ordernumber = 'P200125144832374' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371977'
                WHERE ordernumber = 'P200125144920294' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '157070'
                WHERE ordernumber = 'P180125144954678' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354822'
                WHERE ordernumber = 'P180125145154250' 
            
2024-01-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '157070'
                WHERE ordernumber = 'P180125145252162' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371978'
                WHERE ordernumber = 'P420125145306250' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '269154'
                WHERE ordernumber = 'P180125150640657' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '169566'
                WHERE ordernumber = 'P180125150736882' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354965'
                WHERE ordernumber = 'P180125150959426' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371980'
                WHERE ordernumber = 'P420125151239883' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '370801'
                WHERE ordernumber = 'P180125151311677' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340572'
                WHERE ordernumber = 'P180125151417949' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '84930'
                WHERE ordernumber = 'P200125151714113' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '326303'
                WHERE ordernumber = 'P200125152002212' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297056'
                WHERE ordernumber = 'P420125152129614' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371989'
                WHERE ordernumber = 'P420125153408313' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '154281'
                WHERE ordernumber = 'P200125153437533' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '121932'
                WHERE ordernumber = 'P420125153512232' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371992'
                WHERE ordernumber = 'P420125154220906' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371993'
                WHERE ordernumber = 'P180125154237576' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371993'
                WHERE ordernumber = 'P180125154311293' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349210'
                WHERE ordernumber = 'P180125154434413' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346753'
                WHERE ordernumber = 'P420125154559364' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '309299'
                WHERE ordernumber = 'P180125154958952' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237327'
                WHERE ordernumber = 'P200125155142346' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '368627'
                WHERE ordernumber = 'P200125155346119' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371999'
                WHERE ordernumber = 'P200125155454453' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372001'
                WHERE ordernumber = 'P200125155557277' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372002'
                WHERE ordernumber = 'P420125155710213' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372003'
                WHERE ordernumber = 'P200125155711534' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '85633'
                WHERE ordernumber = 'P190125155924203' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '36461'
                WHERE ordernumber = 'P200125160009699' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '262619'
                WHERE ordernumber = 'P420125160035999' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '135355'
                WHERE ordernumber = 'P200125160116273' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372007'
                WHERE ordernumber = 'P420125160244905' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102807'
                WHERE ordernumber = 'P180125160250114' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '233396'
                WHERE ordernumber = 'P420125160416946' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '124755'
                WHERE ordernumber = 'P200125161217726' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313246'
                WHERE ordernumber = 'P180125162010357' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '341983'
                WHERE ordernumber = 'P420125162713151' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372016'
                WHERE ordernumber = 'P200125162836195' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372018'
                WHERE ordernumber = 'P420125162952564' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372019'
                WHERE ordernumber = 'P420125163544506' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '118047'
                WHERE ordernumber = 'P180125163620946' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '217639'
                WHERE ordernumber = 'P180125163919966' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '322426'
                WHERE ordernumber = 'P420125163956861' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275735'
                WHERE ordernumber = 'P180125164344843' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '360058'
                WHERE ordernumber = 'P420125164756550' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '218573'
                WHERE ordernumber = 'P200125165000548' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '129083'
                WHERE ordernumber = 'P180125165058438' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287235'
                WHERE ordernumber = 'P200125165601610' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372024'
                WHERE ordernumber = 'P420125165658543' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352244'
                WHERE ordernumber = 'P420125165827129' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '170685'
                WHERE ordernumber = 'P200125165838975' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '90959'
                WHERE ordernumber = 'P180125170410582' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372031'
                WHERE ordernumber = 'P180125170539455' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '119536'
                WHERE ordernumber = 'P180125171146548' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372034'
                WHERE ordernumber = 'P420125171258963' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371730'
                WHERE ordernumber = 'P200125171425631' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '303969'
                WHERE ordernumber = 'P420125171528255' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337626'
                WHERE ordernumber = 'P420125171958506' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '330225'
                WHERE ordernumber = 'P180125172013976' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346696'
                WHERE ordernumber = 'P200125172318985' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100972'
                WHERE ordernumber = 'P180125172453537' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238530'
                WHERE ordernumber = 'P200125172557713' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351749'
                WHERE ordernumber = 'P180125172602476' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245850'
                WHERE ordernumber = 'P200125172859600' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '165442'
                WHERE ordernumber = 'P200125173323320' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '232297'
                WHERE ordernumber = 'P200125173358634' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '123739'
                WHERE ordernumber = 'P420125173618569' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '229285'
                WHERE ordernumber = 'P200125173723595' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340529'
                WHERE ordernumber = 'P200125173926159' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '126817'
                WHERE ordernumber = 'P180125174442393' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '226572'
                WHERE ordernumber = 'P420125174616160' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '311650'
                WHERE ordernumber = 'P200125174721122' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '159647'
                WHERE ordernumber = 'P200125174755934' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358875'
                WHERE ordernumber = 'P420125174805751' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372042'
                WHERE ordernumber = 'P420125174949508' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350850'
                WHERE ordernumber = 'P420125175055652' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346464'
                WHERE ordernumber = 'P200125175926527' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372050'
                WHERE ordernumber = 'P420125180303288' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372051'
                WHERE ordernumber = 'P420125180347736' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '314386'
                WHERE ordernumber = 'P180125180604374' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346246'
                WHERE ordernumber = 'P420125181542138' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '48997'
                WHERE ordernumber = 'P420125182719981' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '256761'
                WHERE ordernumber = 'P200125182751294' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245478'
                WHERE ordernumber = 'P180125182824708' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372059'
                WHERE ordernumber = 'P420125183008157' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '256761'
                WHERE ordernumber = 'P200125183046856' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '256463'
                WHERE ordernumber = 'P190125183919457' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '4'
                WHERE ordernumber = 'P530125184016285' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356317'
                WHERE ordernumber = 'P420125184127359' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '139402'
                WHERE ordernumber = 'P200125184321485' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '62723'
                WHERE ordernumber = 'P200125184433918' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '235629'
                WHERE ordernumber = 'P200125184625499' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372066'
                WHERE ordernumber = 'P420125185007481' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372066'
                WHERE ordernumber = 'P420125185337565' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245917'
                WHERE ordernumber = 'P190125190154949' 
            
2024-01-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372075'
                WHERE ordernumber = 'P420125190902316' 
            
2024-01-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372076'
                WHERE ordernumber = 'P420125191035140' 
            
2024-01-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372079'
                WHERE ordernumber = 'P420125191437364' 
            
2024-01-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '98206'
                WHERE ordernumber = 'P420125191536508' 
            
2024-01-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '314736'
                WHERE ordernumber = 'P190125191736869' 
            
2024-01-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '77886'
                WHERE ordernumber = 'P200125192517709' 
            
2024-01-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '314798'
                WHERE ordernumber = 'P420125192839717' 
            
2024-01-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372087'
                WHERE ordernumber = 'P200125193402540' 
            
2024-01-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '109893'
                WHERE ordernumber = 'P190125193440502' 
            
2024-01-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '337355'
                WHERE ordernumber = 'P200125193503342' 
            
2024-01-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '357650'
                WHERE ordernumber = 'P190125193544661' 
            
2024-01-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372089'
                WHERE ordernumber = 'P200125193612849' 
            
2024-01-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372090'
                WHERE ordernumber = 'P420125193903371' 
            
2024-01-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '292461'
                WHERE ordernumber = 'P190125194616296'