2025-03-05 01:00:02 -- 將會員中心id寫入data-lake 2025-03-05 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 '2025-03-04%'; 2025-03-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '243561' WHERE ordernumber = 'P2503040000007' 2025-03-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '459364' WHERE ordernumber = 'P2503040000009' 2025-03-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '249481' WHERE ordernumber = 'P2503040000010' 2025-03-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '337413' WHERE ordernumber = 'P2503040000012' 2025-03-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '269457' WHERE ordernumber = 'P2503040000013' 2025-03-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '215803' WHERE ordernumber = 'P2503040000014' 2025-03-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '457426' WHERE ordernumber = 'P2503040000017' 2025-03-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '459366' WHERE ordernumber = 'P2503040000021' 2025-03-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '459367' WHERE ordernumber = 'P2503040000023' 2025-03-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '453704' WHERE ordernumber = 'P2503040000025' 2025-03-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '459368' WHERE ordernumber = 'P2503040000035' 2025-03-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '459369' WHERE ordernumber = 'P2503040000037' 2025-03-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '459370' WHERE ordernumber = 'P2503040000038' 2025-03-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '366011' WHERE ordernumber = 'P2503040000040' 2025-03-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '459371' WHERE ordernumber = 'P2503040000041' 2025-03-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '281418' WHERE ordernumber = 'P2503040000042' 2025-03-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '459372' WHERE ordernumber = 'P2503040000044' 2025-03-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '324982' WHERE ordernumber = 'P2503040000045' 2025-03-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '270748' WHERE ordernumber = 'P2503040000047' 2025-03-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '257909' WHERE ordernumber = 'P2503040000048' 2025-03-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '455976' WHERE ordernumber = 'P2503040000049' 2025-03-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '385932' WHERE ordernumber = 'P2503040000053' 2025-03-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '459369' WHERE ordernumber = 'P2503040000054' 2025-03-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '227566' WHERE ordernumber = 'P2503040000055' 2025-03-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '97753' WHERE ordernumber = 'P2503040000058' 2025-03-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '276395' WHERE ordernumber = 'P2503040000059' 2025-03-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '456113' WHERE ordernumber = 'P2503040000060' 2025-03-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '79940' WHERE ordernumber = 'P2503040000062' 2025-03-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '266355' WHERE ordernumber = 'P2503040000066' 2025-03-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '286464' WHERE ordernumber = 'P2503040000071' 2025-03-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '296998' WHERE ordernumber = 'P2503040000074' 2025-03-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '459377' WHERE ordernumber = 'P2503040000080' 2025-03-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '136868' WHERE ordernumber = 'P2503040000082' 2025-03-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '446203' WHERE ordernumber = 'P2503040000085' 2025-03-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '459379' WHERE ordernumber = 'P2503040000093' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '353758' WHERE ordernumber = 'P2503040000094' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459380' WHERE ordernumber = 'P2503040000095' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '456906' WHERE ordernumber = 'P2503040000098' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '453523' WHERE ordernumber = 'P2503040000100' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459381' WHERE ordernumber = 'P2503040000101' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '374936' WHERE ordernumber = 'P2503040000109' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459329' WHERE ordernumber = 'P2503040000111' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '296329' WHERE ordernumber = 'P2503040000113' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459382' WHERE ordernumber = 'P2503040000114' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459383' WHERE ordernumber = 'P2503040000115' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '206790' WHERE ordernumber = 'P2503040000116' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '288910' WHERE ordernumber = 'P2503040000117' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459384' WHERE ordernumber = 'P2503040000118' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '406568' WHERE ordernumber = 'P2503040000121' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '291438' WHERE ordernumber = 'P2503040000122' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459385' WHERE ordernumber = 'P2503040000123' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '457924' WHERE ordernumber = 'P2503040000127' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459386' WHERE ordernumber = 'P2503040000128' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '134710' WHERE ordernumber = 'P2503040000132' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '369368' WHERE ordernumber = 'P2503040000135' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459387' WHERE ordernumber = 'P2503040000136' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459388' WHERE ordernumber = 'P2503040000138' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459389' WHERE ordernumber = 'P2503040000139' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '43401' WHERE ordernumber = 'P2503040000141' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '103972' WHERE ordernumber = 'P2503040000143' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459393' WHERE ordernumber = 'P2503040000144' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459390' WHERE ordernumber = 'P2503040000146' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '223482' WHERE ordernumber = 'P2503040000150' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '381324' WHERE ordernumber = 'P2503040000157' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '456033' WHERE ordernumber = 'P2503040000158' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '103163' WHERE ordernumber = 'P2503040000165' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459396' WHERE ordernumber = 'P2503040000167' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459399' WHERE ordernumber = 'P2503040000170' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459400' WHERE ordernumber = 'P2503040000171' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459401' WHERE ordernumber = 'P2503040000172' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459402' WHERE ordernumber = 'P2503040000174' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459403' WHERE ordernumber = 'P2503040000175' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459404' WHERE ordernumber = 'P2503040000178' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459406' WHERE ordernumber = 'P2503040000179' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459405' WHERE ordernumber = 'P2503040000181' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '280856' WHERE ordernumber = 'P2503040000183' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459408' WHERE ordernumber = 'P2503040000184' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '254408' WHERE ordernumber = 'P2503040000185' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459409' WHERE ordernumber = 'P2503040000186' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '224877' WHERE ordernumber = 'P2503040000187' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459410' WHERE ordernumber = 'P2503040000188' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459411' WHERE ordernumber = 'P2503040000194' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459412' WHERE ordernumber = 'P2503040000196' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '294147' WHERE ordernumber = 'P2503040000197' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459413' WHERE ordernumber = 'P2503040000199' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459414' WHERE ordernumber = 'P2503040000200' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459416' WHERE ordernumber = 'P2503040000201' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459411' WHERE ordernumber = 'P2503040000202' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459418' WHERE ordernumber = 'P2503040000203' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459411' WHERE ordernumber = 'P2503040000205' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459412' WHERE ordernumber = 'P2503040000206' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459413' WHERE ordernumber = 'P2503040000207' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459416' WHERE ordernumber = 'P2503040000208' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459415' WHERE ordernumber = 'P2503040000210' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459415' WHERE ordernumber = 'P2503040000212' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459421' WHERE ordernumber = 'P2503040000213' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459420' WHERE ordernumber = 'P2503040000214' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '103972' WHERE ordernumber = 'P2503040000215' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '76575' WHERE ordernumber = 'P2503040000216' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '103972' WHERE ordernumber = 'P2503040000217' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '436621' WHERE ordernumber = 'P2503040000223' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '451549' WHERE ordernumber = 'P2503040000227' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459424' WHERE ordernumber = 'P2503040000230' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459423' WHERE ordernumber = 'P2503040000231' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459425' WHERE ordernumber = 'P2503040000233' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '224573' WHERE ordernumber = 'P2503040000241' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459427' WHERE ordernumber = 'P2503040000243' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '97810' WHERE ordernumber = 'P2503040000244' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459431' WHERE ordernumber = 'P2503040000254' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459432' WHERE ordernumber = 'P2503040000255' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459433' WHERE ordernumber = 'P2503040000256' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459434' WHERE ordernumber = 'P2503040000261' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459436' WHERE ordernumber = 'P2503040000263' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459437' WHERE ordernumber = 'P2503040000265' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '458973' WHERE ordernumber = 'P2503040000266' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '245332' WHERE ordernumber = 'P2503040000267' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '425047' WHERE ordernumber = 'P2503040000271' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '458973' WHERE ordernumber = 'P2503040000273' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '447354' WHERE ordernumber = 'P2503040000278' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459442' WHERE ordernumber = 'P2503040000281' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '430953' WHERE ordernumber = 'P2503040000282' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459443' WHERE ordernumber = 'P2503040000285' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459444' WHERE ordernumber = 'P2503040000296' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459445' WHERE ordernumber = 'P2503040000302' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459447' WHERE ordernumber = 'P2503040000307' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '459448' WHERE ordernumber = 'P2503040000310' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '104592' WHERE ordernumber = 'P2503040000313' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '291414' WHERE ordernumber = 'P2503040000314' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '229034' WHERE ordernumber = 'P2503040000315' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '396477' WHERE ordernumber = 'P2503040000321' 2025-03-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '382343' WHERE ordernumber = 'P2503040000322' 2025-03-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '459449' WHERE ordernumber = 'P2503040000324' 2025-03-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '343808' WHERE ordernumber = 'P2503040000325' 2025-03-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '428478' WHERE ordernumber = 'P2503040000329' 2025-03-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '450152' WHERE ordernumber = 'P2503040000332' 2025-03-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '389962' WHERE ordernumber = 'P2503040000334' 2025-03-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '459450' WHERE ordernumber = 'P2503040000337' 2025-03-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '459452' WHERE ordernumber = 'P2503040000346' 2025-03-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '146660' WHERE ordernumber = 'P2503040000348' 2025-03-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '97352' WHERE ordernumber = 'P2503040000349' 2025-03-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '459453' WHERE ordernumber = 'P2503040000350' 2025-03-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '423875' WHERE ordernumber = 'P2503040000351' 2025-03-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '459454' WHERE ordernumber = 'P2503040000354' 2025-03-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '459456' WHERE ordernumber = 'P2503040000359' 2025-03-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '320448' WHERE ordernumber = 'P2503040000360' 2025-03-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '382742' WHERE ordernumber = 'P2503040000381' 2025-03-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '362505' WHERE ordernumber = 'P2503040000383' 2025-03-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '344858' WHERE ordernumber = 'P2503040000384' 2025-03-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '362505' WHERE ordernumber = 'P2503040000385' 2025-03-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '344858' WHERE ordernumber = 'P2503040000387' 2025-03-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '237657' WHERE ordernumber = 'P2503040000389' 2025-03-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '360913' WHERE ordernumber = 'P2503040000390' 2025-03-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '459457' WHERE ordernumber = 'P2503040000392' 2025-03-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '459459' WHERE ordernumber = 'P2503040000393' 2025-03-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '459460' WHERE ordernumber = 'P2503040000394' 2025-03-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '459462' WHERE ordernumber = 'P2503040000396' 2025-03-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '459463' WHERE ordernumber = 'P2503040000397' 2025-03-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '459465' WHERE ordernumber = 'P2503040000399' 2025-03-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '459465' WHERE ordernumber = 'P2503040000401' 2025-03-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '258365' WHERE ordernumber = 'P2503040000405'