2024-04-05 01:00:03 -- 將會員中心id寫入data-lake
2024-04-05 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-04%';
        
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '327431'
                WHERE ordernumber = 'P200404110613227' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '152524'
                WHERE ordernumber = 'P180404110624758' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '204876'
                WHERE ordernumber = 'P190404110759651' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350377'
                WHERE ordernumber = 'P200404111752252' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '592'
                WHERE ordernumber = 'P190404113457352' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350016'
                WHERE ordernumber = 'P190404113601165' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350016'
                WHERE ordernumber = 'P190404113733600' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353647'
                WHERE ordernumber = 'P190404114556693' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '107972'
                WHERE ordernumber = 'P190404115403554' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '273603'
                WHERE ordernumber = 'P190404120457602' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383504'
                WHERE ordernumber = 'P190404121417203' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '216054'
                WHERE ordernumber = 'P190404121932620' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '145854'
                WHERE ordernumber = 'P200404124221388' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380923'
                WHERE ordernumber = 'P630404124829540' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '169457'
                WHERE ordernumber = 'P190404124929150' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384308'
                WHERE ordernumber = 'P630404130424317' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '117847'
                WHERE ordernumber = 'P190404130714864' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309225'
                WHERE ordernumber = 'P200404130820539' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384309'
                WHERE ordernumber = 'P200404131126697' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380790'
                WHERE ordernumber = 'P420404131354875' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384310'
                WHERE ordernumber = 'P180404131815943' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384311'
                WHERE ordernumber = 'P180404132130676' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '206892'
                WHERE ordernumber = 'P190404132231819' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379653'
                WHERE ordernumber = 'P590404132705592' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '332944'
                WHERE ordernumber = 'P200404132939698' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384313'
                WHERE ordernumber = 'P200404133140663' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384314'
                WHERE ordernumber = 'P420404133301550' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '327206'
                WHERE ordernumber = 'P200404134207963' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '226148'
                WHERE ordernumber = 'P180404134506908' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352250'
                WHERE ordernumber = 'P200404135005474' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346957'
                WHERE ordernumber = 'P180404135020596' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381777'
                WHERE ordernumber = 'P180404135249575' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384317'
                WHERE ordernumber = 'P590404135354356' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296764'
                WHERE ordernumber = 'P180404135457239' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296764'
                WHERE ordernumber = 'P180404135524978' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377746'
                WHERE ordernumber = 'P180404135620766' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377742'
                WHERE ordernumber = 'P180404135810472' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278204'
                WHERE ordernumber = 'P180404135901532' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384318'
                WHERE ordernumber = 'P180404140829797' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384319'
                WHERE ordernumber = 'P420404141043350' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '203022'
                WHERE ordernumber = 'P180404141857350' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384320'
                WHERE ordernumber = 'P180404142245807' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '222879'
                WHERE ordernumber = 'P180404142509479' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384321'
                WHERE ordernumber = 'P180404142801301' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '76805'
                WHERE ordernumber = 'P180404143003530' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384322'
                WHERE ordernumber = 'P590404143250198' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382414'
                WHERE ordernumber = 'P180404143511136' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384323'
                WHERE ordernumber = 'P190404143653844' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384324'
                WHERE ordernumber = 'P420404144106974' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384325'
                WHERE ordernumber = 'P190404144313695' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291936'
                WHERE ordernumber = 'P630404144423863' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378213'
                WHERE ordernumber = 'P200404144716798' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384326'
                WHERE ordernumber = 'P180404144807112' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384328'
                WHERE ordernumber = 'P200404145754672' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384329'
                WHERE ordernumber = 'P180404145936714' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '360115'
                WHERE ordernumber = 'P180404150140784' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384329'
                WHERE ordernumber = 'P180404150244371' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384331'
                WHERE ordernumber = 'P190404150611597' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384332'
                WHERE ordernumber = 'P180404151028372' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '330740'
                WHERE ordernumber = 'P180404151327320' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384334'
                WHERE ordernumber = 'P200404151659865' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382858'
                WHERE ordernumber = 'P200404151915543' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384335'
                WHERE ordernumber = 'P180404151925654' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384337'
                WHERE ordernumber = 'P420404152617662' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384338'
                WHERE ordernumber = 'P200404152625962' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287643'
                WHERE ordernumber = 'P180404153047467' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93636'
                WHERE ordernumber = 'P180404153443848' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305270'
                WHERE ordernumber = 'P180404153531460' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384343'
                WHERE ordernumber = 'P180404154710648' 
            
