2024-01-28 01:00:02 -- 將會員中心id寫入data-lake
2024-01-28 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-01-27%';
        
2024-01-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '345891'
                WHERE ordernumber = 'P180122152637671' 
            
2024-01-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '313481'
                WHERE ordernumber = 'P180127101531818' 
            
2024-01-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '116084'
                WHERE ordernumber = 'P190127102831142' 
            
2024-01-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '237040'
                WHERE ordernumber = 'P200127110201577' 
            
2024-01-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '226962'
                WHERE ordernumber = 'P200127110243236' 
            
2024-01-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '154794'
                WHERE ordernumber = 'P180127110328229' 
            
2024-01-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '110736'
                WHERE ordernumber = 'P200127110414159' 
            
2024-01-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '258516'
                WHERE ordernumber = 'P200127110539635' 
            
2024-01-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '258516'
                WHERE ordernumber = 'P200127110607171' 
            
2024-01-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '247934'
                WHERE ordernumber = 'P180127110608959' 
            
2024-01-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '314295'
                WHERE ordernumber = 'P200127110652150' 
            
2024-01-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '372586'
                WHERE ordernumber = 'P420127111022331' 
            
2024-01-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '372587'
                WHERE ordernumber = 'P200127111115561' 
            
2024-01-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '114971'
                WHERE ordernumber = 'P180127111209835' 
            
2024-01-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '126299'
                WHERE ordernumber = 'P180127111914458' 
            
2024-01-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '372591'
                WHERE ordernumber = 'P190127112024601' 
            
