2024-03-26 01:00:03 -- 將會員中心id寫入data-lake
2024-03-26 01:00:03 -- 
            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-03-25%';
        
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103190'
                WHERE ordernumber = 'P190325110313428' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383053'
                WHERE ordernumber = 'P200325110349625' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302040'
                WHERE ordernumber = 'P190325110439328' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '333377'
                WHERE ordernumber = 'P200325110734396' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383042'
                WHERE ordernumber = 'P190325110903275' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383052'
                WHERE ordernumber = 'P590325110906930' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383054'
                WHERE ordernumber = 'P200325111144112' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '270147'
                WHERE ordernumber = 'P200325111238512' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '257964'
                WHERE ordernumber = 'P200325111453912' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383056'
                WHERE ordernumber = 'P200325111847616' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383055'
                WHERE ordernumber = 'P180325111847771' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98812'
                WHERE ordernumber = 'P200325112311518' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383058'
                WHERE ordernumber = 'P180325112539313' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97842'
                WHERE ordernumber = 'P180325112911295' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '231680'
                WHERE ordernumber = 'P180325113024362' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339631'
                WHERE ordernumber = 'P200325113025936' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '203688'
                WHERE ordernumber = 'P420325113121939' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383059'
                WHERE ordernumber = 'P200325113421621' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383061'
                WHERE ordernumber = 'P590325114849712' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382747'
                WHERE ordernumber = 'P180325114900858' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103788'
                WHERE ordernumber = 'P180325115052882' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383062'
                WHERE ordernumber = 'P180325115214990' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340676'
                WHERE ordernumber = 'P180325115802440' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98922'
                WHERE ordernumber = 'P200325120100178' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180325120500975' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277595'
                WHERE ordernumber = 'P420325120702467' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '104521'
                WHERE ordernumber = 'P200325122728892' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383069'
                WHERE ordernumber = 'P180325123153563' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100465'
                WHERE ordernumber = 'P420325123343850' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383070'
                WHERE ordernumber = 'P420325123602660' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383071'
                WHERE ordernumber = 'P180325123703390' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '296811'
                WHERE ordernumber = 'P420325123739826' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343958'
                WHERE ordernumber = 'P420325124459822' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103285'
                WHERE ordernumber = 'P180325124558131' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357082'
                WHERE ordernumber = 'P180325124652223' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380839'
                WHERE ordernumber = 'P200325124746253' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '336612'
                WHERE ordernumber = 'P200325130831943' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '317859'
                WHERE ordernumber = 'P200325131524316' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '167097'
                WHERE ordernumber = 'P200325131835803' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380031'
                WHERE ordernumber = 'P200325132135126' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383076'
                WHERE ordernumber = 'P420325132731994' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '141900'
                WHERE ordernumber = 'P420325132959604' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '242927'
                WHERE ordernumber = 'P180325133553426' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '101291'
                WHERE ordernumber = 'P420325133746642' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '375884'
                WHERE ordernumber = 'P180325134038181' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383079'
                WHERE ordernumber = 'P190325135003297' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383080'
                WHERE ordernumber = 'P420325135109910' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '267354'
                WHERE ordernumber = 'P420325135542487' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383081'
                WHERE ordernumber = 'P190325140026341' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '248970'
                WHERE ordernumber = 'P200325140143482' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357618'
                WHERE ordernumber = 'P180325141432440' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343585'
                WHERE ordernumber = 'P180325142126407' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230531'
                WHERE ordernumber = 'P190325142836620' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383085'
                WHERE ordernumber = 'P180325143604829' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383086'
                WHERE ordernumber = 'P180325143809314' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383087'
                WHERE ordernumber = 'P200325144029207' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383088'
                WHERE ordernumber = 'P200325144319291' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102595'
                WHERE ordernumber = 'P200325144405460' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382824'
                WHERE ordernumber = 'P180325144420149' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383091'
                WHERE ordernumber = 'P180325145239862' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245281'
                WHERE ordernumber = 'P200325150619709' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383092'
                WHERE ordernumber = 'P200325150722465' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383093'
                WHERE ordernumber = 'P190325151232607' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299928'
                WHERE ordernumber = 'P200325151322224' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383095'
                WHERE ordernumber = 'P180325151737879' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383097'
                WHERE ordernumber = 'P420325152323200' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383095'
                WHERE ordernumber = 'P190325152507642' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97539'
                WHERE ordernumber = 'P590325152544604' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345768'
                WHERE ordernumber = 'P180325152806119' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '235050'
                WHERE ordernumber = 'P180325153000412' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '229781'
                WHERE ordernumber = 'P200325153041429' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '293407'
                WHERE ordernumber = 'P180325153734464' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '270393'
                WHERE ordernumber = 'P180325153938326' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '235839'
                WHERE ordernumber = 'P200325155950489' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '101636'
                WHERE ordernumber = 'P180325160216531' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '65316'
                WHERE ordernumber = 'P200325160859321' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '113502'
                WHERE ordernumber = 'P180325161222959' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383099'
                WHERE ordernumber = 'P190325161259783' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383100'
                WHERE ordernumber = 'P180325161733908' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383102'
                WHERE ordernumber = 'P420325163008265' 
            
