2024-04-10 01:00:03 -- 將會員中心id寫入data-lake
2024-04-10 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-09%';
        
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384779'
                WHERE ordernumber = 'P630409105227151' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '317214'
                WHERE ordernumber = 'P180409110101976' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '139459'
                WHERE ordernumber = 'P190409110926255' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384914'
                WHERE ordernumber = 'P190409111131212' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384915'
                WHERE ordernumber = 'P190409112106885' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384916'
                WHERE ordernumber = 'P420409112151504' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '156520'
                WHERE ordernumber = 'P200409112334470' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384917'
                WHERE ordernumber = 'P190409113116643' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384919'
                WHERE ordernumber = 'P200409113456162' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384121'
                WHERE ordernumber = 'P180409113641356' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384921'
                WHERE ordernumber = 'P190409113727177' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384922'
                WHERE ordernumber = 'P180409113823901' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296950'
                WHERE ordernumber = 'P420409114340961' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384924'
                WHERE ordernumber = 'P630409115104489' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303490'
                WHERE ordernumber = 'P190409115354116' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384925'
                WHERE ordernumber = 'P630409115605892' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '292994'
                WHERE ordernumber = 'P190409115817195' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180409120002650' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '246060'
                WHERE ordernumber = 'P190409120311872' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367946'
                WHERE ordernumber = 'P420409120416950' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285867'
                WHERE ordernumber = 'P190409120853334' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162029'
                WHERE ordernumber = 'P190409121055341' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '236620'
                WHERE ordernumber = 'P190409121518650' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384926'
                WHERE ordernumber = 'P190409121711244' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100896'
                WHERE ordernumber = 'P190409122133288' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384927'
                WHERE ordernumber = 'P200409122153641' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '227829'
                WHERE ordernumber = 'P190409123611881' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382093'
                WHERE ordernumber = 'P190409123721868' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302473'
                WHERE ordernumber = 'P200409124217594' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '130789'
                WHERE ordernumber = 'P180409124251869' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '327411'
                WHERE ordernumber = 'P190409124558588' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344084'
                WHERE ordernumber = 'P200409125032504' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384928'
                WHERE ordernumber = 'P190409125148398' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '115196'
                WHERE ordernumber = 'P180409125429646' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '115196'
                WHERE ordernumber = 'P180409125724586' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '115196'
                WHERE ordernumber = 'P180409125831727' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384929'
                WHERE ordernumber = 'P420409125901544' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384930'
                WHERE ordernumber = 'P420409130018951' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384933'
                WHERE ordernumber = 'P420409130722115' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384934'
                WHERE ordernumber = 'P180409130854926' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297128'
                WHERE ordernumber = 'P200409130858863' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '234734'
                WHERE ordernumber = 'P200409131643249' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '161937'
                WHERE ordernumber = 'P200409132128216' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245327'
                WHERE ordernumber = 'P180409133157428' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384936'
                WHERE ordernumber = 'P190409133358144' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354173'
                WHERE ordernumber = 'P190409134627323' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384937'
                WHERE ordernumber = 'P200409134720122' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '217445'
                WHERE ordernumber = 'P190409134859158' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '131785'
                WHERE ordernumber = 'P180409135005595' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384939'
                WHERE ordernumber = 'P190409135149124' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384940'
                WHERE ordernumber = 'P200409135251595' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381109'
                WHERE ordernumber = 'P180409135441231' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278807'
                WHERE ordernumber = 'P200409135749866' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307412'
                WHERE ordernumber = 'P180409140325888' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384941'
                WHERE ordernumber = 'P180409140846598' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '64196'
                WHERE ordernumber = 'P180409141204223' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384943'
                WHERE ordernumber = 'P630409141601858' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '211556'
                WHERE ordernumber = 'P180409141702958' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287188'
                WHERE ordernumber = 'P180409141748112' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '133699'
                WHERE ordernumber = 'P630409141918407' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384944'
                WHERE ordernumber = 'P200409142705624' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305444'
                WHERE ordernumber = 'P420409142944765' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384946'
                WHERE ordernumber = 'P420409143450209' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384947'
                WHERE ordernumber = 'P630409144258755' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384949'
                WHERE ordernumber = 'P200409145106995' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384950'
                WHERE ordernumber = 'P200409145234599' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305850'
                WHERE ordernumber = 'P200409145549641' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228727'
                WHERE ordernumber = 'P190409145904632' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384953'
                WHERE ordernumber = 'P200409150154549' 
            
