2024-10-15 01:00:02 -- 將會員中心id寫入data-lake
2024-10-15 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-10-14%';
        
2024-10-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P181014110046297' 
            
2024-10-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425851'
                WHERE ordernumber = 'P181014110249293' 
            
2024-10-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '274874'
                WHERE ordernumber = 'P181014110521983' 
            
2024-10-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '320225'
                WHERE ordernumber = 'P181014110623878' 
            
2024-10-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425852'
                WHERE ordernumber = 'P191014111325451' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349239'
                WHERE ordernumber = 'P181014111330230' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342649'
                WHERE ordernumber = 'P191014112344453' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '267365'
                WHERE ordernumber = 'P421014112458234' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '89746'
                WHERE ordernumber = 'P191014112558485' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99616'
                WHERE ordernumber = 'P191014113926518' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425853'
                WHERE ordernumber = 'P201014113937230' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425855'
                WHERE ordernumber = 'P181014114204730' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '233808'
                WHERE ordernumber = 'P711014114214264' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305319'
                WHERE ordernumber = 'P631014114306754' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425856'
                WHERE ordernumber = 'P191014114551665' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425858'
                WHERE ordernumber = 'P711014114603926' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425857'
                WHERE ordernumber = 'P181014114800453' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '329156'
                WHERE ordernumber = 'P421014115324541' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425860'
                WHERE ordernumber = 'P711014115454421' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425862'
                WHERE ordernumber = 'P421014120027299' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '153237'
                WHERE ordernumber = 'P201014121232544' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '274717'
                WHERE ordernumber = 'P181014121450587' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '68905'
                WHERE ordernumber = 'P181014121944141' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423919'
                WHERE ordernumber = 'P731014122533479' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '127600'
                WHERE ordernumber = 'P181014123131880' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425864'
                WHERE ordernumber = 'P181014123448913' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425864'
                WHERE ordernumber = 'P181014123615445' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344831'
                WHERE ordernumber = 'P181014123800609' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425865'
                WHERE ordernumber = 'P181014124022832' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346884'
                WHERE ordernumber = 'P181014124202282' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424271'
                WHERE ordernumber = 'P421014124253549' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425867'
                WHERE ordernumber = 'P201014124604586' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '329693'
                WHERE ordernumber = 'P181014124827300' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '267678'
                WHERE ordernumber = 'P201014124851184' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '215911'
                WHERE ordernumber = 'P181014125031922' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '95695'
                WHERE ordernumber = 'P201014130201384' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400150'
                WHERE ordernumber = 'P181014130323793' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '95695'
                WHERE ordernumber = 'P201014130408304' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351456'
                WHERE ordernumber = 'P711014131605547' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '114186'
                WHERE ordernumber = 'P201014131648570' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '80892'
                WHERE ordernumber = 'P191014131725327' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425871'
                WHERE ordernumber = 'P711014131752208' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '114186'
                WHERE ordernumber = 'P201014131804321' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303767'
                WHERE ordernumber = 'P421014131805806' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425872'
                WHERE ordernumber = 'P631014131821743' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425870'
                WHERE ordernumber = 'P191014131840922' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287979'
                WHERE ordernumber = 'P201014132027207' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '363084'
                WHERE ordernumber = 'P421014132548798' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425874'
                WHERE ordernumber = 'P191014132608472' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425876'
                WHERE ordernumber = 'P201014132722783' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425875'
                WHERE ordernumber = 'P731014132753551' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403335'
                WHERE ordernumber = 'P421014132824770' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368224'
                WHERE ordernumber = 'P421014132945677' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '222004'
                WHERE ordernumber = 'P201014133121884' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238273'
                WHERE ordernumber = 'P201014133342609' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '218516'
                WHERE ordernumber = 'P181014133554683' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425877'
                WHERE ordernumber = 'P711014133745475' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425878'
                WHERE ordernumber = 'P201014134105321' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424647'
                WHERE ordernumber = 'P421014134202214' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425873'
                WHERE ordernumber = 'P421014134652774' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425879'
                WHERE ordernumber = 'P181014135143873' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337747'
                WHERE ordernumber = 'P421014135458894' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425882'
                WHERE ordernumber = 'P201014135500257' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425880'
                WHERE ordernumber = 'P731014135614125' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425881'
                WHERE ordernumber = 'P421014135719269' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421603'
                WHERE ordernumber = 'P201014140734633' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425884'
                WHERE ordernumber = 'P421014140738257' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425885'
                WHERE ordernumber = 'P181014140841556' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425886'
                WHERE ordernumber = 'P181014141022656' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388984'
                WHERE ordernumber = 'P181014141355939' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425885'
                WHERE ordernumber = 'P181014141502130' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425886'
                WHERE ordernumber = 'P181014141706345' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '56458'
                WHERE ordernumber = 'P201014141709764' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425888'
                WHERE ordernumber = 'P421014141934474' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '163961'
                WHERE ordernumber = 'P201014142502707' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425889'
                WHERE ordernumber = 'P731014142613658' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341320'
                WHERE ordernumber = 'P201014143726529' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '232251'
                WHERE ordernumber = 'P181014144606193' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425246'
                WHERE ordernumber = 'P181014144931797' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424809'
                WHERE ordernumber = 'P201014144953274' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425890'
                WHERE ordernumber = 'P181014150205264' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425891'
                WHERE ordernumber = 'P181014150456851' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230221'
                WHERE ordernumber = 'P181014150755640' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425893'
                WHERE ordernumber = 'P201014150947878' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425892'
                WHERE ordernumber = 'P181014151022778' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277682'
                WHERE ordernumber = 'P201014151246766' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357114'
                WHERE ordernumber = 'P181014151256697' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306273'
                WHERE ordernumber = 'P181014151628959' 
            
