2024-07-22 01:00:03 -- 將會員中心id寫入data-lake
2024-07-22 01:00:03 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-07-21%';
        
2024-07-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302614'
                WHERE ordernumber = 'P200721110412378' 
            
2024-07-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '225141'
                WHERE ordernumber = 'P180721110424890' 
            
2024-07-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276228'
                WHERE ordernumber = 'P190721110523963' 
            
2024-07-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402331'
                WHERE ordernumber = 'P420721110635733' 
            
2024-07-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277551'
                WHERE ordernumber = 'P190721110729687' 
            
2024-07-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345943'
                WHERE ordernumber = 'P420721110807851' 
            
2024-07-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402332'
                WHERE ordernumber = 'P200721110851400' 
            
2024-07-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113696'
                WHERE ordernumber = 'P190721110921438' 
            
2024-07-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401431'
                WHERE ordernumber = 'P200721111051347' 
            
2024-07-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402333'
                WHERE ordernumber = 'P420721111218258' 
            
2024-07-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402334'
                WHERE ordernumber = 'P200721111306220' 
            
2024-07-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391656'
                WHERE ordernumber = 'P420721111325247' 
            
2024-07-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389745'
                WHERE ordernumber = 'P200721111448208' 
            
2024-07-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286447'
                WHERE ordernumber = 'P200721111609699' 
            
2024-07-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99941'
                WHERE ordernumber = 'P190721111729710' 
            
2024-07-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401701'
                WHERE ordernumber = 'P420721111754250' 
            
2024-07-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402335'
                WHERE ordernumber = 'P200721111857742' 
            
2024-07-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378316'
                WHERE ordernumber = 'P420721111939469' 
            
2024-07-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '165305'
                WHERE ordernumber = 'P200721112013995' 
            
2024-07-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301494'
                WHERE ordernumber = 'P180721112147609' 
            
2024-07-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298399'
                WHERE ordernumber = 'P200721113452875' 
            
2024-07-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '111810'
                WHERE ordernumber = 'P180721114350867' 
            
2024-07-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402337'
                WHERE ordernumber = 'P190721114512509' 
            
2024-07-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402339'
                WHERE ordernumber = 'P200721114910628' 
            
2024-07-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402340'
                WHERE ordernumber = 'P180721115550743' 
            
2024-07-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402341'
                WHERE ordernumber = 'P420721115554261' 
            
2024-07-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401060'
                WHERE ordernumber = 'P190721115947619' 
            
2024-07-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402345'
                WHERE ordernumber = 'P420721120042579' 
            
2024-07-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402346'
                WHERE ordernumber = 'P420721120352765' 
            
2024-07-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99251'
                WHERE ordernumber = 'P200721121005972' 
            
2024-07-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99037'
                WHERE ordernumber = 'P180721122031777' 
            
2024-07-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402348'
                WHERE ordernumber = 'P420721122113438' 
            
2024-07-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402349'
                WHERE ordernumber = 'P200721122722812' 
            
2024-07-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307686'
                WHERE ordernumber = 'P200721122929544' 
            
2024-07-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402351'
                WHERE ordernumber = 'P200721123442349' 
            
2024-07-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402352'
                WHERE ordernumber = 'P180721123459332' 
            
2024-07-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402353'
                WHERE ordernumber = 'P180721123542779' 
            
2024-07-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402354'
                WHERE ordernumber = 'P420721124058897' 
            
2024-07-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402355'
                WHERE ordernumber = 'P200721124153114' 
            
