2024-10-18 01:00:01 -- 將會員中心id寫入data-lake
2024-10-18 01:00:01 -- 
            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-17%';
        
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '289212'
                WHERE ordernumber = 'P201017110202774' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419547'
                WHERE ordernumber = 'P421017110417563' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '93911'
                WHERE ordernumber = 'P181017110741895' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '284049'
                WHERE ordernumber = 'P191017110907496' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426242'
                WHERE ordernumber = 'P181017111724542' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426243'
                WHERE ordernumber = 'P201017112020508' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '399816'
                WHERE ordernumber = 'P421017112028115' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425037'
                WHERE ordernumber = 'P711017112036143' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421375'
                WHERE ordernumber = 'P181017112335115' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '67043'
                WHERE ordernumber = 'P201017112338522' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426176'
                WHERE ordernumber = 'P181017112833950' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '141288'
                WHERE ordernumber = 'P201017113033561' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283039'
                WHERE ordernumber = 'P181017113058170' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426244'
                WHERE ordernumber = 'P711017113106578' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426169'
                WHERE ordernumber = 'P181017113251354' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378210'
                WHERE ordernumber = 'P201017113354833' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '235779'
                WHERE ordernumber = 'P201017113736116' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426245'
                WHERE ordernumber = 'P181017113815141' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '116975'
                WHERE ordernumber = 'P201017114047853' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '81970'
                WHERE ordernumber = 'P181017114302407' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426247'
                WHERE ordernumber = 'P181017120139955' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426248'
                WHERE ordernumber = 'P181017120343621' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '411469'
                WHERE ordernumber = 'P201017121212548' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426249'
                WHERE ordernumber = 'P731017121301373' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426250'
                WHERE ordernumber = 'P201017121344723' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426252'
                WHERE ordernumber = 'P421017122220733' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426255'
                WHERE ordernumber = 'P181017122440273' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426256'
                WHERE ordernumber = 'P421017122521339' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426254'
                WHERE ordernumber = 'P181017122647323' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '347176'
                WHERE ordernumber = 'P421017122845364' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426257'
                WHERE ordernumber = 'P181017122922119' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '304926'
                WHERE ordernumber = 'P181017123118251' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426253'
                WHERE ordernumber = 'P181017123310296' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '335197'
                WHERE ordernumber = 'P421017123410930' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426259'
                WHERE ordernumber = 'P181017123921304' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426260'
                WHERE ordernumber = 'P201017124222289' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426261'
                WHERE ordernumber = 'P181017124304233' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '112587'
                WHERE ordernumber = 'P181017124504639' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426259'
                WHERE ordernumber = 'P181017124701666' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422626'
                WHERE ordernumber = 'P731017124822379' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423872'
                WHERE ordernumber = 'P421017124914484' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '296916'
                WHERE ordernumber = 'P421017125030233' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426262'
                WHERE ordernumber = 'P731017125144586' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426266'
                WHERE ordernumber = 'P181017130043520' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '352563'
                WHERE ordernumber = 'P201017130051936' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426212'
                WHERE ordernumber = 'P731017130423252' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426267'
                WHERE ordernumber = 'P181017130507785' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426268'
                WHERE ordernumber = 'P181017131122896' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '401947'
                WHERE ordernumber = 'P201017131243962' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421658'
                WHERE ordernumber = 'P181017132018482' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426270'
                WHERE ordernumber = 'P181017132137686' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426271'
                WHERE ordernumber = 'P201017132158406' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350741'
                WHERE ordernumber = 'P201017133239214' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426272'
                WHERE ordernumber = 'P731017133501834' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426275'
                WHERE ordernumber = 'P181017134216796' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426275'
                WHERE ordernumber = 'P181017134234575' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426274'
                WHERE ordernumber = 'P731017134300403' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287470'
                WHERE ordernumber = 'P181017134522779' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426276'
                WHERE ordernumber = 'P731017134625196' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426143'
                WHERE ordernumber = 'P421017134802794' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426279'
                WHERE ordernumber = 'P201017134829253' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426280'
                WHERE ordernumber = 'P181017135054480' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426282'
                WHERE ordernumber = 'P201017135250192' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426278'
                WHERE ordernumber = 'P421017135258859' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426282'
                WHERE ordernumber = 'P201017135456347' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426283'
                WHERE ordernumber = 'P181017135604524' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '242828'
                WHERE ordernumber = 'P181017140359342' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '369500'
                WHERE ordernumber = 'P771017140543864' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426285'
                WHERE ordernumber = 'P181017141025206' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426285'
                WHERE ordernumber = 'P181017141606950' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396484'
                WHERE ordernumber = 'P631017141704162' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426287'
                WHERE ordernumber = 'P201017141851871' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420554'
                WHERE ordernumber = 'P421017141914525' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426288'
                WHERE ordernumber = 'P771017142346467' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426286'
                WHERE ordernumber = 'P181017142711402' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426289'
                WHERE ordernumber = 'P771017143304764' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426290'
                WHERE ordernumber = 'P201017143320926' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '299335'
                WHERE ordernumber = 'P181017143346934' 
            
