2024-04-28 01:00:01 -- 將會員中心id寫入data-lake
2024-04-28 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-04-27%';
        
2024-04-28 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '387186'
                WHERE ordernumber = 'P420427105056579' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '372758'
                WHERE ordernumber = 'P200427110229719' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '321635'
                WHERE ordernumber = 'P200427110607146' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355931'
                WHERE ordernumber = 'P190427110626645' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '271997'
                WHERE ordernumber = 'P200427110658829' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378054'
                WHERE ordernumber = 'P200427110750303' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '362719'
                WHERE ordernumber = 'P180427110836734' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387190'
                WHERE ordernumber = 'P190427110955663' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387078'
                WHERE ordernumber = 'P420427111227991' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '294916'
                WHERE ordernumber = 'P190427111259997' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '96014'
                WHERE ordernumber = 'P180427111540922' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '223138'
                WHERE ordernumber = 'P180427112256693' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '363159'
                WHERE ordernumber = 'P420427112424992' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387191'
                WHERE ordernumber = 'P200427112647485' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '368021'
                WHERE ordernumber = 'P190427113214757' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '286957'
                WHERE ordernumber = 'P200427113527444' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387192'
                WHERE ordernumber = 'P420427113704251' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '93632'
                WHERE ordernumber = 'P200427114028157' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '364974'
                WHERE ordernumber = 'P190427114035838' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348246'
                WHERE ordernumber = 'P420427114059910' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '290185'
                WHERE ordernumber = 'P420427114735152' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100659'
                WHERE ordernumber = 'P630427115225464' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387194'
                WHERE ordernumber = 'P180427115521444' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '347019'
                WHERE ordernumber = 'P630427115617984' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378293'
                WHERE ordernumber = 'P420427115644340' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '209892'
                WHERE ordernumber = 'P630427120028514' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387195'
                WHERE ordernumber = 'P630427120226480' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387195'
                WHERE ordernumber = 'P630427120319658' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '236474'
                WHERE ordernumber = 'P180427120329314' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180427121330454' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381510'
                WHERE ordernumber = 'P180427121739818' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387196'
                WHERE ordernumber = 'P630427121936526' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387197'
                WHERE ordernumber = 'P420427122157155' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387198'
                WHERE ordernumber = 'P420427122649920' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '271765'
                WHERE ordernumber = 'P180427122758685' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386309'
                WHERE ordernumber = 'P420427123133270' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387199'
                WHERE ordernumber = 'P180427123313247' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '294539'
                WHERE ordernumber = 'P420427123318746' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '286027'
                WHERE ordernumber = 'P200427123347376' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '366190'
                WHERE ordernumber = 'P180427123501706' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '318743'
                WHERE ordernumber = 'P180427123638815' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '359866'
                WHERE ordernumber = 'P630427123659216' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387201'
                WHERE ordernumber = 'P200427124200159' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '279848'
                WHERE ordernumber = 'P180427124342676' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '271495'
                WHERE ordernumber = 'P180427125542237' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '104875'
                WHERE ordernumber = 'P190427125624802' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '271495'
                WHERE ordernumber = 'P180427125643773' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '302285'
                WHERE ordernumber = 'P180427130105324' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387202'
                WHERE ordernumber = 'P630427130242290' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386187'
                WHERE ordernumber = 'P200427130618149' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386187'
                WHERE ordernumber = 'P200427130650826' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387204'
                WHERE ordernumber = 'P630427130746661' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387200'
                WHERE ordernumber = 'P180427131238339' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387200'
                WHERE ordernumber = 'P180427131543705' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '271033'
                WHERE ordernumber = 'P200427131631722' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '289505'
                WHERE ordernumber = 'P180427131719232' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387206'
                WHERE ordernumber = 'P180427131851607' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '238090'
                WHERE ordernumber = 'P180427132312318' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387207'
                WHERE ordernumber = 'P420427132437506' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387208'
                WHERE ordernumber = 'P200427132455685' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '236420'
                WHERE ordernumber = 'P200427132535427' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387207'
                WHERE ordernumber = 'P420427132716398' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '281780'
                WHERE ordernumber = 'P630427133046791' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '276251'
                WHERE ordernumber = 'P200427133415928' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '229681'
                WHERE ordernumber = 'P420427133738503' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382792'
                WHERE ordernumber = 'P200427134819976' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '229284'
                WHERE ordernumber = 'P200427134854453' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '161113'
                WHERE ordernumber = 'P200427134931622' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '98914'
                WHERE ordernumber = 'P180427135302421' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387211'
                WHERE ordernumber = 'P180427135524474' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387210'
                WHERE ordernumber = 'P630427135546457' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387212'
                WHERE ordernumber = 'P180427135617701' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '340424'
                WHERE ordernumber = 'P200427135750290' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '236377'
                WHERE ordernumber = 'P200427135853504' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387213'
                WHERE ordernumber = 'P420427140315296' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '222609'
                WHERE ordernumber = 'P180427140710519' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387214'
                WHERE ordernumber = 'P420427140724325' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379026'
                WHERE ordernumber = 'P180427141306756' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387217'
                WHERE ordernumber = 'P200427141334737' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '207245'
                WHERE ordernumber = 'P180427141806826' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '155800'
                WHERE ordernumber = 'P630427141835257' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387218'
                WHERE ordernumber = 'P190427142008192' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387219'
                WHERE ordernumber = 'P200427142115837' 
            
