2024-10-17 01:00:01 -- 將會員中心id寫入data-lake
2024-10-17 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-16%';
        
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '212111'
                WHERE ordernumber = 'P181016110637746' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426083'
                WHERE ordernumber = 'P201016111128784' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426082'
                WHERE ordernumber = 'P181016111232530' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '408701'
                WHERE ordernumber = 'P421016111324580' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '122204'
                WHERE ordernumber = 'P631016111511253' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426084'
                WHERE ordernumber = 'P181016111515310' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426085'
                WHERE ordernumber = 'P181016111834521' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426087'
                WHERE ordernumber = 'P201016112300315' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426088'
                WHERE ordernumber = 'P771016112545663' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '297128'
                WHERE ordernumber = 'P201016112650179' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426089'
                WHERE ordernumber = 'P421016112657120' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426090'
                WHERE ordernumber = 'P421016112817321' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99126'
                WHERE ordernumber = 'P181016113139531' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426091'
                WHERE ordernumber = 'P181016113215305' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426093'
                WHERE ordernumber = 'P421016113350774' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396445'
                WHERE ordernumber = 'P421016113450305' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426094'
                WHERE ordernumber = 'P181016114040688' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423826'
                WHERE ordernumber = 'P771016115108431' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426095'
                WHERE ordernumber = 'P421016115239829' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '235985'
                WHERE ordernumber = 'P201016115302369' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426096'
                WHERE ordernumber = 'P771016120203730' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426097'
                WHERE ordernumber = 'P181016120345724' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426099'
                WHERE ordernumber = 'P201016120734219' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385967'
                WHERE ordernumber = 'P201016121300341' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '324062'
                WHERE ordernumber = 'P181016121630511' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426101'
                WHERE ordernumber = 'P181016122817494' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426103'
                WHERE ordernumber = 'P181016123010485' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420965'
                WHERE ordernumber = 'P421016123012673' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386992'
                WHERE ordernumber = 'P181016123140647' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426102'
                WHERE ordernumber = 'P731016123250245' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '148561'
                WHERE ordernumber = 'P181016123637317' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '375232'
                WHERE ordernumber = 'P181016124024154' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '285414'
                WHERE ordernumber = 'P201016124251317' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '328228'
                WHERE ordernumber = 'P181016124316661' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '136257'
                WHERE ordernumber = 'P771016124351875' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426105'
                WHERE ordernumber = 'P421016124745405' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423754'
                WHERE ordernumber = 'P421016125437650' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '137065'
                WHERE ordernumber = 'P181016125452843' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426109'
                WHERE ordernumber = 'P181016130516403' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '95007'
                WHERE ordernumber = 'P181016130623883' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426108'
                WHERE ordernumber = 'P731016130646634' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '95007'
                WHERE ordernumber = 'P181016130812953' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '95007'
                WHERE ordernumber = 'P181016130904808' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426109'
                WHERE ordernumber = 'P181016131203429' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426110'
                WHERE ordernumber = 'P771016132018774' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426111'
                WHERE ordernumber = 'P711016132216371' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '181598'
                WHERE ordernumber = 'P771016132307874' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426113'
                WHERE ordernumber = 'P181016132508150' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426112'
                WHERE ordernumber = 'P771016132709793' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350559'
                WHERE ordernumber = 'P201016132714414' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426114'
                WHERE ordernumber = 'P181016133137443' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '404069'
                WHERE ordernumber = 'P421016133215738' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '192556'
                WHERE ordernumber = 'P191016133446483' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426116'
                WHERE ordernumber = 'P771016133448884' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426115'
                WHERE ordernumber = 'P181016133508865' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '335250'
                WHERE ordernumber = 'P771016133637553' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '55581'
                WHERE ordernumber = 'P421016134006301' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '242048'
                WHERE ordernumber = 'P191016134100921' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426118'
                WHERE ordernumber = 'P731016134145275' 
            
