2024-12-03 01:00:01 -- 將會員中心id寫入data-lake
2024-12-03 01:00:01 -- 
            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-02%';
        
2024-12-03 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '256568'
                WHERE ordernumber = 'P2412020000229' 
            
2024-12-03 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '328345'
                WHERE ordernumber = 'P2412020000349' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432770'
                WHERE ordernumber = 'P2412020000543' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432779'
                WHERE ordernumber = 'P2412020000619' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '73683'
                WHERE ordernumber = 'P2412020000750' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432770'
                WHERE ordernumber = 'P2412020000945' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '345125'
                WHERE ordernumber = 'P2412020001083' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '218840'
                WHERE ordernumber = 'P2412020001387' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '400719'
                WHERE ordernumber = 'P2412020001478' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '105426'
                WHERE ordernumber = 'P2412020001673' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '163979'
                WHERE ordernumber = 'P2412020001767' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432783'
                WHERE ordernumber = 'P2412020001995' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '228868'
                WHERE ordernumber = 'P2412020002238' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432785'
                WHERE ordernumber = 'P2412020002571' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '341040'
                WHERE ordernumber = 'P2412020002772' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '86200'
                WHERE ordernumber = 'P2412020003081' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432786'
                WHERE ordernumber = 'P2412020003245' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389788'
                WHERE ordernumber = 'P2412020003343' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '363024'
                WHERE ordernumber = 'P2412020003640' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '86304'
                WHERE ordernumber = 'P2412020003725' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '290339'
                WHERE ordernumber = 'P2412020003847' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430326'
                WHERE ordernumber = 'P2412020003922' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432795'
                WHERE ordernumber = 'P2412020004127' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432796'
                WHERE ordernumber = 'P2412020004259' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287296'
                WHERE ordernumber = 'P2412020004392' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432798'
                WHERE ordernumber = 'P2412020004418' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432801'
                WHERE ordernumber = 'P2412020004868' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432800'
                WHERE ordernumber = 'P2412020004922' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432802'
                WHERE ordernumber = 'P2412020005067' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432804'
                WHERE ordernumber = 'P2412020005170' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '296904'
                WHERE ordernumber = 'P2412020005559' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432810'
                WHERE ordernumber = 'P2412020005613' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113370'
                WHERE ordernumber = 'P2412020005714' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '105536'
                WHERE ordernumber = 'P2412020005865' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432812'
                WHERE ordernumber = 'P2412020005999' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428577'
                WHERE ordernumber = 'P2412020006124' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432814'
                WHERE ordernumber = 'P2412020006380' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432815'
                WHERE ordernumber = 'P2412020006425' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432816'
                WHERE ordernumber = 'P2412020006659' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432817'
                WHERE ordernumber = 'P2412020006792' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407550'
                WHERE ordernumber = 'P2412020006890' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432818'
                WHERE ordernumber = 'P2412020006913' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432819'
                WHERE ordernumber = 'P2412020007053' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '347860'
                WHERE ordernumber = 'P2412020007110' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '329389'
                WHERE ordernumber = 'P2412020007287' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P2412020007884' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430752'
                WHERE ordernumber = 'P2412020008071' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '365159'
                WHERE ordernumber = 'P2412020008141' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432826'
                WHERE ordernumber = 'P2412020008231' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432831'
                WHERE ordernumber = 'P2412020008330' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '331846'
                WHERE ordernumber = 'P2412020008441' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '277731'
                WHERE ordernumber = 'P2412020008543' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407516'
                WHERE ordernumber = 'P2412020008655' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432832'
                WHERE ordernumber = 'P2412020008751' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '285488'
                WHERE ordernumber = 'P2412020008897' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424068'
                WHERE ordernumber = 'P2412020008960' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '251728'
                WHERE ordernumber = 'P2412020009148' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431023'
                WHERE ordernumber = 'P2412020009441' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432835'
                WHERE ordernumber = 'P2412020009589' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432834'
                WHERE ordernumber = 'P2412020009658' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '117540'
                WHERE ordernumber = 'P2412020009838' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396176'
                WHERE ordernumber = 'P2412020009996' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '224516'
                WHERE ordernumber = 'P2412020010037' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394199'
                WHERE ordernumber = 'P2412020010280' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432841'
                WHERE ordernumber = 'P2412020010330' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432842'
                WHERE ordernumber = 'P2412020010644' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432843'
                WHERE ordernumber = 'P2412020010838' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429505'
                WHERE ordernumber = 'P2412020011174' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '305138'
                WHERE ordernumber = 'P2412020011226' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '224624'
                WHERE ordernumber = 'P2412020011372' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432845'
                WHERE ordernumber = 'P2412020011446' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '233817'
                WHERE ordernumber = 'P2412020011681' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '223485'
                WHERE ordernumber = 'P2412020011857' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388031'
                WHERE ordernumber = 'P2412020011932' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432848'
                WHERE ordernumber = 'P2412020012024' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348922'
                WHERE ordernumber = 'P2412020012264' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432849'
                WHERE ordernumber = 'P2412020012342' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '305084'
                WHERE ordernumber = 'P2412020012650' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432852'
                WHERE ordernumber = 'P2412020013073' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '336063'
                WHERE ordernumber = 'P2412020013149' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '325003'
                WHERE ordernumber = 'P2412020013451' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381164'
                WHERE ordernumber = 'P2412020013982' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '294456'
                WHERE ordernumber = 'P2412020014312' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '346854'
                WHERE ordernumber = 'P2412020014624' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '279371'
                WHERE ordernumber = 'P2412020014896' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431097'
                WHERE ordernumber = 'P2412020014927' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432856'
                WHERE ordernumber = 'P2412020015051' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392379'
                WHERE ordernumber = 'P2412020015179' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '121498'
                WHERE ordernumber = 'P2412020015331' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432857'
                WHERE ordernumber = 'P2412020015488' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432858'
                WHERE ordernumber = 'P2412020015834' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '296403'
                WHERE ordernumber = 'P2412020015918' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432858'
                WHERE ordernumber = 'P2412020016088' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '315315'
                WHERE ordernumber = 'P2412020016334' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '111127'
                WHERE ordernumber = 'P2412020016431' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '237035'
                WHERE ordernumber = 'P2412020016653' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371977'
                WHERE ordernumber = 'P2412020016797' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432864'
                WHERE ordernumber = 'P2412020016919' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432863'
                WHERE ordernumber = 'P2412020017473' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '320706'
                WHERE ordernumber = 'P2412020017525' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '202180'
                WHERE ordernumber = 'P2412020018094' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '239817'
                WHERE ordernumber = 'P2412020018199' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '335111'
                WHERE ordernumber = 'P2412020018273' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '130976'
                WHERE ordernumber = 'P2412020018386' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432867'
                WHERE ordernumber = 'P2412020018487' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348798'
                WHERE ordernumber = 'P2412020018627' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432868'
                WHERE ordernumber = 'P2412020018758' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432869'
                WHERE ordernumber = 'P2412020018834' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '313481'
                WHERE ordernumber = 'P2412020018981' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432871'
                WHERE ordernumber = 'P2412020019054' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432873'
                WHERE ordernumber = 'P2412020019353' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432875'
                WHERE ordernumber = 'P2412020019695' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432876'
                WHERE ordernumber = 'P2412020019717' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '232294'
                WHERE ordernumber = 'P2412020019819' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '297072'
                WHERE ordernumber = 'P2412020020073' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430231'
                WHERE ordernumber = 'P2412020020498' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432879'
                WHERE ordernumber = 'P2412020020895' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391040'
                WHERE ordernumber = 'P2412020020926' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432881'
                WHERE ordernumber = 'P2412020021021' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283083'
                WHERE ordernumber = 'P2412020021262' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '315087'
                WHERE ordernumber = 'P2412020021337' 
            