2024-04-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '74290'
                WHERE ordernumber = 'P420427142624852' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '53681'
                WHERE ordernumber = 'P420427143019363' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387214'
                WHERE ordernumber = 'P420427143537283' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387221'
                WHERE ordernumber = 'P630427143559661' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387222'
                WHERE ordernumber = 'P180427143821981' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '146262'
                WHERE ordernumber = 'P180427143930124' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340150'
                WHERE ordernumber = 'P180427144220550' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '328399'
                WHERE ordernumber = 'P420427144243387' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384569'
                WHERE ordernumber = 'P190427144311474' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384569'
                WHERE ordernumber = 'P190427144409404' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387223'
                WHERE ordernumber = 'P180427144553145' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387224'
                WHERE ordernumber = 'P200427144638875' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387226'
                WHERE ordernumber = 'P200427144747594' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387225'
                WHERE ordernumber = 'P630427144748860' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302925'
                WHERE ordernumber = 'P180427144959709' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387203'
                WHERE ordernumber = 'P420427145039296' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387227'
                WHERE ordernumber = 'P180427145154121' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382771'
                WHERE ordernumber = 'P190427145304474' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '124039'
                WHERE ordernumber = 'P200427145445800' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '86290'
                WHERE ordernumber = 'P420427145532847' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '330642'
                WHERE ordernumber = 'P420427145619527' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387214'
                WHERE ordernumber = 'P420427150037500' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '318647'
                WHERE ordernumber = 'P420427150230914' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101160'
                WHERE ordernumber = 'P200427150438171' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387229'
                WHERE ordernumber = 'P200427150711387' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387230'
                WHERE ordernumber = 'P630427151353511' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344874'
                WHERE ordernumber = 'P420427151539911' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '50320'
                WHERE ordernumber = 'P630427151721692' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387231'
                WHERE ordernumber = 'P420427151724309' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383475'
                WHERE ordernumber = 'P420427152001156' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334954'
                WHERE ordernumber = 'P420427152134488' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380724'
                WHERE ordernumber = 'P180427152311625' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387232'
                WHERE ordernumber = 'P420427152322250' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387169'
                WHERE ordernumber = 'P200427152401644' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '180470'
                WHERE ordernumber = 'P200427152903597' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387234'
                WHERE ordernumber = 'P420427153000497' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387235'
                WHERE ordernumber = 'P420427153127193' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94814'
                WHERE ordernumber = 'P180427153229890' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383207'
                WHERE ordernumber = 'P180427154026917' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248977'
                WHERE ordernumber = 'P200427154234878' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387236'
                WHERE ordernumber = 'P180427154521354' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386120'
                WHERE ordernumber = 'P200427154544874' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '49200'
                WHERE ordernumber = 'P420427154935907' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284415'
                WHERE ordernumber = 'P200427155104818' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387237'
                WHERE ordernumber = 'P180427155116354' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387238'
                WHERE ordernumber = 'P200427155153503' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379951'
                WHERE ordernumber = 'P180427155419803' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341299'
                WHERE ordernumber = 'P190427155422195' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387239'
                WHERE ordernumber = 'P190427155457828' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387240'
                WHERE ordernumber = 'P180427160138308' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371964'
                WHERE ordernumber = 'P420427160237347' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387241'
                WHERE ordernumber = 'P180427160300315' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '252565'
                WHERE ordernumber = 'P180427160346681' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387242'
                WHERE ordernumber = 'P190427161137237' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387243'
                WHERE ordernumber = 'P420427161316777' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387245'
                WHERE ordernumber = 'P630427162210696' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '246453'
                WHERE ordernumber = 'P200427162252449' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387246'
                WHERE ordernumber = 'P200427162725183' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377003'
                WHERE ordernumber = 'P630427162727112' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351673'
                WHERE ordernumber = 'P180427162744706' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387244'
                WHERE ordernumber = 'P180427162855867' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387247'
                WHERE ordernumber = 'P190427163051962' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380768'
                WHERE ordernumber = 'P590427163147514' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380769'
                WHERE ordernumber = 'P590427163303214' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '316106'
                WHERE ordernumber = 'P200427163430478' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387250'
                WHERE ordernumber = 'P180427163646888' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387251'
                WHERE ordernumber = 'P180427163943459' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '165404'
                WHERE ordernumber = 'P200427164159324' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387252'
                WHERE ordernumber = 'P420427164220320' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387253'
                WHERE ordernumber = 'P200427164250215' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '321217'
                WHERE ordernumber = 'P420427164804681' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '288429'
                WHERE ordernumber = 'P180427164914703' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387254'
                WHERE ordernumber = 'P190427165211234' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387255'
                WHERE ordernumber = 'P180427165603781' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387256'
                WHERE ordernumber = 'P200427165712511' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '146945'
                WHERE ordernumber = 'P180427170059511' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387257'
                WHERE ordernumber = 'P200427170224414' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387259'
                WHERE ordernumber = 'P630427170344862' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '332478'
                WHERE ordernumber = 'P200427170359528' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387258'
                WHERE ordernumber = 'P420427170451868' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387260'
                WHERE ordernumber = 'P180427170654264' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238114'
                WHERE ordernumber = 'P200427170658568' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '173328'
                WHERE ordernumber = 'P200427170942851' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387261'
                WHERE ordernumber = 'P420427171600392' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276368'
                WHERE ordernumber = 'P200427171615859' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387262'
                WHERE ordernumber = 'P200427171722813' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281300'
                WHERE ordernumber = 'P180427171811830' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387228'
                WHERE ordernumber = 'P420427171821578' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387263'
                WHERE ordernumber = 'P200427171937804' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245940'
                WHERE ordernumber = 'P200427172219315' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '122712'
                WHERE ordernumber = 'P420427172826727' 
            
