2024-01-18 01:00:03 -- 將會員中心id寫入data-lake
2024-01-18 01:00:03 -- 
            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-17%';
        
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '333580'
                WHERE ordernumber = 'P420117110145695' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '166544'
                WHERE ordernumber = 'P200117110340203' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367838'
                WHERE ordernumber = 'P180117110353368' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367839'
                WHERE ordernumber = 'P420117110430225' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342792'
                WHERE ordernumber = 'P180117110520954' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367842'
                WHERE ordernumber = 'P190117110548428' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367841'
                WHERE ordernumber = 'P200117110612559' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98293'
                WHERE ordernumber = 'P200117110650664' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '125423'
                WHERE ordernumber = 'P180117110714324' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239475'
                WHERE ordernumber = 'P180117110809831' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367844'
                WHERE ordernumber = 'P200117110844586' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367844'
                WHERE ordernumber = 'P200117110922642' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '363301'
                WHERE ordernumber = 'P190117110934900' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239481'
                WHERE ordernumber = 'P180117110935438' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '222823'
                WHERE ordernumber = 'P180117111021210' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299765'
                WHERE ordernumber = 'P200117111043345' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367845'
                WHERE ordernumber = 'P180117111128282' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362901'
                WHERE ordernumber = 'P180117111247810' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367204'
                WHERE ordernumber = 'P200117111321537' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362901'
                WHERE ordernumber = 'P180117111334608' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101282'
                WHERE ordernumber = 'P180117111426637' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367850'
                WHERE ordernumber = 'P200117111455868' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367851'
                WHERE ordernumber = 'P180117111526121' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367852'
                WHERE ordernumber = 'P190117111532896' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367849'
                WHERE ordernumber = 'P420117111543411' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365357'
                WHERE ordernumber = 'P180117111730690' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365357'
                WHERE ordernumber = 'P180117111759547' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367855'
                WHERE ordernumber = 'P200117111813421' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367859'
                WHERE ordernumber = 'P420117111949761' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277535'
                WHERE ordernumber = 'P180117112337274' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160734'
                WHERE ordernumber = 'P200117112441820' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93882'
                WHERE ordernumber = 'P200117112659779' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365116'
                WHERE ordernumber = 'P190117112746984' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96628'
                WHERE ordernumber = 'P180117112752734' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '106210'
                WHERE ordernumber = 'P200117112805831' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367866'
                WHERE ordernumber = 'P200117112937234' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367865'
                WHERE ordernumber = 'P420117113020964' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367867'
                WHERE ordernumber = 'P180117113113975' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '335158'
                WHERE ordernumber = 'P420117113142645' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367868'
                WHERE ordernumber = 'P200117113216779' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307514'
                WHERE ordernumber = 'P200117113314218' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314391'
                WHERE ordernumber = 'P180117113337646' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367869'
                WHERE ordernumber = 'P180117113519140' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '155895'
                WHERE ordernumber = 'P200117113601560' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367871'
                WHERE ordernumber = 'P180117113609375' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180117113640473' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344250'
                WHERE ordernumber = 'P180117113924171' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349143'
                WHERE ordernumber = 'P180117114105615' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349143'
                WHERE ordernumber = 'P180117114159611' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '295092'
                WHERE ordernumber = 'P180117114236598' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367876'
                WHERE ordernumber = 'P200117114348522' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '104690'
                WHERE ordernumber = 'P180117114540270' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367877'
                WHERE ordernumber = 'P180117114643533' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302835'
                WHERE ordernumber = 'P180117114700844' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367879'
                WHERE ordernumber = 'P420117114748857' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '288246'
                WHERE ordernumber = 'P180117114841261' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '259061'
                WHERE ordernumber = 'P200117114921153' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '259061'
                WHERE ordernumber = 'P200117115005645' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349444'
                WHERE ordernumber = 'P420117115020513' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282195'
                WHERE ordernumber = 'P180117115157576' 
            