2024-01-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '257299'
                WHERE ordernumber = 'P200127112204904' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372595'
                WHERE ordernumber = 'P190127112751672' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '152524'
                WHERE ordernumber = 'P180127112758670' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '322183'
                WHERE ordernumber = 'P190127112927960' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '292737'
                WHERE ordernumber = 'P180127112933557' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '156076'
                WHERE ordernumber = 'P200127113011486' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '369333'
                WHERE ordernumber = 'P180127113013230' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247909'
                WHERE ordernumber = 'P190127113038766' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '120652'
                WHERE ordernumber = 'P190127113151641' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '229851'
                WHERE ordernumber = 'P190127113250221' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350320'
                WHERE ordernumber = 'P420127113306612' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372599'
                WHERE ordernumber = 'P200127113340714' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353470'
                WHERE ordernumber = 'P180127113459503' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372595'
                WHERE ordernumber = 'P180127113619478' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '126659'
                WHERE ordernumber = 'P190127113841199' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357204'
                WHERE ordernumber = 'P200127113912434' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278465'
                WHERE ordernumber = 'P180127113934638' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306561'
                WHERE ordernumber = 'P200127114030813' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372603'
                WHERE ordernumber = 'P180127114117170' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372604'
                WHERE ordernumber = 'P420127114157829' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372605'
                WHERE ordernumber = 'P420127114346964' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359804'
                WHERE ordernumber = 'P420127114615527' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '216153'
                WHERE ordernumber = 'P200127114650857' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372607'
                WHERE ordernumber = 'P200127114800709' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289269'
                WHERE ordernumber = 'P180127115039372' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '319393'
                WHERE ordernumber = 'P420127115106969' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279563'
                WHERE ordernumber = 'P180127115139435' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366620'
                WHERE ordernumber = 'P200127115818940' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '328633'
                WHERE ordernumber = 'P180127120217672' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355744'
                WHERE ordernumber = 'P200127120306852' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341040'
                WHERE ordernumber = 'P180127120412942' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '363857'
                WHERE ordernumber = 'P200127120503698' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '84727'
                WHERE ordernumber = 'P180127120518744' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372617'
                WHERE ordernumber = 'P190127120924681' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '154617'
                WHERE ordernumber = 'P200127120956707' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '317859'
                WHERE ordernumber = 'P200127121551530' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372613'
                WHERE ordernumber = 'P180127121918915' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372621'
                WHERE ordernumber = 'P420127122130712' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '124743'
                WHERE ordernumber = 'P180127122437767' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365257'
                WHERE ordernumber = 'P420127122437514' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372622'
                WHERE ordernumber = 'P180127122611550' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283421'
                WHERE ordernumber = 'P180127122800567' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '146565'
                WHERE ordernumber = 'P530127122954501' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '57435'
                WHERE ordernumber = 'P180127123224967' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '217708'
                WHERE ordernumber = 'P200127123328813' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275592'
                WHERE ordernumber = 'P200127123502195' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '312252'
                WHERE ordernumber = 'P180127123643873' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370397'
                WHERE ordernumber = 'P180127124012123' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372628'
                WHERE ordernumber = 'P180127124234614' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '259735'
                WHERE ordernumber = 'P180127124444965' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '220642'
                WHERE ordernumber = 'P200127124906298' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291973'
                WHERE ordernumber = 'P180127124933792' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283537'
                WHERE ordernumber = 'P420127125000350' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '274697'
                WHERE ordernumber = 'P420127125106424' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372631'
                WHERE ordernumber = 'P420127125406687' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '252894'
                WHERE ordernumber = 'P200127125414520' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240957'
                WHERE ordernumber = 'P180127125509771' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371589'
                WHERE ordernumber = 'P180127125547431' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372634'
                WHERE ordernumber = 'P420127125632503' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93652'
                WHERE ordernumber = 'P200127125707621' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '128130'
                WHERE ordernumber = 'P180127125936930' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '161047'
                WHERE ordernumber = 'P200127130003201' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299779'
                WHERE ordernumber = 'P200127130058770' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372637'
                WHERE ordernumber = 'P200127130351213' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372638'
                WHERE ordernumber = 'P420127130637440' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302158'
                WHERE ordernumber = 'P200127130827736' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '111232'
                WHERE ordernumber = 'P180127130946371' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372642'
                WHERE ordernumber = 'P420127131134550' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372643'
                WHERE ordernumber = 'P200127131217702' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '255447'
                WHERE ordernumber = 'P200127131443577' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '216105'
                WHERE ordernumber = 'P180127131644958' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '216105'
                WHERE ordernumber = 'P180127131722636' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '90938'
                WHERE ordernumber = 'P200127131853852' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '158677'
                WHERE ordernumber = 'P420127131859162' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '104456'
                WHERE ordernumber = 'P180127132126368' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372649'
                WHERE ordernumber = 'P420127132200762' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372651'
                WHERE ordernumber = 'P420127132405972' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372650'
                WHERE ordernumber = 'P180127132501945' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372652'
                WHERE ordernumber = 'P200127132657931' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309225'
                WHERE ordernumber = 'P200127132807622' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365891'
                WHERE ordernumber = 'P200127133228271' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365460'
                WHERE ordernumber = 'P420127133438804' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271490'
                WHERE ordernumber = 'P190127133621732' 
            
