2024-08-17 01:00:02 -- 將會員中心id寫入data-lake
2024-08-17 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-08-16%';
        
2024-08-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '359064'
                WHERE ordernumber = 'P200816110430878' 
            
2024-08-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '306512'
                WHERE ordernumber = 'P190816110635362' 
            
2024-08-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409113'
                WHERE ordernumber = 'P420816110730525' 
            
2024-08-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '83959'
                WHERE ordernumber = 'P180816110813555' 
            
2024-08-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '241589'
                WHERE ordernumber = 'P190816110855765' 
            
2024-08-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '313724'
                WHERE ordernumber = 'P200816110921748' 
            
2024-08-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407646'
                WHERE ordernumber = 'P420816111000192' 
            
2024-08-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378055'
                WHERE ordernumber = 'P420816111053236' 
            
2024-08-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '121498'
                WHERE ordernumber = 'P200816111159772' 
            
2024-08-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409118'
                WHERE ordernumber = 'P200816111259441' 
            
2024-08-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '73683'
                WHERE ordernumber = 'P190816111329656' 
            
2024-08-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409116'
                WHERE ordernumber = 'P420816111530755' 
            
2024-08-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '245375'
                WHERE ordernumber = 'P180816111652989' 
            
2024-08-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '221941'
                WHERE ordernumber = 'P200816111829238' 
            
2024-08-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409111'
                WHERE ordernumber = 'P180816112119523' 
            
2024-08-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409121'
                WHERE ordernumber = 'P180816112317316' 
            
2024-08-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378658'
                WHERE ordernumber = 'P180816112509716' 
            
2024-08-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409123'
                WHERE ordernumber = 'P200816112855248' 
            
2024-08-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409124'
                WHERE ordernumber = 'P180816113015746' 
            
2024-08-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409127'
                WHERE ordernumber = 'P420816113130667' 
            
2024-08-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '291860'
                WHERE ordernumber = 'P180816113130220' 
            
2024-08-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '309057'
                WHERE ordernumber = 'P180816113511364' 
            
2024-08-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '238480'
                WHERE ordernumber = 'P200816113555285' 
            
2024-08-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '356762'
                WHERE ordernumber = 'P200816113859947' 
            
