2024-12-08 01:00:02 -- 將會員中心id寫入data-lake
2024-12-08 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-12-07%';
        
2024-12-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382896'
                WHERE ordernumber = 'P2412070000165' 
            
2024-12-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348622'
                WHERE ordernumber = 'P2412070000497' 
            
2024-12-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433727'
                WHERE ordernumber = 'P2412070000525' 
            
2024-12-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433726'
                WHERE ordernumber = 'P2412070000646' 
            
2024-12-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '286359'
                WHERE ordernumber = 'P2412070000723' 
            
2024-12-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '66860'
                WHERE ordernumber = 'P2412070000826' 
            
2024-12-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433136'
                WHERE ordernumber = 'P2412070000982' 
            
2024-12-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '110757'
                WHERE ordernumber = 'P2412070001069' 
            
2024-12-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '399783'
                WHERE ordernumber = 'P2412070001112' 
            
2024-12-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '310979'
                WHERE ordernumber = 'P2412070001239' 
            
2024-12-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '301524'
                WHERE ordernumber = 'P2412070001329' 
            
2024-12-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433725'
                WHERE ordernumber = 'P2412070001433' 
            
2024-12-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '403240'
                WHERE ordernumber = 'P2412070001642' 
            
2024-12-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '208779'
                WHERE ordernumber = 'P2412070001957' 
            
2024-12-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '139543'
                WHERE ordernumber = 'P2412070002022' 
            
2024-12-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '310979'
                WHERE ordernumber = 'P2412070002148' 
            
2024-12-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433728'
                WHERE ordernumber = 'P2412070002462' 
            
2024-12-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433723'
                WHERE ordernumber = 'P2412070002652' 
            
2024-12-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420802'
                WHERE ordernumber = 'P2412070002714' 
            
2024-12-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433730'
                WHERE ordernumber = 'P2412070003323' 
            
2024-12-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '152524'
                WHERE ordernumber = 'P2412070003424' 
            
2024-12-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '95002'
                WHERE ordernumber = 'P2412070003673' 
            
2024-12-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433731'
                WHERE ordernumber = 'P2412070003749' 
            
2024-12-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '146262'
                WHERE ordernumber = 'P2412070004085' 
            
2024-12-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433734'
                WHERE ordernumber = 'P2412070004116' 
            
2024-12-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '163990'
                WHERE ordernumber = 'P2412070004247' 
            
2024-12-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433735'
                WHERE ordernumber = 'P2412070004329' 
            
2024-12-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433736'
                WHERE ordernumber = 'P2412070004468' 
            
2024-12-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '298283'
                WHERE ordernumber = 'P2412070004536' 
            
2024-12-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433729'
                WHERE ordernumber = 'P2412070004684' 
            
2024-12-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433737'
                WHERE ordernumber = 'P2412070004883' 
            
2024-12-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '208650'
                WHERE ordernumber = 'P2412070005052' 
            
2024-12-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '119754'
                WHERE ordernumber = 'P2412070005195' 
            
2024-12-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '405768'
                WHERE ordernumber = 'P2412070005235' 
            
2024-12-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433536'
                WHERE ordernumber = 'P2412070005320' 
            
2024-12-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433738'
                WHERE ordernumber = 'P2412070005496' 
            
2024-12-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '154471'
                WHERE ordernumber = 'P2412070005512' 
            
2024-12-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382216'
                WHERE ordernumber = 'P2412070005637' 
            
