2024-10-28 01:00:02 -- 將會員中心id寫入data-lake
2024-10-28 01:00:02 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-10-27%';
        
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427826'
                WHERE ordernumber = 'P631027101543686' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427413'
                WHERE ordernumber = 'P421027110436893' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '127878'
                WHERE ordernumber = 'P201027110925978' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '305503'
                WHERE ordernumber = 'P181027111340692' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '319774'
                WHERE ordernumber = 'P421027112435641' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '102047'
                WHERE ordernumber = 'P201027112800558' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '400017'
                WHERE ordernumber = 'P181027113623117' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '228082'
                WHERE ordernumber = 'P181027113702586' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427831'
                WHERE ordernumber = 'P421027113940262' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427832'
                WHERE ordernumber = 'P421027114117940' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427834'
                WHERE ordernumber = 'P771027114207691' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427833'
                WHERE ordernumber = 'P421027114233694' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380438'
                WHERE ordernumber = 'P181027114430183' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '81113'
                WHERE ordernumber = 'P201027114808503' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '177142'
                WHERE ordernumber = 'P181027115346852' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427837'
                WHERE ordernumber = 'P591027120558167' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427838'
                WHERE ordernumber = 'P201027120659551' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427840'
                WHERE ordernumber = 'P201027121121744' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427842'
                WHERE ordernumber = 'P181027121858768' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427843'
                WHERE ordernumber = 'P181027121950278' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '95433'
                WHERE ordernumber = 'P421027122000919' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427845'
                WHERE ordernumber = 'P591027122100562' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427846'
                WHERE ordernumber = 'P181027122112534' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427844'
                WHERE ordernumber = 'P181027122352463' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '216901'
                WHERE ordernumber = 'P181027122537786' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395551'
                WHERE ordernumber = 'P201027122625745' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427848'
                WHERE ordernumber = 'P181027122642600' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '218886'
                WHERE ordernumber = 'P201027122759861' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427849'
                WHERE ordernumber = 'P711027122916917' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '242799'
                WHERE ordernumber = 'P181027123056943' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427847'
                WHERE ordernumber = 'P181027123309395' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427841'
                WHERE ordernumber = 'P181027123418187' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '137641'
                WHERE ordernumber = 'P181027123642296' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '256363'
                WHERE ordernumber = 'P421027123934150' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427097'
                WHERE ordernumber = 'P421027124052272' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427852'
                WHERE ordernumber = 'P421027124140129' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427854'
                WHERE ordernumber = 'P181027124338648' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '228228'
                WHERE ordernumber = 'P191027124618610' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '135820'
                WHERE ordernumber = 'P421027125039508' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427857'
                WHERE ordernumber = 'P771027125135751' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381807'
                WHERE ordernumber = 'P421027125419961' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '241147'
                WHERE ordernumber = 'P201027125608629' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427858'
                WHERE ordernumber = 'P201027125841131' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '1522'
                WHERE ordernumber = 'P181027125858584' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '367461'
                WHERE ordernumber = 'P771027130230616' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427860'
                WHERE ordernumber = 'P181027131246997' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '339683'
                WHERE ordernumber = 'P421027131455290' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427862'
                WHERE ordernumber = 'P711027132621453' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427864'
                WHERE ordernumber = 'P771027133308770' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427863'
                WHERE ordernumber = 'P711027133452202' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425500'
                WHERE ordernumber = 'P201027133542245' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423660'
                WHERE ordernumber = 'P421027133554987' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427836'
                WHERE ordernumber = 'P201027134236169' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427866'
                WHERE ordernumber = 'P181027134645624' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427867'
                WHERE ordernumber = 'P201027134803741' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423270'
                WHERE ordernumber = 'P201027134847891' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '296398'
                WHERE ordernumber = 'P181027134904402' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381066'
                WHERE ordernumber = 'P201027135049866' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '315898'
                WHERE ordernumber = 'P181027135411647' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '224698'
                WHERE ordernumber = 'P421027135735974' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427870'
                WHERE ordernumber = 'P181027140751704' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '105669'
                WHERE ordernumber = 'P201027141037767' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427871'
                WHERE ordernumber = 'P201027141724682' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396351'
                WHERE ordernumber = 'P771027141740283' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427873'
                WHERE ordernumber = 'P201027142007512' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427872'
                WHERE ordernumber = 'P421027142013229' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425925'
                WHERE ordernumber = 'P201027142103798' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99926'
                WHERE ordernumber = 'P181027142755287' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423575'
                WHERE ordernumber = 'P711027142938985' 
            
