2024-06-03 01:00:01 -- 將會員中心id寫入data-lake
2024-06-03 01:00:01 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-06-02%';
        
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '347104'
                WHERE ordernumber = 'P180602110552766' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393661'
                WHERE ordernumber = 'P180602110845223' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '245532'
                WHERE ordernumber = 'P190602111727457' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393663'
                WHERE ordernumber = 'P200602112304966' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393665'
                WHERE ordernumber = 'P710602112632713' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393664'
                WHERE ordernumber = 'P420602113040394' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '120506'
                WHERE ordernumber = 'P190602114128895' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393668'
                WHERE ordernumber = 'P180602114144212' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393669'
                WHERE ordernumber = 'P200602114219376' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393670'
                WHERE ordernumber = 'P200602114319863' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '306632'
                WHERE ordernumber = 'P180602114700675' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '165635'
                WHERE ordernumber = 'P190602114807315' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393671'
                WHERE ordernumber = 'P420602114926203' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '319593'
                WHERE ordernumber = 'P200602115032292' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '322571'
                WHERE ordernumber = 'P200602115455968' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393674'
                WHERE ordernumber = 'P200602115548484' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393676'
                WHERE ordernumber = 'P420602115933752' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393677'
                WHERE ordernumber = 'P180602120028787' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '322571'
                WHERE ordernumber = 'P200602120218459' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393653'
                WHERE ordernumber = 'P190602120332351' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '281421'
                WHERE ordernumber = 'P200602120354235' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393678'
                WHERE ordernumber = 'P180602120438532' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393068'
                WHERE ordernumber = 'P200602120655724' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393679'
                WHERE ordernumber = 'P420602120905761' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393680'
                WHERE ordernumber = 'P180602121500205' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393682'
                WHERE ordernumber = 'P190602121546746' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393681'
                WHERE ordernumber = 'P710602121611962' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393683'
                WHERE ordernumber = 'P180602121833764' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '102280'
                WHERE ordernumber = 'P180602122315521' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '224223'
                WHERE ordernumber = 'P180602122447770' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393685'
                WHERE ordernumber = 'P710602122904964' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392385'
                WHERE ordernumber = 'P180602123335449' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378554'
                WHERE ordernumber = 'P710602123415578' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393687'
                WHERE ordernumber = 'P200602123623767' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393688'
                WHERE ordernumber = 'P180602123744822' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355927'
                WHERE ordernumber = 'P200602123959775' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371940'
                WHERE ordernumber = 'P420602124326840' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393689'
                WHERE ordernumber = 'P180602124421360' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393690'
                WHERE ordernumber = 'P200602125549409' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393691'
                WHERE ordernumber = 'P420602125619784' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99157'
                WHERE ordernumber = 'P180602130033361' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393692'
                WHERE ordernumber = 'P200602130420600' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393693'
                WHERE ordernumber = 'P180602130426299' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393694'
                WHERE ordernumber = 'P200602130858280' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393695'
                WHERE ordernumber = 'P420602130940994' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '82798'
                WHERE ordernumber = 'P630602130941476' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393696'
                WHERE ordernumber = 'P420602131254357' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '108432'
                WHERE ordernumber = 'P200602131831204' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '110867'
                WHERE ordernumber = 'P180602131840883' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393698'
                WHERE ordernumber = 'P180602132134836' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393699'
                WHERE ordernumber = 'P200602132153620' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '246112'
                WHERE ordernumber = 'P180602132631193' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '290101'
                WHERE ordernumber = 'P200602132703260' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393700'
                WHERE ordernumber = 'P180602132936647' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '216942'
                WHERE ordernumber = 'P190602133333883' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '173241'
                WHERE ordernumber = 'P630602133339322' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393701'
                WHERE ordernumber = 'P180602133346766' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388221'
                WHERE ordernumber = 'P420602133539743' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387364'
                WHERE ordernumber = 'P180602133850275' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393206'
                WHERE ordernumber = 'P180602134154669' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393206'
                WHERE ordernumber = 'P180602134234764' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '312262'
                WHERE ordernumber = 'P180602134351800' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393704'
                WHERE ordernumber = 'P200602135019948' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '87294'
                WHERE ordernumber = 'P200602135153510' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393705'
                WHERE ordernumber = 'P180602135258355' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393707'
                WHERE ordernumber = 'P180602135717116' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390118'
                WHERE ordernumber = 'P190602135718401' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '122751'
                WHERE ordernumber = 'P180602135936449' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393709'
                WHERE ordernumber = 'P420602135937953' 
            