2024-08-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '318604'
                WHERE ordernumber = 'P180816114112549' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '336794'
                WHERE ordernumber = 'P420816115112858' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337311'
                WHERE ordernumber = 'P420816115234316' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409136'
                WHERE ordernumber = 'P200816115322684' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409138'
                WHERE ordernumber = 'P420816120115186' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409140'
                WHERE ordernumber = 'P420816120222126' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389657'
                WHERE ordernumber = 'P180816120255423' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409141'
                WHERE ordernumber = 'P420816120425772' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409144'
                WHERE ordernumber = 'P200816120938749' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409145'
                WHERE ordernumber = 'P180816121010276' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409144'
                WHERE ordernumber = 'P200816121139340' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409149'
                WHERE ordernumber = 'P180816121553204' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '206284'
                WHERE ordernumber = 'P420816121808843' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '47047'
                WHERE ordernumber = 'P200816122048253' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '129323'
                WHERE ordernumber = 'P180816122337598' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409153'
                WHERE ordernumber = 'P420816122733550' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99779'
                WHERE ordernumber = 'P180816122954917' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396718'
                WHERE ordernumber = 'P200816123802344' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409159'
                WHERE ordernumber = 'P420816123918400' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '259250'
                WHERE ordernumber = 'P420816124011511' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409160'
                WHERE ordernumber = 'P200816124039357' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271209'
                WHERE ordernumber = 'P420816124055668' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296906'
                WHERE ordernumber = 'P420816124137373' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '274523'
                WHERE ordernumber = 'P190816124231860' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301971'
                WHERE ordernumber = 'P420816124239627' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409161'
                WHERE ordernumber = 'P180816124528340' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389093'
                WHERE ordernumber = 'P200816124814994' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409163'
                WHERE ordernumber = 'P180816125132442' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302805'
                WHERE ordernumber = 'P420816125215440' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409164'
                WHERE ordernumber = 'P180816125617223' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409165'
                WHERE ordernumber = 'P200816125715606' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '129410'
                WHERE ordernumber = 'P200816125917280' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398163'
                WHERE ordernumber = 'P200816130042228' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '244056'
                WHERE ordernumber = 'P190816130124391' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409166'
                WHERE ordernumber = 'P420816130243954' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '179349'
                WHERE ordernumber = 'P420816130442329' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '280068'
                WHERE ordernumber = 'P190816130725193' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383653'
                WHERE ordernumber = 'P180816131131238' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '115574'
                WHERE ordernumber = 'P180816131230363' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409170'
                WHERE ordernumber = 'P420816131643879' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409171'
                WHERE ordernumber = 'P420816132027550' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285580'
                WHERE ordernumber = 'P180816132305133' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409175'
                WHERE ordernumber = 'P200816132313986' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '111252'
                WHERE ordernumber = 'P200816133110403' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '216260'
                WHERE ordernumber = 'P190816133222594' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '111252'
                WHERE ordernumber = 'P200816133453780' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409179'
                WHERE ordernumber = 'P180816133613420' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409180'
                WHERE ordernumber = 'P420816133704236' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409185'
                WHERE ordernumber = 'P180816134401472' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285587'
                WHERE ordernumber = 'P200816134411333' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409187'
                WHERE ordernumber = 'P190816134619926' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409189'
                WHERE ordernumber = 'P180816134644152' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409190'
                WHERE ordernumber = 'P420816134724754' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381361'
                WHERE ordernumber = 'P180816135144738' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409192'
                WHERE ordernumber = 'P420816135235529' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403286'
                WHERE ordernumber = 'P420816135558653' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102917'
                WHERE ordernumber = 'P180816135559300' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '80893'
                WHERE ordernumber = 'P200816135735987' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406592'
                WHERE ordernumber = 'P180816135818845' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162674'
                WHERE ordernumber = 'P420816140226374' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '65115'
                WHERE ordernumber = 'P200816140506569' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409194'
                WHERE ordernumber = 'P200816140655888' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409196'
                WHERE ordernumber = 'P180816140725861' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409197'
                WHERE ordernumber = 'P200816140930120' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '218125'
                WHERE ordernumber = 'P200816141441363' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '243770'
                WHERE ordernumber = 'P190816141552859' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '221250'
                WHERE ordernumber = 'P180816141621799' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '106167'
                WHERE ordernumber = 'P180816141739781' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408905'
                WHERE ordernumber = 'P420816142203877' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '139793'
                WHERE ordernumber = 'P180816142240573' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409204'
                WHERE ordernumber = 'P200816142322196' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409205'
                WHERE ordernumber = 'P420816142405785' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '252332'
                WHERE ordernumber = 'P180816142555474' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353658'
                WHERE ordernumber = 'P180816142947449' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409212'
                WHERE ordernumber = 'P200816144009179' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '254880'
                WHERE ordernumber = 'P190816144043854' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '234207'
                WHERE ordernumber = 'P200816144124628' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '258017'
                WHERE ordernumber = 'P180816144137209' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409215'
                WHERE ordernumber = 'P190816144404115' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297722'
                WHERE ordernumber = 'P420816144503799' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408937'
                WHERE ordernumber = 'P180816144701285' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409216'
                WHERE ordernumber = 'P420816144828349' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350836'
                WHERE ordernumber = 'P180816144954238' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97110'
                WHERE ordernumber = 'P630816145140259' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '253165'
                WHERE ordernumber = 'P590816145235245' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409219'
                WHERE ordernumber = 'P180816145354892' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409220'
                WHERE ordernumber = 'P420816145609466' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298854'
                WHERE ordernumber = 'P420816145932891' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409225'
                WHERE ordernumber = 'P200816150246133' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409224'
                WHERE ordernumber = 'P180816150309832' 
            
