2025-02-04 01:00:02 -- 將會員中心id寫入data-lake
2025-02-04 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 '2025-02-03%';
        
2025-02-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '452884'
                WHERE ordernumber = 'P2502030000014' 
            
2025-02-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393227'
                WHERE ordernumber = 'P2502030000018' 
            
2025-02-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '121148'
                WHERE ordernumber = 'P2502030000025' 
            
2025-02-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '454669'
                WHERE ordernumber = 'P2502030000027' 
            
2025-02-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '454671'
                WHERE ordernumber = 'P2502030000028' 
            
2025-02-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '216822'
                WHERE ordernumber = 'P2502030000029' 
            
2025-02-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '322287'
                WHERE ordernumber = 'P2502030000030' 
            
2025-02-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '309074'
                WHERE ordernumber = 'P2502030000032' 
            
2025-02-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '212237'
                WHERE ordernumber = 'P2502030000033' 
            
2025-02-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '454672'
                WHERE ordernumber = 'P2502030000039' 
            
2025-02-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '454673'
                WHERE ordernumber = 'P2502030000040' 
            
2025-02-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '454674'
                WHERE ordernumber = 'P2502030000052' 
            
2025-02-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99933'
                WHERE ordernumber = 'P2502030000061' 
            
2025-02-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '454675'
                WHERE ordernumber = 'P2502030000071' 
            
2025-02-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '454676'
                WHERE ordernumber = 'P2502030000074' 
            
2025-02-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '454677'
                WHERE ordernumber = 'P2502030000077' 
            
2025-02-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '454678'
                WHERE ordernumber = 'P2502030000078' 
            
2025-02-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '454679'
                WHERE ordernumber = 'P2502030000082' 
            
2025-02-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '454680'
                WHERE ordernumber = 'P2502030000083' 
            
2025-02-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386742'
                WHERE ordernumber = 'P2502030000085' 
            
2025-02-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '234716'
                WHERE ordernumber = 'P2502030000087' 
            
2025-02-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '454681'
                WHERE ordernumber = 'P2502030000088' 
            
2025-02-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '454682'
                WHERE ordernumber = 'P2502030000091' 
            
2025-02-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '372351'
                WHERE ordernumber = 'P2502030000092' 
            
2025-02-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409228'
                WHERE ordernumber = 'P2502030000095' 
            
2025-02-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '454683'
                WHERE ordernumber = 'P2502030000100' 
            
2025-02-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '335331'
                WHERE ordernumber = 'P2502030000102' 
            
2025-02-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '454684'
                WHERE ordernumber = 'P2502030000103' 
            
2025-02-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431549'
                WHERE ordernumber = 'P2502030000104' 
            
2025-02-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '357280'
                WHERE ordernumber = 'P2502030000106' 
            
2025-02-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '104141'
                WHERE ordernumber = 'P2502030000111' 
            
2025-02-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '297128'
                WHERE ordernumber = 'P2502030000112' 
            
2025-02-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '446859'
                WHERE ordernumber = 'P2502030000113' 
            
2025-02-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '446859'
                WHERE ordernumber = 'P2502030000114' 
            
2025-02-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '116975'
                WHERE ordernumber = 'P2502030000116' 
            
