2024-11-06 01:00:02 -- 將會員中心id寫入data-lake
2024-11-06 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-05%';
        
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426083'
                WHERE ordernumber = 'P201105110120929' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429011'
                WHERE ordernumber = 'P421105110446836' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429012'
                WHERE ordernumber = 'P421105111556653' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429014'
                WHERE ordernumber = 'P191105111942763' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '352563'
                WHERE ordernumber = 'P201105112102840' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428155'
                WHERE ordernumber = 'P421105112220366' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '334506'
                WHERE ordernumber = 'P631105113108202' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429016'
                WHERE ordernumber = 'P201105113326876' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '248803'
                WHERE ordernumber = 'P201105113555351' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429017'
                WHERE ordernumber = 'P181105113556533' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429018'
                WHERE ordernumber = 'P201105113751607' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '196012'
                WHERE ordernumber = 'P631105114211254' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420409'
                WHERE ordernumber = 'P181105114457930' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '405514'
                WHERE ordernumber = 'P181105114923956' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '383919'
                WHERE ordernumber = 'P421105115504209' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '276855'
                WHERE ordernumber = 'P201105115937738' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348897'
                WHERE ordernumber = 'P181105115940686' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429020'
                WHERE ordernumber = 'P201105120559805' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429021'
                WHERE ordernumber = 'P181105121156758' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429022'
                WHERE ordernumber = 'P181105122303925' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429023'
                WHERE ordernumber = 'P181105122739763' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428429'
                WHERE ordernumber = 'P201105124229600' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429024'
                WHERE ordernumber = 'P421105124527217' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429025'
                WHERE ordernumber = 'P181105124536383' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429026'
                WHERE ordernumber = 'P181105125309149' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429027'
                WHERE ordernumber = 'P181105125450762' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429028'
                WHERE ordernumber = 'P181105130339664' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429033'
                WHERE ordernumber = 'P181105130832308' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429032'
                WHERE ordernumber = 'P181105131032655' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429036'
                WHERE ordernumber = 'P181105133216643' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429035'
                WHERE ordernumber = 'P421105133254938' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100490'
                WHERE ordernumber = 'P201105133514812' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '343585'
                WHERE ordernumber = 'P181105133715944' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380354'
                WHERE ordernumber = 'P421105133933156' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387893'
                WHERE ordernumber = 'P201105134426411' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429039'
                WHERE ordernumber = 'P421105134450568' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429040'
                WHERE ordernumber = 'P421105134514740' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '143087'
                WHERE ordernumber = 'P201105134853230' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380636'
                WHERE ordernumber = 'P181105134935395' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '347683'
                WHERE ordernumber = 'P201105135234190' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '340743'
                WHERE ordernumber = 'P421105140248857' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '129975'
                WHERE ordernumber = 'P181105140747940' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '160711'
                WHERE ordernumber = 'P201105142008256' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429044'
                WHERE ordernumber = 'P181105142041187' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429045'
                WHERE ordernumber = 'P771105142823913' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429048'
                WHERE ordernumber = 'P181105143343162' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429049'
                WHERE ordernumber = 'P421105143642652' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429050'
                WHERE ordernumber = 'P201105144304172' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429051'
                WHERE ordernumber = 'P181105144924352' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429050'
                WHERE ordernumber = 'P201105144932367' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429053'
                WHERE ordernumber = 'P771105150134302' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '164870'
                WHERE ordernumber = 'P201105151235441' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385841'
                WHERE ordernumber = 'P201105151707508' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '224784'
                WHERE ordernumber = 'P181105152020404' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429054'
                WHERE ordernumber = 'P201105152308959' 
            
