2024-10-10 01:00:02 -- 將會員中心id寫入data-lake
2024-10-10 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-10-09%';
        
2024-10-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '162040'
                WHERE ordernumber = 'P631009104216303' 
            
2024-10-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '297128'
                WHERE ordernumber = 'P201009110256332' 
            
2024-10-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '95069'
                WHERE ordernumber = 'P181009110533171' 
            
2024-10-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424852'
                WHERE ordernumber = 'P181009110621739' 
            
2024-10-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424856'
                WHERE ordernumber = 'P191009110700749' 
            
2024-10-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424853'
                WHERE ordernumber = 'P181009110829834' 
            
2024-10-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424857'
                WHERE ordernumber = 'P421009110928409' 
            
2024-10-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371882'
                WHERE ordernumber = 'P421009111017189' 
            
2024-10-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '352165'
                WHERE ordernumber = 'P191009111040881' 
            
2024-10-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423406'
                WHERE ordernumber = 'P421009111702675' 
            
2024-10-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '339282'
                WHERE ordernumber = 'P421009111834428' 
            
2024-10-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424858'
                WHERE ordernumber = 'P181009111955419' 
            
2024-10-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377360'
                WHERE ordernumber = 'P201009112112935' 
            
2024-10-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424859'
                WHERE ordernumber = 'P711009112158164' 
            
2024-10-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '277012'
                WHERE ordernumber = 'P201009112221428' 
            
2024-10-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424860'
                WHERE ordernumber = 'P181009112327440' 
            
2024-10-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '232073'
                WHERE ordernumber = 'P181009112520829' 
            
2024-10-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424861'
                WHERE ordernumber = 'P181009112854419' 
            
2024-10-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '279244'
                WHERE ordernumber = 'P181009113103498' 
            
2024-10-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '324016'
                WHERE ordernumber = 'P181009113957111' 
            
2024-10-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424862'
                WHERE ordernumber = 'P201009114050329' 
            
2024-10-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387524'
                WHERE ordernumber = 'P181009114136405' 
            
2024-10-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424864'
                WHERE ordernumber = 'P201009114436152' 
            
2024-10-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387524'
                WHERE ordernumber = 'P181009114509582' 
            
2024-10-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424047'
                WHERE ordernumber = 'P201009114532967' 
            
2024-10-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424865'
                WHERE ordernumber = 'P421009115037949' 
            
2024-10-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '344290'
                WHERE ordernumber = 'P181009115112190' 
            
2024-10-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424867'
                WHERE ordernumber = 'P631009115354167' 
            
2024-10-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395301'
                WHERE ordernumber = 'P181009115352977' 
            
2024-10-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '282575'
                WHERE ordernumber = 'P181009115445221' 
            
2024-10-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '399985'
                WHERE ordernumber = 'P181009115629183' 
            
2024-10-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424868'
                WHERE ordernumber = 'P631009115824353' 
            
2024-10-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '140799'
                WHERE ordernumber = 'P201009120026558' 
            
2024-10-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '311208'
                WHERE ordernumber = 'P201009120313755' 
            
2024-10-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '278592'
                WHERE ordernumber = 'P201009120408353' 
            
