2023-12-03 01:00:02 -- 將會員中心id寫入data-lake
2023-12-03 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 '2023-12-02%';
        
2023-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '12858'
                WHERE ordernumber = 'P421202100539970' 
            
2023-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '324722'
                WHERE ordernumber = 'P421202103936314' 
            
2023-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '97950'
                WHERE ordernumber = 'P201202110129265' 
            
2023-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350269'
                WHERE ordernumber = 'P191202110207742' 
            
2023-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283578'
                WHERE ordernumber = 'P191202110304721' 
            
2023-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350270'
                WHERE ordernumber = 'P181202110401667' 
            
2023-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '118251'
                WHERE ordernumber = 'P201202110409868' 
            
2023-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350272'
                WHERE ordernumber = 'P421202110547829' 
            
2023-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '314574'
                WHERE ordernumber = 'P181202110616826' 
            
2023-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '339940'
                WHERE ordernumber = 'P201202110810704' 
            
2023-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350273'
                WHERE ordernumber = 'P201202110931125' 
            
2023-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350274'
                WHERE ordernumber = 'P181202111107691' 
            
2023-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '199537'
                WHERE ordernumber = 'P181202111250885' 
            
2023-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350275'
                WHERE ordernumber = 'P181202111411563' 
            
2023-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '347708'
                WHERE ordernumber = 'P201202111447633' 
            
2023-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350276'
                WHERE ordernumber = 'P181202111543785' 
            
2023-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '284931'
                WHERE ordernumber = 'P201202111600852' 
            
2023-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350277'
                WHERE ordernumber = 'P201202111735797' 
            
2023-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350278'
                WHERE ordernumber = 'P201202112004845' 
            
2023-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '94507'
                WHERE ordernumber = 'P181202112111299' 
            
2023-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '291308'
                WHERE ordernumber = 'P181202112241698' 
            
2023-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350279'
                WHERE ordernumber = 'P181202112517272' 
            
2023-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '129091'
                WHERE ordernumber = 'P181202112637447' 
            
2023-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '288989'
                WHERE ordernumber = 'P201202112804163' 
            
2023-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '339659'
                WHERE ordernumber = 'P201202113103695' 
            
2023-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '328377'
                WHERE ordernumber = 'P191202113631278' 
            
2023-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '102851'
                WHERE ordernumber = 'P201202113706354' 
            
2023-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '346636'
                WHERE ordernumber = 'P181202113804689' 
            
2023-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350281'
                WHERE ordernumber = 'P181202114404735' 
            
2023-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350282'
                WHERE ordernumber = 'P201202114422553' 
            
2023-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350283'
                WHERE ordernumber = 'P181202114509547' 
            
