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'