2024-09-10 01:00:01 -- 將會員中心id寫入data-lake
2024-09-10 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-09-09%';
        
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '274869'
                WHERE ordernumber = 'P630909101410968' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '164920'
                WHERE ordernumber = 'P200909110207749' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '94028'
                WHERE ordernumber = 'P200909110414118' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420127'
                WHERE ordernumber = 'P420909110449181' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420130'
                WHERE ordernumber = 'P200909110644393' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420128'
                WHERE ordernumber = 'P420909110727750' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '139462'
                WHERE ordernumber = 'P200909110749388' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420035'
                WHERE ordernumber = 'P420909110812825' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377920'
                WHERE ordernumber = 'P200909111255389' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '122376'
                WHERE ordernumber = 'P190909111347643' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '416382'
                WHERE ordernumber = 'P420909111430443' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '130202'
                WHERE ordernumber = 'P180909111440507' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420137'
                WHERE ordernumber = 'P420909111607940' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420138'
                WHERE ordernumber = 'P420909111657268' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '62816'
                WHERE ordernumber = 'P180909111827115' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '367788'
                WHERE ordernumber = 'P190909111827750' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '418284'
                WHERE ordernumber = 'P420909112021729' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '336589'
                WHERE ordernumber = 'P200909112134916' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420139'
                WHERE ordernumber = 'P420909112158173' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420130'
                WHERE ordernumber = 'P200909112242114' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '121498'
                WHERE ordernumber = 'P200909112606660' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '418683'
                WHERE ordernumber = 'P190909112617732' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420128'
                WHERE ordernumber = 'P420909112655561' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '308251'
                WHERE ordernumber = 'P200909112701464' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '208665'
                WHERE ordernumber = 'P190909112831175' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420142'
                WHERE ordernumber = 'P420909112908872' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '416371'
                WHERE ordernumber = 'P420909113054647' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '128545'
                WHERE ordernumber = 'P420909113147836' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420122'
                WHERE ordernumber = 'P180909113327373' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420137'
                WHERE ordernumber = 'P420909113612600' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420125'
                WHERE ordernumber = 'P180909113707839' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420119'
                WHERE ordernumber = 'P190909114037583' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420119'
                WHERE ordernumber = 'P190909114051847' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420145'
                WHERE ordernumber = 'P420909114123194' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420140'
                WHERE ordernumber = 'P180909114350727' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420140'
                WHERE ordernumber = 'P180909114436119' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420129'
                WHERE ordernumber = 'P180909114515123' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '339254'
                WHERE ordernumber = 'P420909114526434' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '264391'
                WHERE ordernumber = 'P420909114626374' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '303682'
                WHERE ordernumber = 'P420909114731174' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283248'
                WHERE ordernumber = 'P190909115007213' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283248'
                WHERE ordernumber = 'P190909115038730' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420151'
                WHERE ordernumber = 'P420909115105865' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420152'
                WHERE ordernumber = 'P420909115150199' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '230318'
                WHERE ordernumber = 'P180909115209613' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '149474'
                WHERE ordernumber = 'P190909115553188' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '149474'
                WHERE ordernumber = 'P190909115608209' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353651'
                WHERE ordernumber = 'P200909115650712' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407903'
                WHERE ordernumber = 'P420909115715916' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '95844'
                WHERE ordernumber = 'P200909115802424' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420157'
                WHERE ordernumber = 'P420909115844696' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420146'
                WHERE ordernumber = 'P420909120017989' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180909120108671' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420158'
                WHERE ordernumber = 'P420909120309434' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '130868'
                WHERE ordernumber = 'P190909120342799' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420159'
                WHERE ordernumber = 'P420909120414146' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420160'
                WHERE ordernumber = 'P420909120540937' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419960'
                WHERE ordernumber = 'P190909120611875' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420147'
                WHERE ordernumber = 'P190909120856436' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420162'
                WHERE ordernumber = 'P420909120949780' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420149'
                WHERE ordernumber = 'P190909121105884' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '89674'
                WHERE ordernumber = 'P200909121122898' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '102595'
                WHERE ordernumber = 'P200909121558337' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '86200'
                WHERE ordernumber = 'P180909121925954' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '307197'
                WHERE ordernumber = 'P200909122323125' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '418683'
                WHERE ordernumber = 'P180909122726629' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '418683'
                WHERE ordernumber = 'P180909122812941' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420168'
                WHERE ordernumber = 'P200909122904153' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420156'
                WHERE ordernumber = 'P190909122915996' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420156'
                WHERE ordernumber = 'P190909122934230' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420156'
                WHERE ordernumber = 'P190909122958215' 
            