2024-10-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426117'
                WHERE ordernumber = 'P421016134316381' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '79520'
                WHERE ordernumber = 'P181016134530402' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422790'
                WHERE ordernumber = 'P421016134620461' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426115'
                WHERE ordernumber = 'P181016134929875' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339109'
                WHERE ordernumber = 'P181016135001372' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422790'
                WHERE ordernumber = 'P421016135205734' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314804'
                WHERE ordernumber = 'P201016135448776' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395962'
                WHERE ordernumber = 'P201016135655853' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230115'
                WHERE ordernumber = 'P181016140809373' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426120'
                WHERE ordernumber = 'P181016141049574' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426119'
                WHERE ordernumber = 'P731016141310983' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426119'
                WHERE ordernumber = 'P731016141442421' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302675'
                WHERE ordernumber = 'P771016141615419' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426122'
                WHERE ordernumber = 'P771016142152591' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '168395'
                WHERE ordernumber = 'P201016142157658' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426121'
                WHERE ordernumber = 'P181016142303521' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426123'
                WHERE ordernumber = 'P181016142432400' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426124'
                WHERE ordernumber = 'P421016142627778' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405782'
                WHERE ordernumber = 'P421016142725698' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426125'
                WHERE ordernumber = 'P201016142941948' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384691'
                WHERE ordernumber = 'P181016143044155' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283840'
                WHERE ordernumber = 'P181016143150648' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426127'
                WHERE ordernumber = 'P191016143743206' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423488'
                WHERE ordernumber = 'P711016144240919' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423699'
                WHERE ordernumber = 'P421016144547258' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423699'
                WHERE ordernumber = 'P421016144645908' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426129'
                WHERE ordernumber = 'P181016144753598' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426131'
                WHERE ordernumber = 'P731016145025803' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426128'
                WHERE ordernumber = 'P181016145102298' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396973'
                WHERE ordernumber = 'P201016145518822' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365668'
                WHERE ordernumber = 'P421016145733184' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426132'
                WHERE ordernumber = 'P201016150318864' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289689'
                WHERE ordernumber = 'P181016150455317' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426135'
                WHERE ordernumber = 'P421016150819613' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426135'
                WHERE ordernumber = 'P421016150947603' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '369363'
                WHERE ordernumber = 'P731016151254534' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395605'
                WHERE ordernumber = 'P181016151510990' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426136'
                WHERE ordernumber = 'P201016151539690' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '117329'
                WHERE ordernumber = 'P181016151901336' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424663'
                WHERE ordernumber = 'P191016152038875' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426137'
                WHERE ordernumber = 'P201016152208189' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388070'
                WHERE ordernumber = 'P181016152340860' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426138'
                WHERE ordernumber = 'P181016152503595' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P181016152605387' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426139'
                WHERE ordernumber = 'P771016153058374' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279829'
                WHERE ordernumber = 'P201016153342833' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426140'
                WHERE ordernumber = 'P591016153823439' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426141'
                WHERE ordernumber = 'P181016154045967' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228553'
                WHERE ordernumber = 'P181016154523303' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291671'
                WHERE ordernumber = 'P771016154547765' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426142'
                WHERE ordernumber = 'P421016154716691' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426143'
                WHERE ordernumber = 'P421016155001727' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426144'
                WHERE ordernumber = 'P201016155018470' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '294789'
                WHERE ordernumber = 'P421016155247543' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '322480'
                WHERE ordernumber = 'P181016155336619' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426146'
                WHERE ordernumber = 'P771016160026984' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426147'
                WHERE ordernumber = 'P201016160342645' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425852'
                WHERE ordernumber = 'P191016160755902' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398835'
                WHERE ordernumber = 'P201016161125648' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98048'
                WHERE ordernumber = 'P201016161559290' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426149'
                WHERE ordernumber = 'P421016162057920' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98048'
                WHERE ordernumber = 'P201016162159609' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300032'
                WHERE ordernumber = 'P181016162231124' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426150'
                WHERE ordernumber = 'P181016162354801' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426153'
                WHERE ordernumber = 'P771016163056701' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424444'
                WHERE ordernumber = 'P591016163318683' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291320'
                WHERE ordernumber = 'P181016163908609' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426154'
                WHERE ordernumber = 'P711016163922825' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426155'
                WHERE ordernumber = 'P201016164101739' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426156'
                WHERE ordernumber = 'P201016164315564' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '141290'
                WHERE ordernumber = 'P181016164516471' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239063'
                WHERE ordernumber = 'P181016164712238' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403267'
                WHERE ordernumber = 'P181016165611774' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426157'
                WHERE ordernumber = 'P181016165746133' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426160'
                WHERE ordernumber = 'P181016170702885' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409234'
                WHERE ordernumber = 'P421016171216868' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426164'
                WHERE ordernumber = 'P181016171217296' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426165'
                WHERE ordernumber = 'P201016171311823' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426166'
                WHERE ordernumber = 'P181016171323281' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242124'
                WHERE ordernumber = 'P181016171850551' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426163'
                WHERE ordernumber = 'P591016172117580' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381779'
                WHERE ordernumber = 'P181016172822947' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426167'
                WHERE ordernumber = 'P421016173028387' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423425'
                WHERE ordernumber = 'P181016173458382' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423425'
                WHERE ordernumber = 'P181016173539475' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '115343'
                WHERE ordernumber = 'P201016173544353' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423425'
                WHERE ordernumber = 'P181016173647467' 
            
