2024-07-06 01:00:03 -- 將會員中心id寫入data-lake
2024-07-06 01:00:03 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-07-05%';
        
2024-07-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399798'
                WHERE ordernumber = 'P630705100353825' 
            
2024-07-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P200705110107937' 
            
2024-07-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '199262'
                WHERE ordernumber = 'P200705110218392' 
            
2024-07-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '116108'
                WHERE ordernumber = 'P200705110303552' 
            
2024-07-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399806'
                WHERE ordernumber = 'P190705110500444' 
            
2024-07-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399805'
                WHERE ordernumber = 'P200705110502820' 
            
2024-07-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93879'
                WHERE ordernumber = 'P200705110547769' 
            
2024-07-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399807'
                WHERE ordernumber = 'P420705110630278' 
            
2024-07-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399808'
                WHERE ordernumber = 'P190705110657233' 
            
2024-07-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399809'
                WHERE ordernumber = 'P180705110850573' 
            
2024-07-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399810'
                WHERE ordernumber = 'P190705110921664' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345881'
                WHERE ordernumber = 'P200705111244682' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399811'
                WHERE ordernumber = 'P630705111349535' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '215258'
                WHERE ordernumber = 'P180705111837374' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '215258'
                WHERE ordernumber = 'P180705111927192' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399813'
                WHERE ordernumber = 'P180705112126244' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277935'
                WHERE ordernumber = 'P420705112349783' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276100'
                WHERE ordernumber = 'P630705112402288' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278310'
                WHERE ordernumber = 'P200705112458876' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399814'
                WHERE ordernumber = 'P420705112503571' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '363743'
                WHERE ordernumber = 'P180705113003442' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399816'
                WHERE ordernumber = 'P420705113224977' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399817'
                WHERE ordernumber = 'P180705113311244' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '39674'
                WHERE ordernumber = 'P630705113321770' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399415'
                WHERE ordernumber = 'P420705113425123' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381326'
                WHERE ordernumber = 'P420705113628967' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '132768'
                WHERE ordernumber = 'P200705114030553' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398636'
                WHERE ordernumber = 'P420705114146144' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '217809'
                WHERE ordernumber = 'P200705114330794' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399818'
                WHERE ordernumber = 'P180705114341113' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '123829'
                WHERE ordernumber = 'P200705114459748' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276577'
                WHERE ordernumber = 'P180705114848201' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382282'
                WHERE ordernumber = 'P420705114853730' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399820'
                WHERE ordernumber = 'P200705115152435' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399821'
                WHERE ordernumber = 'P420705115159275' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399822'
                WHERE ordernumber = 'P180705115638500' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '256804'
                WHERE ordernumber = 'P180705115842514' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348860'
                WHERE ordernumber = 'P200705115900681' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '274900'
                WHERE ordernumber = 'P190705120140316' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337863'
                WHERE ordernumber = 'P420705121222523' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399824'
                WHERE ordernumber = 'P420705121409600' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399825'
                WHERE ordernumber = 'P630705121521759' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399826'
                WHERE ordernumber = 'P200705121839504' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345515'
                WHERE ordernumber = 'P200705122438445' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '334358'
                WHERE ordernumber = 'P180705122619709' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '133351'
                WHERE ordernumber = 'P200705122857345' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399828'
                WHERE ordernumber = 'P180705123440988' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399828'
                WHERE ordernumber = 'P180705123858131' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399829'
                WHERE ordernumber = 'P190705124103220' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387901'
                WHERE ordernumber = 'P200705124128906' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399831'
                WHERE ordernumber = 'P630705124411204' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '303719'
                WHERE ordernumber = 'P420705124524861' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387378'
                WHERE ordernumber = 'P420705124626911' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '314798'
                WHERE ordernumber = 'P420705124843398' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '209575'
                WHERE ordernumber = 'P190705124940598' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102473'
                WHERE ordernumber = 'P180705125026133' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399832'
                WHERE ordernumber = 'P200705125434858' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237374'
                WHERE ordernumber = 'P180705125537879' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389488'
                WHERE ordernumber = 'P630705125635911' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '320225'
                WHERE ordernumber = 'P180705125714376' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399833'
                WHERE ordernumber = 'P630705125821291' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99522'
                WHERE ordernumber = 'P180705130106511' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '280528'
                WHERE ordernumber = 'P630705131004380' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301491'
                WHERE ordernumber = 'P630705131045768' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399836'
                WHERE ordernumber = 'P630705131233177' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399835'
                WHERE ordernumber = 'P180705131324795' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399838'
                WHERE ordernumber = 'P630705131354715' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399837'
                WHERE ordernumber = 'P200705131517535' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399839'
                WHERE ordernumber = 'P630705131534703' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356723'
                WHERE ordernumber = 'P630705131620308' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359064'
                WHERE ordernumber = 'P200705131919257' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237296'
                WHERE ordernumber = 'P180705131935801' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399840'
                WHERE ordernumber = 'P420705132028141' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399841'
                WHERE ordernumber = 'P190705132031909' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '322385'
                WHERE ordernumber = 'P180705132121866' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399842'
                WHERE ordernumber = 'P420705132147307' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '307366'
                WHERE ordernumber = 'P420705132241300' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356286'
                WHERE ordernumber = 'P180705132355672' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '104347'
                WHERE ordernumber = 'P200705132539530' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344685'
                WHERE ordernumber = 'P180705133119969' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399844'
                WHERE ordernumber = 'P420705133152366' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114142'
                WHERE ordernumber = 'P180705133354542' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '328660'
                WHERE ordernumber = 'P180705133558752' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399845'
                WHERE ordernumber = 'P630705133855553' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399846'
                WHERE ordernumber = 'P180705134115331' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399847'
                WHERE ordernumber = 'P180705134235663' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399030'
                WHERE ordernumber = 'P420705134403261' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399848'
                WHERE ordernumber = 'P180705134947319' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399850'
                WHERE ordernumber = 'P180705135215862' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388488'
                WHERE ordernumber = 'P180705135543732' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '308242'
                WHERE ordernumber = 'P180705135716544' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399854'
                WHERE ordernumber = 'P420705140054625' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '279039'
                WHERE ordernumber = 'P200705140239201' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399855'
                WHERE ordernumber = 'P180705140240234' 
            