2024-07-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305598'
                WHERE ordernumber = 'P180721124156482' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402357'
                WHERE ordernumber = 'P420721124345995' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402358'
                WHERE ordernumber = 'P200721124432637' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342562'
                WHERE ordernumber = 'P420721124537437' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276998'
                WHERE ordernumber = 'P180721124648444' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97952'
                WHERE ordernumber = 'P200721124735322' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402359'
                WHERE ordernumber = 'P180721125322391' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402362'
                WHERE ordernumber = 'P180721130104725' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343684'
                WHERE ordernumber = 'P200721130129288' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402363'
                WHERE ordernumber = 'P200721130223830' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402364'
                WHERE ordernumber = 'P420721130423769' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '239602'
                WHERE ordernumber = 'P200721130912492' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '36333'
                WHERE ordernumber = 'P420721131221179' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402365'
                WHERE ordernumber = 'P200721131315181' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372487'
                WHERE ordernumber = 'P420721131601561' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339018'
                WHERE ordernumber = 'P200721131919396' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402367'
                WHERE ordernumber = 'P190721132100614' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378189'
                WHERE ordernumber = 'P190721132300813' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378189'
                WHERE ordernumber = 'P190721132406740' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97170'
                WHERE ordernumber = 'P190721132640991' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97959'
                WHERE ordernumber = 'P420721132738975' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '212710'
                WHERE ordernumber = 'P190721132841269' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402369'
                WHERE ordernumber = 'P420721133108829' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '128783'
                WHERE ordernumber = 'P190721133303835' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388306'
                WHERE ordernumber = 'P190721133952994' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402370'
                WHERE ordernumber = 'P190721134218545' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340831'
                WHERE ordernumber = 'P420721134250212' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402371'
                WHERE ordernumber = 'P190721134417945' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402368'
                WHERE ordernumber = 'P190721134546460' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402373'
                WHERE ordernumber = 'P190721134815822' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '161368'
                WHERE ordernumber = 'P200721135027415' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402374'
                WHERE ordernumber = 'P190721135047198' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396238'
                WHERE ordernumber = 'P190721135549884' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402375'
                WHERE ordernumber = 'P200721135714340' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402376'
                WHERE ordernumber = 'P200721140211692' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402377'
                WHERE ordernumber = 'P190721140501658' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402378'
                WHERE ordernumber = 'P190721140856183' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402379'
                WHERE ordernumber = 'P420721141315852' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238567'
                WHERE ordernumber = 'P180721141337854' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238567'
                WHERE ordernumber = 'P180721141422733' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402380'
                WHERE ordernumber = 'P190721142102776' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400720'
                WHERE ordernumber = 'P200721142433192' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306975'
                WHERE ordernumber = 'P180721142547921' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '34896'
                WHERE ordernumber = 'P420721142914483' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402384'
                WHERE ordernumber = 'P420721143221698' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402385'
                WHERE ordernumber = 'P180721143239665' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402386'
                WHERE ordernumber = 'P180721143349483' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102558'
                WHERE ordernumber = 'P180721143526646' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '258602'
                WHERE ordernumber = 'P420721143627946' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402386'
                WHERE ordernumber = 'P180721143713414' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402386'
                WHERE ordernumber = 'P180721143830642' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402387'
                WHERE ordernumber = 'P180721144026397' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402388'
                WHERE ordernumber = 'P190721144055718' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398888'
                WHERE ordernumber = 'P420721144407711' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402386'
                WHERE ordernumber = 'P180721144526508' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '244106'
                WHERE ordernumber = 'P200721144754561' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401636'
                WHERE ordernumber = 'P420721145046959' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402391'
                WHERE ordernumber = 'P180721145301402' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275910'
                WHERE ordernumber = 'P180721145902693' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402391'
                WHERE ordernumber = 'P180721145938331' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402392'
                WHERE ordernumber = 'P590721150006211' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402393'
                WHERE ordernumber = 'P180721150331497' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395885'
                WHERE ordernumber = 'P420721150344875' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387808'
                WHERE ordernumber = 'P420721150351367' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402394'
                WHERE ordernumber = 'P420721150449367' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '158943'
                WHERE ordernumber = 'P630721150703116' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402309'
                WHERE ordernumber = 'P190721151433731' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402309'
                WHERE ordernumber = 'P190721151506424' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402396'
                WHERE ordernumber = 'P200721151539542' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282521'
                WHERE ordernumber = 'P180721151739495' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '248346'
                WHERE ordernumber = 'P420721152402747' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '83318'
                WHERE ordernumber = 'P200721152632254' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402398'
                WHERE ordernumber = 'P420721152919165' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402398'
                WHERE ordernumber = 'P420721153056751' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402212'
                WHERE ordernumber = 'P200721153105194' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402399'
                WHERE ordernumber = 'P420721153232909' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402398'
                WHERE ordernumber = 'P420721153333731' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401280'
                WHERE ordernumber = 'P420721153525522' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '49370'
                WHERE ordernumber = 'P200721153648499' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402400'
                WHERE ordernumber = 'P190721153659833' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402403'
                WHERE ordernumber = 'P200721154958968' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '49658'
                WHERE ordernumber = 'P190721155239380' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99647'
                WHERE ordernumber = 'P180721160313274' 
            