2024-12-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432254'
                WHERE ordernumber = 'P2412020021420' 
            
2024-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432884'
                WHERE ordernumber = 'P2412020021519' 
            
2024-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432885'
                WHERE ordernumber = 'P2412020021677' 
            
2024-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432885'
                WHERE ordernumber = 'P2412020021795' 
            
2024-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385156'
                WHERE ordernumber = 'P2412020021824' 
            
2024-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240424'
                WHERE ordernumber = 'P2412020022038' 
            
2024-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94538'
                WHERE ordernumber = 'P2412020022348' 
            
2024-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102656'
                WHERE ordernumber = 'P2412020022532' 
            
2024-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242135'
                WHERE ordernumber = 'P2412020022922' 
            
2024-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415043'
                WHERE ordernumber = 'P2412020023152' 
            
2024-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81074'
                WHERE ordernumber = 'P2412020023624' 
            
2024-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247243'
                WHERE ordernumber = 'P2412020023749' 
            
2024-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239827'
                WHERE ordernumber = 'P2412020024038' 
            
2024-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366373'
                WHERE ordernumber = 'P2412020024175' 
            
2024-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '128798'
                WHERE ordernumber = 'P2412020024222' 
            
2024-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432887'
                WHERE ordernumber = 'P2412020024386' 
            
2024-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '258843'
                WHERE ordernumber = 'P2412020024435' 
            
2024-12-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386512'
                WHERE ordernumber = 'P2412020024647'