2024-01-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '143087'
                WHERE ordernumber = 'P200117115420491' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367886'
                WHERE ordernumber = 'P200117115748950' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367887'
                WHERE ordernumber = 'P420117115841379' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367888'
                WHERE ordernumber = 'P180117115915527' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367889'
                WHERE ordernumber = 'P420117115955831' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367890'
                WHERE ordernumber = 'P190117120114878' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367890'
                WHERE ordernumber = 'P190117120133691' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367893'
                WHERE ordernumber = 'P420117120139566' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367895'
                WHERE ordernumber = 'P200117120150990' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367896'
                WHERE ordernumber = 'P420117120322486' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349010'
                WHERE ordernumber = 'P180117120322523' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '118908'
                WHERE ordernumber = 'P180117120416429' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367890'
                WHERE ordernumber = 'P190117120429212' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '311532'
                WHERE ordernumber = 'P180117120723250' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356304'
                WHERE ordernumber = 'P420117120954223' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367900'
                WHERE ordernumber = 'P180117121045786' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367901'
                WHERE ordernumber = 'P180117121242397' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367902'
                WHERE ordernumber = 'P180117121357238' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367903'
                WHERE ordernumber = 'P420117121549558' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302698'
                WHERE ordernumber = 'P200117121641522' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367904'
                WHERE ordernumber = 'P200117121731600' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367905'
                WHERE ordernumber = 'P180117121759712' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367906'
                WHERE ordernumber = 'P420117121843757' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '235594'
                WHERE ordernumber = 'P200117121911589' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '327891'
                WHERE ordernumber = 'P200117122030459' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '119332'
                WHERE ordernumber = 'P180117122044990' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367907'
                WHERE ordernumber = 'P180117122216621' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98869'
                WHERE ordernumber = 'P200117122233431' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367911'
                WHERE ordernumber = 'P180117122409235' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367914'
                WHERE ordernumber = 'P180117122552839' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367915'
                WHERE ordernumber = 'P420117122651356' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '125859'
                WHERE ordernumber = 'P200117122702430' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '111709'
                WHERE ordernumber = 'P190117122715485' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '363084'
                WHERE ordernumber = 'P420117122740806' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367916'
                WHERE ordernumber = 'P180117122758873' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '107267'
                WHERE ordernumber = 'P180117123026148' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367919'
                WHERE ordernumber = 'P420117123042790' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367921'
                WHERE ordernumber = 'P180117123156180' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348065'
                WHERE ordernumber = 'P420117123456958' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '268747'
                WHERE ordernumber = 'P180117123526449' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94344'
                WHERE ordernumber = 'P180117123639558' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102068'
                WHERE ordernumber = 'P180117123730269' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367924'
                WHERE ordernumber = 'P420117123740349' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367926'
                WHERE ordernumber = 'P200117123748143' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '338997'
                WHERE ordernumber = 'P420117123948471' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237882'
                WHERE ordernumber = 'P200117124005660' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367381'
                WHERE ordernumber = 'P180117124048476' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343632'
                WHERE ordernumber = 'P420117124103714' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367381'
                WHERE ordernumber = 'P180117124110200' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367928'
                WHERE ordernumber = 'P200117124153587' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367929'
                WHERE ordernumber = 'P180117124206712' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367913'
                WHERE ordernumber = 'P180117124422724' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '296906'
                WHERE ordernumber = 'P420117124442313' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '64196'
                WHERE ordernumber = 'P180117124534293' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343394'
                WHERE ordernumber = 'P180117124932557' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '206334'
                WHERE ordernumber = 'P200117124940891' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '58925'
                WHERE ordernumber = 'P420117125217670' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367938'
                WHERE ordernumber = 'P200117125342945' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '233714'
                WHERE ordernumber = 'P180117125357474' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367940'
                WHERE ordernumber = 'P200117125601858' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '300343'
                WHERE ordernumber = 'P420117125601389' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367943'
                WHERE ordernumber = 'P180117125901441' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367945'
                WHERE ordernumber = 'P420117130210514' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367947'
                WHERE ordernumber = 'P420117130327642' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367948'
                WHERE ordernumber = 'P180117130338575' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367951'
                WHERE ordernumber = 'P420117130445272' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '295662'
                WHERE ordernumber = 'P180117130504471' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '223274'
                WHERE ordernumber = 'P200117130547620' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367952'
                WHERE ordernumber = 'P180117130612260' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '135191'
                WHERE ordernumber = 'P420117130622528' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '66860'
                WHERE ordernumber = 'P180117130701958' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367948'
                WHERE ordernumber = 'P180117130830690' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '267583'
                WHERE ordernumber = 'P190117130918916' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367956'
                WHERE ordernumber = 'P180117130927861' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '223274'
                WHERE ordernumber = 'P200117130950879' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367957'
                WHERE ordernumber = 'P180117131017281' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348046'
                WHERE ordernumber = 'P180117131116405' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '209646'
                WHERE ordernumber = 'P180117131303470' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350525'
                WHERE ordernumber = 'P180117131401114' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '214263'
                WHERE ordernumber = 'P200117131407581' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97934'
                WHERE ordernumber = 'P180117131459280' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367959'
                WHERE ordernumber = 'P200117131623968' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367960'
                WHERE ordernumber = 'P200117131734392' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367962'
                WHERE ordernumber = 'P200117131836875' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '74778'
                WHERE ordernumber = 'P200117132056793' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '48124'
                WHERE ordernumber = 'P200117132154339' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230520'
                WHERE ordernumber = 'P200117132412455' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367154'
                WHERE ordernumber = 'P180117132453716' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '148715'
                WHERE ordernumber = 'P190117132507772' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367154'
                WHERE ordernumber = 'P180117132552711' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367966'
                WHERE ordernumber = 'P420117132600392' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367948'
                WHERE ordernumber = 'P180117132631174' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282566'
                WHERE ordernumber = 'P200117132743839' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367970'
                WHERE ordernumber = 'P180117132851718' 
            
