2024-11-22 01:00:02 -- 將會員中心id寫入data-lake
2024-11-22 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-21%';
        
2024-11-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431132'
                WHERE ordernumber = 'P2411210000192' 
            
2024-11-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '340773'
                WHERE ordernumber = 'P2411210000411' 
            
2024-11-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '344439'
                WHERE ordernumber = 'P2411210000660' 
            
2024-11-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431135'
                WHERE ordernumber = 'P2411210000799' 
            
2024-11-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '345613'
                WHERE ordernumber = 'P2411210000810' 
            
2024-11-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431136'
                WHERE ordernumber = 'P2411210000978' 
            
2024-11-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431133'
                WHERE ordernumber = 'P2411210001698' 
            
2024-11-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431134'
                WHERE ordernumber = 'P2411210002073' 
            
2024-11-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '133492'
                WHERE ordernumber = 'P2411210002252' 
            
2024-11-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '383903'
                WHERE ordernumber = 'P2411210002323' 
            
2024-11-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353938'
                WHERE ordernumber = 'P2411210002569' 
            
2024-11-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431138'
                WHERE ordernumber = 'P2411210002892' 
            
2024-11-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431139'
                WHERE ordernumber = 'P2411210003024' 
            
2024-11-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '155893'
                WHERE ordernumber = 'P2411210003197' 
            
2024-11-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '281358'
                WHERE ordernumber = 'P2411210003287' 
            
2024-11-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '132180'
                WHERE ordernumber = 'P2411210003387' 
            
2024-11-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P2411210003518' 
            
2024-11-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431140'
                WHERE ordernumber = 'P2411210003675' 
            
2024-11-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431141'
                WHERE ordernumber = 'P2411210003956' 
            
2024-11-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431128'
                WHERE ordernumber = 'P2411210004033' 
            
2024-11-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '284599'
                WHERE ordernumber = 'P2411210004216' 
            
2024-11-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '182678'
                WHERE ordernumber = 'P2411210004494' 
            
2024-11-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431122'
                WHERE ordernumber = 'P2411210004512' 
            