2024-01-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343775'
                WHERE ordernumber = 'P190127133707761' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '291973'
                WHERE ordernumber = 'P180127133734606' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372659'
                WHERE ordernumber = 'P420127133750997' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372654'
                WHERE ordernumber = 'P190127133807404' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102498'
                WHERE ordernumber = 'P420127133823896' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '93730'
                WHERE ordernumber = 'P200127133926535' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '235469'
                WHERE ordernumber = 'P180127133944425' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372661'
                WHERE ordernumber = 'P420127134005609' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '235469'
                WHERE ordernumber = 'P180127134038791' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372662'
                WHERE ordernumber = 'P420127134127590' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372664'
                WHERE ordernumber = 'P420127134339652' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372665'
                WHERE ordernumber = 'P420127134443848' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372666'
                WHERE ordernumber = 'P420127134621670' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372667'
                WHERE ordernumber = 'P420127134703127' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372668'
                WHERE ordernumber = 'P420127134825696' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371145'
                WHERE ordernumber = 'P200127134920713' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372670'
                WHERE ordernumber = 'P420127135012494' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '336369'
                WHERE ordernumber = 'P420127135144649' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372675'
                WHERE ordernumber = 'P420127135331922' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '360091'
                WHERE ordernumber = 'P420127135438539' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '360088'
                WHERE ordernumber = 'P420127135531467' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372679'
                WHERE ordernumber = 'P200127135639617' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '124369'
                WHERE ordernumber = 'P180127135831902' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372682'
                WHERE ordernumber = 'P420127135854885' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '370238'
                WHERE ordernumber = 'P200127135911960' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '370238'
                WHERE ordernumber = 'P200127135914663' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '370238'
                WHERE ordernumber = 'P200127135916981' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355045'
                WHERE ordernumber = 'P420127140008371' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372679'
                WHERE ordernumber = 'P200127140031250' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372684'
                WHERE ordernumber = 'P430127140040374' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '300214'
                WHERE ordernumber = 'P200127140108475' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299127'
                WHERE ordernumber = 'P200127140227761' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238800'
                WHERE ordernumber = 'P180127140236946' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371461'
                WHERE ordernumber = 'P420127140747472' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '153966'
                WHERE ordernumber = 'P180127141120502' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '262224'
                WHERE ordernumber = 'P200127141325809' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372142'
                WHERE ordernumber = 'P180127141405235' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372142'
                WHERE ordernumber = 'P180127141425120' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372691'
                WHERE ordernumber = 'P420127141437798' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '315412'
                WHERE ordernumber = 'P200127141520831' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372693'
                WHERE ordernumber = 'P430127141611893' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372695'
                WHERE ordernumber = 'P420127141649606' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '177217'
                WHERE ordernumber = 'P420127141721175' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '165508'
                WHERE ordernumber = 'P200127141815733' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372697'
                WHERE ordernumber = 'P420127141838183' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '78772'
                WHERE ordernumber = 'P190127142131405' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '318593'
                WHERE ordernumber = 'P420127142355357' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '128814'
                WHERE ordernumber = 'P180127142442843' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372700'
                WHERE ordernumber = 'P420127142558984' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102664'
                WHERE ordernumber = 'P180127142734521' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372703'
                WHERE ordernumber = 'P200127142800280' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372702'
                WHERE ordernumber = 'P420127142806460' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '95567'
                WHERE ordernumber = 'P180127142905762' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '144506'
                WHERE ordernumber = 'P190127142910559' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372704'
                WHERE ordernumber = 'P420127142937113' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '321809'
                WHERE ordernumber = 'P200127142945489' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '95567'
                WHERE ordernumber = 'P180127143016540' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372705'
                WHERE ordernumber = 'P420127143031969' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372706'
                WHERE ordernumber = 'P420127143209374' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372707'
                WHERE ordernumber = 'P420127143252857' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '231385'
                WHERE ordernumber = 'P180127143447795' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367839'
                WHERE ordernumber = 'P420127143534509' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310160'
                WHERE ordernumber = 'P180127143559774' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372709'
                WHERE ordernumber = 'P420127143653764' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372709'
                WHERE ordernumber = 'P420127143723710' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356794'
                WHERE ordernumber = 'P200127143753593' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372710'
                WHERE ordernumber = 'P420127144127579' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372711'
                WHERE ordernumber = 'P420127144235431' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372712'
                WHERE ordernumber = 'P420127144341167' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372708'
                WHERE ordernumber = 'P190127144421722' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372713'
                WHERE ordernumber = 'P420127144434954' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '153148'
                WHERE ordernumber = 'P190127144544178' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372718'
                WHERE ordernumber = 'P190127144702154' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372720'
                WHERE ordernumber = 'P420127144749729' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372714'
                WHERE ordernumber = 'P200127144759254' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '326263'
                WHERE ordernumber = 'P420127144843436' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372717'
                WHERE ordernumber = 'P190127144908160' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372721'
                WHERE ordernumber = 'P420127145019540' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99037'
                WHERE ordernumber = 'P180127145101177' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372722'
                WHERE ordernumber = 'P420127145116224' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372723'
                WHERE ordernumber = 'P420127145301755' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372726'
                WHERE ordernumber = 'P200127145343153' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372727'
                WHERE ordernumber = 'P420127145419858' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372728'
                WHERE ordernumber = 'P420127145511374' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '241158'
                WHERE ordernumber = 'P180127145549535' 
            