2024-07-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399857'
                WHERE ordernumber = 'P630705141151497' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399859'
                WHERE ordernumber = 'P630705141954224' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399861'
                WHERE ordernumber = 'P420705142909387' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399863'
                WHERE ordernumber = 'P420705143402574' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '285090'
                WHERE ordernumber = 'P180705143456429' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '305944'
                WHERE ordernumber = 'P200705143655753' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '305944'
                WHERE ordernumber = 'P200705143743952' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '340910'
                WHERE ordernumber = 'P420705143919963' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399864'
                WHERE ordernumber = 'P200705143926295' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '249947'
                WHERE ordernumber = 'P200705144645845' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399866'
                WHERE ordernumber = 'P630705144655963' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399695'
                WHERE ordernumber = 'P420705145739641' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399867'
                WHERE ordernumber = 'P420705145902192' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399867'
                WHERE ordernumber = 'P420705150228928' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399868'
                WHERE ordernumber = 'P630705150554485' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399776'
                WHERE ordernumber = 'P180705150558279' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '96943'
                WHERE ordernumber = 'P180705151012145' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399869'
                WHERE ordernumber = 'P200705151112291' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399870'
                WHERE ordernumber = 'P200705151320959' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '293741'
                WHERE ordernumber = 'P180705151330136' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '365153'
                WHERE ordernumber = 'P190705152254111' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399871'
                WHERE ordernumber = 'P200705152635347' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399873'
                WHERE ordernumber = 'P180705153555224' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386121'
                WHERE ordernumber = 'P180705153950743' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384434'
                WHERE ordernumber = 'P190705154216324' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384434'
                WHERE ordernumber = 'P190705154254206' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '261162'
                WHERE ordernumber = 'P190705154429644' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399875'
                WHERE ordernumber = 'P200705154521807' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '41021'
                WHERE ordernumber = 'P190705154828260' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399876'
                WHERE ordernumber = 'P180705154957311' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '287188'
                WHERE ordernumber = 'P180705155501518' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384013'
                WHERE ordernumber = 'P190705155728843' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '346559'
                WHERE ordernumber = 'P180705155727863' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '307060'
                WHERE ordernumber = 'P190705155848461' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399879'
                WHERE ordernumber = 'P190705160009464' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399880'
                WHERE ordernumber = 'P180705160636828' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399881'
                WHERE ordernumber = 'P420705160741418' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '340830'
                WHERE ordernumber = 'P180705161135416' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '308971'
                WHERE ordernumber = 'P420705161257775' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '94814'
                WHERE ordernumber = 'P420705161408476' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '220125'
                WHERE ordernumber = 'P180705161430210' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399852'
                WHERE ordernumber = 'P420705161731151' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '337251'
                WHERE ordernumber = 'P200705161902266' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399882'
                WHERE ordernumber = 'P190705162117209' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399884'
                WHERE ordernumber = 'P180705162235184' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399885'
                WHERE ordernumber = 'P420705162315390' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '286322'
                WHERE ordernumber = 'P180705162757807' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399887'
                WHERE ordernumber = 'P190705163052149' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399886'
                WHERE ordernumber = 'P180705163334856' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '385263'
                WHERE ordernumber = 'P180705163439475' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399888'
                WHERE ordernumber = 'P420705163503395' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399889'
                WHERE ordernumber = 'P200705163546610' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399888'
                WHERE ordernumber = 'P420705163503395' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '118039'
                WHERE ordernumber = 'P180705163949459' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399890'
                WHERE ordernumber = 'P200705164030170' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399891'
                WHERE ordernumber = 'P200705164158249' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399892'
                WHERE ordernumber = 'P200705164318472' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '392762'
                WHERE ordernumber = 'P180705164718962' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399894'
                WHERE ordernumber = 'P630705164846380' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '369333'
                WHERE ordernumber = 'P180705165016409' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '81469'
                WHERE ordernumber = 'P180705165113965' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '222034'
                WHERE ordernumber = 'P420705165523462' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '370247'
                WHERE ordernumber = 'P200705165600172' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399897'
                WHERE ordernumber = 'P630705165806879' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '297135'
                WHERE ordernumber = 'P420705165831525' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '365063'
                WHERE ordernumber = 'P180705165922568' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399898'
                WHERE ordernumber = 'P190705170041182' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '243770'
                WHERE ordernumber = 'P190705170146436' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399835'
                WHERE ordernumber = 'P180705170447410' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399895'
                WHERE ordernumber = 'P190705170546438' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399899'
                WHERE ordernumber = 'P630705170715424' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399312'
                WHERE ordernumber = 'P190705170837936' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399900'
                WHERE ordernumber = 'P190705171046739' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399895'
                WHERE ordernumber = 'P180705171135539' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '270167'
                WHERE ordernumber = 'P190705171432296' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399901'
                WHERE ordernumber = 'P200705171449112' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399902'
                WHERE ordernumber = 'P420705171532162' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '284742'
                WHERE ordernumber = 'P190705171658778' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399903'
                WHERE ordernumber = 'P190705171949924' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399904'
                WHERE ordernumber = 'P630705172208180' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399906'
                WHERE ordernumber = 'P190705172818457' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '264712'
                WHERE ordernumber = 'P180705172906778' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '114408'
                WHERE ordernumber = 'P190705173025898' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399888'
                WHERE ordernumber = 'P420705163503395' 
            