2024-10-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '281382'
                WHERE ordernumber = 'P191009120700751' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424796'
                WHERE ordernumber = 'P181009120734115' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424869'
                WHERE ordernumber = 'P181009122015417' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424870'
                WHERE ordernumber = 'P181009122122906' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424870'
                WHERE ordernumber = 'P181009122508510' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424871'
                WHERE ordernumber = 'P181009122740644' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282921'
                WHERE ordernumber = 'P181009123224404' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424872'
                WHERE ordernumber = 'P181009123510805' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424873'
                WHERE ordernumber = 'P421009124404878' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424874'
                WHERE ordernumber = 'P421009124524303' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424854'
                WHERE ordernumber = 'P181009124608501' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424877'
                WHERE ordernumber = 'P181009124837617' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424876'
                WHERE ordernumber = 'P421009124953643' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424878'
                WHERE ordernumber = 'P201009125008386' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214895'
                WHERE ordernumber = 'P201009125302604' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422987'
                WHERE ordernumber = 'P421009125707870' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424879'
                WHERE ordernumber = 'P181009125903597' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245038'
                WHERE ordernumber = 'P201009130740730' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424881'
                WHERE ordernumber = 'P181009131519440' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424882'
                WHERE ordernumber = 'P421009132200686' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424883'
                WHERE ordernumber = 'P421009132541901' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '250156'
                WHERE ordernumber = 'P591009132549792' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '158535'
                WHERE ordernumber = 'P201009132836893' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '250156'
                WHERE ordernumber = 'P591009132855951' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424887'
                WHERE ordernumber = 'P201009133014987' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424885'
                WHERE ordernumber = 'P181009133027757' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424886'
                WHERE ordernumber = 'P421009133216722' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301109'
                WHERE ordernumber = 'P201009133439562' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424889'
                WHERE ordernumber = 'P191009134121468' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '250883'
                WHERE ordernumber = 'P201009134258212' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424890'
                WHERE ordernumber = 'P711009134707958' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228032'
                WHERE ordernumber = 'P181009135109990' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284599'
                WHERE ordernumber = 'P201009135202137' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239891'
                WHERE ordernumber = 'P181009135244701' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '225730'
                WHERE ordernumber = 'P201009135416364' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424891'
                WHERE ordernumber = 'P181009135554465' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99205'
                WHERE ordernumber = 'P201009135839547' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424210'
                WHERE ordernumber = 'P181009135851766' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '137924'
                WHERE ordernumber = 'P181009140005703' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424893'
                WHERE ordernumber = 'P181009140220798' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '216595'
                WHERE ordernumber = 'P201009140405839' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424892'
                WHERE ordernumber = 'P191009140540651' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422785'
                WHERE ordernumber = 'P181009140549175' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422785'
                WHERE ordernumber = 'P181009140619472' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424895'
                WHERE ordernumber = 'P731009141243643' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306206'
                WHERE ordernumber = 'P181009141244474' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '222335'
                WHERE ordernumber = 'P201009141515907' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424896'
                WHERE ordernumber = 'P421009141611239' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '142572'
                WHERE ordernumber = 'P181009141647194' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '258964'
                WHERE ordernumber = 'P201009141731602' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '253760'
                WHERE ordernumber = 'P181009142003373' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '280531'
                WHERE ordernumber = 'P201009142059786' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424897'
                WHERE ordernumber = 'P731009142213901' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424894'
                WHERE ordernumber = 'P181009142634302' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '373709'
                WHERE ordernumber = 'P201009142730205' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301149'
                WHERE ordernumber = 'P421009142823304' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424898'
                WHERE ordernumber = 'P181009142922984' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '264862'
                WHERE ordernumber = 'P731009143131438' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424899'
                WHERE ordernumber = 'P181009143429909' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424761'
                WHERE ordernumber = 'P181009144146660' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389740'
                WHERE ordernumber = 'P421009144639284' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424901'
                WHERE ordernumber = 'P181009144927674' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356625'
                WHERE ordernumber = 'P421009145144205' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '75984'
                WHERE ordernumber = 'P181009150011993' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291669'
                WHERE ordernumber = 'P201009151324667' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299335'
                WHERE ordernumber = 'P181009151509987' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P181009151722145' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424904'
                WHERE ordernumber = 'P731009151801691' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424906'
                WHERE ordernumber = 'P201009152441362' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424905'
                WHERE ordernumber = 'P181009152534891' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424907'
                WHERE ordernumber = 'P201009152603716' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271204'
                WHERE ordernumber = 'P191009152619616' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422905'
                WHERE ordernumber = 'P191009153054963' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424910'
                WHERE ordernumber = 'P201009153111865' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103107'
                WHERE ordernumber = 'P631009153137121' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424912'
                WHERE ordernumber = 'P191009153251335' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424911'
                WHERE ordernumber = 'P201009153314442' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '74753'
                WHERE ordernumber = 'P181009153400456' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424913'
                WHERE ordernumber = 'P191009153430230' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424914'
                WHERE ordernumber = 'P191009153532394' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424909'
                WHERE ordernumber = 'P181009153604517' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '264172'
                WHERE ordernumber = 'P201009153609837' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277139'
                WHERE ordernumber = 'P201009153719242' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247243'
                WHERE ordernumber = 'P191009153720417' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424913'
                WHERE ordernumber = 'P191009153750841' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402197'
                WHERE ordernumber = 'P191009154006895' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424915'
                WHERE ordernumber = 'P201009154041681' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424916'
                WHERE ordernumber = 'P191009154252467' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424918'
                WHERE ordernumber = 'P201009154521800' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424917'
                WHERE ordernumber = 'P181009154612424' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424919'
                WHERE ordernumber = 'P191009154641871' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '325003'
                WHERE ordernumber = 'P181009154848429' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402332'
                WHERE ordernumber = 'P591009154909731' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424915'
                WHERE ordernumber = 'P201009155022140' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344412'
                WHERE ordernumber = 'P201009155118997' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424920'
                WHERE ordernumber = 'P711009155304274' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424921'
                WHERE ordernumber = 'P731009155420988' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424922'
                WHERE ordernumber = 'P181009155605742' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341878'
                WHERE ordernumber = 'P421009155649349' 
            