2024-01-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367969'
                WHERE ordernumber = 'P190117132900391' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '367948'
                WHERE ordernumber = 'P180117132920748' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '348263'
                WHERE ordernumber = 'P420117133035863' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '367972'
                WHERE ordernumber = 'P420117133131699' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '347211'
                WHERE ordernumber = 'P420117133417771' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '208602'
                WHERE ordernumber = 'P420117133514690' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '367974'
                WHERE ordernumber = 'P420117133637922' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '367975'
                WHERE ordernumber = 'P200117133735281' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '367979'
                WHERE ordernumber = 'P420117133837287' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '367978'
                WHERE ordernumber = 'P200117133851815' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '222698'
                WHERE ordernumber = 'P180117134125532' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '367980'
                WHERE ordernumber = 'P200117134130150' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '367978'
                WHERE ordernumber = 'P200117134156603' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '344831'
                WHERE ordernumber = 'P180117134217788' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '302684'
                WHERE ordernumber = 'P180117134305253' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '300256'
                WHERE ordernumber = 'P180117134344152' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '277541'
                WHERE ordernumber = 'P200117134516932' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '367983'
                WHERE ordernumber = 'P420117134817692' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '367985'
                WHERE ordernumber = 'P200117135002683' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '367986'
                WHERE ordernumber = 'P180117135048579' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '367983'
                WHERE ordernumber = 'P420117135126191' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '367987'
                WHERE ordernumber = 'P180117135149471' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '367988'
                WHERE ordernumber = 'P200117135233522' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '64196'
                WHERE ordernumber = 'P180117135240410' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '231119'
                WHERE ordernumber = 'P420117135335238' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '367989'
                WHERE ordernumber = 'P200117135439174' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '367990'
                WHERE ordernumber = 'P180117135441296' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '367991'
                WHERE ordernumber = 'P180117135659483' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '367994'
                WHERE ordernumber = 'P180117135846840' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '367993'
                WHERE ordernumber = 'P420117135847620' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '284057'
                WHERE ordernumber = 'P200117140057646' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '60067'
                WHERE ordernumber = 'P200117140151621' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '367995'
                WHERE ordernumber = 'P180117140224574' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '157095'
                WHERE ordernumber = 'P200117140640751' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368000'
                WHERE ordernumber = 'P180117140753762' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '116854'
                WHERE ordernumber = 'P200117140913992' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '85645'
                WHERE ordernumber = 'P200117141053840' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368002'
                WHERE ordernumber = 'P180117141055267' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '235838'
                WHERE ordernumber = 'P200117141138538' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '230436'
                WHERE ordernumber = 'P190117141252747' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368004'
                WHERE ordernumber = 'P180117141400905' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '367443'
                WHERE ordernumber = 'P200117141456857' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368007'
                WHERE ordernumber = 'P180117141647732' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368009'
                WHERE ordernumber = 'P200117141652711' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368008'
                WHERE ordernumber = 'P420117141718262' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368010'
                WHERE ordernumber = 'P180117141742898' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368011'
                WHERE ordernumber = 'P200117141841730' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368012'
                WHERE ordernumber = 'P180117141943545' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '286314'
                WHERE ordernumber = 'P180117142028294' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '333734'
                WHERE ordernumber = 'P200117142050293' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '180119'
                WHERE ordernumber = 'P420117142109649' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368017'
                WHERE ordernumber = 'P180117142456540' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368015'
                WHERE ordernumber = 'P420117142541537' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368023'
                WHERE ordernumber = 'P420117142734899' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368024'
                WHERE ordernumber = 'P180117142811291' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '323315'
                WHERE ordernumber = 'P200117142914892' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368026'
                WHERE ordernumber = 'P200117143023317' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368028'
                WHERE ordernumber = 'P180117143101518' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368029'
                WHERE ordernumber = 'P200117143137487' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '247363'
                WHERE ordernumber = 'P200117143312386' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368030'
                WHERE ordernumber = 'P180117143404643' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '266342'
                WHERE ordernumber = 'P180117143456248' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '80916'
                WHERE ordernumber = 'P200117143540634' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368034'
                WHERE ordernumber = 'P180117143724268' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368035'
                WHERE ordernumber = 'P420117143812461' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368037'
                WHERE ordernumber = 'P200117143934707' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '81113'
                WHERE ordernumber = 'P200117144010418' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368038'
                WHERE ordernumber = 'P180117144014367' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '135863'
                WHERE ordernumber = 'P420117144045877' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368038'
                WHERE ordernumber = 'P180117144056123' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368040'
                WHERE ordernumber = 'P200117144134311' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '264650'
                WHERE ordernumber = 'P180117144218370' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '342180'
                WHERE ordernumber = 'P200117144229798' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '359064'
                WHERE ordernumber = 'P200117144314557' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '142248'
                WHERE ordernumber = 'P180117144534606' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368042'
                WHERE ordernumber = 'P420117144814204' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '169751'
                WHERE ordernumber = 'P180117144817829' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368046'
                WHERE ordernumber = 'P180117145032436' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '302190'
                WHERE ordernumber = 'P200117145146164' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '151341'
                WHERE ordernumber = 'P200117145255952' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368049'
                WHERE ordernumber = 'P180117145314635' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '83903'
                WHERE ordernumber = 'P200117145340575' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '367211'
                WHERE ordernumber = 'P200117145903447' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368044'
                WHERE ordernumber = 'P180117145904204' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368044'
                WHERE ordernumber = 'P180117145931960' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368053'
                WHERE ordernumber = 'P420117150126630' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '363423'
                WHERE ordernumber = 'P180117150324453' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368055'
                WHERE ordernumber = 'P200117150424978' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368057'
                WHERE ordernumber = 'P180117150609459' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368056'
                WHERE ordernumber = 'P200117150630604' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368058'
                WHERE ordernumber = 'P180117150721969' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355384'
                WHERE ordernumber = 'P200117150809774' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '363838'
                WHERE ordernumber = 'P420117150904183' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368063'
                WHERE ordernumber = 'P200117150906186' 
            
