2024-11-30 01:00:02 -- 將會員中心id寫入data-lake
2024-11-30 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-11-29%';
        
2024-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432274'
                WHERE ordernumber = 'P2411290000658' 
            
2024-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '95514'
                WHERE ordernumber = 'P2411290000753' 
            
2024-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432275'
                WHERE ordernumber = 'P2411290001113' 
            
2024-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '224252'
                WHERE ordernumber = 'P2411290001418' 
            
2024-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '351437'
                WHERE ordernumber = 'P2411290001613' 
            
2024-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '130790'
                WHERE ordernumber = 'P2411290001844' 
            
2024-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389788'
                WHERE ordernumber = 'P2411290002847' 
            
2024-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432278'
                WHERE ordernumber = 'P2411290003153' 
            
2024-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432279'
                WHERE ordernumber = 'P2411290003287' 
            
2024-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432167'
                WHERE ordernumber = 'P2411290003529' 
            
2024-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427097'
                WHERE ordernumber = 'P2411290003742' 
            
2024-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432280'
                WHERE ordernumber = 'P2411290003948' 
            
2024-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432281'
                WHERE ordernumber = 'P2411290004019' 
            
2024-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427160'
                WHERE ordernumber = 'P2411290004269' 
            
2024-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '102664'
                WHERE ordernumber = 'P2411290004328' 
            
2024-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '258439'
                WHERE ordernumber = 'P2411290004517' 
            
2024-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432283'
                WHERE ordernumber = 'P2411290004858' 
            
2024-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432284'
                WHERE ordernumber = 'P2411290004985' 
            
2024-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '240717'
                WHERE ordernumber = 'P2411290005061' 
            
2024-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '4424'
                WHERE ordernumber = 'P2411290005110' 
            
2024-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432286'
                WHERE ordernumber = 'P2411290005234' 
            
2024-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432285'
                WHERE ordernumber = 'P2411290005320' 
            
2024-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432261'
                WHERE ordernumber = 'P2411290005418' 
            
2024-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432261'
                WHERE ordernumber = 'P2411290005597' 
            
2024-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '171084'
                WHERE ordernumber = 'P2411290005898' 
            
2024-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432289'
                WHERE ordernumber = 'P2411290005947' 
            
2024-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432290'
                WHERE ordernumber = 'P2411290006066' 
            
2024-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '284771'
                WHERE ordernumber = 'P2411290006150' 
            
2024-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '211508'
                WHERE ordernumber = 'P2411290006211' 
            
2024-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432292'
                WHERE ordernumber = 'P2411290006382' 
            
2024-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '252519'
                WHERE ordernumber = 'P2411290006427' 
            
2024-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432292'
                WHERE ordernumber = 'P2411290006742' 
            
2024-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389093'
                WHERE ordernumber = 'P2411290006849' 
            
2024-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432291'
                WHERE ordernumber = 'P2411290006961' 
            
2024-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432297'
                WHERE ordernumber = 'P2411290007051' 
            
2024-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432299'
                WHERE ordernumber = 'P2411290007256' 
            
2024-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432298'
                WHERE ordernumber = 'P2411290007394' 
            
2024-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432301'
                WHERE ordernumber = 'P2411290007614' 
            
2024-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '162977'
                WHERE ordernumber = 'P2411290007822' 
            
2024-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432300'
                WHERE ordernumber = 'P2411290008051' 
            
2024-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432302'
                WHERE ordernumber = 'P2411290008186' 
            
2024-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P2411290008338' 
            
2024-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432303'
                WHERE ordernumber = 'P2411290008469' 
            