2024-08-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409228'
                WHERE ordernumber = 'P420816150645259' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408894'
                WHERE ordernumber = 'P420816151101311' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385100'
                WHERE ordernumber = 'P180816151300511' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409233'
                WHERE ordernumber = 'P200816151329772' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '309799'
                WHERE ordernumber = 'P180816151514405' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385923'
                WHERE ordernumber = 'P180816151600114' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409234'
                WHERE ordernumber = 'P420816151639965' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '62031'
                WHERE ordernumber = 'P200816152358345' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409235'
                WHERE ordernumber = 'P420816152516444' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396973'
                WHERE ordernumber = 'P200816152642614' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409237'
                WHERE ordernumber = 'P180816153013621' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409239'
                WHERE ordernumber = 'P420816153216810' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '47482'
                WHERE ordernumber = 'P420816153553260' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409242'
                WHERE ordernumber = 'P180816153903329' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409241'
                WHERE ordernumber = 'P420816153928345' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403535'
                WHERE ordernumber = 'P630816154042460' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409243'
                WHERE ordernumber = 'P180816154105958' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '167252'
                WHERE ordernumber = 'P180816154235695' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408297'
                WHERE ordernumber = 'P200816155022844' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '258596'
                WHERE ordernumber = 'P180816160049674' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409248'
                WHERE ordernumber = 'P420816160122564' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409216'
                WHERE ordernumber = 'P420816160219710' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409249'
                WHERE ordernumber = 'P200816160442167' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406571'
                WHERE ordernumber = 'P190816160711764' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409251'
                WHERE ordernumber = 'P420816161011196' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '326304'
                WHERE ordernumber = 'P180816161135448' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408823'
                WHERE ordernumber = 'P420816161424944' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407280'
                WHERE ordernumber = 'P180816162152424' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '318987'
                WHERE ordernumber = 'P420816162707339' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409259'
                WHERE ordernumber = 'P180816162930886' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409258'
                WHERE ordernumber = 'P200816163048812' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409262'
                WHERE ordernumber = 'P180816163128457' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395863'
                WHERE ordernumber = 'P180816163243612' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98566'
                WHERE ordernumber = 'P200816163311327' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '136510'
                WHERE ordernumber = 'P200816164047460' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404707'
                WHERE ordernumber = 'P180816164424865' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409268'
                WHERE ordernumber = 'P200816164608135' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390284'
                WHERE ordernumber = 'P630816165227362' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409273'
                WHERE ordernumber = 'P180816165314878' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409272'
                WHERE ordernumber = 'P200816165550188' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409272'
                WHERE ordernumber = 'P200816165625312' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '289584'
                WHERE ordernumber = 'P200816165719417' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '64670'
                WHERE ordernumber = 'P200816170415359' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409272'
                WHERE ordernumber = 'P200816170546201' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '318604'
                WHERE ordernumber = 'P190816171203374' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409281'
                WHERE ordernumber = 'P180816171240503' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409285'
                WHERE ordernumber = 'P190816171930346' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '119752'
                WHERE ordernumber = 'P190816172110784' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409287'
                WHERE ordernumber = 'P200816172810350' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409288'
                WHERE ordernumber = 'P200816172919247' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409289'
                WHERE ordernumber = 'P200816173013219' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391587'
                WHERE ordernumber = 'P420816173102819' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387796'
                WHERE ordernumber = 'P200816173234576' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409290'
                WHERE ordernumber = 'P190816173359863' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352418'
                WHERE ordernumber = 'P190816173714372' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352472'
                WHERE ordernumber = 'P200816173741791' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345134'
                WHERE ordernumber = 'P200816173958150' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401001'
                WHERE ordernumber = 'P180816174144850' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397244'
                WHERE ordernumber = 'P200816174440834' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409295'
                WHERE ordernumber = 'P420816174714475' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230528'
                WHERE ordernumber = 'P190816174738616' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409298'
                WHERE ordernumber = 'P180816175208975' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409299'
                WHERE ordernumber = 'P420816175417558' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366893'
                WHERE ordernumber = 'P200816175425422' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '300653'
                WHERE ordernumber = 'P420816175505306' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409301'
                WHERE ordernumber = 'P200816175809530' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '260675'
                WHERE ordernumber = 'P200816180520942' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '123595'
                WHERE ordernumber = 'P200816180718577' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409303'
                WHERE ordernumber = 'P420816180936686' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409304'
                WHERE ordernumber = 'P200816181056640' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409299'
                WHERE ordernumber = 'P420816181230696' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386162'
                WHERE ordernumber = 'P180816182242234' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '338871'
                WHERE ordernumber = 'P200816182310130' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409008'
                WHERE ordernumber = 'P190816182645466' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396452'
                WHERE ordernumber = 'P180816182653375' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399952'
                WHERE ordernumber = 'P200816183510504' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '133133'
                WHERE ordernumber = 'P180816183534797' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '161127'
                WHERE ordernumber = 'P420816183605162' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403086'
                WHERE ordernumber = 'P420816184319215' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '126536'
                WHERE ordernumber = 'P180816185056889' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '64829'
                WHERE ordernumber = 'P200816185207392' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409314'
                WHERE ordernumber = 'P200816185320996' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394614'
                WHERE ordernumber = 'P200816185358555' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408784'
                WHERE ordernumber = 'P200816185608273' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299419'
                WHERE ordernumber = 'P420816185736314' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409318'
                WHERE ordernumber = 'P420816185911920' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '64829'
                WHERE ordernumber = 'P200816185934938' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387816'
                WHERE ordernumber = 'P630816190126309' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409321'
                WHERE ordernumber = 'P420816190151381' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '139099'
                WHERE ordernumber = 'P190816190522856' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400998'
                WHERE ordernumber = 'P200816190807689' 
            
2024-08-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387819'
                WHERE ordernumber = 'P200816190924748' 
            
2024-08-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395766'
                WHERE ordernumber = 'P200816191111221' 
            
2024-08-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400768'
                WHERE ordernumber = 'P200816191559696' 
            
2024-08-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '409326'
                WHERE ordernumber = 'P190816191741352' 
            
2024-08-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '385328'
                WHERE ordernumber = 'P630816192131674' 
            
2024-08-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '389481'
                WHERE ordernumber = 'P200816192401886' 
            
2024-08-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '409326'
                WHERE ordernumber = 'P190816192913815' 
            
2024-08-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '364952'
                WHERE ordernumber = 'P200816193439490' 
            
2024-08-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '94179'
                WHERE ordernumber = 'P200816194020173' 
            
2024-08-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399885'
                WHERE ordernumber = 'P630816194739515' 
            
2024-08-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '409337'
                WHERE ordernumber = 'P200816194923169'