2024-11-09 01:00:02 -- 將會員中心id寫入data-lake
2024-11-09 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-11-08%';
        
2024-11-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429342'
                WHERE ordernumber = 'P191108110224790' 
            
2024-11-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '226927'
                WHERE ordernumber = 'P191108110421804' 
            
2024-11-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '244719'
                WHERE ordernumber = 'P201108110530447' 
            
2024-11-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429343'
                WHERE ordernumber = 'P181108110636149' 
            
2024-11-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '108211'
                WHERE ordernumber = 'P191108110826784' 
            
2024-11-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429346'
                WHERE ordernumber = 'P201108110852501' 
            
2024-11-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429347'
                WHERE ordernumber = 'P201108111013452' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429349'
                WHERE ordernumber = 'P201108111154591' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429348'
                WHERE ordernumber = 'P191108111434528' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429350'
                WHERE ordernumber = 'P421108111704627' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428462'
                WHERE ordernumber = 'P181108112021652' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429351'
                WHERE ordernumber = 'P181108112430601' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429352'
                WHERE ordernumber = 'P201108112613648' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429354'
                WHERE ordernumber = 'P181108113447744' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429353'
                WHERE ordernumber = 'P201108113655685' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313009'
                WHERE ordernumber = 'P181108114019877' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429355'
                WHERE ordernumber = 'P181108114203981' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377505'
                WHERE ordernumber = 'P201108114402256' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237028'
                WHERE ordernumber = 'P201108114455499' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429356'
                WHERE ordernumber = 'P201108114812447' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348545'
                WHERE ordernumber = 'P421108115225309' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429357'
                WHERE ordernumber = 'P181108115233581' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429358'
                WHERE ordernumber = 'P421108115406868' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '251553'
                WHERE ordernumber = 'P181108115833679' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429361'
                WHERE ordernumber = 'P181108120404563' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '317484'
                WHERE ordernumber = 'P181108120544997' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429364'
                WHERE ordernumber = 'P421108120851164' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429363'
                WHERE ordernumber = 'P201108120930473' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427034'
                WHERE ordernumber = 'P181108121405396' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428883'
                WHERE ordernumber = 'P421108121850862' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429365'
                WHERE ordernumber = 'P201108122111575' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214003'
                WHERE ordernumber = 'P201108122150254' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429366'
                WHERE ordernumber = 'P181108122411312' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '210705'
                WHERE ordernumber = 'P181108122519495' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365717'
                WHERE ordernumber = 'P181108122624570' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '263675'
                WHERE ordernumber = 'P181108123123878' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429367'
                WHERE ordernumber = 'P421108123247744' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425878'
                WHERE ordernumber = 'P201108123408149' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425878'
                WHERE ordernumber = 'P201108123432567' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429368'
                WHERE ordernumber = 'P421108123544191' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '255438'
                WHERE ordernumber = 'P181108123630861' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426256'
                WHERE ordernumber = 'P421108123649220' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429370'
                WHERE ordernumber = 'P181108123746256' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429369'
                WHERE ordernumber = 'P201108123829808' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426460'
                WHERE ordernumber = 'P771108123913923' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '270218'
                WHERE ordernumber = 'P201108123950180' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389788'
                WHERE ordernumber = 'P421108124003987' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287106'
                WHERE ordernumber = 'P181108124142876' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287106'
                WHERE ordernumber = 'P181108124213727' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389093'
                WHERE ordernumber = 'P201108124401540' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '280482'
                WHERE ordernumber = 'P421108124416596' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429372'
                WHERE ordernumber = 'P181108124705689' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346202'
                WHERE ordernumber = 'P421108124718451' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429373'
                WHERE ordernumber = 'P631108124914582' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '104600'
                WHERE ordernumber = 'P181108125045749' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429378'
                WHERE ordernumber = 'P201108125657455' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429375'
                WHERE ordernumber = 'P181108125745533' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423292'
                WHERE ordernumber = 'P201108125800807' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429379'
                WHERE ordernumber = 'P181108130040472' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429335'
                WHERE ordernumber = 'P191108130056216' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429377'
                WHERE ordernumber = 'P191108130218215' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429376'
                WHERE ordernumber = 'P181108130251998' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429377'
                WHERE ordernumber = 'P191108130331692' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429275'
                WHERE ordernumber = 'P421108130428995' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351596'
                WHERE ordernumber = 'P421108130512644' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '255520'
                WHERE ordernumber = 'P191108130910398' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429380'
                WHERE ordernumber = 'P191108131327553' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '329666'
                WHERE ordernumber = 'P191108131709320' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389295'
                WHERE ordernumber = 'P201108131928321' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429328'
                WHERE ordernumber = 'P191108132042665' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347997'
                WHERE ordernumber = 'P191108132446532' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429381'
                WHERE ordernumber = 'P181108132610243' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380531'
                WHERE ordernumber = 'P201108132739712' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100396'
                WHERE ordernumber = 'P191108132753676' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380531'
                WHERE ordernumber = 'P201108132938328' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429382'
                WHERE ordernumber = 'P191108133359954' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278176'
                WHERE ordernumber = 'P201108133530461' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364203'
                WHERE ordernumber = 'P191108133809495' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429383'
                WHERE ordernumber = 'P181108133940849' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '273096'
                WHERE ordernumber = 'P191108134025401' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357721'
                WHERE ordernumber = 'P191108134217991' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '256534'
                WHERE ordernumber = 'P201108134402403' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429384'
                WHERE ordernumber = 'P181108134752930' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '308707'
                WHERE ordernumber = 'P201108135110174' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355573'
                WHERE ordernumber = 'P181108135610495' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '138130'
                WHERE ordernumber = 'P421108135652661' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '293555'
                WHERE ordernumber = 'P201108140141425' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429386'
                WHERE ordernumber = 'P201108141044219' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429388'
                WHERE ordernumber = 'P201108141214577' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429389'
                WHERE ordernumber = 'P201108141303960' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '110061'
                WHERE ordernumber = 'P201108141440803' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429391'
                WHERE ordernumber = 'P181108141919720' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '108997'
                WHERE ordernumber = 'P201108141904779' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393687'
                WHERE ordernumber = 'P201108142025289' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '208574'
                WHERE ordernumber = 'P181108142150444' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429393'
                WHERE ordernumber = 'P771108142835776' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235961'
                WHERE ordernumber = 'P201108143312315' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302881'
                WHERE ordernumber = 'P421108143436341' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '331478'
                WHERE ordernumber = 'P181108143628791' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420969'
                WHERE ordernumber = 'P421108144159710' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '261244'
                WHERE ordernumber = 'P201108144420251' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429394'
                WHERE ordernumber = 'P421108144430578' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388142'
                WHERE ordernumber = 'P421108144510140' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241062'
                WHERE ordernumber = 'P181108144817568' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429396'
                WHERE ordernumber = 'P201108145315542' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429395'
                WHERE ordernumber = 'P181108145529268' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287197'
                WHERE ordernumber = 'P181108145834287' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '80681'
                WHERE ordernumber = 'P181108150229249' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429371'
                WHERE ordernumber = 'P181108150406327' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429397'
                WHERE ordernumber = 'P191108150537823' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429398'
                WHERE ordernumber = 'P421108150609318' 
            