2024-07-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399907'
                WHERE ordernumber = 'P630705173415683' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399908'
                WHERE ordernumber = 'P190705173609564' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399909'
                WHERE ordernumber = 'P630705173613816' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399910'
                WHERE ordernumber = 'P200705173655992' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '241095'
                WHERE ordernumber = 'P180705173655587' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399912'
                WHERE ordernumber = 'P200705174012393' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399913'
                WHERE ordernumber = 'P180705174207238' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399911'
                WHERE ordernumber = 'P200705174619647' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399334'
                WHERE ordernumber = 'P200705174813199' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '392504'
                WHERE ordernumber = 'P200705175139619' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '282856'
                WHERE ordernumber = 'P420705175151894' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '105669'
                WHERE ordernumber = 'P200705175255532' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399914'
                WHERE ordernumber = 'P180705175313211' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '236934'
                WHERE ordernumber = 'P190705175314812' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399915'
                WHERE ordernumber = 'P630705175435318' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399916'
                WHERE ordernumber = 'P180705175807195' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352410'
                WHERE ordernumber = 'P180705175858758' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399917'
                WHERE ordernumber = 'P420705180007731' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '307366'
                WHERE ordernumber = 'P420705180221600' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399919'
                WHERE ordernumber = 'P630705180400745' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353647'
                WHERE ordernumber = 'P190705180501498' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399920'
                WHERE ordernumber = 'P180705180632577' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399505'
                WHERE ordernumber = 'P200705180837194' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399922'
                WHERE ordernumber = 'P190705181009982' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399923'
                WHERE ordernumber = 'P420705181118596' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '397026'
                WHERE ordernumber = 'P200705181215455' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '124407'
                WHERE ordernumber = 'P190705181229489' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '261867'
                WHERE ordernumber = 'P190705181346839' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '207977'
                WHERE ordernumber = 'P200705181446792' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399924'
                WHERE ordernumber = 'P200705181648555' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '124033'
                WHERE ordernumber = 'P180705181707729' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399925'
                WHERE ordernumber = 'P200705181834569' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399926'
                WHERE ordernumber = 'P180705181947869' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '64196'
                WHERE ordernumber = 'P190705182134903' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399929'
                WHERE ordernumber = 'P200705183131743' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399930'
                WHERE ordernumber = 'P630705183625956' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399931'
                WHERE ordernumber = 'P630705183738159' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '203441'
                WHERE ordernumber = 'P630705183842989' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399932'
                WHERE ordernumber = 'P420705184214891' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399328'
                WHERE ordernumber = 'P180705184224340' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '66860'
                WHERE ordernumber = 'P190705184324144' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399933'
                WHERE ordernumber = 'P180705184535225' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399934'
                WHERE ordernumber = 'P200705184645774' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399936'
                WHERE ordernumber = 'P200705184824786' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399935'
                WHERE ordernumber = 'P420705184856953' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '230903'
                WHERE ordernumber = 'P630705184919885' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '125335'
                WHERE ordernumber = 'P190705185123724' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399937'
                WHERE ordernumber = 'P200705185128194' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399938'
                WHERE ordernumber = 'P630705185149267' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '180494'
                WHERE ordernumber = 'P190705185310800' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399939'
                WHERE ordernumber = 'P420705185341592' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '333176'
                WHERE ordernumber = 'P200705185439547' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '358503'
                WHERE ordernumber = 'P420705185500890' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399940'
                WHERE ordernumber = 'P200705185535715' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399941'
                WHERE ordernumber = 'P190705185759608' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399942'
                WHERE ordernumber = 'P190705185940867' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399897'
                WHERE ordernumber = 'P630705190044792' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399943'
                WHERE ordernumber = 'P190705190049551' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '107278'
                WHERE ordernumber = 'P190705190842966' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '396405'
                WHERE ordernumber = 'P630705191026534' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '103342'
                WHERE ordernumber = 'P200705191534944' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399945'
                WHERE ordernumber = 'P200705191925177' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '316531'
                WHERE ordernumber = 'P200705192502285' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399946'
                WHERE ordernumber = 'P190705192544605' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '308644'
                WHERE ordernumber = 'P190705193121598' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399947'
                WHERE ordernumber = 'P190705193216415' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '371020'
                WHERE ordernumber = 'P630705193254539' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '311285'
                WHERE ordernumber = 'P190705193257413' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399948'
                WHERE ordernumber = 'P630705193356477' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399638'
                WHERE ordernumber = 'P190705193443210' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399949'
                WHERE ordernumber = 'P630705193726225' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '245393'
                WHERE ordernumber = 'P200705194135363' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '394861'
                WHERE ordernumber = 'P200705194322964' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '346792'
                WHERE ordernumber = 'P190705194322230' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399950'
                WHERE ordernumber = 'P200705194638682' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '309074'
                WHERE ordernumber = 'P190705194904285' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399951'
                WHERE ordernumber = 'P630705195210878' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399952'
                WHERE ordernumber = 'P200705195742951' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399953'
                WHERE ordernumber = 'P630705200132730' 
            
2024-07-06 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '335815'
                WHERE ordernumber = 'P630705201412383' 
            
2024-07-06 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '399955'
                WHERE ordernumber = 'P630705205113751' 
            
2024-07-06 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '399957'
                WHERE ordernumber = 'P630705213641557'