2024-02-17 01:00:02 -- 將會員中心id寫入data-lake
2024-02-17 01:00:02 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-02-16%';
        
2024-02-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '111810'
                WHERE ordernumber = 'P190216110305462' 
            
2024-02-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '214149'
                WHERE ordernumber = 'P190216110420964' 
            
2024-02-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '305386'
                WHERE ordernumber = 'P200216110556995' 
            
2024-02-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377414'
                WHERE ordernumber = 'P180216110633995' 
            
2024-02-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '352006'
                WHERE ordernumber = 'P200216110715763' 
            
2024-02-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '316491'
                WHERE ordernumber = 'P180216110855441' 
            
2024-02-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '316491'
                WHERE ordernumber = 'P180216110958943' 
            
2024-02-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '374389'
                WHERE ordernumber = 'P180216111253181' 
            
2024-02-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '123223'
                WHERE ordernumber = 'P200216111323892' 
            
2024-02-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '369267'
                WHERE ordernumber = 'P180216111506754' 
            
2024-02-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '316491'
                WHERE ordernumber = 'P180216111604946' 
            
2024-02-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '306524'
                WHERE ordernumber = 'P180216111823224' 
            
2024-02-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377416'
                WHERE ordernumber = 'P190216111914341' 
            
2024-02-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377273'
                WHERE ordernumber = 'P180216111925849' 
            
2024-02-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '106086'
                WHERE ordernumber = 'P180216112105581' 
            
2024-02-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '135443'
                WHERE ordernumber = 'P190216112110963' 
            
2024-02-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '114594'
                WHERE ordernumber = 'P180216112231660' 
            
2024-02-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '346706'
                WHERE ordernumber = 'P190216112615623' 
            
2024-02-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '347462'
                WHERE ordernumber = 'P180216112615708' 
            
2024-02-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '274874'
                WHERE ordernumber = 'P190216112730218' 
            
2024-02-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377350'
                WHERE ordernumber = 'P420216112735620' 
            
2024-02-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '236358'
                WHERE ordernumber = 'P180216112749246' 
            
2024-02-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377418'
                WHERE ordernumber = 'P190216113143964' 
            
2024-02-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377419'
                WHERE ordernumber = 'P180216113447537' 
            
2024-02-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '365462'
                WHERE ordernumber = 'P200216113624880' 
            
2024-02-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377420'
                WHERE ordernumber = 'P180216113854366' 
            
2024-02-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '367272'
                WHERE ordernumber = 'P190216113902225' 
            
2024-02-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377413'
                WHERE ordernumber = 'P190216114026567' 
            
2024-02-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377413'
                WHERE ordernumber = 'P190216114057437' 
            
2024-02-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '135443'
                WHERE ordernumber = 'P190216114550668' 
            
2024-02-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355013'
                WHERE ordernumber = 'P420216114734707' 
            
2024-02-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377400'
                WHERE ordernumber = 'P190216114804934' 
            
