2025-02-13 01:00:02 -- 將會員中心id寫入data-lake
2025-02-13 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-12%';
        
2025-02-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '266261'
                WHERE ordernumber = 'P2502120000017' 
            
2025-02-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339179'
                WHERE ordernumber = 'P2502120000018' 
            
2025-02-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455704'
                WHERE ordernumber = 'P2502120000021' 
            
2025-02-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239130'
                WHERE ordernumber = 'P2502120000026' 
            
2025-02-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455714'
                WHERE ordernumber = 'P2502120000028' 
            
2025-02-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455710'
                WHERE ordernumber = 'P2502120000030' 
            
2025-02-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455705'
                WHERE ordernumber = 'P2502120000031' 
            
2025-02-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291679'
                WHERE ordernumber = 'P2502120000035' 
            
2025-02-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '111604'
                WHERE ordernumber = 'P2502120000039' 
            
2025-02-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455715'
                WHERE ordernumber = 'P2502120000041' 
            
2025-02-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297128'
                WHERE ordernumber = 'P2502120000044' 
            
2025-02-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455717'
                WHERE ordernumber = 'P2502120000048' 
            
2025-02-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99926'
                WHERE ordernumber = 'P2502120000050' 
            
2025-02-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112329'
                WHERE ordernumber = 'P2502120000051' 
            
2025-02-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455718'
                WHERE ordernumber = 'P2502120000057' 
            
2025-02-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112676'
                WHERE ordernumber = 'P2502120000058' 
            
2025-02-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343585'
                WHERE ordernumber = 'P2502120000062' 
            
2025-02-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423031'
                WHERE ordernumber = 'P2502120000065' 
            
2025-02-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '269520'
                WHERE ordernumber = 'P2502120000066' 
            
2025-02-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '208650'
                WHERE ordernumber = 'P2502120000068' 
            
2025-02-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '126657'
                WHERE ordernumber = 'P2502120000070' 
            
2025-02-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113323'
                WHERE ordernumber = 'P2502120000074' 
            
2025-02-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347860'
                WHERE ordernumber = 'P2502120000075' 
            
2025-02-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353415'
                WHERE ordernumber = 'P2502120000076' 
            
2025-02-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301171'
                WHERE ordernumber = 'P2502120000079' 
            
2025-02-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93882'
                WHERE ordernumber = 'P2502120000080' 
            
2025-02-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93882'
                WHERE ordernumber = 'P2502120000082' 
            
2025-02-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455723'
                WHERE ordernumber = 'P2502120000086' 
            
2025-02-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455723'
                WHERE ordernumber = 'P2502120000088' 
            
2025-02-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353415'
                WHERE ordernumber = 'P2502120000089' 
            
2025-02-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455492'
                WHERE ordernumber = 'P2502120000093' 
            
2025-02-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '54776'
                WHERE ordernumber = 'P2502120000095' 
            
2025-02-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '115459'
                WHERE ordernumber = 'P2502120000097' 
            
2025-02-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455725'
                WHERE ordernumber = 'P2502120000099' 
            
2025-02-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '453170'
                WHERE ordernumber = 'P2502120000102' 
            
2025-02-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '251930'
                WHERE ordernumber = 'P2502120000117' 
            
2025-02-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '216990'
                WHERE ordernumber = 'P2502120000118' 
            
2025-02-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455726'
                WHERE ordernumber = 'P2502120000120' 
            
2025-02-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455727'
                WHERE ordernumber = 'P2502120000126' 
            
2025-02-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '209302'
                WHERE ordernumber = 'P2502120000128' 
            
2025-02-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P2502120000131' 
            
2025-02-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455730'
                WHERE ordernumber = 'P2502120000133' 
            
2025-02-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455731'
                WHERE ordernumber = 'P2502120000134' 
            
2025-02-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455732'
                WHERE ordernumber = 'P2502120000138' 
            
2025-02-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '321982'
                WHERE ordernumber = 'P2502120000139' 
            
2025-02-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455733'
                WHERE ordernumber = 'P2502120000140' 
            
2025-02-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '269457'
                WHERE ordernumber = 'P2502120000141' 
            
2025-02-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '125335'
                WHERE ordernumber = 'P2502120000144' 
            
2025-02-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455735'
                WHERE ordernumber = 'P2502120000146' 
            
2025-02-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440123'
                WHERE ordernumber = 'P2502120000147' 
            
2025-02-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455734'
                WHERE ordernumber = 'P2502120000148' 
            
2025-02-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '272572'
                WHERE ordernumber = 'P2502120000152' 
            
2025-02-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455736'
                WHERE ordernumber = 'P2502120000153' 
            
2025-02-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455737'
                WHERE ordernumber = 'P2502120000154' 
            
2025-02-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P2502120000159' 
            
2025-02-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P2502120000171' 
            
2025-02-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378573'
                WHERE ordernumber = 'P2502120000173' 
            
2025-02-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P2502120000174' 
            
2025-02-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94254'
                WHERE ordernumber = 'P2502120000175' 
            
2025-02-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455584'
                WHERE ordernumber = 'P2502120000178' 
            
2025-02-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P2502120000179' 
            
2025-02-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P2502120000182' 
            
2025-02-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '136252'
                WHERE ordernumber = 'P2502120000183' 
            
2025-02-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237534'
                WHERE ordernumber = 'P2502120000184' 
            
2025-02-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '226927'
                WHERE ordernumber = 'P2502120000192' 
            
2025-02-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455742'
                WHERE ordernumber = 'P2502120000196' 
            
2025-02-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P2502120000200' 
            