2023-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350284'
                WHERE ordernumber = 'P201202114517627' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350285'
                WHERE ordernumber = 'P181202114624774' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350286'
                WHERE ordernumber = 'P201202114736964' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '95043'
                WHERE ordernumber = 'P201202115040127' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350287'
                WHERE ordernumber = 'P201202115207528' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238519'
                WHERE ordernumber = 'P181202115208932' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348876'
                WHERE ordernumber = 'P181202115417266' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350288'
                WHERE ordernumber = 'P421202115624297' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '252703'
                WHERE ordernumber = 'P181202115917466' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350292'
                WHERE ordernumber = 'P181202120154559' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350293'
                WHERE ordernumber = 'P181202120426954' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350294'
                WHERE ordernumber = 'P181202120548459' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '75542'
                WHERE ordernumber = 'P181202120748903' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100130'
                WHERE ordernumber = 'P181202121039187' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350296'
                WHERE ordernumber = 'P181202121243457' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349233'
                WHERE ordernumber = 'P201202121303192' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350298'
                WHERE ordernumber = 'P181202122124621' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '312566'
                WHERE ordernumber = 'P181202122617675' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350299'
                WHERE ordernumber = 'P181202122834847' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350300'
                WHERE ordernumber = 'P181202123433780' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240414'
                WHERE ordernumber = 'P181202123556944' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240414'
                WHERE ordernumber = 'P181202123729963' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '224674'
                WHERE ordernumber = 'P201202123806841' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350301'
                WHERE ordernumber = 'P181202124014403' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248159'
                WHERE ordernumber = 'P181202124140601' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350303'
                WHERE ordernumber = 'P201202124238245' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350304'
                WHERE ordernumber = 'P201202124842292' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300204'
                WHERE ordernumber = 'P201202124913791' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350306'
                WHERE ordernumber = 'P191202125001791' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339237'
                WHERE ordernumber = 'P201202125048664' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '312247'
                WHERE ordernumber = 'P181202125103314' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350307'
                WHERE ordernumber = 'P421202125230348' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350308'
                WHERE ordernumber = 'P201202130045190' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350309'
                WHERE ordernumber = 'P181202130320559' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350310'
                WHERE ordernumber = 'P201202130523634' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350311'
                WHERE ordernumber = 'P181202130535579' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291034'
                WHERE ordernumber = 'P421202130604823' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350313'
                WHERE ordernumber = 'P181202130751988' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '326272'
                WHERE ordernumber = 'P181202130848618' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350314'
                WHERE ordernumber = 'P421202130946820' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350315'
                WHERE ordernumber = 'P421202131234401' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350316'
                WHERE ordernumber = 'P181202131433519' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350317'
                WHERE ordernumber = 'P421202131515590' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '87729'
                WHERE ordernumber = 'P181202131554633' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '288972'
                WHERE ordernumber = 'P201202132330666' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350319'
                WHERE ordernumber = 'P191202132506550' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350321'
                WHERE ordernumber = 'P201202132652951' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350320'
                WHERE ordernumber = 'P421202132656641' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '234203'
                WHERE ordernumber = 'P201202132802589' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350321'
                WHERE ordernumber = 'P201202132834639' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349830'
                WHERE ordernumber = 'P201202133642773' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239796'
                WHERE ordernumber = 'P201202133922965' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278210'
                WHERE ordernumber = 'P201202134116355' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350324'
                WHERE ordernumber = 'P201202134623601' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349238'
                WHERE ordernumber = 'P201202134705868' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350325'
                WHERE ordernumber = 'P191202134904594' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '234552'
                WHERE ordernumber = 'P201202135016664' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '234552'
                WHERE ordernumber = 'P201202135058662' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283421'
                WHERE ordernumber = 'P191202135134346' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349268'
                WHERE ordernumber = 'P201202135203294' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350327'
                WHERE ordernumber = 'P191202140002529' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344909'
                WHERE ordernumber = 'P421202140031696' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350328'
                WHERE ordernumber = 'P201202140109604' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '255328'
                WHERE ordernumber = 'P191202140510763' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350329'
                WHERE ordernumber = 'P191202140550851' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350330'
                WHERE ordernumber = 'P191202140727953' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350331'
                WHERE ordernumber = 'P201202140920825' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350332'
                WHERE ordernumber = 'P191202140942388' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287880'
                WHERE ordernumber = 'P191202141316585' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298011'
                WHERE ordernumber = 'P191202141509778' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '65076'
                WHERE ordernumber = 'P201202141713163' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350335'
                WHERE ordernumber = 'P201202141945352' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350336'
                WHERE ordernumber = 'P421202142023141' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350337'
                WHERE ordernumber = 'P201202142300258' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350338'
                WHERE ordernumber = 'P191202142405716' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '121120'
                WHERE ordernumber = 'P201202142540407' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350339'
                WHERE ordernumber = 'P191202142556875' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '255137'
                WHERE ordernumber = 'P201202142631643' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339488'
                WHERE ordernumber = 'P421202142706345' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350340'
                WHERE ordernumber = 'P191202142708795' 
            