2024-10-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '130397'
                WHERE ordernumber = 'P711017143612339' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '363920'
                WHERE ordernumber = 'P421017144039281' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '131786'
                WHERE ordernumber = 'P181017144243839' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278926'
                WHERE ordernumber = 'P181017144644326' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '250733'
                WHERE ordernumber = 'P181017144750982' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424636'
                WHERE ordernumber = 'P201017144819346' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426291'
                WHERE ordernumber = 'P181017145254212' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426143'
                WHERE ordernumber = 'P421017145306605' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426296'
                WHERE ordernumber = 'P731017145503431' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426292'
                WHERE ordernumber = 'P181017145628773' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426292'
                WHERE ordernumber = 'P181017145700470' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426297'
                WHERE ordernumber = 'P421017145710681' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426294'
                WHERE ordernumber = 'P201017145745912' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401440'
                WHERE ordernumber = 'P181017145830472' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '329369'
                WHERE ordernumber = 'P201017150241789' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426295'
                WHERE ordernumber = 'P181017150447908' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426298'
                WHERE ordernumber = 'P181017151118761' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426300'
                WHERE ordernumber = 'P201017151147260' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426299'
                WHERE ordernumber = 'P421017151152975' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426301'
                WHERE ordernumber = 'P201017151242669' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '295055'
                WHERE ordernumber = 'P181017151401936' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426302'
                WHERE ordernumber = 'P731017151735901' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426303'
                WHERE ordernumber = 'P201017151903732' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425132'
                WHERE ordernumber = 'P181017152049165' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426305'
                WHERE ordernumber = 'P771017152204182' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426306'
                WHERE ordernumber = 'P201017152209347' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426307'
                WHERE ordernumber = 'P181017152329671' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426103'
                WHERE ordernumber = 'P181017152754996' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426308'
                WHERE ordernumber = 'P771017152909982' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426304'
                WHERE ordernumber = 'P181017153119468' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426304'
                WHERE ordernumber = 'P181017153127436' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406463'
                WHERE ordernumber = 'P181017153647242' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287669'
                WHERE ordernumber = 'P181017153844401' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426310'
                WHERE ordernumber = 'P181017154039695' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426313'
                WHERE ordernumber = 'P201017154404293' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382671'
                WHERE ordernumber = 'P181017154745200' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426312'
                WHERE ordernumber = 'P181017155031685' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426317'
                WHERE ordernumber = 'P201017155502933' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426318'
                WHERE ordernumber = 'P731017155505787' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426319'
                WHERE ordernumber = 'P181017155608159' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426322'
                WHERE ordernumber = 'P181017160112327' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309725'
                WHERE ordernumber = 'P181017160948620' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426323'
                WHERE ordernumber = 'P731017161158293' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426324'
                WHERE ordernumber = 'P181017161347423' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '251088'
                WHERE ordernumber = 'P201017161551594' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426326'
                WHERE ordernumber = 'P181017161559278' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247204'
                WHERE ordernumber = 'P201017161739300' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426325'
                WHERE ordernumber = 'P181017162022879' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426327'
                WHERE ordernumber = 'P181017162552406' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426328'
                WHERE ordernumber = 'P181017162931243' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '64697'
                WHERE ordernumber = 'P181017163132163' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '327941'
                WHERE ordernumber = 'P181017163333458' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426331'
                WHERE ordernumber = 'P201017163651386' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426332'
                WHERE ordernumber = 'P421017163828152' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426333'
                WHERE ordernumber = 'P421017163908691' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426334'
                WHERE ordernumber = 'P201017163927574' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426330'
                WHERE ordernumber = 'P181017164109645' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426335'
                WHERE ordernumber = 'P771017164317317' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426337'
                WHERE ordernumber = 'P201017164350285' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '121420'
                WHERE ordernumber = 'P421017164447153' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426337'
                WHERE ordernumber = 'P201017164550373' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426340'
                WHERE ordernumber = 'P421017165104984' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426340'
                WHERE ordernumber = 'P421017165133475' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426336'
                WHERE ordernumber = 'P731017165238359' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426339'
                WHERE ordernumber = 'P421017165314724' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426341'
                WHERE ordernumber = 'P421017165508599' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378812'
                WHERE ordernumber = 'P421017165532733' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237921'
                WHERE ordernumber = 'P201017170025674' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401923'
                WHERE ordernumber = 'P181017170040276' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426342'
                WHERE ordernumber = 'P181017170433711' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426345'
                WHERE ordernumber = 'P591017170620706' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '137006'
                WHERE ordernumber = 'P771017171402851' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426346'
                WHERE ordernumber = 'P201017171404862' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424893'
                WHERE ordernumber = 'P181017171533694' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391011'
                WHERE ordernumber = 'P591017171653425' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '129082'
                WHERE ordernumber = 'P201017172008933' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247243'
                WHERE ordernumber = 'P181017172144692' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '130397'
                WHERE ordernumber = 'P711017172322291' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384872'
                WHERE ordernumber = 'P201017172329125' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '326714'
                WHERE ordernumber = 'P181017172515498' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '290047'
                WHERE ordernumber = 'P421017172541886' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '221667'
                WHERE ordernumber = 'P181017172639770' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341897'
                WHERE ordernumber = 'P421017172754421' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426348'
                WHERE ordernumber = 'P421017172941217' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426347'
                WHERE ordernumber = 'P181017172949405' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '209646'
                WHERE ordernumber = 'P181017173120482' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247871'
                WHERE ordernumber = 'P181017173405285' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426349'
                WHERE ordernumber = 'P181017173528694' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426350'
                WHERE ordernumber = 'P181017174012616' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '209693'
                WHERE ordernumber = 'P771017174034979' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422870'
                WHERE ordernumber = 'P181017174134687' 
            