2024-04-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '373343'
                WHERE ordernumber = 'P200409150559806' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384952'
                WHERE ordernumber = 'P190409151024739' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381089'
                WHERE ordernumber = 'P420409151226406' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384955'
                WHERE ordernumber = 'P200409151431993' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384956'
                WHERE ordernumber = 'P190409151452623' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384957'
                WHERE ordernumber = 'P180409151810647' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '270938'
                WHERE ordernumber = 'P200409152301199' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384958'
                WHERE ordernumber = 'P200409152525287' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '334332'
                WHERE ordernumber = 'P420409152630670' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384959'
                WHERE ordernumber = 'P200409152646509' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384956'
                WHERE ordernumber = 'P190409152949722' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230309'
                WHERE ordernumber = 'P180409153505846' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384960'
                WHERE ordernumber = 'P200409153533263' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384961'
                WHERE ordernumber = 'P180409153748557' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384964'
                WHERE ordernumber = 'P200409154536774' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98143'
                WHERE ordernumber = 'P190409154709614' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384965'
                WHERE ordernumber = 'P180409154723929' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384967'
                WHERE ordernumber = 'P200409154914129' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384968'
                WHERE ordernumber = 'P420409155653555' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '247175'
                WHERE ordernumber = 'P420409155735526' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99903'
                WHERE ordernumber = 'P180409160050679' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '267976'
                WHERE ordernumber = 'P180409160151257' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371930'
                WHERE ordernumber = 'P630409160258455' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275910'
                WHERE ordernumber = 'P180409161421721' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384970'
                WHERE ordernumber = 'P420409161735281' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358450'
                WHERE ordernumber = 'P180409162532800' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384971'
                WHERE ordernumber = 'P180409163936323' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384168'
                WHERE ordernumber = 'P180409164829804' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '21348'
                WHERE ordernumber = 'P200409165231739' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384973'
                WHERE ordernumber = 'P420409165741417' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384975'
                WHERE ordernumber = 'P180409165958396' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384976'
                WHERE ordernumber = 'P180409170202161' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380361'
                WHERE ordernumber = 'P590409170413388' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '213304'
                WHERE ordernumber = 'P420409170509282' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '253391'
                WHERE ordernumber = 'P180409170508953' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '121498'
                WHERE ordernumber = 'P200409170739660' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384977'
                WHERE ordernumber = 'P180409171321399' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384978'
                WHERE ordernumber = 'P630409171550433' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '375145'
                WHERE ordernumber = 'P420409171822993' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '363125'
                WHERE ordernumber = 'P630409172716746' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287298'
                WHERE ordernumber = 'P200409173325321' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '250772'
                WHERE ordernumber = 'P180409174221943' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384979'
                WHERE ordernumber = 'P200409174519673' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384980'
                WHERE ordernumber = 'P200409174726764' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283129'
                WHERE ordernumber = 'P180409174740726' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '365178'
                WHERE ordernumber = 'P180409174909381' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '323662'
                WHERE ordernumber = 'P200409175042120' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '143625'
                WHERE ordernumber = 'P180409180240521' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '253113'
                WHERE ordernumber = 'P180409180657831' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '44719'
                WHERE ordernumber = 'P180409180747858' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384983'
                WHERE ordernumber = 'P200409181817602' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384983'
                WHERE ordernumber = 'P200409181820451' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275063'
                WHERE ordernumber = 'P200409182141775' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359375'
                WHERE ordernumber = 'P190409182143699' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348261'
                WHERE ordernumber = 'P190409182356749' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '325304'
                WHERE ordernumber = 'P420409183315128' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '300621'
                WHERE ordernumber = 'P200409183744260' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278727'
                WHERE ordernumber = 'P190409183855804' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '311660'
                WHERE ordernumber = 'P180409183953679' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384984'
                WHERE ordernumber = 'P190409184407639' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '311329'
                WHERE ordernumber = 'P190409184924261' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '149819'
                WHERE ordernumber = 'P190409185226786' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384986'
                WHERE ordernumber = 'P630409185956456' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384987'
                WHERE ordernumber = 'P630409190219698' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '82588'
                WHERE ordernumber = 'P200409191337701' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384988'
                WHERE ordernumber = 'P200409191544786' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384989'
                WHERE ordernumber = 'P630409192035771' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '227842'
                WHERE ordernumber = 'P190409192343441' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342058'
                WHERE ordernumber = 'P200409193301320' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '249123'
                WHERE ordernumber = 'P200409193809943' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384991'
                WHERE ordernumber = 'P200409194027131' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384992'
                WHERE ordernumber = 'P200409194150713' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384993'
                WHERE ordernumber = 'P200409194307545' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384994'
                WHERE ordernumber = 'P630409194424209' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384995'
                WHERE ordernumber = 'P200409195540319' 
            
2024-04-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '254281'
                WHERE ordernumber = 'P630409211206532'