2024-03-01 01:00:02 -- 將會員中心id寫入data-lake
2024-03-01 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-02-29%';
        
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '198400'
                WHERE ordernumber = 'P590229093135558' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379438'
                WHERE ordernumber = 'P420229110209844' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '260288'
                WHERE ordernumber = 'P200229110342707' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '266737'
                WHERE ordernumber = 'P200229110419779' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379439'
                WHERE ordernumber = 'P200229110526684' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '343517'
                WHERE ordernumber = 'P190229110632984' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379440'
                WHERE ordernumber = 'P420229110716741' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379441'
                WHERE ordernumber = 'P190229110900363' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378994'
                WHERE ordernumber = 'P200229110941299' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379442'
                WHERE ordernumber = 'P420229111018790' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379443'
                WHERE ordernumber = 'P420229111204679' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99126'
                WHERE ordernumber = 'P190229111222541' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '347188'
                WHERE ordernumber = 'P190229111405819' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '237873'
                WHERE ordernumber = 'P190229111450298' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '276095'
                WHERE ordernumber = 'P420229111501734' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287106'
                WHERE ordernumber = 'P190229111620112' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '351999'
                WHERE ordernumber = 'P190229111742904' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P200229111946847' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '339631'
                WHERE ordernumber = 'P200229112237343' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379446'
                WHERE ordernumber = 'P190229112644499' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '296484'
                WHERE ordernumber = 'P190229112826308' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371055'
                WHERE ordernumber = 'P200229113655281' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '284276'
                WHERE ordernumber = 'P200229113857783' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '118366'
                WHERE ordernumber = 'P420229113858758' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '240567'
                WHERE ordernumber = 'P180229113920631' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287227'
                WHERE ordernumber = 'P180229114230714' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '345565'
                WHERE ordernumber = 'P420229114343582' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '142903'
                WHERE ordernumber = 'P180229114539591' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '143596'
                WHERE ordernumber = 'P200229114816660' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379211'
                WHERE ordernumber = 'P200229114945909' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379448'
                WHERE ordernumber = 'P420229115006876' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379449'
                WHERE ordernumber = 'P200229115059892' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379450'
                WHERE ordernumber = 'P200229115314152' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '369334'
                WHERE ordernumber = 'P200229115354148' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '341983'
                WHERE ordernumber = 'P420229115409653' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379451'
                WHERE ordernumber = 'P420229115611521' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379246'
                WHERE ordernumber = 'P420229115710419' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '242588'
                WHERE ordernumber = 'P200229115736465' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349042'
                WHERE ordernumber = 'P420229120608179' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '243114'
                WHERE ordernumber = 'P190229120618426' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '93882'
                WHERE ordernumber = 'P420229120804732' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '243675'
                WHERE ordernumber = 'P180229121148670' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379456'
                WHERE ordernumber = 'P180229121525923' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '301554'
                WHERE ordernumber = 'P180229121754202' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '368838'
                WHERE ordernumber = 'P420229122249351' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379459'
                WHERE ordernumber = 'P200229122536985' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379460'
                WHERE ordernumber = 'P200229122618658' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379461'
                WHERE ordernumber = 'P200229122737490' 
            