2024-10-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '285334'
                WHERE ordernumber = 'P421027143300917' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278555'
                WHERE ordernumber = 'P421027143515750' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427879'
                WHERE ordernumber = 'P421027143833895' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427874'
                WHERE ordernumber = 'P181027144018391' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427879'
                WHERE ordernumber = 'P421027144052515' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427875'
                WHERE ordernumber = 'P181027144138878' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282918'
                WHERE ordernumber = 'P191027144519442' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427880'
                WHERE ordernumber = 'P421027144607286' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427881'
                WHERE ordernumber = 'P421027144817181' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383852'
                WHERE ordernumber = 'P421027144902652' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427878'
                WHERE ordernumber = 'P181027144955206' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427027'
                WHERE ordernumber = 'P421027145034386' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380871'
                WHERE ordernumber = 'P201027145228988' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427883'
                WHERE ordernumber = 'P191027145318680' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427884'
                WHERE ordernumber = 'P181027145816216' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427602'
                WHERE ordernumber = 'P201027150059394' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427885'
                WHERE ordernumber = 'P771027150102508' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249812'
                WHERE ordernumber = 'P191027150112163' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427835'
                WHERE ordernumber = 'P201027150139820' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427887'
                WHERE ordernumber = 'P421027150204545' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427886'
                WHERE ordernumber = 'P421027150247198' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '91119'
                WHERE ordernumber = 'P181027150450690' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427890'
                WHERE ordernumber = 'P421027150611982' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427888'
                WHERE ordernumber = 'P191027150828478' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '130195'
                WHERE ordernumber = 'P181027150911353' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '204611'
                WHERE ordernumber = 'P421027151025729' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249812'
                WHERE ordernumber = 'P191027151129635' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427894'
                WHERE ordernumber = 'P421027151139467' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427892'
                WHERE ordernumber = 'P771027151458752' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249812'
                WHERE ordernumber = 'P191027151917807' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306526'
                WHERE ordernumber = 'P771027152010956' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240864'
                WHERE ordernumber = 'P421027152117162' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282835'
                WHERE ordernumber = 'P201027152145815' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427895'
                WHERE ordernumber = 'P421027152201379' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427898'
                WHERE ordernumber = 'P421027152317512' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427900'
                WHERE ordernumber = 'P191027152454442' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427899'
                WHERE ordernumber = 'P421027152522630' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427663'
                WHERE ordernumber = 'P631027152625785' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307253'
                WHERE ordernumber = 'P191027152627361' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399585'
                WHERE ordernumber = 'P201027152647256' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427896'
                WHERE ordernumber = 'P771027152826556' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427897'
                WHERE ordernumber = 'P771027152918523' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341695'
                WHERE ordernumber = 'P771027153039200' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249123'
                WHERE ordernumber = 'P201027153229752' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427901'
                WHERE ordernumber = 'P181027153243172' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427903'
                WHERE ordernumber = 'P421027153349571' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427902'
                WHERE ordernumber = 'P181027153407224' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344013'
                WHERE ordernumber = 'P421027153510219' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307887'
                WHERE ordernumber = 'P201027153520952' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307887'
                WHERE ordernumber = 'P201027153620510' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427904'
                WHERE ordernumber = 'P771027153812138' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427905'
                WHERE ordernumber = 'P181027154422327' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427889'
                WHERE ordernumber = 'P201027154506696' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '326370'
                WHERE ordernumber = 'P201027154701966' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427907'
                WHERE ordernumber = 'P421027154856397' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427909'
                WHERE ordernumber = 'P421027155124168' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381972'
                WHERE ordernumber = 'P181027155237232' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427910'
                WHERE ordernumber = 'P181027155728486' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423103'
                WHERE ordernumber = 'P191027155737958' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98774'
                WHERE ordernumber = 'P201027155904277' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427912'
                WHERE ordernumber = 'P191027155930674' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427908'
                WHERE ordernumber = 'P421027160036741' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427915'
                WHERE ordernumber = 'P181027160347148' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '376736'
                WHERE ordernumber = 'P421027160453223' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '292980'
                WHERE ordernumber = 'P181027160516410' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427914'
                WHERE ordernumber = 'P191027160527789' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427916'
                WHERE ordernumber = 'P181027160603954' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427913'
                WHERE ordernumber = 'P191027160715115' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '267520'
                WHERE ordernumber = 'P201027160928883' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427918'
                WHERE ordernumber = 'P421027161042525' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427920'
                WHERE ordernumber = 'P421027161323183' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427921'
                WHERE ordernumber = 'P201027161435687' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427917'
                WHERE ordernumber = 'P421027161455887' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427919'
                WHERE ordernumber = 'P711027161549614' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394397'
                WHERE ordernumber = 'P201027161548210' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425240'
                WHERE ordernumber = 'P201027161634906' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427922'
                WHERE ordernumber = 'P201027161737111' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427923'
                WHERE ordernumber = 'P421027161847209' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '259523'
                WHERE ordernumber = 'P421027161951393' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '360790'
                WHERE ordernumber = 'P181027162212817' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427869'
                WHERE ordernumber = 'P201027162443914' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427925'
                WHERE ordernumber = 'P181027163018134' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427697'
                WHERE ordernumber = 'P201027163036698' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427927'
                WHERE ordernumber = 'P421027163326284' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245369'
                WHERE ordernumber = 'P201027163736371' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427926'
                WHERE ordernumber = 'P181027163904742' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427928'
                WHERE ordernumber = 'P771027163941289' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '323666'
                WHERE ordernumber = 'P181027164359612' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284827'
                WHERE ordernumber = 'P181027164755753' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427930'
                WHERE ordernumber = 'P771027164948569' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101475'
                WHERE ordernumber = 'P201027165135358' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427931'
                WHERE ordernumber = 'P201027165510981' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427929'
                WHERE ordernumber = 'P181027170611279' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427929'
                WHERE ordernumber = 'P181027170654158' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427932'
                WHERE ordernumber = 'P421027170759992' 
            
