2024-03-12 01:00:02 -- 將會員中心id寫入data-lake
2024-03-12 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-03-11%';
        
2024-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '345721'
                WHERE ordernumber = 'P200311110301903' 
            
2024-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '116117'
                WHERE ordernumber = 'P180311110418931' 
            
2024-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '166311'
                WHERE ordernumber = 'P200311110622726' 
            
2024-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '274998'
                WHERE ordernumber = 'P180311110657443' 
            
2024-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '213779'
                WHERE ordernumber = 'P180311111239375' 
            
2024-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377443'
                WHERE ordernumber = 'P180311111423714' 
            
2024-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '274717'
                WHERE ordernumber = 'P180311111553589' 
            
2024-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381043'
                WHERE ordernumber = 'P180311111713441' 
            
2024-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381040'
                WHERE ordernumber = 'P590311111801673' 
            
2024-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381045'
                WHERE ordernumber = 'P190311111943408' 
            
2024-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381046'
                WHERE ordernumber = 'P420311112637302' 
            
2024-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '375825'
                WHERE ordernumber = 'P180311113056760' 
            
2024-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381048'
                WHERE ordernumber = 'P180311113336677' 
            
2024-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '95915'
                WHERE ordernumber = 'P180311113616739' 
            
2024-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381049'
                WHERE ordernumber = 'P420311114011673' 
            
2024-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99933'
                WHERE ordernumber = 'P200311114148134' 
            
2024-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354202'
                WHERE ordernumber = 'P200311114329681' 
            
2024-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '315066'
                WHERE ordernumber = 'P420311114413240' 
            
2024-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381051'
                WHERE ordernumber = 'P180311114504382' 
            
2024-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '308188'
                WHERE ordernumber = 'P200311114657378' 
            
2024-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '250721'
                WHERE ordernumber = 'P200311114723669' 
            
2024-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381052'
                WHERE ordernumber = 'P180311114926311' 
            
2024-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '111127'
                WHERE ordernumber = 'P190311115133315' 
            
2024-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381050'
                WHERE ordernumber = 'P180311115300650' 
            
2024-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '41785'
                WHERE ordernumber = 'P200311115318439' 
            
2024-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381050'
                WHERE ordernumber = 'P180311115338727' 
            
2024-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381053'
                WHERE ordernumber = 'P190311115445384' 
            
2024-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381054'
                WHERE ordernumber = 'P180311115556342' 
            
2024-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '204136'
                WHERE ordernumber = 'P420311115640395' 
            
2024-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '231698'
                WHERE ordernumber = 'P180311115915935' 
            
2024-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377564'
                WHERE ordernumber = 'P190311115944682' 
            
2024-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377564'
                WHERE ordernumber = 'P190311120014805' 
            
2024-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381055'
                WHERE ordernumber = 'P420311120422163' 
            
2024-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '128516'
                WHERE ordernumber = 'P190311120534975' 
            
2024-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381056'
                WHERE ordernumber = 'P180311120755572' 
            
2024-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381057'
                WHERE ordernumber = 'P420311120822352' 
            
2024-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377422'
                WHERE ordernumber = 'P420311122201829' 
            
2024-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '299101'
                WHERE ordernumber = 'P180311123228643' 
            
2024-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '136987'
                WHERE ordernumber = 'P200311124233533' 
            
2024-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '62142'
                WHERE ordernumber = 'P200311124352220' 
            
2024-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '337891'
                WHERE ordernumber = 'P180311125240711' 
            