2024-01-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372729'
                WHERE ordernumber = 'P420127145605966' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372732'
                WHERE ordernumber = 'P420127145841565' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372733'
                WHERE ordernumber = 'P420127150000949' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '272125'
                WHERE ordernumber = 'P420127150135130' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372735'
                WHERE ordernumber = 'P420127150257839' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372699'
                WHERE ordernumber = 'P190127150357723' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '337234'
                WHERE ordernumber = 'P200127150414566' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372737'
                WHERE ordernumber = 'P420127150507456' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355624'
                WHERE ordernumber = 'P200127150615736' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372740'
                WHERE ordernumber = 'P420127150721808' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372742'
                WHERE ordernumber = 'P420127150849930' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '62550'
                WHERE ordernumber = 'P180127150918985' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372743'
                WHERE ordernumber = 'P420127150943164' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '100750'
                WHERE ordernumber = 'P180127150954788' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372744'
                WHERE ordernumber = 'P430127151104121' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372745'
                WHERE ordernumber = 'P420127151122502' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372746'
                WHERE ordernumber = 'P430127151213248' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358771'
                WHERE ordernumber = 'P180127151305636' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372751'
                WHERE ordernumber = 'P430127151404884' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '256346'
                WHERE ordernumber = 'P180127151441959' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372752'
                WHERE ordernumber = 'P420127151455407' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '365587'
                WHERE ordernumber = 'P190127151702886' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '365587'
                WHERE ordernumber = 'P190127151747354' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372753'
                WHERE ordernumber = 'P420127151801419' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '365587'
                WHERE ordernumber = 'P190127151850827' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372754'
                WHERE ordernumber = 'P420127151852138' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '256346'
                WHERE ordernumber = 'P180127151856203' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372755'
                WHERE ordernumber = 'P180127151946225' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372756'
                WHERE ordernumber = 'P420127152005212' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372757'
                WHERE ordernumber = 'P420127152058572' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '216932'
                WHERE ordernumber = 'P420127152139542' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '250178'
                WHERE ordernumber = 'P420127152222847' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '284772'
                WHERE ordernumber = 'P180127152223815' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372760'
                WHERE ordernumber = 'P420127152313299' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372762'
                WHERE ordernumber = 'P420127152402460' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '335323'
                WHERE ordernumber = 'P200127152504642' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372764'
                WHERE ordernumber = 'P420127152545718' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372766'
                WHERE ordernumber = 'P420127152728381' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372768'
                WHERE ordernumber = 'P420127152824598' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '315952'
                WHERE ordernumber = 'P190127152829294' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372769'
                WHERE ordernumber = 'P420127152926608' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372770'
                WHERE ordernumber = 'P420127153116986' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372771'
                WHERE ordernumber = 'P180127153120887' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '357110'
                WHERE ordernumber = 'P200127153131419' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '152068'
                WHERE ordernumber = 'P190127153222340' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '296801'
                WHERE ordernumber = 'P420127153351691' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '222161'
                WHERE ordernumber = 'P200127153425400' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '125508'
                WHERE ordernumber = 'P420127153542290' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372771'
                WHERE ordernumber = 'P180127153733155' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372774'
                WHERE ordernumber = 'P420127153740891' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '100277'
                WHERE ordernumber = 'P190127153838468' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '90225'
                WHERE ordernumber = 'P200127153851745' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372775'
                WHERE ordernumber = 'P420127153855578' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '316812'
                WHERE ordernumber = 'P420127153950666' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '137641'
                WHERE ordernumber = 'P190127153958691' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '152068'
                WHERE ordernumber = 'P190127154128446' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '263174'
                WHERE ordernumber = 'P180127154158580' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '176236'
                WHERE ordernumber = 'P200127154340413' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '6127'
                WHERE ordernumber = 'P420127154415909' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '342321'
                WHERE ordernumber = 'P200127154508608' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372781'
                WHERE ordernumber = 'P420127154510348' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '166603'
                WHERE ordernumber = 'P180127154756414' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372783'
                WHERE ordernumber = 'P420127154848696' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '326037'
                WHERE ordernumber = 'P190127154902194' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372784'
                WHERE ordernumber = 'P420127154957782' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '344731'
                WHERE ordernumber = 'P530127155008292' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '344731'
                WHERE ordernumber = 'P420127155134831' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372787'
                WHERE ordernumber = 'P420127155300813' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '263174'
                WHERE ordernumber = 'P180127155354697' 
            