2024-02-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377400'
                WHERE ordernumber = 'P190216114832810' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81433'
                WHERE ordernumber = 'P200216114858544' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '265425'
                WHERE ordernumber = 'P190216115117767' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '294394'
                WHERE ordernumber = 'P200216115655347' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313201'
                WHERE ordernumber = 'P180216115703178' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93882'
                WHERE ordernumber = 'P200216115743740' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '375613'
                WHERE ordernumber = 'P190216115746421' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377422'
                WHERE ordernumber = 'P420216115755648' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93619'
                WHERE ordernumber = 'P190216115850536' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101887'
                WHERE ordernumber = 'P190216115959955' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '39552'
                WHERE ordernumber = 'P420216120026769' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351132'
                WHERE ordernumber = 'P190216120144936' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377423'
                WHERE ordernumber = 'P200216120341479' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359360'
                WHERE ordernumber = 'P200216120445363' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377424'
                WHERE ordernumber = 'P200216120607676' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377425'
                WHERE ordernumber = 'P190216120916197' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '332742'
                WHERE ordernumber = 'P190216121107343' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98566'
                WHERE ordernumber = 'P200216121227128' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377427'
                WHERE ordernumber = 'P190216121901309' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377429'
                WHERE ordernumber = 'P200216121914505' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337435'
                WHERE ordernumber = 'P190216122019304' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377430'
                WHERE ordernumber = 'P200216122223823' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377431'
                WHERE ordernumber = 'P180216122442526' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377432'
                WHERE ordernumber = 'P180216122733139' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '318716'
                WHERE ordernumber = 'P420216122848577' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377433'
                WHERE ordernumber = 'P180216123117411' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358802'
                WHERE ordernumber = 'P180216123817314' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103775'
                WHERE ordernumber = 'P180216123941849' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '260405'
                WHERE ordernumber = 'P200216124020127' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377435'
                WHERE ordernumber = 'P200216124128739' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377436'
                WHERE ordernumber = 'P180216124151788' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '375374'
                WHERE ordernumber = 'P200216124803375' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '258516'
                WHERE ordernumber = 'P200216124927370' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377437'
                WHERE ordernumber = 'P180216125204798' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377438'
                WHERE ordernumber = 'P190216125219986' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '143625'
                WHERE ordernumber = 'P180216125341388' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '136257'
                WHERE ordernumber = 'P200216125743789' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377441'
                WHERE ordernumber = 'P420216130230284' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100450'
                WHERE ordernumber = 'P180216130236175' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377442'
                WHERE ordernumber = 'P200216130239910' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100450'
                WHERE ordernumber = 'P180216130313520' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348545'
                WHERE ordernumber = 'P420216130405242' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377444'
                WHERE ordernumber = 'P200216130703178' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283493'
                WHERE ordernumber = 'P180216130748931' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '375470'
                WHERE ordernumber = 'P420216131004321' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377445'
                WHERE ordernumber = 'P200216131104408' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239464'
                WHERE ordernumber = 'P200216131150660' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377446'
                WHERE ordernumber = 'P200216131811945' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377447'
                WHERE ordernumber = 'P420216131851239' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377443'
                WHERE ordernumber = 'P180216132118386' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377449'
                WHERE ordernumber = 'P420216132158705' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98836'
                WHERE ordernumber = 'P420216132246698' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '274955'
                WHERE ordernumber = 'P180216132334695' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377450'
                WHERE ordernumber = 'P420216132348608' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '233829'
                WHERE ordernumber = 'P200216132444646' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '227260'
                WHERE ordernumber = 'P180216132657714' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359332'
                WHERE ordernumber = 'P200216132750278' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351928'
                WHERE ordernumber = 'P420216133343700' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377452'
                WHERE ordernumber = 'P420216133651806' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99633'
                WHERE ordernumber = 'P180216134209472' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377453'
                WHERE ordernumber = 'P180216134325478' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '335369'
                WHERE ordernumber = 'P200216134522548' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377454'
                WHERE ordernumber = 'P420216134547639' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377456'
                WHERE ordernumber = 'P420216134926844' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '80893'
                WHERE ordernumber = 'P200216135356242' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '322472'
                WHERE ordernumber = 'P200216135723669' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377440'
                WHERE ordernumber = 'P180216135842210' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377458'
                WHERE ordernumber = 'P420216140308269' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298962'
                WHERE ordernumber = 'P200216140912873' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350995'
                WHERE ordernumber = 'P200216141221571' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377460'
                WHERE ordernumber = 'P200216142248751' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '229232'
                WHERE ordernumber = 'P180216142407495' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275581'
                WHERE ordernumber = 'P200216142538753' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377461'
                WHERE ordernumber = 'P180216142543210' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298892'
                WHERE ordernumber = 'P420216142551863' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298892'
                WHERE ordernumber = 'P420216142701720' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301300'
                WHERE ordernumber = 'P180216142758293' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350586'
                WHERE ordernumber = 'P180216142939592' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277595'
                WHERE ordernumber = 'P420216143128286' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377217'
                WHERE ordernumber = 'P200216143453724' 
            