2024-04-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387264'
                WHERE ordernumber = 'P200427173037652' 
            
2024-04-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301616'
                WHERE ordernumber = 'P180427173510556' 
            
2024-04-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '229851'
                WHERE ordernumber = 'P180427173643753' 
            
2024-04-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '45455'
                WHERE ordernumber = 'P420427174343262' 
            
2024-04-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '80172'
                WHERE ordernumber = 'P420427174450554' 
            
2024-04-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '163586'
                WHERE ordernumber = 'P180427174630472' 
            
2024-04-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387267'
                WHERE ordernumber = 'P200427175155405' 
            
2024-04-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352257'
                WHERE ordernumber = 'P200427175532368' 
            
2024-04-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '89055'
                WHERE ordernumber = 'P200427175645769' 
            
2024-04-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387269'
                WHERE ordernumber = 'P420427180115500' 
            
2024-04-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '160737'
                WHERE ordernumber = 'P180427180131420' 
            
2024-04-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '228989'
                WHERE ordernumber = 'P180427180236233' 
            
2024-04-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387269'
                WHERE ordernumber = 'P420427180806668' 
            
2024-04-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '292120'
                WHERE ordernumber = 'P180427180916970' 
            
2024-04-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345073'
                WHERE ordernumber = 'P590427182248263' 
            
2024-04-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387270'
                WHERE ordernumber = 'P200427182255954' 
            
2024-04-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '374128'
                WHERE ordernumber = 'P200427182413241' 
            
2024-04-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '241262'
                WHERE ordernumber = 'P190427182741729' 
            
2024-04-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387271'
                WHERE ordernumber = 'P420427183002122' 
            
2024-04-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387272'
                WHERE ordernumber = 'P420427183129553' 
            
2024-04-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '209769'
                WHERE ordernumber = 'P200427183405173' 
            
2024-04-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387273'
                WHERE ordernumber = 'P200427183732313' 
            
2024-04-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380236'
                WHERE ordernumber = 'P420427183738117' 
            
2024-04-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383006'
                WHERE ordernumber = 'P190427184127182' 
            
2024-04-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347551'
                WHERE ordernumber = 'P200427184341832' 
            
2024-04-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387274'
                WHERE ordernumber = 'P200427184516642' 
            
2024-04-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '105869'
                WHERE ordernumber = 'P200427184658436' 
            
2024-04-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387276'
                WHERE ordernumber = 'P420427185137292' 
            
2024-04-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387277'
                WHERE ordernumber = 'P420427185259785' 
            
2024-04-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387280'
                WHERE ordernumber = 'P200427190040488' 
            
2024-04-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96819'
                WHERE ordernumber = 'P630427190445237' 
            
2024-04-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '130789'
                WHERE ordernumber = 'P190427190613226' 
            
2024-04-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387281'
                WHERE ordernumber = 'P200427190624328' 
            
2024-04-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '95310'
                WHERE ordernumber = 'P190427190855685' 
            
2024-04-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '233888'
                WHERE ordernumber = 'P200427191024582' 
            
2024-04-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '37561'
                WHERE ordernumber = 'P630427191813139' 
            
2024-04-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '255606'
                WHERE ordernumber = 'P190427192539480' 
            
2024-04-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387283'
                WHERE ordernumber = 'P200427192848388' 
            
2024-04-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385565'
                WHERE ordernumber = 'P190427193500602' 
            
2024-04-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '80246'
                WHERE ordernumber = 'P200427194643572' 
            
2024-04-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114682'
                WHERE ordernumber = 'P190427194950157' 
            
2024-04-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '325810'
                WHERE ordernumber = 'P590427203059507' 
            
2024-04-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384207'
                WHERE ordernumber = 'P630427203113467'