2024-01-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '65574'
                WHERE ordernumber = 'P420127155513348' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '248366'
                WHERE ordernumber = 'P200127155849401' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '371643'
                WHERE ordernumber = 'P420127155911489' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '372789'
                WHERE ordernumber = 'P420127160022329' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '372790'
                WHERE ordernumber = 'P420127160131832' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '288085'
                WHERE ordernumber = 'P180127160136504' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351944'
                WHERE ordernumber = 'P420127160245651' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '263174'
                WHERE ordernumber = 'P190127160324667' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368944'
                WHERE ordernumber = 'P420127160347274' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '248803'
                WHERE ordernumber = 'P200127160434117' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '86219'
                WHERE ordernumber = 'P190127160439240' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '301771'
                WHERE ordernumber = 'P180127160454375' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '372793'
                WHERE ordernumber = 'P200127160634303' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '86219'
                WHERE ordernumber = 'P190127160716983' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '372794'
                WHERE ordernumber = 'P420127160716961' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '372796'
                WHERE ordernumber = 'P420127160822217' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '104834'
                WHERE ordernumber = 'P190127160853249' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '270378'
                WHERE ordernumber = 'P200127161002255' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '215706'
                WHERE ordernumber = 'P190127161027943' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '215706'
                WHERE ordernumber = 'P190127161118443' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '303380'
                WHERE ordernumber = 'P180127161128915' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '372799'
                WHERE ordernumber = 'P420127161249614' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368511'
                WHERE ordernumber = 'P180127161403849' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368511'
                WHERE ordernumber = 'P180127161431733' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '153352'
                WHERE ordernumber = 'P190127161447478' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368511'
                WHERE ordernumber = 'P180127161501520' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '346530'
                WHERE ordernumber = 'P180127161648178' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '369645'
                WHERE ordernumber = 'P420127161657483' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '372801'
                WHERE ordernumber = 'P420127161744332' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '98720'
                WHERE ordernumber = 'P200127161840975' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '367527'
                WHERE ordernumber = 'P420127161913763' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '372803'
                WHERE ordernumber = 'P420127162009684' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '239591'
                WHERE ordernumber = 'P180127162522746' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353100'
                WHERE ordernumber = 'P180127162642268' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '372805'
                WHERE ordernumber = 'P420127163219531' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '329610'
                WHERE ordernumber = 'P420127163316556' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '285587'
                WHERE ordernumber = 'P200127163442843' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351992'
                WHERE ordernumber = 'P200127163517337' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '372805'
                WHERE ordernumber = 'P420127163534441' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '372805'
                WHERE ordernumber = 'P420127163629466' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '372807'
                WHERE ordernumber = 'P200127163646214' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '349202'
                WHERE ordernumber = 'P180127163649476' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '369941'
                WHERE ordernumber = 'P420127163659625' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '338863'
                WHERE ordernumber = 'P420127163929571' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '96208'
                WHERE ordernumber = 'P180127164212372' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '372810'
                WHERE ordernumber = 'P420127164410594' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '372812'
                WHERE ordernumber = 'P420127164531957' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '372815'
                WHERE ordernumber = 'P420127164641144' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '372816'
                WHERE ordernumber = 'P420127164738165' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '372819'
                WHERE ordernumber = 'P420127164824423' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '278646'
                WHERE ordernumber = 'P180127164905409' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '372820'
                WHERE ordernumber = 'P420127164927698' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '372805'
                WHERE ordernumber = 'P420127165234257' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '372826'
                WHERE ordernumber = 'P430127165518141' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '372827'
                WHERE ordernumber = 'P420127165627992' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '372828'
                WHERE ordernumber = 'P200127165641242' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '372829'
                WHERE ordernumber = 'P420127165803967' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '170447'
                WHERE ordernumber = 'P200127165849144' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '372830'
                WHERE ordernumber = 'P420127165902635' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '89629'
                WHERE ordernumber = 'P200127170010534' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352052'
                WHERE ordernumber = 'P420127170019394' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '372831'
                WHERE ordernumber = 'P420127170146555' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '372832'
                WHERE ordernumber = 'P420127170233150' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '372834'
                WHERE ordernumber = 'P420127170450752' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '303132'
                WHERE ordernumber = 'P180127170554663' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '372836'
                WHERE ordernumber = 'P420127170646350' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '264099'
                WHERE ordernumber = 'P200127170727932' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '107559'
                WHERE ordernumber = 'P190127170914733' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '4355'
                WHERE ordernumber = 'P200127170932992' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '356833'
                WHERE ordernumber = 'P180127171112849' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '356833'
                WHERE ordernumber = 'P180127171134150' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '372837'
                WHERE ordernumber = 'P420127171229460' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '331974'
                WHERE ordernumber = 'P180127171313520' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '372842'
                WHERE ordernumber = 'P420127171554831' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '372843'
                WHERE ordernumber = 'P200127171730216' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '372843'
                WHERE ordernumber = 'P200127171842719' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '184839'
                WHERE ordernumber = 'P420127171901403' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '372846'
                WHERE ordernumber = 'P200127171959910' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '372847'
                WHERE ordernumber = 'P420127172054425' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '372299'
                WHERE ordernumber = 'P420127172143945' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '372850'
                WHERE ordernumber = 'P200127172320947' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '261293'
                WHERE ordernumber = 'P200127172356708' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '372852'
                WHERE ordernumber = 'P420127172450772' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '372853'
                WHERE ordernumber = 'P420127172640546' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353342'
                WHERE ordernumber = 'P200127172731326' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '372854'
                WHERE ordernumber = 'P420127172820690' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '372854'
                WHERE ordernumber = 'P420127172907550' 
            