2024-12-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '20905'
                WHERE ordernumber = 'P2412070005844' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433739'
                WHERE ordernumber = 'P2412070006096' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433740'
                WHERE ordernumber = 'P2412070006164' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345174'
                WHERE ordernumber = 'P2412070006239' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '20905'
                WHERE ordernumber = 'P2412070006491' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '90681'
                WHERE ordernumber = 'P2412070006623' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433741'
                WHERE ordernumber = 'P2412070006946' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '264610'
                WHERE ordernumber = 'P2412070007198' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433743'
                WHERE ordernumber = 'P2412070007273' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433744'
                WHERE ordernumber = 'P2412070007322' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433746'
                WHERE ordernumber = 'P2412070007482' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433747'
                WHERE ordernumber = 'P2412070007647' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '65390'
                WHERE ordernumber = 'P2412070007928' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '131720'
                WHERE ordernumber = 'P2412070008188' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430606'
                WHERE ordernumber = 'P2412070008248' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '154793'
                WHERE ordernumber = 'P2412070008357' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433748'
                WHERE ordernumber = 'P2412070008437' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378846'
                WHERE ordernumber = 'P2412070008631' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433750'
                WHERE ordernumber = 'P2412070008937' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '328157'
                WHERE ordernumber = 'P2412070009169' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '215115'
                WHERE ordernumber = 'P2412070009339' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433751'
                WHERE ordernumber = 'P2412070009454' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309256'
                WHERE ordernumber = 'P2412070009510' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '167929'
                WHERE ordernumber = 'P2412070009739' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '280910'
                WHERE ordernumber = 'P2412070009919' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433755'
                WHERE ordernumber = 'P2412070010184' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426166'
                WHERE ordernumber = 'P2412070010677' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '213832'
                WHERE ordernumber = 'P2412070011045' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433759'
                WHERE ordernumber = 'P2412070011135' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433122'
                WHERE ordernumber = 'P2412070011392' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421439'
                WHERE ordernumber = 'P2412070011641' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433758'
                WHERE ordernumber = 'P2412070011786' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239817'
                WHERE ordernumber = 'P2412070011971' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433760'
                WHERE ordernumber = 'P2412070012243' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433761'
                WHERE ordernumber = 'P2412070012329' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '294778'
                WHERE ordernumber = 'P2412070012543' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276996'
                WHERE ordernumber = 'P2412070012610' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351331'
                WHERE ordernumber = 'P2412070012788' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '80949'
                WHERE ordernumber = 'P2412070012817' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433762'
                WHERE ordernumber = 'P2412070012980' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433763'
                WHERE ordernumber = 'P2412070013089' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433764'
                WHERE ordernumber = 'P2412070013113' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433765'
                WHERE ordernumber = 'P2412070013239' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '122907'
                WHERE ordernumber = 'P2412070013486' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433721'
                WHERE ordernumber = 'P2412070013649' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403409'
                WHERE ordernumber = 'P2412070013935' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248668'
                WHERE ordernumber = 'P2412070014080' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433769'
                WHERE ordernumber = 'P2412070014224' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '252894'
                WHERE ordernumber = 'P2412070014370' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '293407'
                WHERE ordernumber = 'P2412070014879' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431149'
                WHERE ordernumber = 'P2412070015056' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '129975'
                WHERE ordernumber = 'P2412070015330' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '212334'
                WHERE ordernumber = 'P2412070015833' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433773'
                WHERE ordernumber = 'P2412070015924' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433414'
                WHERE ordernumber = 'P2412070016057' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432631'
                WHERE ordernumber = 'P2412070016217' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433776'
                WHERE ordernumber = 'P2412070016525' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433775'
                WHERE ordernumber = 'P2412070016672' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433777'
                WHERE ordernumber = 'P2412070016971' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433768'
                WHERE ordernumber = 'P2412070017262' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433774'
                WHERE ordernumber = 'P2412070017339' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433782'
                WHERE ordernumber = 'P2412070017573' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344454'
                WHERE ordernumber = 'P2412070017817' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '250721'
                WHERE ordernumber = 'P2412070017947' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '325115'
                WHERE ordernumber = 'P2412070018086' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433778'
                WHERE ordernumber = 'P2412070018122' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '143596'
                WHERE ordernumber = 'P2412070018486' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357721'
                WHERE ordernumber = 'P2412070018614' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433783'
                WHERE ordernumber = 'P2412070018773' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '143596'
                WHERE ordernumber = 'P2412070018866' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '197395'
                WHERE ordernumber = 'P2412070018932' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339397'
                WHERE ordernumber = 'P2412070019097' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283779'
                WHERE ordernumber = 'P2412070019175' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283779'
                WHERE ordernumber = 'P2412070019323' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433784'
                WHERE ordernumber = 'P2412070019444' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160734'
                WHERE ordernumber = 'P2412070019554' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433784'
                WHERE ordernumber = 'P2412070019654' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433785'
                WHERE ordernumber = 'P2412070019964' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433787'
                WHERE ordernumber = 'P2412070020010' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433786'
                WHERE ordernumber = 'P2412070020363' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433788'
                WHERE ordernumber = 'P2412070020414' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357190'
                WHERE ordernumber = 'P2412070020520' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433788'
                WHERE ordernumber = 'P2412070020730' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433790'
                WHERE ordernumber = 'P2412070020862' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342672'
                WHERE ordernumber = 'P2412070021186' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424324'
                WHERE ordernumber = 'P2412070021212' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433793'
                WHERE ordernumber = 'P2412070021391' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433792'
                WHERE ordernumber = 'P2412070021465' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433789'
                WHERE ordernumber = 'P2412070021696' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433794'
                WHERE ordernumber = 'P2412070022143' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356322'
                WHERE ordernumber = 'P2412070022257' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '263850'
                WHERE ordernumber = 'P2412070022323' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433795'
                WHERE ordernumber = 'P2412070022447' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433798'
                WHERE ordernumber = 'P2412070022818' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433796'
                WHERE ordernumber = 'P2412070022962' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432881'
                WHERE ordernumber = 'P2412070023231' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287470'
                WHERE ordernumber = 'P2412070023586' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433802'
                WHERE ordernumber = 'P2412070023765' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433801'
                WHERE ordernumber = 'P2412070023848' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408056'
                WHERE ordernumber = 'P2412070023940' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433803'
                WHERE ordernumber = 'P2412070024010' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433806'
                WHERE ordernumber = 'P2412070024127' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433804'
                WHERE ordernumber = 'P2412070024424' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433809'
                WHERE ordernumber = 'P2412070024520' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433810'
                WHERE ordernumber = 'P2412070024645' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381591'
                WHERE ordernumber = 'P2412070024763' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433812'
                WHERE ordernumber = 'P2412070024821' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433813'
                WHERE ordernumber = 'P2412070025211' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '42132'
                WHERE ordernumber = 'P2412070025339' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339483'
                WHERE ordernumber = 'P2412070025547' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433814'
                WHERE ordernumber = 'P2412070025949' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '89061'
                WHERE ordernumber = 'P2412070026023' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245786'
                WHERE ordernumber = 'P2412070026123' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '104421'
                WHERE ordernumber = 'P2412070026223' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433815'
                WHERE ordernumber = 'P2412070026399' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433816'
                WHERE ordernumber = 'P2412070026488' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433817'
                WHERE ordernumber = 'P2412070026691' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '131220'
                WHERE ordernumber = 'P2412070026790' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433818'
                WHERE ordernumber = 'P2412070026919' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '333156'
                WHERE ordernumber = 'P2412070027096' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350586'
                WHERE ordernumber = 'P2412070027150' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314307'
                WHERE ordernumber = 'P2412070027213' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '174924'
                WHERE ordernumber = 'P2412070027323' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291058'
                WHERE ordernumber = 'P2412070027686' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433821'
                WHERE ordernumber = 'P2412070027766' 
            
