2024-08-15 01:00:02 -- 將會員中心id寫入data-lake
2024-08-15 01:00:02 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-08-14%';
        
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '405782'
                WHERE ordernumber = 'P420814110335814' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '408199'
                WHERE ordernumber = 'P180814110341798' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406968'
                WHERE ordernumber = 'P180814110436616' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '222910'
                WHERE ordernumber = 'P420814110550395' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '211573'
                WHERE ordernumber = 'P180814110858775' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '408205'
                WHERE ordernumber = 'P180814111149332' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '399670'
                WHERE ordernumber = 'P420814111320229' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '234998'
                WHERE ordernumber = 'P420814111446589' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '384223'
                WHERE ordernumber = 'P180814111539726' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '408207'
                WHERE ordernumber = 'P180814111910781' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '342846'
                WHERE ordernumber = 'P200814112102451' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '290716'
                WHERE ordernumber = 'P190814112105672' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '408208'
                WHERE ordernumber = 'P180814112154358' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '290716'
                WHERE ordernumber = 'P190814112208329' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '110839'
                WHERE ordernumber = 'P630814112613978' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '402341'
                WHERE ordernumber = 'P420814112706178' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '318861'
                WHERE ordernumber = 'P200814112855886' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '408212'
                WHERE ordernumber = 'P200814112939905' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '80921'
                WHERE ordernumber = 'P200814113049836' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287487'
                WHERE ordernumber = 'P190814113512764' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407439'
                WHERE ordernumber = 'P420814113642256' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '140792'
                WHERE ordernumber = 'P200814113654417' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '408222'
                WHERE ordernumber = 'P190814113810248' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392009'
                WHERE ordernumber = 'P190814113909746' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '408223'
                WHERE ordernumber = 'P180814113924285' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '383091'
                WHERE ordernumber = 'P190814114129300' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '408228'
                WHERE ordernumber = 'P180814114352500' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '351015'
                WHERE ordernumber = 'P200814114609364' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '122742'
                WHERE ordernumber = 'P180814115259984' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388675'
                WHERE ordernumber = 'P180814115507887' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '404303'
                WHERE ordernumber = 'P180814115537676' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '408239'
                WHERE ordernumber = 'P180814120026546' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '248290'
                WHERE ordernumber = 'P200814120244363' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '408242'
                WHERE ordernumber = 'P420814120716150' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '153197'
                WHERE ordernumber = 'P180814121117505' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394556'
                WHERE ordernumber = 'P180814121655992' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '408247'
                WHERE ordernumber = 'P180814121900289' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '116232'
                WHERE ordernumber = 'P180814122108706' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '408249'
                WHERE ordernumber = 'P420814122607970' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '223953'
                WHERE ordernumber = 'P200814122619355' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349405'
                WHERE ordernumber = 'P420814122739408' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '297128'
                WHERE ordernumber = 'P200814122946935' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '408253'
                WHERE ordernumber = 'P420814123704493' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '408252'
                WHERE ordernumber = 'P190814123727550' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348408'
                WHERE ordernumber = 'P200814123752265' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '383137'
                WHERE ordernumber = 'P420814124005154' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '408257'
                WHERE ordernumber = 'P190814124240281' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '408263'
                WHERE ordernumber = 'P420814125556834' 
            