2024-09-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420166'
                WHERE ordernumber = 'P180909123033869' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417496'
                WHERE ordernumber = 'P190909123116599' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '84821'
                WHERE ordernumber = 'P190909123205949' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416294'
                WHERE ordernumber = 'P180909123251436' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419005'
                WHERE ordernumber = 'P190909123515183' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395691'
                WHERE ordernumber = 'P190909123658825' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408653'
                WHERE ordernumber = 'P200909123749800' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420177'
                WHERE ordernumber = 'P420909123751263' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420155'
                WHERE ordernumber = 'P190909123934627' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392809'
                WHERE ordernumber = 'P180909123941231' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '294917'
                WHERE ordernumber = 'P420909124011861' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420171'
                WHERE ordernumber = 'P190909124048495' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420171'
                WHERE ordernumber = 'P190909124106782' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420161'
                WHERE ordernumber = 'P180909124139468' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420183'
                WHERE ordernumber = 'P200909124335692' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420184'
                WHERE ordernumber = 'P420909124454867' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411487'
                WHERE ordernumber = 'P190909124544519' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314080'
                WHERE ordernumber = 'P190909124638413' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420165'
                WHERE ordernumber = 'P180909124750797' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420186'
                WHERE ordernumber = 'P190909124854498' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368067'
                WHERE ordernumber = 'P420909124909349' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420161'
                WHERE ordernumber = 'P190909125115387' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394292'
                WHERE ordernumber = 'P180909125130937' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420169'
                WHERE ordernumber = 'P180909125208218' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344831'
                WHERE ordernumber = 'P190909125217856' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420175'
                WHERE ordernumber = 'P180909125242120' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420188'
                WHERE ordernumber = 'P420909125400781' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '36953'
                WHERE ordernumber = 'P190909125422591' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100921'
                WHERE ordernumber = 'P200909125444333' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420170'
                WHERE ordernumber = 'P190909125611314' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420190'
                WHERE ordernumber = 'P420909125636529' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420173'
                WHERE ordernumber = 'P190909125658653' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420174'
                WHERE ordernumber = 'P190909125937896' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420192'
                WHERE ordernumber = 'P190909130038695' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419877'
                WHERE ordernumber = 'P190909130309574' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420194'
                WHERE ordernumber = 'P200909130501287' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412926'
                WHERE ordernumber = 'P190909130545999' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418148'
                WHERE ordernumber = 'P420909130603677' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416977'
                WHERE ordernumber = 'P200909130633204' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420196'
                WHERE ordernumber = 'P420909130741979' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420161'
                WHERE ordernumber = 'P180909130753316' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394739'
                WHERE ordernumber = 'P420909130948496' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '74107'
                WHERE ordernumber = 'P420909131102310' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419320'
                WHERE ordernumber = 'P190909131125197' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420198'
                WHERE ordernumber = 'P420909131255127' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306735'
                WHERE ordernumber = 'P200909131314165' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420199'
                WHERE ordernumber = 'P420909131551334' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '316726'
                WHERE ordernumber = 'P190909131555423' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418144'
                WHERE ordernumber = 'P190909131856803' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '36953'
                WHERE ordernumber = 'P180909131952347' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337242'
                WHERE ordernumber = 'P190909132038923' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420201'
                WHERE ordernumber = 'P420909132153883' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372351'
                WHERE ordernumber = 'P180909132431293' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415633'
                WHERE ordernumber = 'P200909132437285' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407903'
                WHERE ordernumber = 'P420909132442954' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '267812'
                WHERE ordernumber = 'P190909132711313' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401387'
                WHERE ordernumber = 'P200909133150320' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337242'
                WHERE ordernumber = 'P190909133305471' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338388'
                WHERE ordernumber = 'P180909133314375' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230535'
                WHERE ordernumber = 'P190909133541552' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '252519'
                WHERE ordernumber = 'P180909133647543' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420205'
                WHERE ordernumber = 'P180909133812140' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '108274'
                WHERE ordernumber = 'P190909133837655' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '143760'
                WHERE ordernumber = 'P420909133907493' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '92400'
                WHERE ordernumber = 'P190909134000972' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414748'
                WHERE ordernumber = 'P190909134057586' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286160'
                WHERE ordernumber = 'P180909134121607' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420207'
                WHERE ordernumber = 'P420909134350217' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '212232'
                WHERE ordernumber = 'P180909134427695' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420208'
                WHERE ordernumber = 'P420909134735391' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420210'
                WHERE ordernumber = 'P420909135031689' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420157'
                WHERE ordernumber = 'P200909135047949' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '145009'
                WHERE ordernumber = 'P180909135134332' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420211'
                WHERE ordernumber = 'P420909135156434' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420212'
                WHERE ordernumber = 'P420909135259949' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420213'
                WHERE ordernumber = 'P420909135442321' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276140'
                WHERE ordernumber = 'P180909135500148' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420157'
                WHERE ordernumber = 'P200909135647954' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420214'
                WHERE ordernumber = 'P420909135715274' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334460'
                WHERE ordernumber = 'P200909135828274' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242153'
                WHERE ordernumber = 'P200909135913485' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420215'
                WHERE ordernumber = 'P420909140626893' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420216'
                WHERE ordernumber = 'P200909140716996' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '127593'
                WHERE ordernumber = 'P200909140910442' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420217'
                WHERE ordernumber = 'P190909141015248' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '280371'
                WHERE ordernumber = 'P420909141020172' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420218'
                WHERE ordernumber = 'P200909141059242' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392653'
                WHERE ordernumber = 'P180909141159148' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285283'
                WHERE ordernumber = 'P200909141409337' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '106239'
                WHERE ordernumber = 'P180909141549882' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420157'
                WHERE ordernumber = 'P200909141611168' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '125170'
                WHERE ordernumber = 'P200909142045130' 
            