2024-12-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432348'
                WHERE ordernumber = 'P2412070027988' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '296352'
                WHERE ordernumber = 'P2412070028031' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237179'
                WHERE ordernumber = 'P2412070028116' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433822'
                WHERE ordernumber = 'P2412070028270' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '153613'
                WHERE ordernumber = 'P2412070028413' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433824'
                WHERE ordernumber = 'P2412070028598' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '221252'
                WHERE ordernumber = 'P2412070028696' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '255478'
                WHERE ordernumber = 'P2412070028771' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433825'
                WHERE ordernumber = 'P2412070028862' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433823'
                WHERE ordernumber = 'P2412070028932' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433826'
                WHERE ordernumber = 'P2412070029419' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '267019'
                WHERE ordernumber = 'P2412070029643' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245131'
                WHERE ordernumber = 'P2412070029787' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432348'
                WHERE ordernumber = 'P2412070029920' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433829'
                WHERE ordernumber = 'P2412070030147' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433828'
                WHERE ordernumber = 'P2412070030323' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414714'
                WHERE ordernumber = 'P2412070030441' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433831'
                WHERE ordernumber = 'P2412070030629' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433807'
                WHERE ordernumber = 'P2412070030839' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385213'
                WHERE ordernumber = 'P2412070030987' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433832'
                WHERE ordernumber = 'P2412070031028' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433833'
                WHERE ordernumber = 'P2412070031161' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433834'
                WHERE ordernumber = 'P2412070031215' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433835'
                WHERE ordernumber = 'P2412070031315' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '265944'
                WHERE ordernumber = 'P2412070031489' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433834'
                WHERE ordernumber = 'P2412070031674' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '291184'
                WHERE ordernumber = 'P2412070031948' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433838'
                WHERE ordernumber = 'P2412070032073' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433839'
                WHERE ordernumber = 'P2412070032236' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433840'
                WHERE ordernumber = 'P2412070032352' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433841'
                WHERE ordernumber = 'P2412070032475' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433842'
                WHERE ordernumber = 'P2412070032557' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401947'
                WHERE ordernumber = 'P2412070032656' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404577'
                WHERE ordernumber = 'P2412070032768' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431970'
                WHERE ordernumber = 'P2412070032827' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433844'
                WHERE ordernumber = 'P2412070032947' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433845'
                WHERE ordernumber = 'P2412070033087' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429973'
                WHERE ordernumber = 'P2412070033148' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433836'
                WHERE ordernumber = 'P2412070033238' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433846'
                WHERE ordernumber = 'P2412070033375' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433847'
                WHERE ordernumber = 'P2412070033611' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281892'
                WHERE ordernumber = 'P2412070033747' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433808'
                WHERE ordernumber = 'P2412070034197' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352289'
                WHERE ordernumber = 'P2412070034294' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431684'
                WHERE ordernumber = 'P2412070034694' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432932'
                WHERE ordernumber = 'P2412070034844' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433690'
                WHERE ordernumber = 'P2412070035425' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '335506'
                WHERE ordernumber = 'P2412070035619' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '215829'
                WHERE ordernumber = 'P2412070035954' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386467'
                WHERE ordernumber = 'P2412070036014' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433849'
                WHERE ordernumber = 'P2412070036245' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431493'
                WHERE ordernumber = 'P2412070036516' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433850'
                WHERE ordernumber = 'P2412070036614' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433851'
                WHERE ordernumber = 'P2412070036721' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433395'
                WHERE ordernumber = 'P2412070036897' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '319356'
                WHERE ordernumber = 'P2412070036985' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433852'
                WHERE ordernumber = 'P2412070037129' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299342'
                WHERE ordernumber = 'P2412070037241' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '315642'
                WHERE ordernumber = 'P2412070037366' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433853'
                WHERE ordernumber = 'P2412070037496' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433854'
                WHERE ordernumber = 'P2412070037748' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283337'
                WHERE ordernumber = 'P2412070037958' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433852'
                WHERE ordernumber = 'P2412070038111' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433565'
                WHERE ordernumber = 'P2412070038482' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433855'
                WHERE ordernumber = 'P2412070038582' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433856'
                WHERE ordernumber = 'P2412070038645' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433857'
                WHERE ordernumber = 'P2412070038824' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '285530'
                WHERE ordernumber = 'P2412070038931' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433858'
                WHERE ordernumber = 'P2412070039030' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431885'
                WHERE ordernumber = 'P2412070039174' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433859'
                WHERE ordernumber = 'P2412070039246' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433861'
                WHERE ordernumber = 'P2412070039337' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433858'
                WHERE ordernumber = 'P2412070039469' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '270493'
                WHERE ordernumber = 'P2412070039528' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282484'
                WHERE ordernumber = 'P2412070039653' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433862'
                WHERE ordernumber = 'P2412070039826' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '210816'
                WHERE ordernumber = 'P2412070039915' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '225106'
                WHERE ordernumber = 'P2412070040025' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433863'
                WHERE ordernumber = 'P2412070040212' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433864'
                WHERE ordernumber = 'P2412070040410' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433860'
                WHERE ordernumber = 'P2412070040587' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277000'
                WHERE ordernumber = 'P2412070040720' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433865'
                WHERE ordernumber = 'P2412070040934' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96948'
                WHERE ordernumber = 'P2412070041179' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '325592'
                WHERE ordernumber = 'P2412070041256' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '259089'
                WHERE ordernumber = 'P2412070041362' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433866'
                WHERE ordernumber = 'P2412070041423' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433867'
                WHERE ordernumber = 'P2412070041664' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347085'
                WHERE ordernumber = 'P2412070041740' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433869'
                WHERE ordernumber = 'P2412070041945' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433868'
                WHERE ordernumber = 'P2412070042069' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433870'
                WHERE ordernumber = 'P2412070042219' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '87107'
                WHERE ordernumber = 'P2412070042391' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346089'
                WHERE ordernumber = 'P2412070042469' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '247044'
                WHERE ordernumber = 'P2412070042570' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433872'
                WHERE ordernumber = 'P2412070042689' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433874'
                WHERE ordernumber = 'P2412070042726' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377846'
                WHERE ordernumber = 'P2412070042993' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '225290'
                WHERE ordernumber = 'P2412070043094' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98302'
                WHERE ordernumber = 'P2412070043122' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '115139'
                WHERE ordernumber = 'P2412070043228' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433879'
                WHERE ordernumber = 'P2412070043351' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433880'
                WHERE ordernumber = 'P2412070043469' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433882'
                WHERE ordernumber = 'P2412070043550' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433878'
                WHERE ordernumber = 'P2412070043718' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433877'
                WHERE ordernumber = 'P2412070043817' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430563'
                WHERE ordernumber = 'P2412070043917' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433883'
                WHERE ordernumber = 'P2412070044153' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '312890'
                WHERE ordernumber = 'P2412070044269' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349641'
                WHERE ordernumber = 'P2412070044381' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433881'
                WHERE ordernumber = 'P2412070044430' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '293384'
                WHERE ordernumber = 'P2412070044572' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433885'
                WHERE ordernumber = 'P2412070044726' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114014'
                WHERE ordernumber = 'P2412070044885' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433886'
                WHERE ordernumber = 'P2412070044945' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433887'
                WHERE ordernumber = 'P2412070045120' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432577'
                WHERE ordernumber = 'P2412070045292' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433888'
                WHERE ordernumber = 'P2412070045315' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433891'
                WHERE ordernumber = 'P2412070045577' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433892'
                WHERE ordernumber = 'P2412070045626' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433893'
                WHERE ordernumber = 'P2412070045973' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421658'
                WHERE ordernumber = 'P2412070046124' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '124039'
                WHERE ordernumber = 'P2412070046340' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433898'
                WHERE ordernumber = 'P2412070046578' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432999'
                WHERE ordernumber = 'P2412070046638' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433900'
                WHERE ordernumber = 'P2412070046741' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433901'
                WHERE ordernumber = 'P2412070046898' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395189'
                WHERE ordernumber = 'P2412070047046' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '360904'
                WHERE ordernumber = 'P2412070047131' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433902'
                WHERE ordernumber = 'P2412070047345' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '112543'
                WHERE ordernumber = 'P2412070047795' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433904'
                WHERE ordernumber = 'P2412070048033' 
            
2024-12-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433904'
                WHERE ordernumber = 'P2412070048219'