2024-11-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429400'
                WHERE ordernumber = 'P191108150758668' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '44669'
                WHERE ordernumber = 'P181108150914572' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428917'
                WHERE ordernumber = 'P201108151043432' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429399'
                WHERE ordernumber = 'P631108151424670' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429315'
                WHERE ordernumber = 'P191108151635527' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429402'
                WHERE ordernumber = 'P181108152253590' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429401'
                WHERE ordernumber = 'P421108152317501' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429403'
                WHERE ordernumber = 'P181108152908543' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '307277'
                WHERE ordernumber = 'P201108153328162' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '158657'
                WHERE ordernumber = 'P201108153601660' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429404'
                WHERE ordernumber = 'P771108154052882' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429405'
                WHERE ordernumber = 'P771108154306564' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429406'
                WHERE ordernumber = 'P181108154452967' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429407'
                WHERE ordernumber = 'P201108154518264' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429408'
                WHERE ordernumber = 'P201108154717312' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81645'
                WHERE ordernumber = 'P201108155254194' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429411'
                WHERE ordernumber = 'P421108155338473' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429409'
                WHERE ordernumber = 'P181108155451452' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383852'
                WHERE ordernumber = 'P421108155559521' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429410'
                WHERE ordernumber = 'P181108155606499' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '88699'
                WHERE ordernumber = 'P421108155753248' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '246226'
                WHERE ordernumber = 'P421108155821244' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429412'
                WHERE ordernumber = 'P181108155911987' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '222165'
                WHERE ordernumber = 'P181108160454169' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '300118'
                WHERE ordernumber = 'P181108160906153' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429414'
                WHERE ordernumber = 'P201108161233116' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429415'
                WHERE ordernumber = 'P421108161345312' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '264677'
                WHERE ordernumber = 'P181108161410819' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429413'
                WHERE ordernumber = 'P181108161623188' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '293350'
                WHERE ordernumber = 'P201108161645152' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429416'
                WHERE ordernumber = 'P181108161844354' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429418'
                WHERE ordernumber = 'P191108161923736' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372393'
                WHERE ordernumber = 'P201108161940519' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415949'
                WHERE ordernumber = 'P181108162616874' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429417'
                WHERE ordernumber = 'P181108162820747' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '147849'
                WHERE ordernumber = 'P201108162832597' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81590'
                WHERE ordernumber = 'P181108163024235' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415949'
                WHERE ordernumber = 'P181108163136231' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429422'
                WHERE ordernumber = 'P181108163958507' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429420'
                WHERE ordernumber = 'P771108164118350' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429090'
                WHERE ordernumber = 'P201108164711638' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379284'
                WHERE ordernumber = 'P201108164937379' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '213280'
                WHERE ordernumber = 'P181108165003994' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '244834'
                WHERE ordernumber = 'P201108165044927' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429189'
                WHERE ordernumber = 'P201108165241835' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429426'
                WHERE ordernumber = 'P181108165308515' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429425'
                WHERE ordernumber = 'P181108165446513' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406390'
                WHERE ordernumber = 'P181108170953689' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429423'
                WHERE ordernumber = 'P181108171145455' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429423'
                WHERE ordernumber = 'P181108171231617' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428261'
                WHERE ordernumber = 'P631108171304416' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355598'
                WHERE ordernumber = 'P421108171526507' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429430'
                WHERE ordernumber = 'P181108171607144' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429429'
                WHERE ordernumber = 'P181108172011576' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429432'
                WHERE ordernumber = 'P181108172139558' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429431'
                WHERE ordernumber = 'P181108172531587' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429433'
                WHERE ordernumber = 'P181108172642274' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354220'
                WHERE ordernumber = 'P181108173155951' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '46423'
                WHERE ordernumber = 'P421108173242539' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429436'
                WHERE ordernumber = 'P421108173744257' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '171345'
                WHERE ordernumber = 'P771108173840874' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429435'
                WHERE ordernumber = 'P181108174128688' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429438'
                WHERE ordernumber = 'P421108174155539' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429439'
                WHERE ordernumber = 'P201108174249148' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429440'
                WHERE ordernumber = 'P191108174731405' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '38536'
                WHERE ordernumber = 'P181108174745509' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '270987'
                WHERE ordernumber = 'P201108174842273' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392294'
                WHERE ordernumber = 'P421108174918209' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379943'
                WHERE ordernumber = 'P181108175335242' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425921'
                WHERE ordernumber = 'P421108175441580' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '217936'
                WHERE ordernumber = 'P201108180207691' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429442'
                WHERE ordernumber = 'P181108180228195' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429442'
                WHERE ordernumber = 'P181108180251983' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429444'
                WHERE ordernumber = 'P191108180543213' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429445'
                WHERE ordernumber = 'P191108180703262' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429443'
                WHERE ordernumber = 'P421108180900862' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429446'
                WHERE ordernumber = 'P771108180901884' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '315910'
                WHERE ordernumber = 'P421108181158263' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '315910'
                WHERE ordernumber = 'P421108181229177' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429447'
                WHERE ordernumber = 'P181108181515302' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429449'
                WHERE ordernumber = 'P201108181606180' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '206960'
                WHERE ordernumber = 'P191108181726411' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429392'
                WHERE ordernumber = 'P181108181917303' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346502'
                WHERE ordernumber = 'P201108182120632' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429448'
                WHERE ordernumber = 'P181108182202624' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429452'
                WHERE ordernumber = 'P201108182244902' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429385'
                WHERE ordernumber = 'P181108182429515' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402114'
                WHERE ordernumber = 'P201108182610144' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429450'
                WHERE ordernumber = 'P181108183343328' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383383'
                WHERE ordernumber = 'P201108183426336' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429455'
                WHERE ordernumber = 'P421108183430741' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '286124'
                WHERE ordernumber = 'P191108183640487' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402114'
                WHERE ordernumber = 'P201108183719510' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429454'
                WHERE ordernumber = 'P181108184013576' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429457'
                WHERE ordernumber = 'P201108190548915' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '93028'
                WHERE ordernumber = 'P201108190705635' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '280157'
                WHERE ordernumber = 'P201108191045764' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346099'
                WHERE ordernumber = 'P191108191303432' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391279'
                WHERE ordernumber = 'P191108191458702' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429458'
                WHERE ordernumber = 'P191108191626835' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429459'
                WHERE ordernumber = 'P191108192118330' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '228348'
                WHERE ordernumber = 'P191108192214910' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '320057'
                WHERE ordernumber = 'P201108192430264' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429460'
                WHERE ordernumber = 'P191108192727918' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429462'
                WHERE ordernumber = 'P191108193000657' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414844'
                WHERE ordernumber = 'P201108193548114' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '314504'
                WHERE ordernumber = 'P191108193959598' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394882'
                WHERE ordernumber = 'P201108194246119' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '413199'
                WHERE ordernumber = 'P771108194541626' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '214794'
                WHERE ordernumber = 'P191108194750217' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429465'
                WHERE ordernumber = 'P191108195444632' 
            
2024-11-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '314630'
                WHERE ordernumber = 'P191108195828552' 
            
2024-11-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '291881'
                WHERE ordernumber = 'P771108210321770' 
            
2024-11-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '291883'
                WHERE ordernumber = 'P771108210443313'