2024-04-11 01:00:03 -- 將會員中心id寫入data-lake
2024-04-11 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-04-10%';
        
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '361342'
                WHERE ordernumber = 'P630410102111172' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '159220'
                WHERE ordernumber = 'P200410110317736' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385026'
                WHERE ordernumber = 'P180410110416355' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359064'
                WHERE ordernumber = 'P200410111711246' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385027'
                WHERE ordernumber = 'P200410112155253' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94266'
                WHERE ordernumber = 'P200410112400784' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350218'
                WHERE ordernumber = 'P180410112808687' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378213'
                WHERE ordernumber = 'P200410113006747' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '156520'
                WHERE ordernumber = 'P200410113356998' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385028'
                WHERE ordernumber = 'P180410113540478' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '158535'
                WHERE ordernumber = 'P200410114047555' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '375005'
                WHERE ordernumber = 'P180410114223504' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '375005'
                WHERE ordernumber = 'P180410114313394' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P190410114823148' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385031'
                WHERE ordernumber = 'P180410115538686' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385032'
                WHERE ordernumber = 'P200410115639697' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385033'
                WHERE ordernumber = 'P200410120501708' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235164'
                WHERE ordernumber = 'P200410120628441' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '109704'
                WHERE ordernumber = 'P180410120718943' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378330'
                WHERE ordernumber = 'P420410120837130' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309133'
                WHERE ordernumber = 'P200410121103580' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385037'
                WHERE ordernumber = 'P420410121946536' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385036'
                WHERE ordernumber = 'P200410122201977' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378301'
                WHERE ordernumber = 'P420410122812812' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349278'
                WHERE ordernumber = 'P200410125158635' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '253697'
                WHERE ordernumber = 'P200410125613393' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '293682'
                WHERE ordernumber = 'P590410125946763' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238442'
                WHERE ordernumber = 'P200410130200998' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385040'
                WHERE ordernumber = 'P200410131329323' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385040'
                WHERE ordernumber = 'P200410132120458' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385041'
                WHERE ordernumber = 'P180410132249398' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385042'
                WHERE ordernumber = 'P180410132610676' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385043'
                WHERE ordernumber = 'P180410133134334' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385044'
                WHERE ordernumber = 'P180410133252631' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385045'
                WHERE ordernumber = 'P180410133534526' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383309'
                WHERE ordernumber = 'P180410133737467' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385046'
                WHERE ordernumber = 'P180410133943740' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385047'
                WHERE ordernumber = 'P190410134015590' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385048'
                WHERE ordernumber = 'P180410134218538' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '290405'
                WHERE ordernumber = 'P180410134741808' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '127024'
                WHERE ordernumber = 'P180410135215853' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385050'
                WHERE ordernumber = 'P180410140049113' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381267'
                WHERE ordernumber = 'P420410140311251' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160114'
                WHERE ordernumber = 'P180410140556375' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354541'
                WHERE ordernumber = 'P180410140752813' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '220663'
                WHERE ordernumber = 'P180410141214279' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '333437'
                WHERE ordernumber = 'P200410141907381' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385054'
                WHERE ordernumber = 'P200410142330969' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '327941'
                WHERE ordernumber = 'P180410142432879' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '62067'
                WHERE ordernumber = 'P200410142515988' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '320024'
                WHERE ordernumber = 'P180410142719315' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385055'
                WHERE ordernumber = 'P200410142742528' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378198'
                WHERE ordernumber = 'P180410142952563' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385056'
                WHERE ordernumber = 'P180410143625492' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367983'
                WHERE ordernumber = 'P420410143827881' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228555'
                WHERE ordernumber = 'P180410144309411' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304141'
                WHERE ordernumber = 'P200410144812397' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385057'
                WHERE ordernumber = 'P420410145439864' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '311214'
                WHERE ordernumber = 'P200410145933272' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '140470'
                WHERE ordernumber = 'P180410145946927' 
            