2024-10-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426351'
                WHERE ordernumber = 'P421017174154495' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '87093'
                WHERE ordernumber = 'P181017174419151' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385513'
                WHERE ordernumber = 'P201017174443200' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426352'
                WHERE ordernumber = 'P731017174559703' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400678'
                WHERE ordernumber = 'P181017174736720' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339068'
                WHERE ordernumber = 'P421017174755583' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426354'
                WHERE ordernumber = 'P181017175009713' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '112620'
                WHERE ordernumber = 'P771017175749170' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426356'
                WHERE ordernumber = 'P421017175804970' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426353'
                WHERE ordernumber = 'P191017175833441' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '280373'
                WHERE ordernumber = 'P201017180440273' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359366'
                WHERE ordernumber = 'P191017180448767' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409199'
                WHERE ordernumber = 'P181017180551212' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426358'
                WHERE ordernumber = 'P771017180640149' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426359'
                WHERE ordernumber = 'P191017180726355' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301616'
                WHERE ordernumber = 'P181017181327351' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426360'
                WHERE ordernumber = 'P421017181419401' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426357'
                WHERE ordernumber = 'P191017181526473' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '108189'
                WHERE ordernumber = 'P181017181852734' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382504'
                WHERE ordernumber = 'P181017182009121' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426361'
                WHERE ordernumber = 'P191017182148442' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426363'
                WHERE ordernumber = 'P201017182309365' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426362'
                WHERE ordernumber = 'P421017182353651' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426364'
                WHERE ordernumber = 'P201017182640544' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426365'
                WHERE ordernumber = 'P201017183108482' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426366'
                WHERE ordernumber = 'P771017183230180' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '251584'
                WHERE ordernumber = 'P181017183333387' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426367'
                WHERE ordernumber = 'P201017183513609' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426368'
                WHERE ordernumber = 'P191017183602722' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346532'
                WHERE ordernumber = 'P181017183708130' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426370'
                WHERE ordernumber = 'P201017183738871' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426371'
                WHERE ordernumber = 'P201017183922629' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '95310'
                WHERE ordernumber = 'P191017184127114' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391338'
                WHERE ordernumber = 'P191017184352714' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426374'
                WHERE ordernumber = 'P201017184501778' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '95310'
                WHERE ordernumber = 'P191017184717766' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426373'
                WHERE ordernumber = 'P421017184724968' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426375'
                WHERE ordernumber = 'P711017184742742' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426372'
                WHERE ordernumber = 'P181017184814788' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426378'
                WHERE ordernumber = 'P201017184837634' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '198163'
                WHERE ordernumber = 'P191017184930435' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426376'
                WHERE ordernumber = 'P421017185018210' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '334554'
                WHERE ordernumber = 'P201017185138592' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426379'
                WHERE ordernumber = 'P731017185157515' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '214242'
                WHERE ordernumber = 'P771017185300334' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426380'
                WHERE ordernumber = 'P771017185723817' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426382'
                WHERE ordernumber = 'P731017190355242' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404307'
                WHERE ordernumber = 'P421017190423579' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426383'
                WHERE ordernumber = 'P421017190527860' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426384'
                WHERE ordernumber = 'P731017190807446' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238593'
                WHERE ordernumber = 'P191017191251516' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426381'
                WHERE ordernumber = 'P191017191434630' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '229438'
                WHERE ordernumber = 'P191017191615982' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '374428'
                WHERE ordernumber = 'P191017191827944' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426389'
                WHERE ordernumber = 'P731017191902926' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426391'
                WHERE ordernumber = 'P731017192133886' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426387'
                WHERE ordernumber = 'P191017192145758' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426388'
                WHERE ordernumber = 'P771017192207214' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426390'
                WHERE ordernumber = 'P191017192515349' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '311545'
                WHERE ordernumber = 'P191017192812918' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426392'
                WHERE ordernumber = 'P771017192857824' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '163451'
                WHERE ordernumber = 'P631017193021867' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388577'
                WHERE ordernumber = 'P191017193729664' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426393'
                WHERE ordernumber = 'P191017194344891' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423308'
                WHERE ordernumber = 'P731017194409545' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236756'
                WHERE ordernumber = 'P191017194604548' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '364203'
                WHERE ordernumber = 'P191017195247302' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426394'
                WHERE ordernumber = 'P191017195621178' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426396'
                WHERE ordernumber = 'P191017200237466' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426397'
                WHERE ordernumber = 'P771017200855840' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426398'
                WHERE ordernumber = 'P731017200930812' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '209689'
                WHERE ordernumber = 'P731017201137938' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426399'
                WHERE ordernumber = 'P771017201645244' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '214242'
                WHERE ordernumber = 'P771017202058193' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426401'
                WHERE ordernumber = 'P771017202800460' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426226'
                WHERE ordernumber = 'P631017203852542' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '295132'
                WHERE ordernumber = 'P771017204150778' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337679'
                WHERE ordernumber = 'P711017204346223' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426403'
                WHERE ordernumber = 'P711017205734758' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426405'
                WHERE ordernumber = 'P711017211151133' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426404'
                WHERE ordernumber = 'P771017211153775' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426406'
                WHERE ordernumber = 'P631017211348804' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426407'
                WHERE ordernumber = 'P771017211921322' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391675'
                WHERE ordernumber = 'P711017213348835' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404969'
                WHERE ordernumber = 'P631017215507396' 
            
2024-10-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426408'
                WHERE ordernumber = 'P771017220316310'