2024-07-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402128'
                WHERE ordernumber = 'P180721160452827' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402128'
                WHERE ordernumber = 'P180721160521163' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '40142'
                WHERE ordernumber = 'P190721160602286' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '391738'
                WHERE ordernumber = 'P180721161126698' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402406'
                WHERE ordernumber = 'P200721161141442' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '208677'
                WHERE ordernumber = 'P180721161243122' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402407'
                WHERE ordernumber = 'P180721161402528' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402409'
                WHERE ordernumber = 'P200721161616841' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '296804'
                WHERE ordernumber = 'P200721161805593' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '63047'
                WHERE ordernumber = 'P190721162203752' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '321984'
                WHERE ordernumber = 'P190721162431546' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '37397'
                WHERE ordernumber = 'P180721162551326' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402410'
                WHERE ordernumber = 'P200721162710422' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '212075'
                WHERE ordernumber = 'P180721163243222' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '93598'
                WHERE ordernumber = 'P190721163332997' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402412'
                WHERE ordernumber = 'P200721163351316' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '93598'
                WHERE ordernumber = 'P190721163406292' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '321984'
                WHERE ordernumber = 'P180721163623542' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401613'
                WHERE ordernumber = 'P190721163640209' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402415'
                WHERE ordernumber = 'P190721163728377' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402413'
                WHERE ordernumber = 'P200721164016692' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402416'
                WHERE ordernumber = 'P200721164256160' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402417'
                WHERE ordernumber = 'P180721164308754' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402418'
                WHERE ordernumber = 'P190721164457132' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402419'
                WHERE ordernumber = 'P420721164602236' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '308245'
                WHERE ordernumber = 'P200721164616748' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '97419'
                WHERE ordernumber = 'P180721164638964' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '95460'
                WHERE ordernumber = 'P180721164711137' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '335335'
                WHERE ordernumber = 'P180721164850485' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402421'
                WHERE ordernumber = 'P180721165002352' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402420'
                WHERE ordernumber = 'P420721165024159' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402422'
                WHERE ordernumber = 'P180721165131418' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402423'
                WHERE ordernumber = 'P420721165148851' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '321398'
                WHERE ordernumber = 'P420721165347836' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '137483'
                WHERE ordernumber = 'P200721165536799' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402424'
                WHERE ordernumber = 'P420721165613688' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402425'
                WHERE ordernumber = 'P420721170231841' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '369737'
                WHERE ordernumber = 'P190721170323660' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '387581'
                WHERE ordernumber = 'P200721170528935' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '271320'
                WHERE ordernumber = 'P180721170721395' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '311238'
                WHERE ordernumber = 'P180721170926562' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399834'
                WHERE ordernumber = 'P180721170958634' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '341237'
                WHERE ordernumber = 'P180721171207190' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402426'
                WHERE ordernumber = 'P180721171800493' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '341237'
                WHERE ordernumber = 'P190721171813336' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402427'
                WHERE ordernumber = 'P200721172034499' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '346578'
                WHERE ordernumber = 'P180721172207566' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402428'
                WHERE ordernumber = 'P180721172532382' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '246111'
                WHERE ordernumber = 'P180721173058560' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '380857'
                WHERE ordernumber = 'P180721174223137' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '99427'
                WHERE ordernumber = 'P630721174318277' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402432'
                WHERE ordernumber = 'P420721174434165' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '160498'
                WHERE ordernumber = 'P180721174832513' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401353'
                WHERE ordernumber = 'P190721180208413' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401353'
                WHERE ordernumber = 'P190721180241501' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402402'
                WHERE ordernumber = 'P180721180355465' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402435'
                WHERE ordernumber = 'P420721180443244' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402402'
                WHERE ordernumber = 'P180721180534841' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402438'
                WHERE ordernumber = 'P180721180844914' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '274879'
                WHERE ordernumber = 'P200721181118892' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402439'
                WHERE ordernumber = 'P420721181241120' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402440'
                WHERE ordernumber = 'P180721181442699' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402441'
                WHERE ordernumber = 'P180721181824542' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '272711'
                WHERE ordernumber = 'P420721182109787' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '79155'
                WHERE ordernumber = 'P420721182159567' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '392778'
                WHERE ordernumber = 'P420721182530711' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402442'
                WHERE ordernumber = 'P200721182640965' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '392778'
                WHERE ordernumber = 'P420721182819889' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '128950'
                WHERE ordernumber = 'P190721182825644' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354369'
                WHERE ordernumber = 'P420721183001919' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402444'
                WHERE ordernumber = 'P420721183111169' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '241210'
                WHERE ordernumber = 'P420721183335734' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '310432'
                WHERE ordernumber = 'P420721183522902' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402446'
                WHERE ordernumber = 'P180721183625878' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402447'
                WHERE ordernumber = 'P420721183657139' 
            
2024-07-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402448'
                WHERE ordernumber = 'P180721184002741' 
            
2024-07-22 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402449'
                WHERE ordernumber = 'P200721184459546' 
            
2024-07-22 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '106000'
                WHERE ordernumber = 'P190721184729655' 
            
2024-07-22 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '316466'
                WHERE ordernumber = 'P180721184742316' 
            
2024-07-22 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '161128'
                WHERE ordernumber = 'P590721185249465' 
            
2024-07-22 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180721185704488' 
            
2024-07-22 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402451'
                WHERE ordernumber = 'P190721190556447' 
            
2024-07-22 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '95172'
                WHERE ordernumber = 'P190721190713568' 
            
2024-07-22 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402453'
                WHERE ordernumber = 'P200721190835706' 
            
2024-07-22 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '24'
                WHERE ordernumber = 'P200721191918938' 
            
2024-07-22 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '38288'
                WHERE ordernumber = 'P190721192057271' 
            
2024-07-22 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402454'
                WHERE ordernumber = 'P200721193041626' 
            
2024-07-22 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '157042'
                WHERE ordernumber = 'P200721193507224' 
            
2024-07-22 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '157042'
                WHERE ordernumber = 'P200721193709788' 
            
2024-07-22 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402456'
                WHERE ordernumber = 'P200721194148317' 
            
2024-07-22 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '345678'
                WHERE ordernumber = 'P190721194641349'