2024-10-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340315'
                WHERE ordernumber = 'P201027171945399' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427936'
                WHERE ordernumber = 'P201027172255746' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427934'
                WHERE ordernumber = 'P421027172347222' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427935'
                WHERE ordernumber = 'P421027172450120' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427834'
                WHERE ordernumber = 'P771027172715931' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427939'
                WHERE ordernumber = 'P421027172723363' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427937'
                WHERE ordernumber = 'P181027172819258' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427940'
                WHERE ordernumber = 'P421027172845335' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415205'
                WHERE ordernumber = 'P421027173001733' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427943'
                WHERE ordernumber = 'P421027173139382' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427946'
                WHERE ordernumber = 'P591027173506773' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427944'
                WHERE ordernumber = 'P421027173618327' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427173'
                WHERE ordernumber = 'P421027173706471' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427942'
                WHERE ordernumber = 'P421027173739360' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '291225'
                WHERE ordernumber = 'P771027173743128' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427947'
                WHERE ordernumber = 'P421027173832729' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427945'
                WHERE ordernumber = 'P421027173906887' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '135485'
                WHERE ordernumber = 'P421027174304359' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '136254'
                WHERE ordernumber = 'P181027174654978' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344628'
                WHERE ordernumber = 'P421027175310180' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277235'
                WHERE ordernumber = 'P181027175602869' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427949'
                WHERE ordernumber = 'P181027180026145' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427950'
                WHERE ordernumber = 'P711027180649758' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427952'
                WHERE ordernumber = 'P201027181141142' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427954'
                WHERE ordernumber = 'P711027182017723' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427956'
                WHERE ordernumber = 'P421027182341665' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427957'
                WHERE ordernumber = 'P731027182405853' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427958'
                WHERE ordernumber = 'P711027182440238' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342251'
                WHERE ordernumber = 'P181027182804760' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427960'
                WHERE ordernumber = 'P201027182853777' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '93438'
                WHERE ordernumber = 'P181027183047881' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427962'
                WHERE ordernumber = 'P181027184239567' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427959'
                WHERE ordernumber = 'P201027184322961' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '210745'
                WHERE ordernumber = 'P181027184417548' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389021'
                WHERE ordernumber = 'P181027184541138' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427965'
                WHERE ordernumber = 'P421027185639497' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427964'
                WHERE ordernumber = 'P711027185655291' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284936'
                WHERE ordernumber = 'P191027185943282' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '212643'
                WHERE ordernumber = 'P731027190341869' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427966'
                WHERE ordernumber = 'P731027190748642' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427967'
                WHERE ordernumber = 'P731027190944981' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427963'
                WHERE ordernumber = 'P191027191242485' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427955'
                WHERE ordernumber = 'P191027191315703' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100810'
                WHERE ordernumber = 'P731027191321690' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427968'
                WHERE ordernumber = 'P711027192145252' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '250085'
                WHERE ordernumber = 'P201027192604142' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427970'
                WHERE ordernumber = 'P191027194129786' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427788'
                WHERE ordernumber = 'P731027194333359' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '46603'
                WHERE ordernumber = 'P191027194507970' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '211900'
                WHERE ordernumber = 'P191027194600140' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427972'
                WHERE ordernumber = 'P771027194940213' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427971'
                WHERE ordernumber = 'P771027195051549' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427974'
                WHERE ordernumber = 'P201027200024170' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '84332'
                WHERE ordernumber = 'P201027200254609' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427975'
                WHERE ordernumber = 'P711027200458304' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427976'
                WHERE ordernumber = 'P711027201632236' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427977'
                WHERE ordernumber = 'P711027202121808' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427978'
                WHERE ordernumber = 'P711027202347971' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427979'
                WHERE ordernumber = 'P711027203439405' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427980'
                WHERE ordernumber = 'P711027204717353' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427981'
                WHERE ordernumber = 'P711027205513961' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403645'
                WHERE ordernumber = 'P711027210833484' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427982'
                WHERE ordernumber = 'P771027212551678' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '167080'
                WHERE ordernumber = 'P771027212953114' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395333'
                WHERE ordernumber = 'P631027213339406' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427984'
                WHERE ordernumber = 'P711027213531457' 
            
2024-10-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427986'
                WHERE ordernumber = 'P711027215244518'