2024-03-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379462'
                WHERE ordernumber = 'P180229123021119' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379463'
                WHERE ordernumber = 'P200229123111993' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378632'
                WHERE ordernumber = 'P180229123702417' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379464'
                WHERE ordernumber = 'P200229123717490' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379465'
                WHERE ordernumber = 'P200229123824770' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275486'
                WHERE ordernumber = 'P200229123854807' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379466'
                WHERE ordernumber = 'P420229124206915' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315213'
                WHERE ordernumber = 'P420229124317658' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379467'
                WHERE ordernumber = 'P420229124445620' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379468'
                WHERE ordernumber = 'P420229124536539' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214895'
                WHERE ordernumber = 'P200229125046700' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '80949'
                WHERE ordernumber = 'P200229125146377' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '274129'
                WHERE ordernumber = 'P180229125411627' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377987'
                WHERE ordernumber = 'P420229125425294' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379469'
                WHERE ordernumber = 'P200229125616897' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378465'
                WHERE ordernumber = 'P200229125742236' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379471'
                WHERE ordernumber = 'P200229130346726' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339269'
                WHERE ordernumber = 'P180229130829488' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379472'
                WHERE ordernumber = 'P200229131455159' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348918'
                WHERE ordernumber = 'P180229131631620' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379474'
                WHERE ordernumber = 'P190229131900790' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379475'
                WHERE ordernumber = 'P200229132252293' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379476'
                WHERE ordernumber = 'P200229132730442' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379477'
                WHERE ordernumber = 'P200229133552857' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379478'
                WHERE ordernumber = 'P420229133808846' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379479'
                WHERE ordernumber = 'P200229133906277' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291650'
                WHERE ordernumber = 'P180229133916824' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379480'
                WHERE ordernumber = 'P190229133917900' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '265324'
                WHERE ordernumber = 'P420229134306774' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379481'
                WHERE ordernumber = 'P420229134908540' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379483'
                WHERE ordernumber = 'P190229134945406' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '182156'
                WHERE ordernumber = 'P200229135203506' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '373709'
                WHERE ordernumber = 'P200229135335482' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379485'
                WHERE ordernumber = 'P180229135719169' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '311993'
                WHERE ordernumber = 'P180229135800456' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379487'
                WHERE ordernumber = 'P180229140155397' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '266321'
                WHERE ordernumber = 'P200229140957979' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379488'
                WHERE ordernumber = 'P200229141316682' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379489'
                WHERE ordernumber = 'P200229141502578' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379030'
                WHERE ordernumber = 'P180229142221667' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379490'
                WHERE ordernumber = 'P190229142304968' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345365'
                WHERE ordernumber = 'P200229142610148' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '132682'
                WHERE ordernumber = 'P180229142620409' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102969'
                WHERE ordernumber = 'P190229142745918' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379491'
                WHERE ordernumber = 'P420229142833787' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100925'
                WHERE ordernumber = 'P200229143944349' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379493'
                WHERE ordernumber = 'P190229144005463' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '104419'
                WHERE ordernumber = 'P190229144320198' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379494'
                WHERE ordernumber = 'P200229144402391' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378409'
                WHERE ordernumber = 'P420229144501255' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378620'
                WHERE ordernumber = 'P190229144505728' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379495'
                WHERE ordernumber = 'P420229145150496' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379496'
                WHERE ordernumber = 'P420229145554225' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379497'
                WHERE ordernumber = 'P190229145741631' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379498'
                WHERE ordernumber = 'P200229150248943' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379499'
                WHERE ordernumber = 'P180229150453518' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291037'
                WHERE ordernumber = 'P200229152319372' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99872'
                WHERE ordernumber = 'P180229152346799' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379502'
                WHERE ordernumber = 'P180229152627639' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '61977'
                WHERE ordernumber = 'P180229152818777' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '224834'
                WHERE ordernumber = 'P420229153651228' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '254095'
                WHERE ordernumber = 'P420229154251515' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379504'
                WHERE ordernumber = 'P190229154303998' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338741'
                WHERE ordernumber = 'P190229154340274' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379506'
                WHERE ordernumber = 'P420229155358762' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379507'
                WHERE ordernumber = 'P180229160648119' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379508'
                WHERE ordernumber = 'P180229160745659' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343585'
                WHERE ordernumber = 'P180229161013578' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379510'
                WHERE ordernumber = 'P420229161324757' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379511'
                WHERE ordernumber = 'P200229161522295' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379512'
                WHERE ordernumber = 'P420229161627245' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237690'
                WHERE ordernumber = 'P180229162429741' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378197'
                WHERE ordernumber = 'P180229162645199' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '272890'
                WHERE ordernumber = 'P200229163454201' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '256410'
                WHERE ordernumber = 'P420229163605347' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379514'
                WHERE ordernumber = 'P420229163826451' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303400'
                WHERE ordernumber = 'P180229164139210' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '270826'
                WHERE ordernumber = 'P200229164335657' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '208646'
                WHERE ordernumber = 'P420229164529217' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379515'
                WHERE ordernumber = 'P180229164532476' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366803'
                WHERE ordernumber = 'P180229164710221' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366803'
                WHERE ordernumber = 'P180229164733170' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379516'
                WHERE ordernumber = 'P420229164822177' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379518'
                WHERE ordernumber = 'P180229170535984' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379517'
                WHERE ordernumber = 'P180229170823961' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379520'
                WHERE ordernumber = 'P180229171919759' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '158557'
                WHERE ordernumber = 'P200229171924604' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '212202'
                WHERE ordernumber = 'P180229172611136' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101793'
                WHERE ordernumber = 'P200229172641189' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '369868'
                WHERE ordernumber = 'P420229172833750' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '143193'
                WHERE ordernumber = 'P180229172927848' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379521'
                WHERE ordernumber = 'P200229173009579' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379522'
                WHERE ordernumber = 'P200229173117929' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379523'
                WHERE ordernumber = 'P200229173804637' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379524'
                WHERE ordernumber = 'P420229173812490' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340529'
                WHERE ordernumber = 'P200229173949572' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341057'
                WHERE ordernumber = 'P180229174047502' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118780'
                WHERE ordernumber = 'P200229174216176' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379525'
                WHERE ordernumber = 'P180229174450975' 
            
