2025-02-14 01:00:01 -- 將會員中心id寫入data-lake 2025-02-14 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-02-13%'; 2025-02-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '383623' WHERE ordernumber = 'P2502130000006' 2025-02-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '399498' WHERE ordernumber = 'P2502130000009' 2025-02-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '234781' WHERE ordernumber = 'P2502130000011' 2025-02-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '232090' WHERE ordernumber = 'P2502130000012' 2025-02-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '249481' WHERE ordernumber = 'P2502130000013' 2025-02-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '455829' WHERE ordernumber = 'P2502130000017' 2025-02-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '94924' WHERE ordernumber = 'P2502130000018' 2025-02-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '103972' WHERE ordernumber = 'P2502130000027' 2025-02-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '276379' WHERE ordernumber = 'P2502130000028' 2025-02-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '455831' WHERE ordernumber = 'P2502130000029' 2025-02-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '97517' WHERE ordernumber = 'P2502130000031' 2025-02-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '455833' WHERE ordernumber = 'P2502130000038' 2025-02-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '103972' WHERE ordernumber = 'P2502130000049' 2025-02-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '103972' WHERE ordernumber = 'P2502130000050' 2025-02-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '455148' WHERE ordernumber = 'P2502130000053' 2025-02-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '455834' WHERE ordernumber = 'P2502130000055' 2025-02-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '427011' WHERE ordernumber = 'P2502130000059' 2025-02-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '272704' WHERE ordernumber = 'P2502130000063' 2025-02-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '242226' WHERE ordernumber = 'P2502130000068' 2025-02-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '455837' WHERE ordernumber = 'P2502130000071' 2025-02-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '455838' WHERE ordernumber = 'P2502130000076' 2025-02-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '431738' WHERE ordernumber = 'P2502130000079' 2025-02-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '390599' WHERE ordernumber = 'P2502130000081' 2025-02-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '233874' WHERE ordernumber = 'P2502130000082' 2025-02-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '276313' WHERE ordernumber = 'P2502130000084' 2025-02-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '455842' WHERE ordernumber = 'P2502130000085' 2025-02-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '212571' WHERE ordernumber = 'P2502130000094' 2025-02-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '81046' WHERE ordernumber = 'P2502130000099' 2025-02-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '202092' WHERE ordernumber = 'P2502130000101' 2025-02-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '402285' WHERE ordernumber = 'P2502130000102' 2025-02-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '455836' WHERE ordernumber = 'P2502130000103' 2025-02-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '455845' WHERE ordernumber = 'P2502130000109' 2025-02-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '213262' WHERE ordernumber = 'P2502130000110' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '455116' WHERE ordernumber = 'P2502130000111' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '80978' WHERE ordernumber = 'P2502130000112' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '80978' WHERE ordernumber = 'P2502130000114' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '455846' WHERE ordernumber = 'P2502130000118' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '455847' WHERE ordernumber = 'P2502130000120' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '330696' WHERE ordernumber = 'P2502130000124' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '308273' WHERE ordernumber = 'P2502130000125' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '221012' WHERE ordernumber = 'P2502130000133' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '86200' WHERE ordernumber = 'P2502130000137' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '218311' WHERE ordernumber = 'P2502130000140' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '223258' WHERE ordernumber = 'P2502130000143' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '405269' WHERE ordernumber = 'P2502130000146' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '395285' WHERE ordernumber = 'P2502130000149' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '329467' WHERE ordernumber = 'P2502130000153' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '455854' WHERE ordernumber = 'P2502130000157' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '455850' WHERE ordernumber = 'P2502130000158' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '455850' WHERE ordernumber = 'P2502130000159' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '111140' WHERE ordernumber = 'P2502130000161' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '106148' WHERE ordernumber = 'P2502130000162' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '455853' WHERE ordernumber = 'P2502130000164' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '320692' WHERE ordernumber = 'P2502130000166' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '455856' WHERE ordernumber = 'P2502130000168' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '310799' WHERE ordernumber = 'P2502130000171' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '455834' WHERE ordernumber = 'P2502130000178' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '455858' WHERE ordernumber = 'P2502130000183' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '455858' WHERE ordernumber = 'P2502130000184' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '455859' WHERE ordernumber = 'P2502130000186' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '454764' WHERE ordernumber = 'P2502130000191' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '415713' WHERE ordernumber = 'P2502130000192' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '455861' WHERE ordernumber = 'P2502130000194' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '430020' WHERE ordernumber = 'P2502130000197' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '428835' WHERE ordernumber = 'P2502130000207' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '95446' WHERE ordernumber = 'P2502130000210' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '454421' WHERE ordernumber = 'P2502130000211' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '372351' WHERE ordernumber = 'P2502130000213' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '455865' WHERE ordernumber = 'P2502130000220' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '455867' WHERE ordernumber = 'P2502130000227' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '455866' WHERE ordernumber = 'P2502130000228' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '455868' WHERE ordernumber = 'P2502130000233' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '455870' WHERE ordernumber = 'P2502130000235' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '134579' WHERE ordernumber = 'P2502130000236' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '455872' WHERE ordernumber = 'P2502130000238' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '455874' WHERE ordernumber = 'P2502130000245' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '312854' WHERE ordernumber = 'P2502130000249' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '104898' WHERE ordernumber = 'P2502130000252' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '339269' WHERE ordernumber = 'P2502130000254' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '444558' WHERE ordernumber = 'P2502130000258' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '423219' WHERE ordernumber = 'P2502130000259' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '80905' WHERE ordernumber = 'P2502130000260' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '78136' WHERE ordernumber = 'P2502130000262' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '86612' WHERE ordernumber = 'P2502130000264' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '94000' WHERE ordernumber = 'P2502130000265' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '455878' WHERE ordernumber = 'P2502130000267' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '120996' WHERE ordernumber = 'P2502130000269' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '432608' WHERE ordernumber = 'P2502130000270' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '455877' WHERE ordernumber = 'P2502130000271' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '433040' WHERE ordernumber = 'P2502130000276' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '206261' WHERE ordernumber = 'P2502130000281' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '455881' WHERE ordernumber = 'P2502130000287' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '455881' WHERE ordernumber = 'P2502130000288' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '455883' WHERE ordernumber = 'P2502130000289' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '212189' WHERE ordernumber = 'P2502130000292' 2025-02-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '455884' WHERE ordernumber = 'P2502130000298' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '455885' WHERE ordernumber = 'P2502130000300' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '275484' WHERE ordernumber = 'P2502130000304' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '349380' WHERE ordernumber = 'P2502130000306' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '200751' WHERE ordernumber = 'P2502130000310' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '290301' WHERE ordernumber = 'P2502130000316' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '352199' WHERE ordernumber = 'P2502130000323' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '273285' WHERE ordernumber = 'P2502130000324' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '455890' WHERE ordernumber = 'P2502130000327' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '453402' WHERE ordernumber = 'P2502130000328' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '455891' WHERE ordernumber = 'P2502130000329' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '275913' WHERE ordernumber = 'P2502130000333' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '372758' WHERE ordernumber = 'P2502130000338' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '233302' WHERE ordernumber = 'P2502130000341' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '455892' WHERE ordernumber = 'P2502130000348' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '455894' WHERE ordernumber = 'P2502130000357' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '455895' WHERE ordernumber = 'P2502130000362' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '274832' WHERE ordernumber = 'P2502130000371' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '382353' WHERE ordernumber = 'P2502130000373' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '455897' WHERE ordernumber = 'P2502130000380' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '327548' WHERE ordernumber = 'P2502130000385' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '415293' WHERE ordernumber = 'P2502130000392' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '455899' WHERE ordernumber = 'P2502130000393' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '396460' WHERE ordernumber = 'P2502130000397' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '248048' WHERE ordernumber = 'P2502130000403' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '223482' WHERE ordernumber = 'P2502130000413' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '455903' WHERE ordernumber = 'P2502130000414' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '455871' WHERE ordernumber = 'P2502130000416' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '455873' WHERE ordernumber = 'P2502130000417' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '305825' WHERE ordernumber = 'P2502130000419' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '455904' WHERE ordernumber = 'P2502130000421' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '79320' WHERE ordernumber = 'P2502130000430' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '402168' WHERE ordernumber = 'P2502130000434' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '353554' WHERE ordernumber = 'P2502130000436' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '353554' WHERE ordernumber = 'P2502130000437' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '455905' WHERE ordernumber = 'P2502130000442' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '454723' WHERE ordernumber = 'P2502130000452' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '455905' WHERE ordernumber = 'P2502130000455' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '393164' WHERE ordernumber = 'P2502130000463' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '64131' WHERE ordernumber = 'P2502130000465' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '332953' WHERE ordernumber = 'P2502130000466' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '420640' WHERE ordernumber = 'P2502130000467' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '455908' WHERE ordernumber = 'P2502130000471' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '453825' WHERE ordernumber = 'P2502130000487' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '289391' WHERE ordernumber = 'P2502130000489' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '250023' WHERE ordernumber = 'P2502130000500' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '348787' WHERE ordernumber = 'P2502130000503' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '455910' WHERE ordernumber = 'P2502130000505' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '304863' WHERE ordernumber = 'P2502130000507' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '451031' WHERE ordernumber = 'P2502130000508' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '455910' WHERE ordernumber = 'P2502130000509' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '1484' WHERE ordernumber = 'P2502130000513' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '455913' WHERE ordernumber = 'P2502130000522' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '455914' WHERE ordernumber = 'P2502130000526' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '455914' WHERE ordernumber = 'P2502130000527' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '398069' WHERE ordernumber = 'P2502130000528' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '411697' WHERE ordernumber = 'P2502130000532' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '284675' WHERE ordernumber = 'P2502130000535' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '173407' WHERE ordernumber = 'P2502130000538' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '455916' WHERE ordernumber = 'P2502130000541' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '455917' WHERE ordernumber = 'P2502130000543' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '455917' WHERE ordernumber = 'P2502130000548' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '140090' WHERE ordernumber = 'P2502130000549' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '54989' WHERE ordernumber = 'P2502130000551' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '455921' WHERE ordernumber = 'P2502130000554' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '54989' WHERE ordernumber = 'P2502130000561' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '455921' WHERE ordernumber = 'P2502130000563' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '455923' WHERE ordernumber = 'P2502130000566' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '324082' WHERE ordernumber = 'P2502130000568' 2025-02-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '366061' WHERE ordernumber = 'P2502130000574'