2024-06-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393710'
                WHERE ordernumber = 'P200602140128959' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162987'
                WHERE ordernumber = 'P180602140133648' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384519'
                WHERE ordernumber = 'P180602140351591' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393711'
                WHERE ordernumber = 'P180602140504975' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393712'
                WHERE ordernumber = 'P420602140701295' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393714'
                WHERE ordernumber = 'P180602140837585' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '95188'
                WHERE ordernumber = 'P420602140943713' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310156'
                WHERE ordernumber = 'P190602141111224' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393715'
                WHERE ordernumber = 'P180602141126452' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '361213'
                WHERE ordernumber = 'P180602142105433' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '231264'
                WHERE ordernumber = 'P180602142332881' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393719'
                WHERE ordernumber = 'P180602142632791' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '373251'
                WHERE ordernumber = 'P420602142851925' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393721'
                WHERE ordernumber = 'P180602143025821' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238161'
                WHERE ordernumber = 'P180602143328516' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393722'
                WHERE ordernumber = 'P180602143646608' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393723'
                WHERE ordernumber = 'P200602143743886' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393723'
                WHERE ordernumber = 'P200602143900467' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '329424'
                WHERE ordernumber = 'P200602144001820' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393703'
                WHERE ordernumber = 'P420602144047966' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '376813'
                WHERE ordernumber = 'P200602144243350' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393717'
                WHERE ordernumber = 'P420602144522889' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '280906'
                WHERE ordernumber = 'P200602144530970' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '280906'
                WHERE ordernumber = 'P200602144735341' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393724'
                WHERE ordernumber = 'P420602144758672' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393725'
                WHERE ordernumber = 'P420602144942999' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393726'
                WHERE ordernumber = 'P200602145331967' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393729'
                WHERE ordernumber = 'P420602145721185' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393622'
                WHERE ordernumber = 'P200602145925194' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393731'
                WHERE ordernumber = 'P420602150434653' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '255341'
                WHERE ordernumber = 'P180602150632409' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393733'
                WHERE ordernumber = 'P420602150923830' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389532'
                WHERE ordernumber = 'P180602150929642' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '320710'
                WHERE ordernumber = 'P180602151115469' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383892'
                WHERE ordernumber = 'P180602151433659' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393279'
                WHERE ordernumber = 'P200602151510358' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286849'
                WHERE ordernumber = 'P180602151752983' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '269565'
                WHERE ordernumber = 'P200602151809782' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393734'
                WHERE ordernumber = 'P710602151827982' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393735'
                WHERE ordernumber = 'P180602152317125' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389135'
                WHERE ordernumber = 'P420602152354697' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240734'
                WHERE ordernumber = 'P180602152429388' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392413'
                WHERE ordernumber = 'P190602152438440' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393736'
                WHERE ordernumber = 'P190602152629433' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '222619'
                WHERE ordernumber = 'P200602152845179' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248674'
                WHERE ordernumber = 'P180602152859279' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393706'
                WHERE ordernumber = 'P200602153224833' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393709'
                WHERE ordernumber = 'P420602153318957' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393738'
                WHERE ordernumber = 'P200602153319227' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393739'
                WHERE ordernumber = 'P180602153401418' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283319'
                WHERE ordernumber = 'P180602153518929' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393741'
                WHERE ordernumber = 'P200602153550375' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393737'
                WHERE ordernumber = 'P710602153640774' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '317028'
                WHERE ordernumber = 'P180602154011915' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '31894'
                WHERE ordernumber = 'P200602154047725' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393742'
                WHERE ordernumber = 'P420602154410970' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '128417'
                WHERE ordernumber = 'P200602154836685' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391160'
                WHERE ordernumber = 'P420602154935750' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392743'
                WHERE ordernumber = 'P180602155217402' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392461'
                WHERE ordernumber = 'P190602155241591' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393745'
                WHERE ordernumber = 'P190602155503132' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P180602155539740' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305270'
                WHERE ordernumber = 'P180602155940728' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300317'
                WHERE ordernumber = 'P200602160312210' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '295071'
                WHERE ordernumber = 'P180602160451646' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391640'
                WHERE ordernumber = 'P200602160726684' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343914'
                WHERE ordernumber = 'P200602160843217' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393748'
                WHERE ordernumber = 'P200602161002701' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393749'
                WHERE ordernumber = 'P200602161042572' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393750'
                WHERE ordernumber = 'P200602161151257' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393751'
                WHERE ordernumber = 'P200602161248216' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386359'
                WHERE ordernumber = 'P420602161450633' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343872'
                WHERE ordernumber = 'P180602161610129' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393753'
                WHERE ordernumber = 'P200602161738257' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393754'
                WHERE ordernumber = 'P180602161814699' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393754'
                WHERE ordernumber = 'P180602161940394' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393752'
                WHERE ordernumber = 'P780602162011952' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393755'
                WHERE ordernumber = 'P190602162012615' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393754'
                WHERE ordernumber = 'P180602162326222' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103342'
                WHERE ordernumber = 'P200602162428393' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393758'
                WHERE ordernumber = 'P200602162557232' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337912'
                WHERE ordernumber = 'P180602162901829' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337912'
                WHERE ordernumber = 'P180602162954524' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '131195'
                WHERE ordernumber = 'P190602163213253' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393760'
                WHERE ordernumber = 'P190602163633863' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '263906'
                WHERE ordernumber = 'P180602163823624' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93220'
                WHERE ordernumber = 'P190602164006511' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393761'
                WHERE ordernumber = 'P420602164257517' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385427'
                WHERE ordernumber = 'P200602164624795' 
            