2024-11-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '224784'
                WHERE ordernumber = 'P181105152352970' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429056'
                WHERE ordernumber = 'P181105152658705' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427132'
                WHERE ordernumber = 'P421105152814318' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429057'
                WHERE ordernumber = 'P201105152834732' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368735'
                WHERE ordernumber = 'P181105152845620' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237348'
                WHERE ordernumber = 'P181105153004723' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429058'
                WHERE ordernumber = 'P421105153642346' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398583'
                WHERE ordernumber = 'P181105153847285' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384374'
                WHERE ordernumber = 'P181105154102313' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396061'
                WHERE ordernumber = 'P201105154337800' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348897'
                WHERE ordernumber = 'P181105154344362' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429059'
                WHERE ordernumber = 'P421105154535851' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429060'
                WHERE ordernumber = 'P201105155022213' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380265'
                WHERE ordernumber = 'P201105155213629' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '269846'
                WHERE ordernumber = 'P181105155236157' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429062'
                WHERE ordernumber = 'P201105155539783' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429061'
                WHERE ordernumber = 'P181105155624552' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429063'
                WHERE ordernumber = 'P181105160135735' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282261'
                WHERE ordernumber = 'P201105160556273' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429064'
                WHERE ordernumber = 'P201105160737230' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392414'
                WHERE ordernumber = 'P181105160804506' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276096'
                WHERE ordernumber = 'P201105161246805' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429067'
                WHERE ordernumber = 'P421105161722407' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429068'
                WHERE ordernumber = 'P181105161911386' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429070'
                WHERE ordernumber = 'P201105162208955' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285900'
                WHERE ordernumber = 'P181105162235964' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '128709'
                WHERE ordernumber = 'P421105162326599' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422693'
                WHERE ordernumber = 'P421105162617980' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429071'
                WHERE ordernumber = 'P181105163228440' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397025'
                WHERE ordernumber = 'P421105163410323' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351596'
                WHERE ordernumber = 'P421105163556448' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429073'
                WHERE ordernumber = 'P201105163602433' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429070'
                WHERE ordernumber = 'P201105163748754' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429069'
                WHERE ordernumber = 'P421105163920337' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429075'
                WHERE ordernumber = 'P181105164553194' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '121498'
                WHERE ordernumber = 'P201105164838989' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102949'
                WHERE ordernumber = 'P771105164944202' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429077'
                WHERE ordernumber = 'P771105165428316' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429078'
                WHERE ordernumber = 'P421105165739207' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429080'
                WHERE ordernumber = 'P181105170149517' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429081'
                WHERE ordernumber = 'P181105170250795' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429076'
                WHERE ordernumber = 'P181105170505673' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429084'
                WHERE ordernumber = 'P201105170755471' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291477'
                WHERE ordernumber = 'P771105171519253' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429083'
                WHERE ordernumber = 'P181105171720675' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97199'
                WHERE ordernumber = 'P201105172323209' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429085'
                WHERE ordernumber = 'P181105172829698' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '316700'
                WHERE ordernumber = 'P181105172937497' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275019'
                WHERE ordernumber = 'P181105174003834' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396154'
                WHERE ordernumber = 'P201105174113352' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429087'
                WHERE ordernumber = 'P181105174328813' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400167'
                WHERE ordernumber = 'P181105175257982' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '316470'
                WHERE ordernumber = 'P181105175547942' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358469'
                WHERE ordernumber = 'P201105175703721' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '178774'
                WHERE ordernumber = 'P421105175804247' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429090'
                WHERE ordernumber = 'P591105180050795' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429091'
                WHERE ordernumber = 'P181105180103980' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417397'
                WHERE ordernumber = 'P201105180133331' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429092'
                WHERE ordernumber = 'P181105180450889' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429094'
                WHERE ordernumber = 'P421105180705596' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429093'
                WHERE ordernumber = 'P771105180710114' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '122253'
                WHERE ordernumber = 'P181105181523911' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429095'
                WHERE ordernumber = 'P201105182016316' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429097'
                WHERE ordernumber = 'P201105182304937' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429096'
                WHERE ordernumber = 'P181105182648758' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '290320'
                WHERE ordernumber = 'P201105183043953' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385896'
                WHERE ordernumber = 'P201105183305466' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429099'
                WHERE ordernumber = 'P771105183419393' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429101'
                WHERE ordernumber = 'P421105183449392' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429102'
                WHERE ordernumber = 'P421105183540791' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429103'
                WHERE ordernumber = 'P201105183757237' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429100'
                WHERE ordernumber = 'P771105183912112' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298026'
                WHERE ordernumber = 'P421105184529426' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '246956'
                WHERE ordernumber = 'P201105184720175' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429105'
                WHERE ordernumber = 'P771105184957501' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429104'
                WHERE ordernumber = 'P421105185036538' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429106'
                WHERE ordernumber = 'P191105185146216' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342845'
                WHERE ordernumber = 'P191105185820381' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429107'
                WHERE ordernumber = 'P191105190242973' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425065'
                WHERE ordernumber = 'P201105190532258' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347364'
                WHERE ordernumber = 'P191105191458703' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429108'
                WHERE ordernumber = 'P771105191805196' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429109'
                WHERE ordernumber = 'P191105192107986' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '85510'
                WHERE ordernumber = 'P191105192521575' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235646'
                WHERE ordernumber = 'P201105192727285' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429110'
                WHERE ordernumber = 'P191105193122712' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352298'
                WHERE ordernumber = 'P191105193422592' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384089'
                WHERE ordernumber = 'P201105194640136' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385092'
                WHERE ordernumber = 'P191105194847412' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384089'
                WHERE ordernumber = 'P201105194929808' 
            
2024-11-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429116'
                WHERE ordernumber = 'P771105213110455'