2025-03-06 01:00:01 -- 將會員ä¸å¿ƒid寫入data-lake 2025-03-06 01:00:01 -- 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-05%'; 2025-03-06 01:00:01 -- UPDATE `omo_order_list` SET userId = '234868' WHERE ordernumber = 'P2503050000010' 2025-03-06 01:00:01 -- UPDATE `omo_order_list` SET userId = '459489' WHERE ordernumber = 'P2503050000011' 2025-03-06 01:00:01 -- UPDATE `omo_order_list` SET userId = '459491' WHERE ordernumber = 'P2503050000014' 2025-03-06 01:00:01 -- UPDATE `omo_order_list` SET userId = '459492' WHERE ordernumber = 'P2503050000015' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '232524' WHERE ordernumber = 'P2503050000017' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '459490' WHERE ordernumber = 'P2503050000020' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '252285' WHERE ordernumber = 'P2503050000022' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '251553' WHERE ordernumber = 'P2503050000024' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '459494' WHERE ordernumber = 'P2503050000026' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '459490' WHERE ordernumber = 'P2503050000027' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '352298' WHERE ordernumber = 'P2503050000029' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '297128' WHERE ordernumber = 'P2503050000030' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '314983' WHERE ordernumber = 'P2503050000031' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '444465' WHERE ordernumber = 'P2503050000032' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '101108' WHERE ordernumber = 'P2503050000034' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '261223' WHERE ordernumber = 'P2503050000035' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '459495' WHERE ordernumber = 'P2503050000036' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '93882' WHERE ordernumber = 'P2503050000037' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '459496' WHERE ordernumber = 'P2503050000039' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '459498' WHERE ordernumber = 'P2503050000040' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '459499' WHERE ordernumber = 'P2503050000041' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '455855' WHERE ordernumber = 'P2503050000043' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '459500' WHERE ordernumber = 'P2503050000046' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '454786' WHERE ordernumber = 'P2503050000051' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '358902' WHERE ordernumber = 'P2503050000054' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '459502' WHERE ordernumber = 'P2503050000055' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '459505' WHERE ordernumber = 'P2503050000057' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '459506' WHERE ordernumber = 'P2503050000058' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '342329' WHERE ordernumber = 'P2503050000063' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '429426' WHERE ordernumber = 'P2503050000064' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '459509' WHERE ordernumber = 'P2503050000068' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '459512' WHERE ordernumber = 'P2503050000071' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '439633' WHERE ordernumber = 'P2503050000072' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '454783' WHERE ordernumber = 'P2503050000074' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '459511' WHERE ordernumber = 'P2503050000075' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '459510' WHERE ordernumber = 'P2503050000077' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '167520' WHERE ordernumber = 'P2503050000079' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '282441' WHERE ordernumber = 'P2503050000080' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '459514' WHERE ordernumber = 'P2503050000082' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '419583' WHERE ordernumber = 'P2503050000085' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '249481' WHERE ordernumber = 'P2503050000087' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '459514' WHERE ordernumber = 'P2503050000090' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '98946' WHERE ordernumber = 'P2503050000094' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '381071' WHERE ordernumber = 'P2503050000095' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '333559' WHERE ordernumber = 'P2503050000096' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '459517' WHERE ordernumber = 'P2503050000097' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '262967' WHERE ordernumber = 'P2503050000098' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '408680' WHERE ordernumber = 'P2503050000102' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '263119' WHERE ordernumber = 'P2503050000104' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '316972' WHERE ordernumber = 'P2503050000105' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '459519' WHERE ordernumber = 'P2503050000115' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '459522' WHERE ordernumber = 'P2503050000118' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '459523' WHERE ordernumber = 'P2503050000119' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '421456' WHERE ordernumber = 'P2503050000120' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '428295' WHERE ordernumber = 'P2503050000122' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '430293' WHERE ordernumber = 'P2503050000124' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '96436' WHERE ordernumber = 'P2503050000126' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '96436' WHERE ordernumber = 'P2503050000127' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '96436' WHERE ordernumber = 'P2503050000128' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '459525' WHERE ordernumber = 'P2503050000130' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '459526' WHERE ordernumber = 'P2503050000137' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '459526' WHERE ordernumber = 'P2503050000138' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '350559' WHERE ordernumber = 'P2503050000140' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '459528' WHERE ordernumber = 'P2503050000145' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '413036' WHERE ordernumber = 'P2503050000146' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '305270' WHERE ordernumber = 'P2503050000147' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '457602' WHERE ordernumber = 'P2503050000148' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '459530' WHERE ordernumber = 'P2503050000150' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '459531' WHERE ordernumber = 'P2503050000155' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '459533' WHERE ordernumber = 'P2503050000156' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '459534' WHERE ordernumber = 'P2503050000160' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '459530' WHERE ordernumber = 'P2503050000162' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '382565' WHERE ordernumber = 'P2503050000163' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '459535' WHERE ordernumber = 'P2503050000165' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '299911' WHERE ordernumber = 'P2503050000167' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '455611' WHERE ordernumber = 'P2503050000168' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '459537' WHERE ordernumber = 'P2503050000170' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '459536' WHERE ordernumber = 'P2503050000174' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '459538' WHERE ordernumber = 'P2503050000175' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '459538' WHERE ordernumber = 'P2503050000176' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '459539' WHERE ordernumber = 'P2503050000177' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '459541' WHERE ordernumber = 'P2503050000181' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '459542' WHERE ordernumber = 'P2503050000184' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '323973' WHERE ordernumber = 'P2503050000185' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '459536' WHERE ordernumber = 'P2503050000186' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '285180' WHERE ordernumber = 'P2503050000188' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '238603' WHERE ordernumber = 'P2503050000190' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '401701' WHERE ordernumber = 'P2503050000199' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '164144' WHERE ordernumber = 'P2503050000200' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '459544' WHERE ordernumber = 'P2503050000202' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '459543' WHERE ordernumber = 'P2503050000205' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '303489' WHERE ordernumber = 'P2503050000206' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '459545' WHERE ordernumber = 'P2503050000207' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '459546' WHERE ordernumber = 'P2503050000212' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '459548' WHERE ordernumber = 'P2503050000216' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '247007' WHERE ordernumber = 'P2503050000219' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '459549' WHERE ordernumber = 'P2503050000228' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '459550' WHERE ordernumber = 'P2503050000231' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '459549' WHERE ordernumber = 'P2503050000232' 2025-03-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '389141' WHERE ordernumber = 'P2503050000236' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '398891' WHERE ordernumber = 'P2503050000237' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '459551' WHERE ordernumber = 'P2503050000239' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '457114' WHERE ordernumber = 'P2503050000245' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '289368' WHERE ordernumber = 'P2503050000248' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '459553' WHERE ordernumber = 'P2503050000249' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '459554' WHERE ordernumber = 'P2503050000251' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '94254' WHERE ordernumber = 'P2503050000254' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '459555' WHERE ordernumber = 'P2503050000258' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '111604' WHERE ordernumber = 'P2503050000259' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '459554' WHERE ordernumber = 'P2503050000263' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '109483' WHERE ordernumber = 'P2503050000265' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '277792' WHERE ordernumber = 'P2503050000268' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '289310' WHERE ordernumber = 'P2503050000269' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '430773' WHERE ordernumber = 'P2503050000270' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '454830' WHERE ordernumber = 'P2503050000271' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '408768' WHERE ordernumber = 'P2503050000273' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '459558' WHERE ordernumber = 'P2503050000274' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '452216' WHERE ordernumber = 'P2503050000278' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '99048' WHERE ordernumber = 'P2503050000280' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '452216' WHERE ordernumber = 'P2503050000287' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '459562' WHERE ordernumber = 'P2503050000288' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '344290' WHERE ordernumber = 'P2503050000290' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '369232' WHERE ordernumber = 'P2503050000291' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '86775' WHERE ordernumber = 'P2503050000292' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '341544' WHERE ordernumber = 'P2503050000295' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '399715' WHERE ordernumber = 'P2503050000298' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '459566' WHERE ordernumber = 'P2503050000300' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '136062' WHERE ordernumber = 'P2503050000307' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '312863' WHERE ordernumber = 'P2503050000309' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '292137' WHERE ordernumber = 'P2503050000315' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '459565' WHERE ordernumber = 'P2503050000316' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '459568' WHERE ordernumber = 'P2503050000318' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '459565' WHERE ordernumber = 'P2503050000319' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '424444' WHERE ordernumber = 'P2503050000321' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '85243' WHERE ordernumber = 'P2503050000322' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '459571' WHERE ordernumber = 'P2503050000326' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '459574' WHERE ordernumber = 'P2503050000350' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '293848' WHERE ordernumber = 'P2503050000353' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '242754' WHERE ordernumber = 'P2503050000356' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '459575' WHERE ordernumber = 'P2503050000358' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '459576' WHERE ordernumber = 'P2503050000361' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '459579' WHERE ordernumber = 'P2503050000365' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '459578' WHERE ordernumber = 'P2503050000366' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '391720' WHERE ordernumber = 'P2503050000369' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '459580' WHERE ordernumber = 'P2503050000370' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '459581' WHERE ordernumber = 'P2503050000371' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '400664' WHERE ordernumber = 'P2503050000375' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '459582' WHERE ordernumber = 'P2503050000377' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '236530' WHERE ordernumber = 'P2503050000378' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '262957' WHERE ordernumber = 'P2503050000379' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '459584' WHERE ordernumber = 'P2503050000383' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '116920' WHERE ordernumber = 'P2503050000387' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '399448' WHERE ordernumber = 'P2503050000390' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '389855' WHERE ordernumber = 'P2503050000392' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '459586' WHERE ordernumber = 'P2503050000398' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '459587' WHERE ordernumber = 'P2503050000403' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '208071' WHERE ordernumber = 'P2503050000405' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '208071' WHERE ordernumber = 'P2503050000407' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '459589' WHERE ordernumber = 'P2503050000408' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '455723' WHERE ordernumber = 'P2503050000409' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '421239' WHERE ordernumber = 'P2503050000413' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '378610' WHERE ordernumber = 'P2503050000414' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '264675' WHERE ordernumber = 'P2503050000415' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '459588' WHERE ordernumber = 'P2503050000416' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '459590' WHERE ordernumber = 'P2503050000417' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '459590' WHERE ordernumber = 'P2503050000418' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '459591' WHERE ordernumber = 'P2503050000420' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '307740' WHERE ordernumber = 'P2503050000422' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '218685' WHERE ordernumber = 'P2503050000423' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '459588' WHERE ordernumber = 'P2503050000424' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '459593' WHERE ordernumber = 'P2503050000426' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '458311' WHERE ordernumber = 'P2503050000428' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '459564' WHERE ordernumber = 'P2503050000430' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '459595' WHERE ordernumber = 'P2503050000435' 2025-03-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '302434' WHERE ordernumber = 'P2503050000441'