2024-06-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393762'
                WHERE ordernumber = 'P710602164659422' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393764'
                WHERE ordernumber = 'P200602164756234' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393763'
                WHERE ordernumber = 'P420602164802997' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393765'
                WHERE ordernumber = 'P420602165042145' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351732'
                WHERE ordernumber = 'P180602165059952' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393766'
                WHERE ordernumber = 'P200602165142311' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393763'
                WHERE ordernumber = 'P420602165143384' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392859'
                WHERE ordernumber = 'P190602165237782' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393767'
                WHERE ordernumber = 'P180602165321119' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393768'
                WHERE ordernumber = 'P200602165455386' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393769'
                WHERE ordernumber = 'P710602170016803' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393092'
                WHERE ordernumber = 'P420602170032364' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102736'
                WHERE ordernumber = 'P180602170046839' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393770'
                WHERE ordernumber = 'P200602170123803' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393772'
                WHERE ordernumber = 'P200602170753869' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393773'
                WHERE ordernumber = 'P180602170820384' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393774'
                WHERE ordernumber = 'P200602171443143' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '128720'
                WHERE ordernumber = 'P180602171609370' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393778'
                WHERE ordernumber = 'P180602171933166' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393779'
                WHERE ordernumber = 'P180602172110685' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393780'
                WHERE ordernumber = 'P180602172231124' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390926'
                WHERE ordernumber = 'P780602172311982' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '244236'
                WHERE ordernumber = 'P780602172508717' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393776'
                WHERE ordernumber = 'P630602172510920' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356807'
                WHERE ordernumber = 'P180602172834471' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '67950'
                WHERE ordernumber = 'P420602172905192' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '128451'
                WHERE ordernumber = 'P180602173117615' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393782'
                WHERE ordernumber = 'P710602173218927' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393783'
                WHERE ordernumber = 'P200602173613386' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '129837'
                WHERE ordernumber = 'P420602173807809' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '129083'
                WHERE ordernumber = 'P180602173829460' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393784'
                WHERE ordernumber = 'P190602174827946' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393785'
                WHERE ordernumber = 'P180602174943704' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389619'
                WHERE ordernumber = 'P200602175132898' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344013'
                WHERE ordernumber = 'P420602175223153' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393786'
                WHERE ordernumber = 'P200602175531125' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393787'
                WHERE ordernumber = 'P180602175631443' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '58970'
                WHERE ordernumber = 'P200602175723671' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391122'
                WHERE ordernumber = 'P180602180105869' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393788'
                WHERE ordernumber = 'P420602180216454' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276672'
                WHERE ordernumber = 'P200602180910225' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '318593'
                WHERE ordernumber = 'P420602181205692' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392454'
                WHERE ordernumber = 'P180602181409584' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '216607'
                WHERE ordernumber = 'P420602181447240' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393790'
                WHERE ordernumber = 'P180602181653562' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '298546'
                WHERE ordernumber = 'P190602181844485' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393792'
                WHERE ordernumber = 'P200602182008878' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '279103'
                WHERE ordernumber = 'P200602182109622' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393793'
                WHERE ordernumber = 'P200602182353598' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393795'
                WHERE ordernumber = 'P420602183440596' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393796'
                WHERE ordernumber = 'P200602183528128' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393797'
                WHERE ordernumber = 'P420602183747414' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '101457'
                WHERE ordernumber = 'P200602183806410' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393799'
                WHERE ordernumber = 'P710602185244169' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393800'
                WHERE ordernumber = 'P190602185422168' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393802'
                WHERE ordernumber = 'P190602185556122' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393804'
                WHERE ordernumber = 'P200602191206334' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393805'
                WHERE ordernumber = 'P710602192005507' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387796'
                WHERE ordernumber = 'P200602192342531' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393806'
                WHERE ordernumber = 'P710602192422415' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '239199'
                WHERE ordernumber = 'P190602192448543' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393808'
                WHERE ordernumber = 'P190602194040815' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393810'
                WHERE ordernumber = 'P190602194246404' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393813'
                WHERE ordernumber = 'P190602194852133' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278056'
                WHERE ordernumber = 'P190602195757443' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393818'
                WHERE ordernumber = 'P710602201345837' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '312687'
                WHERE ordernumber = 'P780602201637652' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393822'
                WHERE ordernumber = 'P710602203214581' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393823'
                WHERE ordernumber = 'P710602204531912' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393825'
                WHERE ordernumber = 'P630602205525468' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381631'
                WHERE ordernumber = 'P710602213720815' 
            
2024-06-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393831'
                WHERE ordernumber = 'P710602213938575'