2025-02-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455743'
                WHERE ordernumber = 'P2502120000201' 
            
2025-02-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430619'
                WHERE ordernumber = 'P2502120000204' 
            
2025-02-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P2502120000207' 
            
2025-02-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '374994'
                WHERE ordernumber = 'P2502120000208' 
            
2025-02-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P2502120000209' 
            
2025-02-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382409'
                WHERE ordernumber = 'P2502120000210' 
            
2025-02-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455746'
                WHERE ordernumber = 'P2502120000211' 
            
2025-02-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81134'
                WHERE ordernumber = 'P2502120000216' 
            
2025-02-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426568'
                WHERE ordernumber = 'P2502120000220' 
            
2025-02-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455747'
                WHERE ordernumber = 'P2502120000221' 
            
2025-02-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455748'
                WHERE ordernumber = 'P2502120000225' 
            
2025-02-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404281'
                WHERE ordernumber = 'P2502120000232' 
            
2025-02-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455749'
                WHERE ordernumber = 'P2502120000242' 
            
2025-02-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455754'
                WHERE ordernumber = 'P2502120000260' 
            
2025-02-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '267520'
                WHERE ordernumber = 'P2502120000267' 
            
2025-02-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349607'
                WHERE ordernumber = 'P2502120000272' 
            
2025-02-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '253769'
                WHERE ordernumber = 'P2502120000278' 
            
2025-02-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455757'
                WHERE ordernumber = 'P2502120000281' 
            
2025-02-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455758'
                WHERE ordernumber = 'P2502120000282' 
            
2025-02-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '138938'
                WHERE ordernumber = 'P2502120000283' 
            
2025-02-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '36338'
                WHERE ordernumber = 'P2502120000284' 
            
2025-02-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431549'
                WHERE ordernumber = 'P2502120000285' 
            
2025-02-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99638'
                WHERE ordernumber = 'P2502120000292' 
            
2025-02-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '121498'
                WHERE ordernumber = 'P2502120000298' 
            
2025-02-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455760'
                WHERE ordernumber = 'P2502120000300' 
            
2025-02-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340805'
                WHERE ordernumber = 'P2502120000301' 
            
2025-02-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '208433'
                WHERE ordernumber = 'P2502120000305' 
            
2025-02-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '208433'
                WHERE ordernumber = 'P2502120000311' 
            
2025-02-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '420159'
                WHERE ordernumber = 'P2502120000319' 
            
2025-02-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455763'
                WHERE ordernumber = 'P2502120000321' 
            
2025-02-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455765'
                WHERE ordernumber = 'P2502120000329' 
            
2025-02-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455764'
                WHERE ordernumber = 'P2502120000331' 
            
2025-02-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '228399'
                WHERE ordernumber = 'P2502120000334' 
            
2025-02-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455766'
                WHERE ordernumber = 'P2502120000336' 
            
2025-02-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '451795'
                WHERE ordernumber = 'P2502120000338' 
            
2025-02-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '313744'
                WHERE ordernumber = 'P2502120000342' 
            
2025-02-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '282101'
                WHERE ordernumber = 'P2502120000346' 
            
2025-02-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '296753'
                WHERE ordernumber = 'P2502120000351' 
            
2025-02-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455767'
                WHERE ordernumber = 'P2502120000358' 
            
2025-02-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455768'
                WHERE ordernumber = 'P2502120000367' 
            
2025-02-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '180512'
                WHERE ordernumber = 'P2502120000368' 
            
2025-02-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455770'
                WHERE ordernumber = 'P2502120000375' 
            
2025-02-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455774'
                WHERE ordernumber = 'P2502120000388' 
            
2025-02-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455775'
                WHERE ordernumber = 'P2502120000390' 
            
2025-02-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '390648'
                WHERE ordernumber = 'P2502120000391' 
            
2025-02-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455773'
                WHERE ordernumber = 'P2502120000394' 
            
2025-02-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455778'
                WHERE ordernumber = 'P2502120000406' 
            
2025-02-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455778'
                WHERE ordernumber = 'P2502120000407' 
            
2025-02-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455777'
                WHERE ordernumber = 'P2502120000410' 
            
2025-02-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '382512'
                WHERE ordernumber = 'P2502120000411' 
            
2025-02-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '101791'
                WHERE ordernumber = 'P2502120000413' 
            
2025-02-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '435040'
                WHERE ordernumber = 'P2502120000420' 
            
2025-02-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '74778'
                WHERE ordernumber = 'P2502120000424' 
            
2025-02-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '225044'
                WHERE ordernumber = 'P2502120000425' 
            
2025-02-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '311641'
                WHERE ordernumber = 'P2502120000427' 
            
2025-02-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455783'
                WHERE ordernumber = 'P2502120000432' 
            
2025-02-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '389119'
                WHERE ordernumber = 'P2502120000433' 
            
2025-02-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455784'
                WHERE ordernumber = 'P2502120000435' 
            
2025-02-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '287464'
                WHERE ordernumber = 'P2502120000439' 
            
2025-02-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '378390'
                WHERE ordernumber = 'P2502120000440' 
            
2025-02-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '348824'
                WHERE ordernumber = 'P2502120000454' 
            
2025-02-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '212209'
                WHERE ordernumber = 'P2502120000455' 
            
2025-02-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455786'
                WHERE ordernumber = 'P2502120000461' 
            
2025-02-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455787'
                WHERE ordernumber = 'P2502120000462' 
            
2025-02-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426310'
                WHERE ordernumber = 'P2502120000464' 
            
2025-02-13 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455788'
                WHERE ordernumber = 'P2502120000465'