2024-11-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '399585'
                WHERE ordernumber = 'P2411210004833' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431146'
                WHERE ordernumber = 'P2411210005020' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431147'
                WHERE ordernumber = 'P2411210005112' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431146'
                WHERE ordernumber = 'P2411210005520' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431150'
                WHERE ordernumber = 'P2411210005731' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247064'
                WHERE ordernumber = 'P2411210006174' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '329282'
                WHERE ordernumber = 'P2411210006397' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430800'
                WHERE ordernumber = 'P2411210006782' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430944'
                WHERE ordernumber = 'P2411210006858' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431154'
                WHERE ordernumber = 'P2411210007211' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431155'
                WHERE ordernumber = 'P2411210007370' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431157'
                WHERE ordernumber = 'P2411210007577' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431159'
                WHERE ordernumber = 'P2411210007691' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429658'
                WHERE ordernumber = 'P2411210008055' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428850'
                WHERE ordernumber = 'P2411210008187' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401679'
                WHERE ordernumber = 'P2411210008390' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '260517'
                WHERE ordernumber = 'P2411210008636' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214813'
                WHERE ordernumber = 'P2411210009065' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431170'
                WHERE ordernumber = 'P2411210009899' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305137'
                WHERE ordernumber = 'P2411210010097' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377614'
                WHERE ordernumber = 'P2411210010291' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431077'
                WHERE ordernumber = 'P2411210010549' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431077'
                WHERE ordernumber = 'P2411210010686' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412326'
                WHERE ordernumber = 'P2411210010987' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '104230'
                WHERE ordernumber = 'P2411210011165' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '78136'
                WHERE ordernumber = 'P2411210011223' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429954'
                WHERE ordernumber = 'P2411210011415' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431173'
                WHERE ordernumber = 'P2411210011554' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431175'
                WHERE ordernumber = 'P2411210011762' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431174'
                WHERE ordernumber = 'P2411210011856' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431176'
                WHERE ordernumber = 'P2411210011984' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '161924'
                WHERE ordernumber = 'P2411210012028' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431177'
                WHERE ordernumber = 'P2411210012137' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431178'
                WHERE ordernumber = 'P2411210012345' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431179'
                WHERE ordernumber = 'P2411210012441' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430619'
                WHERE ordernumber = 'P2411210013156' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431182'
                WHERE ordernumber = 'P2411210013257' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431183'
                WHERE ordernumber = 'P2411210013365' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431005'
                WHERE ordernumber = 'P2411210013452' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431071'
                WHERE ordernumber = 'P2411210013520' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431185'
                WHERE ordernumber = 'P2411210013791' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '88985'
                WHERE ordernumber = 'P2411210013863' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '255560'
                WHERE ordernumber = 'P2411210013934' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '294892'
                WHERE ordernumber = 'P2411210014450' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404953'
                WHERE ordernumber = 'P2411210014697' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97293'
                WHERE ordernumber = 'P2411210015095' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '244793'
                WHERE ordernumber = 'P2411210015330' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431190'
                WHERE ordernumber = 'P2411210016142' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431190'
                WHERE ordernumber = 'P2411210016227' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431190'
                WHERE ordernumber = 'P2411210016346' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346578'
                WHERE ordernumber = 'P2411210016423' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431188'
                WHERE ordernumber = 'P2411210016678' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '252044'
                WHERE ordernumber = 'P2411210017128' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313619'
                WHERE ordernumber = 'P2411210017295' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '135991'
                WHERE ordernumber = 'P2411210017330' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431192'
                WHERE ordernumber = 'P2411210017495' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429970'
                WHERE ordernumber = 'P2411210017524' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431194'
                WHERE ordernumber = 'P2411210017634' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431193'
                WHERE ordernumber = 'P2411210017770' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416265'
                WHERE ordernumber = 'P2411210018415' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387229'
                WHERE ordernumber = 'P2411210018588' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429764'
                WHERE ordernumber = 'P2411210018754' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305265'
                WHERE ordernumber = 'P2411210018850' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431196'
                WHERE ordernumber = 'P2411210018937' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430105'
                WHERE ordernumber = 'P2411210019093' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431198'
                WHERE ordernumber = 'P2411210019171' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431199'
                WHERE ordernumber = 'P2411210019385' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431201'
                WHERE ordernumber = 'P2411210019684' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '290005'
                WHERE ordernumber = 'P2411210020043' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112568'
                WHERE ordernumber = 'P2411210020188' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431204'
                WHERE ordernumber = 'P2411210020463' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '86113'
                WHERE ordernumber = 'P2411210020543' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358866'
                WHERE ordernumber = 'P2411210020659' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248037'
                WHERE ordernumber = 'P2411210020798' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430898'
                WHERE ordernumber = 'P2411210020982' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305672'
                WHERE ordernumber = 'P2411210021278' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431205'
                WHERE ordernumber = 'P2411210021361' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '149008'
                WHERE ordernumber = 'P2411210021570' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426279'
                WHERE ordernumber = 'P2411210022128' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340818'
                WHERE ordernumber = 'P2411210022277' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431208'
                WHERE ordernumber = 'P2411210022361' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431210'
                WHERE ordernumber = 'P2411210022462' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '127195'
                WHERE ordernumber = 'P2411210022535' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301384'
                WHERE ordernumber = 'P2411210022632' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431208'
                WHERE ordernumber = 'P2411210022761' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431210'
                WHERE ordernumber = 'P2411210022979' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313312'
                WHERE ordernumber = 'P2411210023034' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431216'
                WHERE ordernumber = 'P2411210023397' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '86113'
                WHERE ordernumber = 'P2411210023226' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '308755'
                WHERE ordernumber = 'P2411210023575' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431217'
                WHERE ordernumber = 'P2411210023827' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364206'
                WHERE ordernumber = 'P2411210024126' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431213'
                WHERE ordernumber = 'P2411210024256' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102949'
                WHERE ordernumber = 'P2411210024491' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431219'
                WHERE ordernumber = 'P2411210024569' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431220'
                WHERE ordernumber = 'P2411210024632' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431222'
                WHERE ordernumber = 'P2411210024876' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390006'
                WHERE ordernumber = 'P2411210025023' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431223'
                WHERE ordernumber = 'P2411210025160' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431224'
                WHERE ordernumber = 'P2411210025252' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431225'
                WHERE ordernumber = 'P2411210025312' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431226'
                WHERE ordernumber = 'P2411210025458' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431227'
                WHERE ordernumber = 'P2411210025655' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431228'
                WHERE ordernumber = 'P2411210025870' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431226'
                WHERE ordernumber = 'P2411210026019' 
            
2024-11-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '89001'
                WHERE ordernumber = 'P2411210026317'