2024-11-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '414248'
                WHERE ordernumber = 'P2411290008681' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235191'
                WHERE ordernumber = 'P2411290008996' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432304'
                WHERE ordernumber = 'P2411290009294' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432304'
                WHERE ordernumber = 'P2411290009446' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432306'
                WHERE ordernumber = 'P2411290009568' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379585'
                WHERE ordernumber = 'P2411290009920' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '318891'
                WHERE ordernumber = 'P2411290010069' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275642'
                WHERE ordernumber = 'P2411290010281' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367339'
                WHERE ordernumber = 'P2411290010314' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432307'
                WHERE ordernumber = 'P2411290010475' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '133830'
                WHERE ordernumber = 'P2411290010644' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432308'
                WHERE ordernumber = 'P2411290010798' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '290994'
                WHERE ordernumber = 'P2411290010955' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94254'
                WHERE ordernumber = 'P2411290011057' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432311'
                WHERE ordernumber = 'P2411290011224' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406568'
                WHERE ordernumber = 'P2411290011347' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415800'
                WHERE ordernumber = 'P2411290011610' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432312'
                WHERE ordernumber = 'P2411290011795' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296943'
                WHERE ordernumber = 'P2411290011868' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '212418'
                WHERE ordernumber = 'P2411290011934' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '40430'
                WHERE ordernumber = 'P2411290012026' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162018'
                WHERE ordernumber = 'P2411290012112' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432314'
                WHERE ordernumber = 'P2411290012341' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379634'
                WHERE ordernumber = 'P2411290012457' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432315'
                WHERE ordernumber = 'P2411290012529' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432316'
                WHERE ordernumber = 'P2411290012657' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '265649'
                WHERE ordernumber = 'P2411290012771' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432313'
                WHERE ordernumber = 'P2411290012831' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432318'
                WHERE ordernumber = 'P2411290012989' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276855'
                WHERE ordernumber = 'P2411290013048' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432319'
                WHERE ordernumber = 'P2411290013228' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348816'
                WHERE ordernumber = 'P2411290013561' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432320'
                WHERE ordernumber = 'P2411290013629' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431855'
                WHERE ordernumber = 'P2411290013749' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '210705'
                WHERE ordernumber = 'P2411290014556' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414543'
                WHERE ordernumber = 'P2411290014628' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432321'
                WHERE ordernumber = 'P2411290014787' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370453'
                WHERE ordernumber = 'P2411290015242' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432322'
                WHERE ordernumber = 'P2411290015360' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432325'
                WHERE ordernumber = 'P2411290015450' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '125140'
                WHERE ordernumber = 'P2411290015684' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432326'
                WHERE ordernumber = 'P2411290015863' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432327'
                WHERE ordernumber = 'P2411290015923' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347413'
                WHERE ordernumber = 'P2411290016281' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432329'
                WHERE ordernumber = 'P2411290016430' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432330'
                WHERE ordernumber = 'P2411290016551' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '20802'
                WHERE ordernumber = 'P2411290017626' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240295'
                WHERE ordernumber = 'P2411290017774' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432332'
                WHERE ordernumber = 'P2411290017834' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432333'
                WHERE ordernumber = 'P2411290018014' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '147891'
                WHERE ordernumber = 'P2411290018197' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427092'
                WHERE ordernumber = 'P2411290018241' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432334'
                WHERE ordernumber = 'P2411290018471' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432337'
                WHERE ordernumber = 'P2411290018791' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432338'
                WHERE ordernumber = 'P2411290019135' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432335'
                WHERE ordernumber = 'P2411290019211' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432340'
                WHERE ordernumber = 'P2411290019463' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432342'
                WHERE ordernumber = 'P2411290019882' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432334'
                WHERE ordernumber = 'P2411290020037' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432343'
                WHERE ordernumber = 'P2411290020199' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432341'
                WHERE ordernumber = 'P2411290020324' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432341'
                WHERE ordernumber = 'P2411290020472' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '272843'
                WHERE ordernumber = 'P2411290020715' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423045'
                WHERE ordernumber = 'P2411290020827' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '274874'
                WHERE ordernumber = 'P2411290020969' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432345'
                WHERE ordernumber = 'P2411290021071' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432346'
                WHERE ordernumber = 'P2411290021145' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '274874'
                WHERE ordernumber = 'P2411290021221' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404113'
                WHERE ordernumber = 'P2411290021378' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432348'
                WHERE ordernumber = 'P2411290021423' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388338'
                WHERE ordernumber = 'P2411290021689' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '259528'
                WHERE ordernumber = 'P2411290021931' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432350'
                WHERE ordernumber = 'P2411290022067' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432349'
                WHERE ordernumber = 'P2411290022139' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426136'
                WHERE ordernumber = 'P2411290022236' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '226971'
                WHERE ordernumber = 'P2411290022393' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427653'
                WHERE ordernumber = 'P2411290022751' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300701'
                WHERE ordernumber = 'P2411290022816' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112579'
                WHERE ordernumber = 'P2411290022949' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432352'
                WHERE ordernumber = 'P2411290023196' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94347'
                WHERE ordernumber = 'P2411290023229' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162779'
                WHERE ordernumber = 'P2411290023840' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422972'
                WHERE ordernumber = 'P2411290024183' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '211298'
                WHERE ordernumber = 'P2411290024539' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350213'
                WHERE ordernumber = 'P2411290024623' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432354'
                WHERE ordernumber = 'P2411290024749' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432353'
                WHERE ordernumber = 'P2411290024812' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '273567'
                WHERE ordernumber = 'P2411290024982' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81698'
                WHERE ordernumber = 'P2411290025087' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385618'
                WHERE ordernumber = 'P2411290025474' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '86113'
                WHERE ordernumber = 'P2411290025547' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384449'
                WHERE ordernumber = 'P2411290025658' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '294879'
                WHERE ordernumber = 'P2411290025722' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P2411290025825' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94055'
                WHERE ordernumber = 'P2411290025919' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432356'
                WHERE ordernumber = 'P2411290026088' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432357'
                WHERE ordernumber = 'P2411290026172' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432358'
                WHERE ordernumber = 'P2411290026396' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P2411290026565' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432359'
                WHERE ordernumber = 'P2411290026639' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427922'
                WHERE ordernumber = 'P2411290026987' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P2411290027062' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P2411290027150' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P2411290027212' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283811'
                WHERE ordernumber = 'P2411290027394' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P2411290027591' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432361'
                WHERE ordernumber = 'P2411290027758' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275302'
                WHERE ordernumber = 'P2411290028150' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P2411290028449' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P2411290028652' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432363'
                WHERE ordernumber = 'P2411290028737' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P2411290028872' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '324637'
                WHERE ordernumber = 'P2411290028933' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432365'
                WHERE ordernumber = 'P2411290029077' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432367'
                WHERE ordernumber = 'P2411290029189' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432362'
                WHERE ordernumber = 'P2411290029211' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432366'
                WHERE ordernumber = 'P2411290029371' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432362'
                WHERE ordernumber = 'P2411290029497' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432368'
                WHERE ordernumber = 'P2411290029735' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306354'
                WHERE ordernumber = 'P2411290029911' 
            
