2024-03-02 01:00:02 -- 將會員中心id寫入data-lake
2024-03-02 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-01%';
        
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '265324'
                WHERE ordernumber = 'P200301110351300' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '95220'
                WHERE ordernumber = 'P200301110445275' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306877'
                WHERE ordernumber = 'P200301110811112' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245387'
                WHERE ordernumber = 'P190301110813647' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '258068'
                WHERE ordernumber = 'P420301111940437' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379570'
                WHERE ordernumber = 'P180301112129608' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334039'
                WHERE ordernumber = 'P180301112316757' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334039'
                WHERE ordernumber = 'P180301112439614' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379408'
                WHERE ordernumber = 'P180301112742627' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379567'
                WHERE ordernumber = 'P180301113814556' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379572'
                WHERE ordernumber = 'P420301114244732' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379573'
                WHERE ordernumber = 'P420301115327805' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96032'
                WHERE ordernumber = 'P180301120414256' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '141742'
                WHERE ordernumber = 'P180301120730667' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '111419'
                WHERE ordernumber = 'P180301120957682' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304183'
                WHERE ordernumber = 'P180301121259514' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '48705'
                WHERE ordernumber = 'P180301121401556' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379574'
                WHERE ordernumber = 'P200301121905685' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298788'
                WHERE ordernumber = 'P180301122048685' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286110'
                WHERE ordernumber = 'P180301122441773' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '269286'
                WHERE ordernumber = 'P420301122751746' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379577'
                WHERE ordernumber = 'P180301122853498' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '272118'
                WHERE ordernumber = 'P180301123120400' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348545'
                WHERE ordernumber = 'P420301123307820' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379578'
                WHERE ordernumber = 'P180301123307594' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379579'
                WHERE ordernumber = 'P180301123652686' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379580'
                WHERE ordernumber = 'P200301123743727' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379581'
                WHERE ordernumber = 'P180301124421317' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379561'
                WHERE ordernumber = 'P200301124835685' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379582'
                WHERE ordernumber = 'P420301125012715' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '244025'
                WHERE ordernumber = 'P180301125524281' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379584'
                WHERE ordernumber = 'P180301125659632' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379585'
                WHERE ordernumber = 'P420301125926409' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379586'
                WHERE ordernumber = 'P180301130046130' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379583'
                WHERE ordernumber = 'P590301130136286' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99638'
                WHERE ordernumber = 'P180301130345945' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379587'
                WHERE ordernumber = 'P180301130625953' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379588'
                WHERE ordernumber = 'P200301130653355' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379589'
                WHERE ordernumber = 'P200301130753516' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379590'
                WHERE ordernumber = 'P180301131433274' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238458'
                WHERE ordernumber = 'P200301132323147' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180301132555888' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81603'
                WHERE ordernumber = 'P180301132800544' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379591'
                WHERE ordernumber = 'P200301132807915' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379594'
                WHERE ordernumber = 'P180301134437425' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379595'
                WHERE ordernumber = 'P180301134719405' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379596'
                WHERE ordernumber = 'P420301134823609' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379597'
                WHERE ordernumber = 'P180301134914716' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '262069'
                WHERE ordernumber = 'P180301135357612' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96014'
                WHERE ordernumber = 'P180301135612175' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '259831'
                WHERE ordernumber = 'P420301135615708' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '259831'
                WHERE ordernumber = 'P420301135720666' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309969'
                WHERE ordernumber = 'P200301135808187' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337264'
                WHERE ordernumber = 'P180301140349782' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '317268'
                WHERE ordernumber = 'P420301141506933' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '221802'
                WHERE ordernumber = 'P190301142252123' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '319549'
                WHERE ordernumber = 'P180301142513854' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '243638'
                WHERE ordernumber = 'P180301142618627' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '124608'
                WHERE ordernumber = 'P180301142957769' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287343'
                WHERE ordernumber = 'P190301143353782' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '259988'
                WHERE ordernumber = 'P180301143355336' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237378'
                WHERE ordernumber = 'P190301143515230' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379601'
                WHERE ordernumber = 'P420301143800926' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '122253'
                WHERE ordernumber = 'P180301144517575' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343888'
                WHERE ordernumber = 'P180301145130369' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379605'
                WHERE ordernumber = 'P180301145753859' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '95398'
                WHERE ordernumber = 'P180301150218779' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '234876'
                WHERE ordernumber = 'P200301150632194' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379606'
                WHERE ordernumber = 'P420301151036391' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237203'
                WHERE ordernumber = 'P180301151128813' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '213784'
                WHERE ordernumber = 'P200301151919288' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379608'
                WHERE ordernumber = 'P180301152124786' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355262'
                WHERE ordernumber = 'P420301152250168' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379609'
                WHERE ordernumber = 'P180301152754430' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339701'
                WHERE ordernumber = 'P420301153305337' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379610'
                WHERE ordernumber = 'P180301153605802' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379611'
                WHERE ordernumber = 'P180301153948416' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '290291'
                WHERE ordernumber = 'P200301155005965' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379612'
                WHERE ordernumber = 'P420301155219621' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '212791'
                WHERE ordernumber = 'P180301155322987' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379616'
                WHERE ordernumber = 'P180301160232410' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276994'
                WHERE ordernumber = 'P180301160406812' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378235'
                WHERE ordernumber = 'P180301160634851' 
            