2024-08-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '408264'
                WHERE ordernumber = 'P200814125644474' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392227'
                WHERE ordernumber = 'P190814125800148' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408266'
                WHERE ordernumber = 'P420814125915261' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408270'
                WHERE ordernumber = 'P190814130244914' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296904'
                WHERE ordernumber = 'P420814130255747' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '272784'
                WHERE ordernumber = 'P200814130824702' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '16934'
                WHERE ordernumber = 'P180814131148247' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394386'
                WHERE ordernumber = 'P200814131212403' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388008'
                WHERE ordernumber = 'P180814131326570' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394386'
                WHERE ordernumber = 'P200814131359230' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '16934'
                WHERE ordernumber = 'P180814131536806' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408277'
                WHERE ordernumber = 'P420814131636175' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402091'
                WHERE ordernumber = 'P180814132259181' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408280'
                WHERE ordernumber = 'P180814132537800' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408282'
                WHERE ordernumber = 'P190814132607117' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389071'
                WHERE ordernumber = 'P200814133045388' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394739'
                WHERE ordernumber = 'P420814133201803' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408288'
                WHERE ordernumber = 'P180814133421645' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398858'
                WHERE ordernumber = 'P420814133452882' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408292'
                WHERE ordernumber = 'P180814134151222' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237806'
                WHERE ordernumber = 'P200814134232858' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344135'
                WHERE ordernumber = 'P180814134335608' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283087'
                WHERE ordernumber = 'P180814134719858' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '199646'
                WHERE ordernumber = 'P180814134838451' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408298'
                WHERE ordernumber = 'P180814135022692' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102953'
                WHERE ordernumber = 'P200814135034392' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '74471'
                WHERE ordernumber = 'P180814135203445' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387073'
                WHERE ordernumber = 'P180814135454250' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '332760'
                WHERE ordernumber = 'P180814140334869' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397990'
                WHERE ordernumber = 'P180814140725868' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408307'
                WHERE ordernumber = 'P180814141025224' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408310'
                WHERE ordernumber = 'P180814141737272' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408310'
                WHERE ordernumber = 'P180814141856973' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408314'
                WHERE ordernumber = 'P420814142223126' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338088'
                WHERE ordernumber = 'P190814142505568' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '330341'
                WHERE ordernumber = 'P180814143339522' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '320225'
                WHERE ordernumber = 'P190814143505864' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408325'
                WHERE ordernumber = 'P200814143728593' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '157682'
                WHERE ordernumber = 'P200814143834524' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102473'
                WHERE ordernumber = 'P180814143835773' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367203'
                WHERE ordernumber = 'P180814144652183' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408337'
                WHERE ordernumber = 'P420814145700203' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '125995'
                WHERE ordernumber = 'P190814145706708' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '330124'
                WHERE ordernumber = 'P180814145716362' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '330124'
                WHERE ordernumber = 'P180814145818753' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '216961'
                WHERE ordernumber = 'P190814150031960' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P180814150223366' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408340'
                WHERE ordernumber = 'P420814150705545' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408342'
                WHERE ordernumber = 'P180814151015674' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408345'
                WHERE ordernumber = 'P180814152134499' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408348'
                WHERE ordernumber = 'P180814152417973' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408349'
                WHERE ordernumber = 'P190814152910473' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406187'
                WHERE ordernumber = 'P200814152940650' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298853'
                WHERE ordernumber = 'P180814154347532' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408358'
                WHERE ordernumber = 'P200814154521981' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408361'
                WHERE ordernumber = 'P180814154735532' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408365'
                WHERE ordernumber = 'P180814155023481' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '312854'
                WHERE ordernumber = 'P200814155246877' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408367'
                WHERE ordernumber = 'P180814155305944' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408367'
                WHERE ordernumber = 'P180814155407200' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408374'
                WHERE ordernumber = 'P180814160842714' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408376'
                WHERE ordernumber = 'P190814161018558' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408377'
                WHERE ordernumber = 'P420814161102335' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408380'
                WHERE ordernumber = 'P200814161414394' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345784'
                WHERE ordernumber = 'P180814161506206' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '88985'
                WHERE ordernumber = 'P180814161823646' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406420'
                WHERE ordernumber = 'P420814162020409' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300400'
                WHERE ordernumber = 'P190814162504984' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279980'
                WHERE ordernumber = 'P200814162504740' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408386'
                WHERE ordernumber = 'P190814163207725' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408390'
                WHERE ordernumber = 'P190814163815390' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408386'
                WHERE ordernumber = 'P190814163909658' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408391'
                WHERE ordernumber = 'P180814163936916' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '326304'
                WHERE ordernumber = 'P180814164150434' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408394'
                WHERE ordernumber = 'P180814164359911' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408396'
                WHERE ordernumber = 'P180814164657496' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408397'
                WHERE ordernumber = 'P420814164752819' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408398'
                WHERE ordernumber = 'P180814164816226' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408397'
                WHERE ordernumber = 'P420814164841433' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408227'
                WHERE ordernumber = 'P180814165829233' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408406'
                WHERE ordernumber = 'P190814170209147' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408409'
                WHERE ordernumber = 'P190814170450804' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408410'
                WHERE ordernumber = 'P420814170509813' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408411'
                WHERE ordernumber = 'P180814170511181' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408412'
                WHERE ordernumber = 'P420814170909862' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '211838'
                WHERE ordernumber = 'P180814170959961' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402606'
                WHERE ordernumber = 'P420814171058680' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '114210'
                WHERE ordernumber = 'P180814171133160' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408415'
                WHERE ordernumber = 'P190814171305593' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '329426'
                WHERE ordernumber = 'P420814171315874' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408415'
                WHERE ordernumber = 'P190814171412817' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408419'
                WHERE ordernumber = 'P180814171649647' 
            