2024-03-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379526'
                WHERE ordernumber = 'P420229174749373' 
            
2024-03-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379527'
                WHERE ordernumber = 'P180229174836700' 
            
2024-03-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '253803'
                WHERE ordernumber = 'P420229175108916' 
            
2024-03-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '253803'
                WHERE ordernumber = 'P420229175154239' 
            
2024-03-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379529'
                WHERE ordernumber = 'P200229175322867' 
            
2024-03-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379528'
                WHERE ordernumber = 'P420229175327660' 
            
2024-03-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '373410'
                WHERE ordernumber = 'P420229175519514' 
            
2024-03-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '229471'
                WHERE ordernumber = 'P200229180847206' 
            
2024-03-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378935'
                WHERE ordernumber = 'P420229181001587' 
            
2024-03-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '209438'
                WHERE ordernumber = 'P180229181619671' 
            
2024-03-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377388'
                WHERE ordernumber = 'P200229181712773' 
            
2024-03-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342900'
                WHERE ordernumber = 'P180229182003644' 
            
2024-03-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379531'
                WHERE ordernumber = 'P200229182109383' 
            
2024-03-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '243653'
                WHERE ordernumber = 'P180229182352872' 
            
2024-03-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '217512'
                WHERE ordernumber = 'P200229182840864' 
            
2024-03-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '167479'
                WHERE ordernumber = 'P180229183448725' 
            
2024-03-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379535'
                WHERE ordernumber = 'P200229183644346' 
            
2024-03-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '121795'
                WHERE ordernumber = 'P200229183758431' 
            
2024-03-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '320727'
                WHERE ordernumber = 'P420229183807709' 
            
2024-03-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379536'
                WHERE ordernumber = 'P180229184651185' 
            
2024-03-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345808'
                WHERE ordernumber = 'P190229184913797' 
            
2024-03-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378660'
                WHERE ordernumber = 'P200229190218341' 
            
2024-03-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379538'
                WHERE ordernumber = 'P190229191009852' 
            
2024-03-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '296403'
                WHERE ordernumber = 'P200229191144731' 
            
2024-03-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379539'
                WHERE ordernumber = 'P200229191228112' 
            
2024-03-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379540'
                WHERE ordernumber = 'P190229192515489' 
            
2024-03-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379540'
                WHERE ordernumber = 'P190229192717569' 
            
2024-03-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379431'
                WHERE ordernumber = 'P200229193053870' 
            
2024-03-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379541'
                WHERE ordernumber = 'P200229193940856' 
            
2024-03-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '266705'
                WHERE ordernumber = 'P190229194119683' 
            
2024-03-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '311660'
                WHERE ordernumber = 'P190229194349360'