2024-03-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '273479'
                WHERE ordernumber = 'P180311125435591' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97446'
                WHERE ordernumber = 'P180311130244937' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P420311130829990' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '330640'
                WHERE ordernumber = 'P420311130929910' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372506'
                WHERE ordernumber = 'P420311131118506' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377419'
                WHERE ordernumber = 'P180311131528203' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310704'
                WHERE ordernumber = 'P200311131705426' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '35165'
                WHERE ordernumber = 'P180311132604262' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381066'
                WHERE ordernumber = 'P200311133910247' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '369779'
                WHERE ordernumber = 'P420311135350566' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357882'
                WHERE ordernumber = 'P180311135504985' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305697'
                WHERE ordernumber = 'P180311141044661' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381071'
                WHERE ordernumber = 'P200311141205657' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381070'
                WHERE ordernumber = 'P180311141223554' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381072'
                WHERE ordernumber = 'P180311141717859' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362318'
                WHERE ordernumber = 'P180311141814930' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381073'
                WHERE ordernumber = 'P420311142405293' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '234780'
                WHERE ordernumber = 'P200311142934120' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271241'
                WHERE ordernumber = 'P200311144128635' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381075'
                WHERE ordernumber = 'P190311144650626' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301837'
                WHERE ordernumber = 'P420311144927444' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381077'
                WHERE ordernumber = 'P180311145746895' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381079'
                WHERE ordernumber = 'P190311150713787' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286332'
                WHERE ordernumber = 'P200311151144927' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381078'
                WHERE ordernumber = 'P180311151656514' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381078'
                WHERE ordernumber = 'P180311151744806' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380538'
                WHERE ordernumber = 'P190311152058677' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381082'
                WHERE ordernumber = 'P180311152121491' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247421'
                WHERE ordernumber = 'P200311152700595' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381084'
                WHERE ordernumber = 'P420311153200456' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381085'
                WHERE ordernumber = 'P420311153405682' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381086'
                WHERE ordernumber = 'P180311154253156' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381087'
                WHERE ordernumber = 'P190311155408578' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '246109'
                WHERE ordernumber = 'P180311155720529' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '90938'
                WHERE ordernumber = 'P200311160041260' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381088'
                WHERE ordernumber = 'P180311160302734' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381089'
                WHERE ordernumber = 'P420311160519878' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '120879'
                WHERE ordernumber = 'P180311160520176' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381090'
                WHERE ordernumber = 'P420311160917953' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230102'
                WHERE ordernumber = 'P180311161214506' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '116366'
                WHERE ordernumber = 'P200311161349408' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '158197'
                WHERE ordernumber = 'P200311161517141' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378711'
                WHERE ordernumber = 'P420311162048660' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P190311162157580' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381094'
                WHERE ordernumber = 'P420311163239761' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381095'
                WHERE ordernumber = 'P180311163252606' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '317681'
                WHERE ordernumber = 'P180311163445946' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245143'
                WHERE ordernumber = 'P200311163535148' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381096'
                WHERE ordernumber = 'P180311163635629' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381098'
                WHERE ordernumber = 'P420311163710964' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381101'
                WHERE ordernumber = 'P590311164208817' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285543'
                WHERE ordernumber = 'P180311165202982' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '168418'
                WHERE ordernumber = 'P200311165452157' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355143'
                WHERE ordernumber = 'P180311165832308' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353039'
                WHERE ordernumber = 'P180311170033289' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347628'
                WHERE ordernumber = 'P180311170223625' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '234882'
                WHERE ordernumber = 'P200311171013318' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '119261'
                WHERE ordernumber = 'P200311171102576' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81933'
                WHERE ordernumber = 'P200311171558440' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286101'
                WHERE ordernumber = 'P190311172231542' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381103'
                WHERE ordernumber = 'P420311172717329' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381105'
                WHERE ordernumber = 'P420311173345565' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381106'
                WHERE ordernumber = 'P200311174002241' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381107'
                WHERE ordernumber = 'P420311174055716' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372218'
                WHERE ordernumber = 'P420311174940326' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381108'
                WHERE ordernumber = 'P180311175738637' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '259419'
                WHERE ordernumber = 'P200311180131733' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '261287'
                WHERE ordernumber = 'P180311180731118' 
            
2024-03-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381109'
                WHERE ordernumber = 'P180311181339705' 
            
2024-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301142'
                WHERE ordernumber = 'P420311181621330' 
            
2024-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381112'
                WHERE ordernumber = 'P420311181819655' 
            
2024-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381111'
                WHERE ordernumber = 'P180311182200693' 
            
2024-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358072'
                WHERE ordernumber = 'P200311182328830' 
            
2024-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381115'
                WHERE ordernumber = 'P180311183115761' 
            
2024-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381116'
                WHERE ordernumber = 'P190311183158991' 
            
2024-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '105688'
                WHERE ordernumber = 'P200311183418706' 
            
2024-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381117'
                WHERE ordernumber = 'P200311184337982' 
            
2024-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342058'
                WHERE ordernumber = 'P200311184632324' 
            
2024-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '241976'
                WHERE ordernumber = 'P190311185408290' 
            
2024-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380749'
                WHERE ordernumber = 'P200311185935679' 
            
2024-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380749'
                WHERE ordernumber = 'P200311190034930' 
            
2024-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354297'
                WHERE ordernumber = 'P190311190532135' 
            
2024-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380953'
                WHERE ordernumber = 'P190311192006307' 
            
2024-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380953'
                WHERE ordernumber = 'P190311192048561' 
            
2024-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381120'
                WHERE ordernumber = 'P190311192302702' 
            
2024-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381121'
                WHERE ordernumber = 'P190311192659236' 
            
2024-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305938'
                WHERE ordernumber = 'P420311192718208' 
            
2024-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381122'
                WHERE ordernumber = 'P190311193536656' 
            
2024-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '95708'
                WHERE ordernumber = 'P190311194226333' 
            
2024-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381124'
                WHERE ordernumber = 'P200311195120256' 
            
2024-03-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380577'
                WHERE ordernumber = 'P200311195757378'