2024-04-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334987'
                WHERE ordernumber = 'P420404160431563' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384346'
                WHERE ordernumber = 'P200404160740368' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '317739'
                WHERE ordernumber = 'P630404160835627' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384347'
                WHERE ordernumber = 'P420404160900725' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355601'
                WHERE ordernumber = 'P180404161233254' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384348'
                WHERE ordernumber = 'P420404161936624' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384349'
                WHERE ordernumber = 'P420404162242419' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96793'
                WHERE ordernumber = 'P200404162353245' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '374433'
                WHERE ordernumber = 'P420404163529875' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339070'
                WHERE ordernumber = 'P190404163653202' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384352'
                WHERE ordernumber = 'P420404163756426' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100914'
                WHERE ordernumber = 'P420404163830712' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '242149'
                WHERE ordernumber = 'P180404164159163' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384353'
                WHERE ordernumber = 'P200404164712951' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339395'
                WHERE ordernumber = 'P200404164802112' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384355'
                WHERE ordernumber = 'P200404165144986' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384356'
                WHERE ordernumber = 'P630404165502341' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '194301'
                WHERE ordernumber = 'P630404165930825' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '254492'
                WHERE ordernumber = 'P420404170220572' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '119418'
                WHERE ordernumber = 'P180404170415336' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384357'
                WHERE ordernumber = 'P420404171420451' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384358'
                WHERE ordernumber = 'P630404172257352' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384359'
                WHERE ordernumber = 'P180404172430729' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288367'
                WHERE ordernumber = 'P200404172443497' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384360'
                WHERE ordernumber = 'P180404172531833' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288367'
                WHERE ordernumber = 'P200404172655728' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384361'
                WHERE ordernumber = 'P630404172814480' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384362'
                WHERE ordernumber = 'P200404172844885' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384363'
                WHERE ordernumber = 'P420404173021118' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384364'
                WHERE ordernumber = 'P200404173528482' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384365'
                WHERE ordernumber = 'P590404174314946' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382138'
                WHERE ordernumber = 'P420404174352630' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '219228'
                WHERE ordernumber = 'P180404174608902' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '133842'
                WHERE ordernumber = 'P630404174959551' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282963'
                WHERE ordernumber = 'P180404175218114' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384367'
                WHERE ordernumber = 'P200404175232826' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384368'
                WHERE ordernumber = 'P190404175312965' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384367'
                WHERE ordernumber = 'P200404175505278' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353647'
                WHERE ordernumber = 'P190404180035935' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384370'
                WHERE ordernumber = 'P180404180212874' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '154999'
                WHERE ordernumber = 'P200404180427183' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384371'
                WHERE ordernumber = 'P190404180929404' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '270890'
                WHERE ordernumber = 'P180404181022865' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384372'
                WHERE ordernumber = 'P630404181800120' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '115796'
                WHERE ordernumber = 'P180404182337757' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383686'
                WHERE ordernumber = 'P420404182347720' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '255263'
                WHERE ordernumber = 'P200404182543811' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342851'
                WHERE ordernumber = 'P200404182707963' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283958'
                WHERE ordernumber = 'P200404183254568' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '217348'
                WHERE ordernumber = 'P200404183326967' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384374'
                WHERE ordernumber = 'P180404183507262' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383965'
                WHERE ordernumber = 'P190404183538746' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '273897'
                WHERE ordernumber = 'P200404184153415' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384375'
                WHERE ordernumber = 'P200404185241475' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384376'
                WHERE ordernumber = 'P420404185407903' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384377'
                WHERE ordernumber = 'P420404185552355' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355198'
                WHERE ordernumber = 'P420404185704725' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313371'
                WHERE ordernumber = 'P420404185845273' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94734'
                WHERE ordernumber = 'P200404190431394' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '108089'
                WHERE ordernumber = 'P190404190523213' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '133744'
                WHERE ordernumber = 'P200404190612860' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382480'
                WHERE ordernumber = 'P200404191437257' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384379'
                WHERE ordernumber = 'P200404191855583' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384380'
                WHERE ordernumber = 'P630404192330329' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343981'
                WHERE ordernumber = 'P200404192451310' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384381'
                WHERE ordernumber = 'P200404192847313' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97842'
                WHERE ordernumber = 'P190404193115501' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '365731'
                WHERE ordernumber = 'P190404193717492' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '316064'
                WHERE ordernumber = 'P420404194516292' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '95943'
                WHERE ordernumber = 'P200404194942525' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382480'
                WHERE ordernumber = 'P200404195022805' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384382'
                WHERE ordernumber = 'P630404195207379' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384383'
                WHERE ordernumber = 'P630404200021849' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384387'
                WHERE ordernumber = 'P630404210605735' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '272029'
                WHERE ordernumber = 'P630404211651694' 
            
2024-04-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384389'
                WHERE ordernumber = 'P630404215100525'