2024-03-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379618'
                WHERE ordernumber = 'P420301160707526' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378235'
                WHERE ordernumber = 'P190301160723931' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379619'
                WHERE ordernumber = 'P180301160804623' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97821'
                WHERE ordernumber = 'P200301160857607' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379621'
                WHERE ordernumber = 'P180301161332460' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '1817'
                WHERE ordernumber = 'P180301161702139' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '146258'
                WHERE ordernumber = 'P200301161835499' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379625'
                WHERE ordernumber = 'P420301162640515' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379626'
                WHERE ordernumber = 'P200301162736518' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349489'
                WHERE ordernumber = 'P420301162746707' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '263704'
                WHERE ordernumber = 'P180301163020999' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '315119'
                WHERE ordernumber = 'P200301163123727' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379627'
                WHERE ordernumber = 'P200301163421512' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379629'
                WHERE ordernumber = 'P180301163616784' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379628'
                WHERE ordernumber = 'P420301163623685' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378673'
                WHERE ordernumber = 'P420301164922151' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '263097'
                WHERE ordernumber = 'P190301165100926' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '295943'
                WHERE ordernumber = 'P180301165400575' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379632'
                WHERE ordernumber = 'P190301165647192' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '117993'
                WHERE ordernumber = 'P190301170012574' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '111459'
                WHERE ordernumber = 'P180301170843319' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '376146'
                WHERE ordernumber = 'P420301171355934' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379212'
                WHERE ordernumber = 'P180301171506799' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379412'
                WHERE ordernumber = 'P180301171658393' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94285'
                WHERE ordernumber = 'P180301173323366' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '211536'
                WHERE ordernumber = 'P180301173812450' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377387'
                WHERE ordernumber = 'P180301174130928' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '251059'
                WHERE ordernumber = 'P200301174747332' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343368'
                WHERE ordernumber = 'P180301175354526' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '123995'
                WHERE ordernumber = 'P180301175830227' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379635'
                WHERE ordernumber = 'P200301180304346' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379636'
                WHERE ordernumber = 'P180301180348373' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '309404'
                WHERE ordernumber = 'P180301180511599' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98478'
                WHERE ordernumber = 'P200301180512628' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379637'
                WHERE ordernumber = 'P190301180521407' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379638'
                WHERE ordernumber = 'P200301180632668' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '341580'
                WHERE ordernumber = 'P190301180906434' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '67948'
                WHERE ordernumber = 'P200301181112582' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '295796'
                WHERE ordernumber = 'P190301181116503' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '295796'
                WHERE ordernumber = 'P190301181212946' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379639'
                WHERE ordernumber = 'P200301181320575' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379640'
                WHERE ordernumber = 'P420301181347173' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284597'
                WHERE ordernumber = 'P200301181444369' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379641'
                WHERE ordernumber = 'P190301181910288' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '363438'
                WHERE ordernumber = 'P200301182125492' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379617'
                WHERE ordernumber = 'P420301182336941' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '108997'
                WHERE ordernumber = 'P200301183756894' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '219829'
                WHERE ordernumber = 'P190301183957391' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379644'
                WHERE ordernumber = 'P200301184007958' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '241189'
                WHERE ordernumber = 'P200301184529743' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379645'
                WHERE ordernumber = 'P200301184924283' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379646'
                WHERE ordernumber = 'P420301185424757' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379648'
                WHERE ordernumber = 'P420301185910512' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378277'
                WHERE ordernumber = 'P200301190551113' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301384'
                WHERE ordernumber = 'P190301191242482' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379458'
                WHERE ordernumber = 'P420301191257210' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379650'
                WHERE ordernumber = 'P190301191328723' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379649'
                WHERE ordernumber = 'P190301191922306' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379651'
                WHERE ordernumber = 'P420301191944440' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379652'
                WHERE ordernumber = 'P420301192146587' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236278'
                WHERE ordernumber = 'P190301192212589' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379653'
                WHERE ordernumber = 'P590301192301431' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379080'
                WHERE ordernumber = 'P190301193026666' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379080'
                WHERE ordernumber = 'P190301193216908' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379654'
                WHERE ordernumber = 'P200301194111961' 
            
2024-03-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379655'
                WHERE ordernumber = 'P200301194914999'