2024-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277377'
                WHERE ordernumber = 'P200216144028989' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377463'
                WHERE ordernumber = 'P200216144347960' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '252847'
                WHERE ordernumber = 'P420216144559980' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '373399'
                WHERE ordernumber = 'P420216144841260' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377463'
                WHERE ordernumber = 'P200216144846962' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342475'
                WHERE ordernumber = 'P420216145055891' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377217'
                WHERE ordernumber = 'P200216145339166' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '331715'
                WHERE ordernumber = 'P190216150249361' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '259875'
                WHERE ordernumber = 'P200216150915270' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347940'
                WHERE ordernumber = 'P420216151042238' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377467'
                WHERE ordernumber = 'P200216151142967' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '239380'
                WHERE ordernumber = 'P180216151404706' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377468'
                WHERE ordernumber = 'P200216151507176' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '274941'
                WHERE ordernumber = 'P200216151547639' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '209575'
                WHERE ordernumber = 'P180216151702315' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377469'
                WHERE ordernumber = 'P200216152219262' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377470'
                WHERE ordernumber = 'P420216152353695' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377472'
                WHERE ordernumber = 'P200216152403694' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '373835'
                WHERE ordernumber = 'P200216152434500' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377475'
                WHERE ordernumber = 'P180216153124976' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377476'
                WHERE ordernumber = 'P180216153334939' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377477'
                WHERE ordernumber = 'P180216153648713' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245076'
                WHERE ordernumber = 'P180216153914771' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377479'
                WHERE ordernumber = 'P180216154104668' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377480'
                WHERE ordernumber = 'P190216154206306' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '363198'
                WHERE ordernumber = 'P180216154250631' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377481'
                WHERE ordernumber = 'P180216155100858' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282810'
                WHERE ordernumber = 'P200216155240680' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377482'
                WHERE ordernumber = 'P180216155316575' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377483'
                WHERE ordernumber = 'P200216155340732' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377484'
                WHERE ordernumber = 'P200216155426184' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '248154'
                WHERE ordernumber = 'P180216155703599' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245513'
                WHERE ordernumber = 'P180216160004149' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377402'
                WHERE ordernumber = 'P200216160421164' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275129'
                WHERE ordernumber = 'P180216160443667' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377486'
                WHERE ordernumber = 'P180216160759658' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377487'
                WHERE ordernumber = 'P190216160815175' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '212686'
                WHERE ordernumber = 'P190216160930430' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377488'
                WHERE ordernumber = 'P180216161030547' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100925'
                WHERE ordernumber = 'P200216161055706' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306044'
                WHERE ordernumber = 'P420216161302223' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377489'
                WHERE ordernumber = 'P420216161431963' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '167601'
                WHERE ordernumber = 'P200216161532370' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337234'
                WHERE ordernumber = 'P200216161715682' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371701'
                WHERE ordernumber = 'P190216161816549' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377492'
                WHERE ordernumber = 'P190216162544483' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '108214'
                WHERE ordernumber = 'P190216162738551' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284493'
                WHERE ordernumber = 'P190216163045998' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '220763'
                WHERE ordernumber = 'P190216163346225' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377494'
                WHERE ordernumber = 'P200216163450604' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377495'
                WHERE ordernumber = 'P190216163510923' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '233829'
                WHERE ordernumber = 'P200216163530530' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '93266'
                WHERE ordernumber = 'P190216163612693' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '376044'
                WHERE ordernumber = 'P190216163743813' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '131195'
                WHERE ordernumber = 'P190216163826767' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377496'
                WHERE ordernumber = 'P190216163925547' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '264535'
                WHERE ordernumber = 'P420216164316595' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '95844'
                WHERE ordernumber = 'P200216164406620' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '158233'
                WHERE ordernumber = 'P200216164447674' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100338'
                WHERE ordernumber = 'P200216164646348' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '280693'
                WHERE ordernumber = 'P190216164955932' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377499'
                WHERE ordernumber = 'P200216165502907' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310246'
                WHERE ordernumber = 'P200216165611488' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377500'
                WHERE ordernumber = 'P420216165649355' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377501'
                WHERE ordernumber = 'P200216165725534' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '376128'
                WHERE ordernumber = 'P190216170136342' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377502'
                WHERE ordernumber = 'P420216170140114' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '279538'
                WHERE ordernumber = 'P200216170658358' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340093'
                WHERE ordernumber = 'P200216170849960' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377504'
                WHERE ordernumber = 'P420216171214877' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '242248'
                WHERE ordernumber = 'P420216171420685' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99468'
                WHERE ordernumber = 'P200216171545118' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377505'
                WHERE ordernumber = 'P200216171734792' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '215207'
                WHERE ordernumber = 'P420216171902901' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '133727'
                WHERE ordernumber = 'P420216172202788' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276899'
                WHERE ordernumber = 'P200216172458118' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377510'
                WHERE ordernumber = 'P200216172913475' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277905'
                WHERE ordernumber = 'P420216173621917' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377512'
                WHERE ordernumber = 'P190216173947353' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377513'
                WHERE ordernumber = 'P420216173954363' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '128999'
                WHERE ordernumber = 'P190216174043412' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345175'
                WHERE ordernumber = 'P190216174307585' 
            