2024-09-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409221'
                WHERE ordernumber = 'P200909142156681' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '324703'
                WHERE ordernumber = 'P180909142331698' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '324703'
                WHERE ordernumber = 'P180909142344267' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '324703'
                WHERE ordernumber = 'P180909142352836' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '324703'
                WHERE ordernumber = 'P180909142400574' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420220'
                WHERE ordernumber = 'P200909142714888' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409308'
                WHERE ordernumber = 'P420909143039959' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81408'
                WHERE ordernumber = 'P200909143130417' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420221'
                WHERE ordernumber = 'P420909143247637' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281599'
                WHERE ordernumber = 'P180909143352747' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281599'
                WHERE ordernumber = 'P180909143407169' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392615'
                WHERE ordernumber = 'P200909143704581' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419544'
                WHERE ordernumber = 'P420909143850447' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352199'
                WHERE ordernumber = 'P420909144215471' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '365572'
                WHERE ordernumber = 'P420909144444269' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '293741'
                WHERE ordernumber = 'P180909144659343' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380961'
                WHERE ordernumber = 'P200909144833445' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420222'
                WHERE ordernumber = 'P180909145008877' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '224912'
                WHERE ordernumber = 'P180909145509533' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358469'
                WHERE ordernumber = 'P200909145710398' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282484'
                WHERE ordernumber = 'P190909145736145' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420225'
                WHERE ordernumber = 'P180909145919874' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420226'
                WHERE ordernumber = 'P420909150156883' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382266'
                WHERE ordernumber = 'P420909150239353' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420227'
                WHERE ordernumber = 'P420909150436382' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420228'
                WHERE ordernumber = 'P420909150635982' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337314'
                WHERE ordernumber = 'P420909150804709' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372909'
                WHERE ordernumber = 'P200909150946962' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '241726'
                WHERE ordernumber = 'P200909151034914' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '241726'
                WHERE ordernumber = 'P200909151228790' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '211119'
                WHERE ordernumber = 'P180909151245274' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '241726'
                WHERE ordernumber = 'P200909151248927' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411007'
                WHERE ordernumber = 'P420909151312561' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420234'
                WHERE ordernumber = 'P420909152233961' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '220538'
                WHERE ordernumber = 'P200909152250583' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420236'
                WHERE ordernumber = 'P420909153007637' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420069'
                WHERE ordernumber = 'P200909153143191' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420238'
                WHERE ordernumber = 'P420909153214987' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420069'
                WHERE ordernumber = 'P200909153229138' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100928'
                WHERE ordernumber = 'P200909153407789' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '36613'
                WHERE ordernumber = 'P200909153620366' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415819'
                WHERE ordernumber = 'P420909153944886' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420242'
                WHERE ordernumber = 'P420909154433392' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '157035'
                WHERE ordernumber = 'P200909154615264' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420243'
                WHERE ordernumber = 'P420909154630542' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '160121'
                WHERE ordernumber = 'P200909155347281' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378296'
                WHERE ordernumber = 'P180909155635545' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '61704'
                WHERE ordernumber = 'P180909162408147' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393960'
                WHERE ordernumber = 'P420909162723530' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420249'
                WHERE ordernumber = 'P420909163042179' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '198885'
                WHERE ordernumber = 'P630909164410935' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '272572'
                WHERE ordernumber = 'P420909164451302' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390136'
                WHERE ordernumber = 'P630909164501888' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398841'
                WHERE ordernumber = 'P180909164802256' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420252'
                WHERE ordernumber = 'P420909165215304' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '364203'
                WHERE ordernumber = 'P180909170208504' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '319253'
                WHERE ordernumber = 'P180909170540999' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420256'
                WHERE ordernumber = 'P200909170650546' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '413447'
                WHERE ordernumber = 'P180909170807486' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '413447'
                WHERE ordernumber = 'P180909170826845' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '416197'
                WHERE ordernumber = 'P180909170926482' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '214445'
                WHERE ordernumber = 'P180909171056381' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415842'
                WHERE ordernumber = 'P420909175351438' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '364567'
                WHERE ordernumber = 'P180909175634498' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '27462'
                WHERE ordernumber = 'P200909175728610' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '229947'
                WHERE ordernumber = 'P180909180242298' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419979'
                WHERE ordernumber = 'P180909180459166' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420264'
                WHERE ordernumber = 'P420909180736648' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '221302'
                WHERE ordernumber = 'P200909181126327' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '243812'
                WHERE ordernumber = 'P630909182532790' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389139'
                WHERE ordernumber = 'P630909183101486' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337001'
                WHERE ordernumber = 'P420909183515224' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337001'
                WHERE ordernumber = 'P420909183707822' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '369235'
                WHERE ordernumber = 'P420909184115991' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '270393'
                WHERE ordernumber = 'P180909185311837' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418353'
                WHERE ordernumber = 'P180909185634992' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420269'
                WHERE ordernumber = 'P180909190246926' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420226'
                WHERE ordernumber = 'P630909192449331' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420226'
                WHERE ordernumber = 'P630909193536311' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397901'
                WHERE ordernumber = 'P630909193850385' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397901'
                WHERE ordernumber = 'P630909193959926' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '132161'
                WHERE ordernumber = 'P180909195649896' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '213859'
                WHERE ordernumber = 'P180909200334426' 
            
2024-09-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '25'
                WHERE ordernumber = 'P190909200457658'