2024-01-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '372855'
                WHERE ordernumber = 'P190127172953435' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '163432'
                WHERE ordernumber = 'P200127173310733' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '65362'
                WHERE ordernumber = 'P180127173415721' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '281001'
                WHERE ordernumber = 'P200127173613616' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '372857'
                WHERE ordernumber = 'P420127173708730' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '372859'
                WHERE ordernumber = 'P420127174037112' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '356802'
                WHERE ordernumber = 'P420127174109395' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '372860'
                WHERE ordernumber = 'P420127174650827' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '231777'
                WHERE ordernumber = 'P200127174903365' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '348987'
                WHERE ordernumber = 'P200127175141598' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '97853'
                WHERE ordernumber = 'P180127175354876' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '372868'
                WHERE ordernumber = 'P200127175419554' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '365269'
                WHERE ordernumber = 'P420127175644467' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '372870'
                WHERE ordernumber = 'P190127175712671' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '372871'
                WHERE ordernumber = 'P420127175741485' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '350434'
                WHERE ordernumber = 'P200127175742462' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '351377'
                WHERE ordernumber = 'P420127175919214' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '169223'
                WHERE ordernumber = 'P420127180100170' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '350642'
                WHERE ordernumber = 'P180127180107154' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '141900'
                WHERE ordernumber = 'P200127180214537' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '348119'
                WHERE ordernumber = 'P420127180248802' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '372874'
                WHERE ordernumber = 'P420127180350857' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '372875'
                WHERE ordernumber = 'P420127180436500' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '372879'
                WHERE ordernumber = 'P420127180614580' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '367480'
                WHERE ordernumber = 'P200127180624123' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '372880'
                WHERE ordernumber = 'P420127180659979' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '372883'
                WHERE ordernumber = 'P420127180808969' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '372884'
                WHERE ordernumber = 'P420127180934774' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '372885'
                WHERE ordernumber = 'P420127181156377' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '372886'
                WHERE ordernumber = 'P420127181335551' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '372885'
                WHERE ordernumber = 'P420127181416731' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '372888'
                WHERE ordernumber = 'P420127181540522' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '372889'
                WHERE ordernumber = 'P420127181628791' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '372890'
                WHERE ordernumber = 'P420127181716180' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '372891'
                WHERE ordernumber = 'P420127181811225' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '372893'
                WHERE ordernumber = 'P420127182149485' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '127187'
                WHERE ordernumber = 'P200127182726580' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '296858'
                WHERE ordernumber = 'P420127182729483' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '309387'
                WHERE ordernumber = 'P180127182845711' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '367420'
                WHERE ordernumber = 'P200127182929132' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '372901'
                WHERE ordernumber = 'P420127183716117' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '344297'
                WHERE ordernumber = 'P420127183824277' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '129053'
                WHERE ordernumber = 'P190127183847160' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '365868'
                WHERE ordernumber = 'P190127183928301' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '341361'
                WHERE ordernumber = 'P420127184305830' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '369008'
                WHERE ordernumber = 'P180127184348919' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '372905'
                WHERE ordernumber = 'P420127184411216' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '369008'
                WHERE ordernumber = 'P180127184442745' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '100206'
                WHERE ordernumber = 'P200127184505633' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '372907'
                WHERE ordernumber = 'P420127184815769' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '372908'
                WHERE ordernumber = 'P190127184903907' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '372909'
                WHERE ordernumber = 'P200127184923490' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '287849'
                WHERE ordernumber = 'P420127184927286' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '372911'
                WHERE ordernumber = 'P420127185036462' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '213908'
                WHERE ordernumber = 'P200127185103974' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '364232'
                WHERE ordernumber = 'P420127185339302' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '279256'
                WHERE ordernumber = 'P200127185453328' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '216155'
                WHERE ordernumber = 'P420127185602577' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '372912'
                WHERE ordernumber = 'P190127185703585' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '372914'
                WHERE ordernumber = 'P420127185848837' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '372916'
                WHERE ordernumber = 'P420127190301738' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '245383'
                WHERE ordernumber = 'P190127190520957' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '262121'
                WHERE ordernumber = 'P200127190659349' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '372919'
                WHERE ordernumber = 'P190127190750348' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '372920'
                WHERE ordernumber = 'P420127190943376' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '372923'
                WHERE ordernumber = 'P190127191306159' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '219269'
                WHERE ordernumber = 'P180127191405409' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '371628'
                WHERE ordernumber = 'P420127191659420' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '287796'
                WHERE ordernumber = 'P420127191927793' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '372925'
                WHERE ordernumber = 'P420127192028913' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '372926'
                WHERE ordernumber = 'P420127192248173' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '372927'
                WHERE ordernumber = 'P420127192431664' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '372928'
                WHERE ordernumber = 'P420127192527353' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '372929'
                WHERE ordernumber = 'P420127193002261' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '222289'
                WHERE ordernumber = 'P200127193044144' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '261396'
                WHERE ordernumber = 'P420127193128505' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '104252'
                WHERE ordernumber = 'P420127193214540' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '372931'
                WHERE ordernumber = 'P420127193314985' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '348229'
                WHERE ordernumber = 'P420127193409616' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '372932'
                WHERE ordernumber = 'P420127193531688' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '238189'
                WHERE ordernumber = 'P190127193630436' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '232359'
                WHERE ordernumber = 'P420127194049204' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '372936'
                WHERE ordernumber = 'P420127194405904' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '372938'
                WHERE ordernumber = 'P420127194721396' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '351969'
                WHERE ordernumber = 'P420127194827795' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '245316'
                WHERE ordernumber = 'P200127195022758' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '372955'
                WHERE ordernumber = 'P420127200335988' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '372957'
                WHERE ordernumber = 'P420127200611596' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '372958'
                WHERE ordernumber = 'P420127200711391' 
            