2024-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356589'
                WHERE ordernumber = 'P200216174314500' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377515'
                WHERE ordernumber = 'P420216174331557' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377516'
                WHERE ordernumber = 'P200216174500335' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377517'
                WHERE ordernumber = 'P420216174616704' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '267562'
                WHERE ordernumber = 'P200216174639188' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377518'
                WHERE ordernumber = 'P420216174754442' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377521'
                WHERE ordernumber = 'P190216175056531' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377522'
                WHERE ordernumber = 'P420216175125327' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '226174'
                WHERE ordernumber = 'P200216175308192' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377524'
                WHERE ordernumber = 'P200216175657245' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '216942'
                WHERE ordernumber = 'P180216175707292' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '160428'
                WHERE ordernumber = 'P190216175945300' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377525'
                WHERE ordernumber = 'P420216180156226' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377526'
                WHERE ordernumber = 'P420216180406147' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377511'
                WHERE ordernumber = 'P190216180615398' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377527'
                WHERE ordernumber = 'P200216181001892' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '146262'
                WHERE ordernumber = 'P190216181324250' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '127955'
                WHERE ordernumber = 'P190216181637501' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377528'
                WHERE ordernumber = 'P420216181930588' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '96012'
                WHERE ordernumber = 'P200216182136633' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '209287'
                WHERE ordernumber = 'P190216182211997' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377529'
                WHERE ordernumber = 'P200216182316587' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377530'
                WHERE ordernumber = 'P190216182639229' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377531'
                WHERE ordernumber = 'P420216182719564' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377532'
                WHERE ordernumber = 'P190216182751128' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377534'
                WHERE ordernumber = 'P190216182852922' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '365227'
                WHERE ordernumber = 'P200216183210782' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '282143'
                WHERE ordernumber = 'P200216183306172' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '357924'
                WHERE ordernumber = 'P200216183338638' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377535'
                WHERE ordernumber = 'P200216183604943' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377537'
                WHERE ordernumber = 'P200216183719679' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377539'
                WHERE ordernumber = 'P200216183755699' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358884'
                WHERE ordernumber = 'P190216183846320' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377540'
                WHERE ordernumber = 'P200216183925159' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351195'
                WHERE ordernumber = 'P200216184212188' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377535'
                WHERE ordernumber = 'P200216184243774' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377535'
                WHERE ordernumber = 'P200216184427707' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '374404'
                WHERE ordernumber = 'P420216184426811' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '258156'
                WHERE ordernumber = 'P180216184535729' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377542'
                WHERE ordernumber = 'P200216184543472' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '258156'
                WHERE ordernumber = 'P180216184617778' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377541'
                WHERE ordernumber = 'P200216184627947' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377543'
                WHERE ordernumber = 'P180216184757593' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349123'
                WHERE ordernumber = 'P190216185306642' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377544'
                WHERE ordernumber = 'P200216185523870' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377545'
                WHERE ordernumber = 'P200216185616564' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '98900'
                WHERE ordernumber = 'P190216190339475' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377547'
                WHERE ordernumber = 'P200216191015974' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377548'
                WHERE ordernumber = 'P190216191122487' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377549'
                WHERE ordernumber = 'P420216191545352' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '364742'
                WHERE ordernumber = 'P420216191804794' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '302050'
                WHERE ordernumber = 'P200216191839351' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '240328'
                WHERE ordernumber = 'P190216191846555' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '215827'
                WHERE ordernumber = 'P190216191929481' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '375527'
                WHERE ordernumber = 'P190216192635226' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '271182'
                WHERE ordernumber = 'P190216192717785' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377550'
                WHERE ordernumber = 'P190216193013737' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377551'
                WHERE ordernumber = 'P190216193253136' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '340836'
                WHERE ordernumber = 'P420216193304391' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '236183'
                WHERE ordernumber = 'P190216193624359' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '236183'
                WHERE ordernumber = 'P190216193742493' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377552'
                WHERE ordernumber = 'P420216194153262' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377538'
                WHERE ordernumber = 'P190216195320924' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '376566'
                WHERE ordernumber = 'P190216195602963' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377428'
                WHERE ordernumber = 'P190216195657682' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377554'
                WHERE ordernumber = 'P190216200303616' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '208650'
                WHERE ordernumber = 'P190216200433114' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377556'
                WHERE ordernumber = 'P190216200647388' 
            
2024-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377554'
                WHERE ordernumber = 'P190216200746246'