2024-10-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424593'
                WHERE ordernumber = 'P181016173750163' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98920'
                WHERE ordernumber = 'P181016173933132' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426168'
                WHERE ordernumber = 'P771016173947561' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423113'
                WHERE ordernumber = 'P181016174034679' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426169'
                WHERE ordernumber = 'P181016174429827' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426171'
                WHERE ordernumber = 'P201016174603264' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426169'
                WHERE ordernumber = 'P181016174626484' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426172'
                WHERE ordernumber = 'P181016174750729' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425939'
                WHERE ordernumber = 'P201016175044838' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426174'
                WHERE ordernumber = 'P181016175556861' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426173'
                WHERE ordernumber = 'P591016175804243' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426170'
                WHERE ordernumber = 'P191016175929464' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '244185'
                WHERE ordernumber = 'P201016180344983' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '111673'
                WHERE ordernumber = 'P181016180345437' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426175'
                WHERE ordernumber = 'P181016180528415' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '291258'
                WHERE ordernumber = 'P711016180645831' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426070'
                WHERE ordernumber = 'P201016180737136' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '291258'
                WHERE ordernumber = 'P711016180812169' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306379'
                WHERE ordernumber = 'P421016181408140' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '108286'
                WHERE ordernumber = 'P181016181415716' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '317371'
                WHERE ordernumber = 'P181016181510547' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412205'
                WHERE ordernumber = 'P181016181924389' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426178'
                WHERE ordernumber = 'P421016182117976' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '286632'
                WHERE ordernumber = 'P181016182401482' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '86860'
                WHERE ordernumber = 'P421016182453295' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '248042'
                WHERE ordernumber = 'P201016182544343' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284766'
                WHERE ordernumber = 'P181016182625874' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426179'
                WHERE ordernumber = 'P201016182736748' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426180'
                WHERE ordernumber = 'P181016182901990' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426181'
                WHERE ordernumber = 'P181016183342406' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426182'
                WHERE ordernumber = 'P421016184058465' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426183'
                WHERE ordernumber = 'P421016184412190' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426184'
                WHERE ordernumber = 'P201016184536997' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426185'
                WHERE ordernumber = 'P201016185315667' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '228348'
                WHERE ordernumber = 'P191016185316177' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417776'
                WHERE ordernumber = 'P201016185400985' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '303501'
                WHERE ordernumber = 'P771016185708919' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426186'
                WHERE ordernumber = 'P421016185712603' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390050'
                WHERE ordernumber = 'P201016185930732' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426187'
                WHERE ordernumber = 'P191016190059911' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423407'
                WHERE ordernumber = 'P711016190342371' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426189'
                WHERE ordernumber = 'P711016190631501' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313303'
                WHERE ordernumber = 'P201016190732596' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '369737'
                WHERE ordernumber = 'P191016191549163' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '93414'
                WHERE ordernumber = 'P201016191727235' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426184'
                WHERE ordernumber = 'P201016192114548' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '244544'
                WHERE ordernumber = 'P201016192314388' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399936'
                WHERE ordernumber = 'P201016193310739' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426194'
                WHERE ordernumber = 'P191016193519225' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426193'
                WHERE ordernumber = 'P191016193947135' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '327990'
                WHERE ordernumber = 'P191016194201833' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419235'
                WHERE ordernumber = 'P191016194410231' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426195'
                WHERE ordernumber = 'P711016194455269' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337912'
                WHERE ordernumber = 'P771016195234994' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '243601'
                WHERE ordernumber = 'P201016195717459' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '226240'
                WHERE ordernumber = 'P191016200021362' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '243601'
                WHERE ordernumber = 'P201016200155340' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426197'
                WHERE ordernumber = 'P771016201734202' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426200'
                WHERE ordernumber = 'P771016203437803' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426202'
                WHERE ordernumber = 'P771016204145696' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426203'
                WHERE ordernumber = 'P771016205154578' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426204'
                WHERE ordernumber = 'P771016205403576' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276344'
                WHERE ordernumber = 'P591016205610778' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276344'
                WHERE ordernumber = 'P591016205954596' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426205'
                WHERE ordernumber = 'P771016210151200' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422204'
                WHERE ordernumber = 'P711016210618398' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426206'
                WHERE ordernumber = 'P711016211322305' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302058'
                WHERE ordernumber = 'P771016211609218' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426209'
                WHERE ordernumber = 'P771016212211634' 
            
2024-10-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '158000'
                WHERE ordernumber = 'P771016215301778'