2024-10-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424924'
                WHERE ordernumber = 'P181009160625761' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396004'
                WHERE ordernumber = 'P181009160812154' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424923'
                WHERE ordernumber = 'P181009161138369' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424925'
                WHERE ordernumber = 'P191009161212560' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424926'
                WHERE ordernumber = 'P201009161459475' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102976'
                WHERE ordernumber = 'P201009162156918' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424927'
                WHERE ordernumber = 'P181009162203235' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424929'
                WHERE ordernumber = 'P181009162338834' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424931'
                WHERE ordernumber = 'P711009162600892' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404138'
                WHERE ordernumber = 'P201009162922663' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '361458'
                WHERE ordernumber = 'P181009163410433' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424932'
                WHERE ordernumber = 'P191009163419272' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424934'
                WHERE ordernumber = 'P201009163540591' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299129'
                WHERE ordernumber = 'P201009163758954' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424933'
                WHERE ordernumber = 'P711009163942961' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394762'
                WHERE ordernumber = 'P191009164030614' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342189'
                WHERE ordernumber = 'P181009164049304' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424936'
                WHERE ordernumber = 'P191009164155186' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424935'
                WHERE ordernumber = 'P421009164503676' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424937'
                WHERE ordernumber = 'P181009164558377' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424251'
                WHERE ordernumber = 'P201009164651513' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424938'
                WHERE ordernumber = 'P181009164715700' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424903'
                WHERE ordernumber = 'P631009164731944' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424937'
                WHERE ordernumber = 'P181009164800866' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424939'
                WHERE ordernumber = 'P191009164828488' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '368927'
                WHERE ordernumber = 'P421009164935892' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423238'
                WHERE ordernumber = 'P181009165100608' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424940'
                WHERE ordernumber = 'P181009165530235' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424941'
                WHERE ordernumber = 'P201009165604870' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340592'
                WHERE ordernumber = 'P711009165725471' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424943'
                WHERE ordernumber = 'P181009165917900' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424942'
                WHERE ordernumber = 'P181009165948467' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '186441'
                WHERE ordernumber = 'P201009170132486' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424251'
                WHERE ordernumber = 'P201009170347271' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386625'
                WHERE ordernumber = 'P181009170634295' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424945'
                WHERE ordernumber = 'P181009170915797' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424946'
                WHERE ordernumber = 'P711009170948772' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424947'
                WHERE ordernumber = 'P201009171112395' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305707'
                WHERE ordernumber = 'P181009171304311' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424946'
                WHERE ordernumber = 'P711009171445848' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424948'
                WHERE ordernumber = 'P181009171507300' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305751'
                WHERE ordernumber = 'P421009171543808' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '167650'
                WHERE ordernumber = 'P421009171650194' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351985'
                WHERE ordernumber = 'P421009171932308' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424950'
                WHERE ordernumber = 'P421009172027310' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424949'
                WHERE ordernumber = 'P711009172033825' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '160799'
                WHERE ordernumber = 'P201009172114449' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424952'
                WHERE ordernumber = 'P181009172259213' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424954'
                WHERE ordernumber = 'P181009172414413' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424955'
                WHERE ordernumber = 'P421009172502921' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382554'
                WHERE ordernumber = 'P181009172608174' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424954'
                WHERE ordernumber = 'P181009172744622' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '112833'
                WHERE ordernumber = 'P181009172859998' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '263242'
                WHERE ordernumber = 'P191009172907192' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '365235'
                WHERE ordernumber = 'P181009172947831' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '263242'
                WHERE ordernumber = 'P191009173230660' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '244627'
                WHERE ordernumber = 'P181009173240220' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '264712'
                WHERE ordernumber = 'P181009173719695' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424953'
                WHERE ordernumber = 'P181009173832231' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424957'
                WHERE ordernumber = 'P731009173948703' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400934'
                WHERE ordernumber = 'P591009174008633' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424960'
                WHERE ordernumber = 'P711009174050875' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396908'
                WHERE ordernumber = 'P631009174107614' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '307135'
                WHERE ordernumber = 'P181009174224333' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424961'
                WHERE ordernumber = 'P711009174637752' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '109255'
                WHERE ordernumber = 'P181009174902135' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424962'
                WHERE ordernumber = 'P181009175128200' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424855'
                WHERE ordernumber = 'P181009175429570' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424963'
                WHERE ordernumber = 'P421009175554843' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424966'
                WHERE ordernumber = 'P181009175623218' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '143314'
                WHERE ordernumber = 'P181009175740597' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424965'
                WHERE ordernumber = 'P421009175913587' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424967'
                WHERE ordernumber = 'P181009175947425' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385532'
                WHERE ordernumber = 'P421009180044578' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424968'
                WHERE ordernumber = 'P711009180151164' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424970'
                WHERE ordernumber = 'P201009180203347' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424969'
                WHERE ordernumber = 'P181009180203257' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424971'
                WHERE ordernumber = 'P421009180337837' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423825'
                WHERE ordernumber = 'P181009180636784' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424972'
                WHERE ordernumber = 'P181009180833345' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '219388'
                WHERE ordernumber = 'P191009181034916' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '118999'
                WHERE ordernumber = 'P201009181120183' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424974'
                WHERE ordernumber = 'P181009181129122' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405905'
                WHERE ordernumber = 'P731009181232269' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '374458'
                WHERE ordernumber = 'P201009181301548' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '214805'
                WHERE ordernumber = 'P181009181405352' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424975'
                WHERE ordernumber = 'P191009181409352' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424973'
                WHERE ordernumber = 'P191009181501444' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424976'
                WHERE ordernumber = 'P181009181747640' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424977'
                WHERE ordernumber = 'P201009181911945' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424978'
                WHERE ordernumber = 'P181009181931398' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '137003'
                WHERE ordernumber = 'P731009181948675' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394922'
                WHERE ordernumber = 'P181009182054683' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349629'
                WHERE ordernumber = 'P201009182614648' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304451'
                WHERE ordernumber = 'P421009182732164' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '308233'
                WHERE ordernumber = 'P201009183119714' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81645'
                WHERE ordernumber = 'P201009183516636' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424979'
                WHERE ordernumber = 'P731009183810824' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424981'
                WHERE ordernumber = 'P181009184224833' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305321'
                WHERE ordernumber = 'P201009184401478' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '206345'
                WHERE ordernumber = 'P181009184831972' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424981'
                WHERE ordernumber = 'P191009184838726' 
            