2024-01-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368065'
                WHERE ordernumber = 'P200117151019743' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368068'
                WHERE ordernumber = 'P180117151102898' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368070'
                WHERE ordernumber = 'P420117151131948' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '275812'
                WHERE ordernumber = 'P180117151147721' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368073'
                WHERE ordernumber = 'P200117151318692' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '312854'
                WHERE ordernumber = 'P200117151924384' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368076'
                WHERE ordernumber = 'P180117151929714' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368078'
                WHERE ordernumber = 'P180117152029987' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '291523'
                WHERE ordernumber = 'P200117152034727' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '239510'
                WHERE ordernumber = 'P200117152227734' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368081'
                WHERE ordernumber = 'P180117152438646' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '66007'
                WHERE ordernumber = 'P180117152531885' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368082'
                WHERE ordernumber = 'P420117152532408' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '229003'
                WHERE ordernumber = 'P200117152557918' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368083'
                WHERE ordernumber = 'P420117152718438' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368084'
                WHERE ordernumber = 'P180117152726617' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '245864'
                WHERE ordernumber = 'P180117152816359' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '226007'
                WHERE ordernumber = 'P200117152859599' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368085'
                WHERE ordernumber = 'P180117152922542' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368086'
                WHERE ordernumber = 'P420117152948299' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '121704'
                WHERE ordernumber = 'P180117153018706' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '311517'
                WHERE ordernumber = 'P180117153118463' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368087'
                WHERE ordernumber = 'P420117153118610' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '237174'
                WHERE ordernumber = 'P200117153122445' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '79509'
                WHERE ordernumber = 'P180117153135931' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368088'
                WHERE ordernumber = 'P420117153225758' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '363974'
                WHERE ordernumber = 'P180117153232595' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '222809'
                WHERE ordernumber = 'P180117153332465' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '299702'
                WHERE ordernumber = 'P420117153355748' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '167062'
                WHERE ordernumber = 'P180117153450235' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368089'
                WHERE ordernumber = 'P180117153741579' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368091'
                WHERE ordernumber = 'P180117153849759' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368090'
                WHERE ordernumber = 'P420117153910894' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352096'
                WHERE ordernumber = 'P180117154120290' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '168270'
                WHERE ordernumber = 'P200117154516858' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368093'
                WHERE ordernumber = 'P180117154529723' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '329277'
                WHERE ordernumber = 'P200117154619837' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '227710'
                WHERE ordernumber = 'P200117154754496' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368097'
                WHERE ordernumber = 'P420117154807677' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368098'
                WHERE ordernumber = 'P180117154958620' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368099'
                WHERE ordernumber = 'P420117155127484' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '276443'
                WHERE ordernumber = 'P180117155328767' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '360768'
                WHERE ordernumber = 'P420117155402683' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368102'
                WHERE ordernumber = 'P420117155536642' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368104'
                WHERE ordernumber = 'P180117155610904' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '211708'
                WHERE ordernumber = 'P420117155705530' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '276443'
                WHERE ordernumber = 'P180117155706830' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368105'
                WHERE ordernumber = 'P420117155822717' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '207299'
                WHERE ordernumber = 'P180117155850766' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368107'
                WHERE ordernumber = 'P180117155943678' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '221802'
                WHERE ordernumber = 'P180117160233344' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368108'
                WHERE ordernumber = 'P420117160305674' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '121180'
                WHERE ordernumber = 'P180117160426878' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '98423'
                WHERE ordernumber = 'P200117160500228' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368109'
                WHERE ordernumber = 'P420117160508719' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368111'
                WHERE ordernumber = 'P420117160636554' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368112'
                WHERE ordernumber = 'P420117160820958' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '288367'
                WHERE ordernumber = 'P200117161122510' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '266373'
                WHERE ordernumber = 'P200117161424886' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368116'
                WHERE ordernumber = 'P180117161453279' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '241210'
                WHERE ordernumber = 'P200117161631578' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '167252'
                WHERE ordernumber = 'P180117161702985' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '362367'
                WHERE ordernumber = 'P420117161920824' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368117'
                WHERE ordernumber = 'P180117161945515' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '323501'
                WHERE ordernumber = 'P180117162050714' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '78115'
                WHERE ordernumber = 'P200117162114785' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '236627'
                WHERE ordernumber = 'P200117162147386' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368120'
                WHERE ordernumber = 'P180117162208316' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368122'
                WHERE ordernumber = 'P200117162519318' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '160130'
                WHERE ordernumber = 'P180117162548989' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368123'
                WHERE ordernumber = 'P200117162644525' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368125'
                WHERE ordernumber = 'P180117162749143' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '367683'
                WHERE ordernumber = 'P180117162923178' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368128'
                WHERE ordernumber = 'P200117163040119' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368130'
                WHERE ordernumber = 'P200117163136169' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368129'
                WHERE ordernumber = 'P420117163150689' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '235005'
                WHERE ordernumber = 'P420117163319861' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368133'
                WHERE ordernumber = 'P420117163423298' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368136'
                WHERE ordernumber = 'P420117163830455' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '116809'
                WHERE ordernumber = 'P180117163937439' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368125'
                WHERE ordernumber = 'P180117164045897' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '343585'
                WHERE ordernumber = 'P180117164224152' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368137'
                WHERE ordernumber = 'P180117164310974' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368138'
                WHERE ordernumber = 'P180117164417781' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '346119'
                WHERE ordernumber = 'P420117164426701' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '102337'
                WHERE ordernumber = 'P180117164502592' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '325003'
                WHERE ordernumber = 'P180117164616488' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368144'
                WHERE ordernumber = 'P420117164625948' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368145'
                WHERE ordernumber = 'P420117164839867' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '317282'
                WHERE ordernumber = 'P180117164854653' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368148'
                WHERE ordernumber = 'P200117164935299' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '304783'
                WHERE ordernumber = 'P180117165109982' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368129'
                WHERE ordernumber = 'P420117165118865' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '354950'
                WHERE ordernumber = 'P180117165259762' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368151'
                WHERE ordernumber = 'P420117165310677' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368152'
                WHERE ordernumber = 'P200117165328792' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368152'
                WHERE ordernumber = 'P200117165416420' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '74953'
                WHERE ordernumber = 'P180117165514583' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368155'
                WHERE ordernumber = 'P200117165730949' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '97821'
                WHERE ordernumber = 'P200117170022761' 
            