2024-03-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304572'
                WHERE ordernumber = 'P420325163503238' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '380585'
                WHERE ordernumber = 'P180325163749384' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383104'
                WHERE ordernumber = 'P420325164247872' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '378365'
                WHERE ordernumber = 'P420325164701769' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383106'
                WHERE ordernumber = 'P180325165418846' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366271'
                WHERE ordernumber = 'P200325170030298' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '259307'
                WHERE ordernumber = 'P180325170142561' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383108'
                WHERE ordernumber = 'P200325170444753' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '311758'
                WHERE ordernumber = 'P180325170908781' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '116784'
                WHERE ordernumber = 'P180325171042459' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383109'
                WHERE ordernumber = 'P180325171223350' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383110'
                WHERE ordernumber = 'P420325172754896' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377505'
                WHERE ordernumber = 'P200325173422622' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '91003'
                WHERE ordernumber = 'P180325174237554' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '280157'
                WHERE ordernumber = 'P200325174352725' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '298635'
                WHERE ordernumber = 'P180325174559575' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383112'
                WHERE ordernumber = 'P420325175224161' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383113'
                WHERE ordernumber = 'P180325175234430' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381887'
                WHERE ordernumber = 'P180325175706771' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383114'
                WHERE ordernumber = 'P420325175732171' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '279668'
                WHERE ordernumber = 'P190325180459637' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383115'
                WHERE ordernumber = 'P180325180535786' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383116'
                WHERE ordernumber = 'P190325180607529' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '248215'
                WHERE ordernumber = 'P200325180730836' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '241196'
                WHERE ordernumber = 'P190325180733242' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '87785'
                WHERE ordernumber = 'P200325180908896' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '279017'
                WHERE ordernumber = 'P190325180942169' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '293682'
                WHERE ordernumber = 'P200325181150239' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '286820'
                WHERE ordernumber = 'P200325181246261' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '215272'
                WHERE ordernumber = 'P180325181937747' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '288433'
                WHERE ordernumber = 'P200325182046171' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '339556'
                WHERE ordernumber = 'P200325182337134' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383118'
                WHERE ordernumber = 'P180325183016578' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352817'
                WHERE ordernumber = 'P420325183048744' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383119'
                WHERE ordernumber = 'P420325183207998' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '253760'
                WHERE ordernumber = 'P180325184256894' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '135178'
                WHERE ordernumber = 'P200325184741320' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '252809'
                WHERE ordernumber = 'P190325184849859' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '228942'
                WHERE ordernumber = 'P190325185444550' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383121'
                WHERE ordernumber = 'P420325185743412' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383120'
                WHERE ordernumber = 'P590325185922936' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383122'
                WHERE ordernumber = 'P190325190524643' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '223446'
                WHERE ordernumber = 'P190325191223424' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '226140'
                WHERE ordernumber = 'P200325191313405' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '254651'
                WHERE ordernumber = 'P190325191800528' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '105194'
                WHERE ordernumber = 'P190325192020888' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '380695'
                WHERE ordernumber = 'P420325193018453' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383125'
                WHERE ordernumber = 'P190325193303587' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '98852'
                WHERE ordernumber = 'P190325193544783' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383126'
                WHERE ordernumber = 'P420325193627197' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383127'
                WHERE ordernumber = 'P420325193946520' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '159425'
                WHERE ordernumber = 'P200325194131662' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383129'
                WHERE ordernumber = 'P190325194230571' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '211065'
                WHERE ordernumber = 'P200325194313154' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383130'
                WHERE ordernumber = 'P200325194655440' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '235839'
                WHERE ordernumber = 'P200325195159459' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '371644'
                WHERE ordernumber = 'P190325195217583' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '329340'
                WHERE ordernumber = 'P200325195246493' 
            
2024-03-26 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383131'
                WHERE ordernumber = 'P190325195559215'