2024-01-28 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '372959'
                WHERE ordernumber = 'P420127200845261' 
            
2024-01-28 01:00:08 -- 
                UPDATE `omo_order_list` SET userId = '361626'
                WHERE ordernumber = 'P420127200935684' 
            
2024-01-28 01:00:08 -- 
                UPDATE `omo_order_list` SET userId = '372960'
                WHERE ordernumber = 'P420127201109427' 
            
2024-01-28 01:00:08 -- 
                UPDATE `omo_order_list` SET userId = '372961'
                WHERE ordernumber = 'P420127201200765' 
            
2024-01-28 01:00:08 -- 
                UPDATE `omo_order_list` SET userId = '372962'
                WHERE ordernumber = 'P430127201220690' 
            
2024-01-28 01:00:08 -- 
                UPDATE `omo_order_list` SET userId = '277966'
                WHERE ordernumber = 'P420127201344675' 
            
2024-01-28 01:00:08 -- 
                UPDATE `omo_order_list` SET userId = '372964'
                WHERE ordernumber = 'P420127201505798' 
            
2024-01-28 01:00:08 -- 
                UPDATE `omo_order_list` SET userId = '372966'
                WHERE ordernumber = 'P420127201722302' 
            
2024-01-28 01:00:08 -- 
                UPDATE `omo_order_list` SET userId = '360888'
                WHERE ordernumber = 'P420127202458256' 
            