2024-10-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425896'
                WHERE ordernumber = 'P201014151931431' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425895'
                WHERE ordernumber = 'P421014152003794' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424442'
                WHERE ordernumber = 'P181014152532211' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '133472'
                WHERE ordernumber = 'P731014152904516' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '311575'
                WHERE ordernumber = 'P421014153012603' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '256123'
                WHERE ordernumber = 'P181014153528318' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425897'
                WHERE ordernumber = 'P201014153655489' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '208654'
                WHERE ordernumber = 'P181014153708798' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425898'
                WHERE ordernumber = 'P421014153945334' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '274916'
                WHERE ordernumber = 'P201014154749934' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425902'
                WHERE ordernumber = 'P181014154923525' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425900'
                WHERE ordernumber = 'P421014155008561' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '108112'
                WHERE ordernumber = 'P181014155038993' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302614'
                WHERE ordernumber = 'P201014155803438' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '217501'
                WHERE ordernumber = 'P181014160506568' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102379'
                WHERE ordernumber = 'P181014161227772' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425903'
                WHERE ordernumber = 'P201014161531733' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '220732'
                WHERE ordernumber = 'P181014161917870' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '375350'
                WHERE ordernumber = 'P711014162321767' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '244702'
                WHERE ordernumber = 'P201014162518985' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423714'
                WHERE ordernumber = 'P421014162643719' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94009'
                WHERE ordernumber = 'P201014163012409' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425905'
                WHERE ordernumber = 'P421014163235832' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '316185'
                WHERE ordernumber = 'P421014163355369' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390082'
                WHERE ordernumber = 'P421014163447128' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '316185'
                WHERE ordernumber = 'P421014163724389' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401444'
                WHERE ordernumber = 'P181014165155973' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389962'
                WHERE ordernumber = 'P421014165715799' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425909'
                WHERE ordernumber = 'P181014165724389' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424788'
                WHERE ordernumber = 'P201014170252149' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '364203'
                WHERE ordernumber = 'P181014170820436' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425910'
                WHERE ordernumber = 'P181014170944592' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '315804'
                WHERE ordernumber = 'P201014171131771' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425911'
                WHERE ordernumber = 'P181014171933355' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425914'
                WHERE ordernumber = 'P181014172240687' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425913'
                WHERE ordernumber = 'P731014172310231' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425912'
                WHERE ordernumber = 'P421014172358976' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425915'
                WHERE ordernumber = 'P201014172550489' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '248567'
                WHERE ordernumber = 'P181014172630351' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100700'
                WHERE ordernumber = 'P181014173019328' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '128995'
                WHERE ordernumber = 'P191014173206485' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96007'
                WHERE ordernumber = 'P181014173555861' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425916'
                WHERE ordernumber = 'P711014173735851' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96007'
                WHERE ordernumber = 'P181014173737785' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425917'
                WHERE ordernumber = 'P731014174417640' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390707'
                WHERE ordernumber = 'P711014174422458' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415244'
                WHERE ordernumber = 'P421014174814487' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415244'
                WHERE ordernumber = 'P421014174853415' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425919'
                WHERE ordernumber = 'P181014175029278' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415244'
                WHERE ordernumber = 'P421014175041148' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425921'
                WHERE ordernumber = 'P421014175635340' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425922'
                WHERE ordernumber = 'P181014180043258' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403467'
                WHERE ordernumber = 'P421014180051833' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425923'
                WHERE ordernumber = 'P201014181154692' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425924'
                WHERE ordernumber = 'P181014182316258' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288361'
                WHERE ordernumber = 'P181014182455142' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425925'
                WHERE ordernumber = 'P201014183248480' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399409'
                WHERE ordernumber = 'P181014184337775' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425926'
                WHERE ordernumber = 'P201014184343966' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423655'
                WHERE ordernumber = 'P421014184450836' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423655'
                WHERE ordernumber = 'P421014184616317' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423655'
                WHERE ordernumber = 'P421014184757443' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425928'
                WHERE ordernumber = 'P201014185015762' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423655'
                WHERE ordernumber = 'P421014185140783' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '326783'
                WHERE ordernumber = 'P201014185338456' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411391'
                WHERE ordernumber = 'P181014185340166' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302195'
                WHERE ordernumber = 'P201014185442573' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425927'
                WHERE ordernumber = 'P731014185758838' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425930'
                WHERE ordernumber = 'P191014190554845' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423204'
                WHERE ordernumber = 'P201014191341651' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425933'
                WHERE ordernumber = 'P191014193809923' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425934'
                WHERE ordernumber = 'P201014194716928' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425935'
                WHERE ordernumber = 'P201014195136841' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '88568'
                WHERE ordernumber = 'P201014195732760' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276080'
                WHERE ordernumber = 'P201014195906357' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425936'
                WHERE ordernumber = 'P711014200022766' 
            
2024-10-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276080'
                WHERE ordernumber = 'P201014200107553'