2023-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '268266'
                WHERE ordernumber = 'P201202142738327' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350341'
                WHERE ordernumber = 'P421202142846575' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350342'
                WHERE ordernumber = 'P421202143000334' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306986'
                WHERE ordernumber = 'P201202143116541' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350343'
                WHERE ordernumber = 'P191202143121206' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350346'
                WHERE ordernumber = 'P421202143843183' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350347'
                WHERE ordernumber = 'P191202143855235' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350348'
                WHERE ordernumber = 'P181202144015693' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350349'
                WHERE ordernumber = 'P421202144104694' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350350'
                WHERE ordernumber = 'P421202144141610' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '251919'
                WHERE ordernumber = 'P201202144214893' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350351'
                WHERE ordernumber = 'P201202144301961' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277586'
                WHERE ordernumber = 'P201202144352122' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350352'
                WHERE ordernumber = 'P421202144400486' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350353'
                WHERE ordernumber = 'P181202144522497' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350354'
                WHERE ordernumber = 'P181202144940160' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350355'
                WHERE ordernumber = 'P421202145134227' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350356'
                WHERE ordernumber = 'P201202145838417' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '101882'
                WHERE ordernumber = 'P201202150116812' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350357'
                WHERE ordernumber = 'P181202150144722' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '290091'
                WHERE ordernumber = 'P201202150749770' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282484'
                WHERE ordernumber = 'P191202151330167' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350363'
                WHERE ordernumber = 'P191202151444907' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350364'
                WHERE ordernumber = 'P191202151609844' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350365'
                WHERE ordernumber = 'P201202151735116' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348409'
                WHERE ordernumber = 'P191202152000294' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288303'
                WHERE ordernumber = 'P201202152529146' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '72803'
                WHERE ordernumber = 'P421202152546815' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350369'
                WHERE ordernumber = 'P421202152653474' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302951'
                WHERE ordernumber = 'P191202152723543' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350370'
                WHERE ordernumber = 'P181202152813953' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350371'
                WHERE ordernumber = 'P191202152932198' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '133101'
                WHERE ordernumber = 'P181202153337176' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '244187'
                WHERE ordernumber = 'P201202153514408' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350372'
                WHERE ordernumber = 'P191202153516587' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347630'
                WHERE ordernumber = 'P421202154104620' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344412'
                WHERE ordernumber = 'P201202154429264' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350374'
                WHERE ordernumber = 'P421202155013766' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '321391'
                WHERE ordernumber = 'P181202155121245' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '285098'
                WHERE ordernumber = 'P191202155355129' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347838'
                WHERE ordernumber = 'P191202155506193' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350375'
                WHERE ordernumber = 'P181202155517254' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '270849'
                WHERE ordernumber = 'P421202155759920' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350376'
                WHERE ordernumber = 'P181202155856610' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350378'
                WHERE ordernumber = 'P191202155900532' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350377'
                WHERE ordernumber = 'P201202155953439' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350379'
                WHERE ordernumber = 'P191202155953298' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350380'
                WHERE ordernumber = 'P181202160010634' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350381'
                WHERE ordernumber = 'P181202160204114' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350382'
                WHERE ordernumber = 'P191202160253925' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350380'
                WHERE ordernumber = 'P181202160353165' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350383'
                WHERE ordernumber = 'P421202160352125' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350384'
                WHERE ordernumber = 'P181202160458152' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306287'
                WHERE ordernumber = 'P201202160504875' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350385'
                WHERE ordernumber = 'P201202160630753' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '321909'
                WHERE ordernumber = 'P421202160841987' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350157'
                WHERE ordernumber = 'P191202160858411' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350386'
                WHERE ordernumber = 'P181202160928353' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350157'
                WHERE ordernumber = 'P191202160930722' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '243888'
                WHERE ordernumber = 'P201202160956821' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350386'
                WHERE ordernumber = 'P191202161145732' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348227'
                WHERE ordernumber = 'P191202161719242' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '250156'
                WHERE ordernumber = 'P201202161720839' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306516'
                WHERE ordernumber = 'P191202161847726' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350387'
                WHERE ordernumber = 'P181202162046265' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350202'
                WHERE ordernumber = 'P421202162240989' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350388'
                WHERE ordernumber = 'P181202162410890' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350390'
                WHERE ordernumber = 'P181202162714440' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350391'
                WHERE ordernumber = 'P201202162714559' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350388'
                WHERE ordernumber = 'P181202162747507' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '222289'
                WHERE ordernumber = 'P201202162832529' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350392'
                WHERE ordernumber = 'P181202163001520' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '216524'
                WHERE ordernumber = 'P201202163123424' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '317237'
                WHERE ordernumber = 'P181202163400979' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350395'
                WHERE ordernumber = 'P181202164041480' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350396'
                WHERE ordernumber = 'P201202164310468' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '316411'
                WHERE ordernumber = 'P201202164441315' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350397'
                WHERE ordernumber = 'P181202164531526' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '247992'
                WHERE ordernumber = 'P201202164808652' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350398'
                WHERE ordernumber = 'P181202165119761' 
            