2025-02-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '454686'
                WHERE ordernumber = 'P2502030000124' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454687'
                WHERE ordernumber = 'P2502030000125' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430880'
                WHERE ordernumber = 'P2502030000127' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '274874'
                WHERE ordernumber = 'P2502030000129' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '258964'
                WHERE ordernumber = 'P2502030000130' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426103'
                WHERE ordernumber = 'P2502030000132' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407516'
                WHERE ordernumber = 'P2502030000134' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304697'
                WHERE ordernumber = 'P2502030000136' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454689'
                WHERE ordernumber = 'P2502030000137' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '261715'
                WHERE ordernumber = 'P2502030000141' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287427'
                WHERE ordernumber = 'P2502030000142' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454688'
                WHERE ordernumber = 'P2502030000145' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '453075'
                WHERE ordernumber = 'P2502030000146' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395833'
                WHERE ordernumber = 'P2502030000148' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276302'
                WHERE ordernumber = 'P2502030000150' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454691'
                WHERE ordernumber = 'P2502030000157' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454692'
                WHERE ordernumber = 'P2502030000158' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '319905'
                WHERE ordernumber = 'P2502030000159' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454694'
                WHERE ordernumber = 'P2502030000161' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93882'
                WHERE ordernumber = 'P2502030000165' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454695'
                WHERE ordernumber = 'P2502030000175' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454697'
                WHERE ordernumber = 'P2502030000189' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426282'
                WHERE ordernumber = 'P2502030000190' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445644'
                WHERE ordernumber = 'P2502030000192' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381201'
                WHERE ordernumber = 'P2502030000213' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454700'
                WHERE ordernumber = 'P2502030000214' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454701'
                WHERE ordernumber = 'P2502030000222' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307686'
                WHERE ordernumber = 'P2502030000230' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377441'
                WHERE ordernumber = 'P2502030000237' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '441534'
                WHERE ordernumber = 'P2502030000238' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433408'
                WHERE ordernumber = 'P2502030000244' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454704'
                WHERE ordernumber = 'P2502030000246' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348437'
                WHERE ordernumber = 'P2502030000256' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242958'
                WHERE ordernumber = 'P2502030000258' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454706'
                WHERE ordernumber = 'P2502030000262' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '201386'
                WHERE ordernumber = 'P2502030000271' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '84477'
                WHERE ordernumber = 'P2502030000272' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '221252'
                WHERE ordernumber = 'P2502030000273' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442169'
                WHERE ordernumber = 'P2502030000279' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434277'
                WHERE ordernumber = 'P2502030000280' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '51678'
                WHERE ordernumber = 'P2502030000281' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407903'
                WHERE ordernumber = 'P2502030000287' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454707'
                WHERE ordernumber = 'P2502030000295' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454709'
                WHERE ordernumber = 'P2502030000301' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '246380'
                WHERE ordernumber = 'P2502030000312' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406820'
                WHERE ordernumber = 'P2502030000316' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404353'
                WHERE ordernumber = 'P2502030000326' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405062'
                WHERE ordernumber = 'P2502030000329' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454713'
                WHERE ordernumber = 'P2502030000333' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454715'
                WHERE ordernumber = 'P2502030000340' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454715'
                WHERE ordernumber = 'P2502030000343' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414185'
                WHERE ordernumber = 'P2502030000346' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385058'
                WHERE ordernumber = 'P2502030000357' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454719'
                WHERE ordernumber = 'P2502030000362' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118801'
                WHERE ordernumber = 'P2502030000363' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282342'
                WHERE ordernumber = 'P2502030000365' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454720'
                WHERE ordernumber = 'P2502030000393' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454521'
                WHERE ordernumber = 'P2502030000402' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454721'
                WHERE ordernumber = 'P2502030000404' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '207025'
                WHERE ordernumber = 'P2502030000411' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276022'
                WHERE ordernumber = 'P2502030000414' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248651'
                WHERE ordernumber = 'P2502030000430' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454722'
                WHERE ordernumber = 'P2502030000438' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348877'
                WHERE ordernumber = 'P2502030000439' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454723'
                WHERE ordernumber = 'P2502030000443' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454724'
                WHERE ordernumber = 'P2502030000447' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424515'
                WHERE ordernumber = 'P2502030000448' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454723'
                WHERE ordernumber = 'P2502030000453' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454725'
                WHERE ordernumber = 'P2502030000454' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96428'
                WHERE ordernumber = 'P2502030000457' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454727'
                WHERE ordernumber = 'P2502030000458' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337464'
                WHERE ordernumber = 'P2502030000470' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '70268'
                WHERE ordernumber = 'P2502030000477' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454728'
                WHERE ordernumber = 'P2502030000485' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247272'
                WHERE ordernumber = 'P2502030000486' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358828'
                WHERE ordernumber = 'P2502030000487' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431365'
                WHERE ordernumber = 'P2502030000488' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454729'
                WHERE ordernumber = 'P2502030000489' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344787'
                WHERE ordernumber = 'P2502030000490' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310908'
                WHERE ordernumber = 'P2502030000491' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '211251'
                WHERE ordernumber = 'P2502030000497' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454730'
                WHERE ordernumber = 'P2502030000501' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454732'
                WHERE ordernumber = 'P2502030000504' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454734'
                WHERE ordernumber = 'P2502030000513' 
            
2025-02-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '192684'
                WHERE ordernumber = 'P2502030000515'