2024-04-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385058'
                WHERE ordernumber = 'P420410150650624' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385059'
                WHERE ordernumber = 'P180410150745131' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385060'
                WHERE ordernumber = 'P180410151216773' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '271302'
                WHERE ordernumber = 'P200410151725287' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385062'
                WHERE ordernumber = 'P200410151847404' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353647'
                WHERE ordernumber = 'P180410152103941' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '241971'
                WHERE ordernumber = 'P180410152300115' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385065'
                WHERE ordernumber = 'P180410153449351' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385066'
                WHERE ordernumber = 'P180410154054204' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385067'
                WHERE ordernumber = 'P180410154258674' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385069'
                WHERE ordernumber = 'P630410154755910' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385071'
                WHERE ordernumber = 'P420410155132695' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385073'
                WHERE ordernumber = 'P200410155149397' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385072'
                WHERE ordernumber = 'P630410155211165' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '115459'
                WHERE ordernumber = 'P200410160329609' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378490'
                WHERE ordernumber = 'P180410160622945' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385074'
                WHERE ordernumber = 'P180410160751987' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '105699'
                WHERE ordernumber = 'P200410161950259' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385078'
                WHERE ordernumber = 'P180410162704428' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385079'
                WHERE ordernumber = 'P190410162743759' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237882'
                WHERE ordernumber = 'P200410163606969' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '66860'
                WHERE ordernumber = 'P180410163754491' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385083'
                WHERE ordernumber = 'P200410163808312' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356231'
                WHERE ordernumber = 'P180410164004146' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385084'
                WHERE ordernumber = 'P190410164007631' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '122650'
                WHERE ordernumber = 'P180410164446809' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381928'
                WHERE ordernumber = 'P420410164712396' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '63906'
                WHERE ordernumber = 'P200410165137673' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385082'
                WHERE ordernumber = 'P190410165430858' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275063'
                WHERE ordernumber = 'P200410170613127' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385070'
                WHERE ordernumber = 'P180410170746749' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '365728'
                WHERE ordernumber = 'P190410170800593' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385086'
                WHERE ordernumber = 'P180410170938488' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385087'
                WHERE ordernumber = 'P420410171510245' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313481'
                WHERE ordernumber = 'P180410172649666' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '204136'
                WHERE ordernumber = 'P200410173225894' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385090'
                WHERE ordernumber = 'P180410173630314' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '117540'
                WHERE ordernumber = 'P420410174250178' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381675'
                WHERE ordernumber = 'P420410174910800' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340529'
                WHERE ordernumber = 'P200410175206948' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '235621'
                WHERE ordernumber = 'P200410175519190' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385091'
                WHERE ordernumber = 'P420410175702418' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '235465'
                WHERE ordernumber = 'P420410180053149' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '92400'
                WHERE ordernumber = 'P180410180611209' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98426'
                WHERE ordernumber = 'P200410180643450' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302949'
                WHERE ordernumber = 'P420410180917191' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '118593'
                WHERE ordernumber = 'P180410181748429' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '242889'
                WHERE ordernumber = 'P190410182950647' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385096'
                WHERE ordernumber = 'P190410183343269' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353647'
                WHERE ordernumber = 'P190410183753931' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '260675'
                WHERE ordernumber = 'P200410184034446' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385097'
                WHERE ordernumber = 'P190410184148366' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385096'
                WHERE ordernumber = 'P190410184229413' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236942'
                WHERE ordernumber = 'P190410184418945' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359274'
                WHERE ordernumber = 'P190410184515294' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380385'
                WHERE ordernumber = 'P200410184708327' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385098'
                WHERE ordernumber = 'P200410184808274' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '363438'
                WHERE ordernumber = 'P200410185011662' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '227447'
                WHERE ordernumber = 'P420410190105158' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385099'
                WHERE ordernumber = 'P200410192600864' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '112218'
                WHERE ordernumber = 'P190410192806762' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383246'
                WHERE ordernumber = 'P190410193041565' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304141'
                WHERE ordernumber = 'P200410193120844' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '157000'
                WHERE ordernumber = 'P190410193443407' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304422'
                WHERE ordernumber = 'P200410194211650' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385100'
                WHERE ordernumber = 'P190410194310750' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '267619'
                WHERE ordernumber = 'P200410194411926' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '327990'
                WHERE ordernumber = 'P190410194449862' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385102'
                WHERE ordernumber = 'P190410194626759' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385103'
                WHERE ordernumber = 'P420410194641634' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385105'
                WHERE ordernumber = 'P420410195754309' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385107'
                WHERE ordernumber = 'P630410202232477' 
            
2024-04-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '363441'
                WHERE ordernumber = 'P630410205953575'