2023-12-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '117676'
                WHERE ordernumber = 'P201202165310878' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350399'
                WHERE ordernumber = 'P181202165710660' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '348868'
                WHERE ordernumber = 'P181202170034305' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350400'
                WHERE ordernumber = 'P421202170424651' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '282642'
                WHERE ordernumber = 'P191202170435749' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350401'
                WHERE ordernumber = 'P421202170605528' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '258546'
                WHERE ordernumber = 'P201202170653569' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350402'
                WHERE ordernumber = 'P421202170745189' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350403'
                WHERE ordernumber = 'P181202170816834' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350404'
                WHERE ordernumber = 'P421202170911764' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350403'
                WHERE ordernumber = 'P181202170922330' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '342097'
                WHERE ordernumber = 'P181202171023844' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349770'
                WHERE ordernumber = 'P421202171155914' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350405'
                WHERE ordernumber = 'P421202171221231' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '286632'
                WHERE ordernumber = 'P181202171307738' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350407'
                WHERE ordernumber = 'P181202171443840' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '341476'
                WHERE ordernumber = 'P421202171654807' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350409'
                WHERE ordernumber = 'P421202172110293' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350410'
                WHERE ordernumber = 'P181202172137786' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350412'
                WHERE ordernumber = 'P421202172305810' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '341702'
                WHERE ordernumber = 'P421202172447348' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '241359'
                WHERE ordernumber = 'P181202172529731' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '241359'
                WHERE ordernumber = 'P181202172555521' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '252028'
                WHERE ordernumber = 'P181202172809885' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '225185'
                WHERE ordernumber = 'P181202172834413' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '213209'
                WHERE ordernumber = 'P181202172957702' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '225197'
                WHERE ordernumber = 'P181202173053125' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350415'
                WHERE ordernumber = 'P421202173154882' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350416'
                WHERE ordernumber = 'P181202173550607' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '346957'
                WHERE ordernumber = 'P181202173814262' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350413'
                WHERE ordernumber = 'P421202173853665' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '206396'
                WHERE ordernumber = 'P181202174130964' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350421'
                WHERE ordernumber = 'P201202174414134' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '139272'
                WHERE ordernumber = 'P201202174451852' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350419'
                WHERE ordernumber = 'P201202174736207' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '253661'
                WHERE ordernumber = 'P181202175054181' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350423'
                WHERE ordernumber = 'P421202175256192' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350427'
                WHERE ordernumber = 'P191202180130851' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350428'
                WHERE ordernumber = 'P201202180141640' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350430'
                WHERE ordernumber = 'P201202180250485' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '239817'
                WHERE ordernumber = 'P201202180530456' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '139727'
                WHERE ordernumber = 'P201202180625469' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350432'
                WHERE ordernumber = 'P181202180741130' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '342750'
                WHERE ordernumber = 'P421202180809691' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350434'
                WHERE ordernumber = 'P201202180833118' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '213389'
                WHERE ordernumber = 'P181202181000452' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '287725'
                WHERE ordernumber = 'P201202181351418' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350435'
                WHERE ordernumber = 'P421202181600187' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350436'
                WHERE ordernumber = 'P181202181612543' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350437'
                WHERE ordernumber = 'P181202181717413' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350438'
                WHERE ordernumber = 'P181202181854310' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350439'
                WHERE ordernumber = 'P181202182010500' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350441'
                WHERE ordernumber = 'P181202182232701' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350442'
                WHERE ordernumber = 'P181202182340667' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '231406'
                WHERE ordernumber = 'P181202182512563' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350444'
                WHERE ordernumber = 'P181202182612381' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350445'
                WHERE ordernumber = 'P181202182756841' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '234716'
                WHERE ordernumber = 'P181202182907861' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350446'
                WHERE ordernumber = 'P181202182956864' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350448'
                WHERE ordernumber = 'P191202183110284' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '280256'
                WHERE ordernumber = 'P181202183150429' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350450'
                WHERE ordernumber = 'P181202183938301' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '304627'
                WHERE ordernumber = 'P201202184006288' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350452'
                WHERE ordernumber = 'P181202184126214' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350453'
                WHERE ordernumber = 'P181202184556951' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '304627'
                WHERE ordernumber = 'P201202184651383' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350454'
                WHERE ordernumber = 'P181202184658980' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350456'
                WHERE ordernumber = 'P181202184753337' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '348464'
                WHERE ordernumber = 'P181202184851692' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350459'
                WHERE ordernumber = 'P191202185205477' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '317171'
                WHERE ordernumber = 'P191202190116648' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '325923'
                WHERE ordernumber = 'P421202190158621' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '222823'
                WHERE ordernumber = 'P191202193136328' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '99866'
                WHERE ordernumber = 'P191202193404967' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350471'
                WHERE ordernumber = 'P191202194507327' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350475'
                WHERE ordernumber = 'P201202195306508' 
            
2023-12-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '289391'
                WHERE ordernumber = 'P191202195717563'