2024-11-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427027'
                WHERE ordernumber = 'P2411290030044' 
            
2024-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432348'
                WHERE ordernumber = 'P2411290030125' 
            
2024-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306354'
                WHERE ordernumber = 'P2411290030245' 
            
2024-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '4568'
                WHERE ordernumber = 'P2411290030587' 
            
2024-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432348'
                WHERE ordernumber = 'P2411290030678' 
            
2024-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432369'
                WHERE ordernumber = 'P2411290030881' 
            
2024-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '244672'
                WHERE ordernumber = 'P2411290031526' 
            
2024-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432371'
                WHERE ordernumber = 'P2411290031719' 
            
2024-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '323537'
                WHERE ordernumber = 'P2411290031835' 
            
2024-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432374'
                WHERE ordernumber = 'P2411290031939' 
            
2024-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427276'
                WHERE ordernumber = 'P2411290032397' 
            
2024-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431440'
                WHERE ordernumber = 'P2411290032621' 
            
2024-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346372'
                WHERE ordernumber = 'P2411290032749' 
            
2024-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432377'
                WHERE ordernumber = 'P2411290032986' 
            
2024-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '46581'
                WHERE ordernumber = 'P2411290033052' 
            
2024-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400983'
                WHERE ordernumber = 'P2411290033116' 
            
2024-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432378'
                WHERE ordernumber = 'P2411290033427' 
            
2024-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99160'
                WHERE ordernumber = 'P2411290033551' 
            
2024-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284402'
                WHERE ordernumber = 'P2411290033830' 
            
2024-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '206307'
                WHERE ordernumber = 'P2411290034062' 
            
2024-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '229636'
                WHERE ordernumber = 'P2411290034123' 
            
2024-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '228348'
                WHERE ordernumber = 'P2411290034223' 
            
2024-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '206307'
                WHERE ordernumber = 'P2411290034333' 
            
2024-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432381'
                WHERE ordernumber = 'P2411290034447' 
            
2024-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421268'
                WHERE ordernumber = 'P2411290034535' 
            
2024-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432382'
                WHERE ordernumber = 'P2411290034765' 
            
2024-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '331239'
                WHERE ordernumber = 'P2411290034819' 
            
2024-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410937'
                WHERE ordernumber = 'P2411290034978' 
            
2024-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '270218'
                WHERE ordernumber = 'P2411290035138' 
            
2024-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432384'
                WHERE ordernumber = 'P2411290035482' 
            
2024-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432386'
                WHERE ordernumber = 'P2411290035566' 
            
2024-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '229132'
                WHERE ordernumber = 'P2411290035625' 
            
2024-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301374'
                WHERE ordernumber = 'P2411290035787' 
            
2024-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432387'
                WHERE ordernumber = 'P2411290035869' 
            
2024-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432388'
                WHERE ordernumber = 'P2411290035941' 
            
2024-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422164'
                WHERE ordernumber = 'P2411290036050' 
            
2024-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96447'
                WHERE ordernumber = 'P2411290036250' 
            
2024-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432390'
                WHERE ordernumber = 'P2411290036965' 
            
2024-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '314574'
                WHERE ordernumber = 'P2411290037092' 
            
2024-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389855'
                WHERE ordernumber = 'P2411290037163' 
            
2024-11-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432391'
                WHERE ordernumber = 'P2411290037438'