2024-10-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424982'
                WHERE ordernumber = 'P421009185704603' 
            
2024-10-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '89036'
                WHERE ordernumber = 'P201009185759881' 
            
2024-10-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '259084'
                WHERE ordernumber = 'P191009185941338' 
            
2024-10-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '237186'
                WHERE ordernumber = 'P191009190319712' 
            
2024-10-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '409664'
                WHERE ordernumber = 'P191009190714894' 
            
2024-10-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424983'
                WHERE ordernumber = 'P201009191020166' 
            
2024-10-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424984'
                WHERE ordernumber = 'P191009191407708' 
            
2024-10-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424984'
                WHERE ordernumber = 'P191009191609693' 
            
2024-10-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424985'
                WHERE ordernumber = 'P191009192254542' 
            
2024-10-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '422077'
                WHERE ordernumber = 'P731009192316745' 
            
2024-10-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '283798'
                WHERE ordernumber = 'P201009192521600' 
            
2024-10-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424986'
                WHERE ordernumber = 'P711009192528257' 
            
2024-10-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424987'
                WHERE ordernumber = 'P191009192611222' 
            
2024-10-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424988'
                WHERE ordernumber = 'P191009192752975' 
            
2024-10-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424987'
                WHERE ordernumber = 'P191009192835912' 
            
2024-10-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424989'
                WHERE ordernumber = 'P711009193007822' 
            
2024-10-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424990'
                WHERE ordernumber = 'P191009193212767' 
            
2024-10-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423755'
                WHERE ordernumber = 'P591009193313297' 
            
2024-10-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '288851'
                WHERE ordernumber = 'P191009193529120' 
            
2024-10-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424991'
                WHERE ordernumber = 'P191009193643865' 
            
2024-10-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424992'
                WHERE ordernumber = 'P191009193747388' 
            
2024-10-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424993'
                WHERE ordernumber = 'P191009193921779' 
            
2024-10-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424995'
                WHERE ordernumber = 'P191009194035475' 
            
2024-10-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '310755'
                WHERE ordernumber = 'P191009194259806' 
            
2024-10-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '357988'
                WHERE ordernumber = 'P191009194500900' 
            
2024-10-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424151'
                WHERE ordernumber = 'P191009194703950' 
            
2024-10-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424996'
                WHERE ordernumber = 'P201009194718519' 
            
2024-10-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383225'
                WHERE ordernumber = 'P191009194855990' 
            
2024-10-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377927'
                WHERE ordernumber = 'P711009195315216' 
            
2024-10-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '340376'
                WHERE ordernumber = 'P631009195648688' 
            
2024-10-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '142108'
                WHERE ordernumber = 'P191009195909168' 
            
2024-10-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424997'
                WHERE ordernumber = 'P731009200227928' 
            
2024-10-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424998'
                WHERE ordernumber = 'P731009201644409' 
            
2024-10-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '189947'
                WHERE ordernumber = 'P711009202028491' 
            
2024-10-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '172504'
                WHERE ordernumber = 'P711009202507545' 
            
2024-10-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '317863'
                WHERE ordernumber = 'P711009202656650' 
            
2024-10-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '425000'
                WHERE ordernumber = 'P711009203114271' 
            
2024-10-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '425003'
                WHERE ordernumber = 'P711009212125492'