2024-08-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408419'
                WHERE ordernumber = 'P180814171917668' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230115'
                WHERE ordernumber = 'P180814172426619' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408425'
                WHERE ordernumber = 'P180814172957237' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '116319'
                WHERE ordernumber = 'P180814173332608' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408428'
                WHERE ordernumber = 'P180814173804142' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '74778'
                WHERE ordernumber = 'P200814174146877' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384310'
                WHERE ordernumber = 'P180814174413822' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408434'
                WHERE ordernumber = 'P180814174615826' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408435'
                WHERE ordernumber = 'P180814174805159' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '285694'
                WHERE ordernumber = 'P190814174955235' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '279917'
                WHERE ordernumber = 'P180814175210941' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408438'
                WHERE ordernumber = 'P180814175345419' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '280528'
                WHERE ordernumber = 'P630814175450937' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '315096'
                WHERE ordernumber = 'P200814180338992' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408441'
                WHERE ordernumber = 'P180814180416250' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '143149'
                WHERE ordernumber = 'P200814180539122' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408443'
                WHERE ordernumber = 'P180814180542953' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408444'
                WHERE ordernumber = 'P180814180818609' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278615'
                WHERE ordernumber = 'P180814181055136' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386856'
                WHERE ordernumber = 'P180814181210423' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408448'
                WHERE ordernumber = 'P200814181211446' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407742'
                WHERE ordernumber = 'P420814181219387' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344912'
                WHERE ordernumber = 'P180814181556867' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301815'
                WHERE ordernumber = 'P200814181705520' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313246'
                WHERE ordernumber = 'P180814181714618' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355384'
                WHERE ordernumber = 'P200814181854640' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245610'
                WHERE ordernumber = 'P200814181949592' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408449'
                WHERE ordernumber = 'P180814181950344' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '175105'
                WHERE ordernumber = 'P200814182107519' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '269473'
                WHERE ordernumber = 'P200814182158797' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408451'
                WHERE ordernumber = 'P200814182330323' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '321807'
                WHERE ordernumber = 'P180814182350995' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99427'
                WHERE ordernumber = 'P630814182354414' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '309225'
                WHERE ordernumber = 'P200814182509283' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408454'
                WHERE ordernumber = 'P200814182834403' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '220047'
                WHERE ordernumber = 'P200814183319824' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408459'
                WHERE ordernumber = 'P180814183754833' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408463'
                WHERE ordernumber = 'P180814184845544' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408464'
                WHERE ordernumber = 'P200814184925748' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408335'
                WHERE ordernumber = 'P420814185222767' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '328345'
                WHERE ordernumber = 'P190814185747284' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '104814'
                WHERE ordernumber = 'P190814190354319' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '161436'
                WHERE ordernumber = 'P190814190613180' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408473'
                WHERE ordernumber = 'P190814191107334' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408480'
                WHERE ordernumber = 'P200814191353230' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408482'
                WHERE ordernumber = 'P200814192427339' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381054'
                WHERE ordernumber = 'P190814192542729' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408483'
                WHERE ordernumber = 'P200814192828875' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396828'
                WHERE ordernumber = 'P200814193017911' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277329'
                WHERE ordernumber = 'P190814193731409' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408489'
                WHERE ordernumber = 'P200814193803888' 
            
2024-08-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408500'
                WHERE ordernumber = 'P190814195847293'