2024-01-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '99477'
                WHERE ordernumber = 'P180117170202880' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '99477'
                WHERE ordernumber = 'P180117170243312' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '350391'
                WHERE ordernumber = 'P200117170319199' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '356006'
                WHERE ordernumber = 'P180117170322215' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '353989'
                WHERE ordernumber = 'P180117170429904' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '368161'
                WHERE ordernumber = 'P420117170618497' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '309762'
                WHERE ordernumber = 'P180117170710868' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '156166'
                WHERE ordernumber = 'P200117171113675' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '344347'
                WHERE ordernumber = 'P180117171245582' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '368164'
                WHERE ordernumber = 'P200117171316563' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '360673'
                WHERE ordernumber = 'P420117171359651' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '288589'
                WHERE ordernumber = 'P200117171440243' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '359309'
                WHERE ordernumber = 'P190117171449911' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '368106'
                WHERE ordernumber = 'P420117171858936' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '368168'
                WHERE ordernumber = 'P200117172205293' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '368169'
                WHERE ordernumber = 'P180117172334429' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '368172'
                WHERE ordernumber = 'P420117172712142' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '236299'
                WHERE ordernumber = 'P180117172948977' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '368173'
                WHERE ordernumber = 'P420117173015352' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '368176'
                WHERE ordernumber = 'P200117173120247' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '368177'
                WHERE ordernumber = 'P420117173634413' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '350338'
                WHERE ordernumber = 'P180117173639728' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '340558'
                WHERE ordernumber = 'P180117173931316' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '232645'
                WHERE ordernumber = 'P200117174045710' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '95916'
                WHERE ordernumber = 'P200117174202600' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '368180'
                WHERE ordernumber = 'P180117174345696' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '368180'
                WHERE ordernumber = 'P180117174418646' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '368184'
                WHERE ordernumber = 'P420117174623417' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '368185'
                WHERE ordernumber = 'P180117174757365' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '326214'
                WHERE ordernumber = 'P180117174914466' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '367614'
                WHERE ordernumber = 'P420117174919119' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '368189'
                WHERE ordernumber = 'P200117175004928' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '194301'
                WHERE ordernumber = 'P420117175021156' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '368190'
                WHERE ordernumber = 'P200117175130115' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '368191'
                WHERE ordernumber = 'P420117175202232' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '265788'
                WHERE ordernumber = 'P420117175345526' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '368193'
                WHERE ordernumber = 'P200117175509565' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '238530'
                WHERE ordernumber = 'P200117175617911' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '98423'
                WHERE ordernumber = 'P200117175709785' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '304086'
                WHERE ordernumber = 'P180117180116463' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '102922'
                WHERE ordernumber = 'P420117180246156' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '362346'
                WHERE ordernumber = 'P180117181457226' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '211877'
                WHERE ordernumber = 'P190117181549403' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '368200'
                WHERE ordernumber = 'P200117181552227' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '362346'
                WHERE ordernumber = 'P180117181558770' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '362346'
                WHERE ordernumber = 'P180117181617884' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '246402'
                WHERE ordernumber = 'P190117181618700' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '348962'
                WHERE ordernumber = 'P190117181931595' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '368204'
                WHERE ordernumber = 'P420117182012797' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '368205'
                WHERE ordernumber = 'P420117182128801' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '100508'
                WHERE ordernumber = 'P190117182205595' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '367480'
                WHERE ordernumber = 'P200117182250636' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '240659'
                WHERE ordernumber = 'P200117182339780' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '329191'
                WHERE ordernumber = 'P180117182536755' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '368207'
                WHERE ordernumber = 'P180117182707935' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '102419'
                WHERE ordernumber = 'P200117182947585' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '344471'
                WHERE ordernumber = 'P180117183505893' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '368214'
                WHERE ordernumber = 'P420117183516624' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '307262'
                WHERE ordernumber = 'P200117184243220' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '368215'
                WHERE ordernumber = 'P420117184313544' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '364901'
                WHERE ordernumber = 'P180117184343267' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '363319'
                WHERE ordernumber = 'P200117184456685' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '363319'
                WHERE ordernumber = 'P200117184654814' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '365755'
                WHERE ordernumber = 'P200117184903594' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '308789'
                WHERE ordernumber = 'P180117185048692' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '368223'
                WHERE ordernumber = 'P190117185103996' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '309439'
                WHERE ordernumber = 'P190117185610308' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '368225'
                WHERE ordernumber = 'P420117185610267' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '368229'
                WHERE ordernumber = 'P420117190225629' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '367562'
                WHERE ordernumber = 'P190117190828160' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '248858'
                WHERE ordernumber = 'P190117190950297' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '104173'
                WHERE ordernumber = 'P190117191047773' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '368238'
                WHERE ordernumber = 'P190117191230979' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '368239'
                WHERE ordernumber = 'P200117191242303' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '327735'
                WHERE ordernumber = 'P420117191423951' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '368242'
                WHERE ordernumber = 'P200117191435556' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '368242'
                WHERE ordernumber = 'P200117191521673' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '349208'
                WHERE ordernumber = 'P190117191758519' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '368243'
                WHERE ordernumber = 'P200117191824615' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '349208'
                WHERE ordernumber = 'P190117191851557' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '368244'
                WHERE ordernumber = 'P190117191954714' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '368245'
                WHERE ordernumber = 'P200117192125512' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '368246'
                WHERE ordernumber = 'P190117192140310' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '97683'
                WHERE ordernumber = 'P190117192600349' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '289730'
                WHERE ordernumber = 'P190117192704919' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '368254'
                WHERE ordernumber = 'P190117193014801' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '164161'
                WHERE ordernumber = 'P200117193016852' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '100566'
                WHERE ordernumber = 'P190117193341440' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '270515'
                WHERE ordernumber = 'P200117193446753' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '368256'
                WHERE ordernumber = 'P190117193517670' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '270515'
                WHERE ordernumber = 'P200117193604956' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '139402'
                WHERE ordernumber = 'P200117193858622' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '368260'
                WHERE ordernumber = 'P190117194219145' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '368263'
                WHERE ordernumber = 'P190117194721421' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '368263'
                WHERE ordernumber = 'P190117194801673' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '368264'
                WHERE ordernumber = 'P420117194925678' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '368266'
                WHERE ordernumber = 'P190117195101229' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '368270'
                WHERE ordernumber = 'P200117195330907' 
            
2024-01-18 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '368270'
                WHERE ordernumber = 'P200117195417582' 
            
2024-01-18 01:00:08 -- 
                UPDATE `omo_order_list` SET userId = '368271'
                WHERE ordernumber = 'P420117195440219' 
            
2024-01-18 01:00:08 -- 
                UPDATE `omo_order_list` SET userId = '80893'
                WHERE ordernumber = 'P200117195635721' 
            
2024-01-18 01:00:08 -- 
                UPDATE `omo_order_list` SET userId = '32787'
                WHERE ordernumber = 'P190117195752766'