2024-01-28 01:00:08 -- 
                UPDATE `omo_order_list` SET userId = '253301'
                WHERE ordernumber = 'P420127202849640' 
            
2024-01-28 01:00:08 -- 
                UPDATE `omo_order_list` SET userId = '268147'
                WHERE ordernumber = 'P420127203716333' 
            
2024-01-28 01:00:08 -- 
                UPDATE `omo_order_list` SET userId = '372980'
                WHERE ordernumber = 'P420127204150196' 
            
2024-01-28 01:00:08 -- 
                UPDATE `omo_order_list` SET userId = '335633'
                WHERE ordernumber = 'P420127205447923' 
            
2024-01-28 01:00:08 -- 
                UPDATE `omo_order_list` SET userId = '372992'
                WHERE ordernumber = 'P420127205700588' 
            
2024-01-28 01:00:08 -- 
                UPDATE `omo_order_list` SET userId = '372993'
                WHERE ordernumber = 'P420127205812393' 
            
2024-01-28 01:00:08 -- 
                UPDATE `omo_order_list` SET userId = '372994'
                WHERE ordernumber = 'P420127205905430' 
            
2024-01-28 01:00:08 -- 
                UPDATE `omo_order_list` SET userId = '372996'
                WHERE ordernumber = 'P420127210000267' 
            
2024-01-28 01:00:08 -- 
                UPDATE `omo_order_list` SET userId = '274352'
                WHERE ordernumber = 'P420127210313956' 
            
2024-01-28 01:00:08 -- 
                UPDATE `omo_order_list` SET userId = '372998'
                WHERE ordernumber = 'P420127211014778' 
            
2024-01-28 01:00:08 -- 
                UPDATE `omo_order_list` SET userId = '300492'
                WHERE ordernumber = 'P420127211839426' 
            
2024-01-28 01:00:08 -- 
                UPDATE `omo_order_list` SET userId = '373002'
                WHERE ordernumber = 'P420127212243530' 
            
2024-01-28 01:00:08 -- 
                UPDATE `omo_order_list` SET userId = '373007'
                WHERE ordernumber = 'P420127213902370' 
            
2024-01-28 01:00:08 -- 
                UPDATE `omo_order_list` SET userId = '373015'
                WHERE ordernumber = 'P420127215106575' 
            
2024-01-28 01:00:08 -- 
                UPDATE `omo_order_list` SET userId = '373016'
                WHERE ordernumber = 'P420127215605189' 
            
2024-01-28 01:00:08 -- 
                UPDATE `omo_order_list` SET userId = '373018'
                WHERE ordernumber = 'P420127220120495' 
            
2024-01-28 01:00:08 -- 
                UPDATE `omo_order_list` SET userId = '373019'
                WHERE ordernumber = 'P420127220246535'