2025-02-06 01:00:01 -- 將會員中心id寫入data-lake 2025-02-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-02-05%'; 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '454864' WHERE ordernumber = 'P2502050000011' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '276053' WHERE ordernumber = 'P2502050000012' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '431742' WHERE ordernumber = 'P2502050000017' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '96014' WHERE ordernumber = 'P2502050000018' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '346441' WHERE ordernumber = 'P2502050000020' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '449060' WHERE ordernumber = 'P2502050000025' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '333852' WHERE ordernumber = 'P2502050000026' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '454865' WHERE ordernumber = 'P2502050000029' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '353554' WHERE ordernumber = 'P2502050000031' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '454866' WHERE ordernumber = 'P2502050000043' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '313605' WHERE ordernumber = 'P2502050000044' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '127195' WHERE ordernumber = 'P2502050000045' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '448517' WHERE ordernumber = 'P2502050000047' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '115668' WHERE ordernumber = 'P2502050000048' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '118407' WHERE ordernumber = 'P2502050000054' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '25451' WHERE ordernumber = 'P2502050000064' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '25451' WHERE ordernumber = 'P2502050000065' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '432653' WHERE ordernumber = 'P2502050000070' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '432290' WHERE ordernumber = 'P2502050000080' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '282487' WHERE ordernumber = 'P2502050000082' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '112568' WHERE ordernumber = 'P2502050000091' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '99638' WHERE ordernumber = 'P2502050000096' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '447175' WHERE ordernumber = 'P2502050000098' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '269501' WHERE ordernumber = 'P2502050000102' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '284241' WHERE ordernumber = 'P2502050000103' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '284241' WHERE ordernumber = 'P2502050000107' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '435040' WHERE ordernumber = 'P2502050000112' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '450631' WHERE ordernumber = 'P2502050000113' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '434069' WHERE ordernumber = 'P2502050000116' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '454872' WHERE ordernumber = 'P2502050000117' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '313610' WHERE ordernumber = 'P2502050000123' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '453449' WHERE ordernumber = 'P2502050000124' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '454873' WHERE ordernumber = 'P2502050000127' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '396899' WHERE ordernumber = 'P2502050000128' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '308729' WHERE ordernumber = 'P2502050000131' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '454874' WHERE ordernumber = 'P2502050000136' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '451339' WHERE ordernumber = 'P2502050000139' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '454875' WHERE ordernumber = 'P2502050000140' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '454876' WHERE ordernumber = 'P2502050000141' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '99566' WHERE ordernumber = 'P2502050000143' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '102558' WHERE ordernumber = 'P2502050000146' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '137217' WHERE ordernumber = 'P2502050000147' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '454877' WHERE ordernumber = 'P2502050000149' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '225050' WHERE ordernumber = 'P2502050000155' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '454878' WHERE ordernumber = 'P2502050000164' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '454879' WHERE ordernumber = 'P2502050000171' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '431742' WHERE ordernumber = 'P2502050000172' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '330549' WHERE ordernumber = 'P2502050000174' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '454880' WHERE ordernumber = 'P2502050000176' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '343918' WHERE ordernumber = 'P2502050000182' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '433141' WHERE ordernumber = 'P2502050000188' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '454881' WHERE ordernumber = 'P2502050000189' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '346022' WHERE ordernumber = 'P2502050000199' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '346022' WHERE ordernumber = 'P2502050000200' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '454883' WHERE ordernumber = 'P2502050000201' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '294478' WHERE ordernumber = 'P2502050000202' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '352047' WHERE ordernumber = 'P2502050000208' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '454884' WHERE ordernumber = 'P2502050000212' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '274507' WHERE ordernumber = 'P2502050000214' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '303548' WHERE ordernumber = 'P2502050000216' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '387029' WHERE ordernumber = 'P2502050000217' 2025-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '454885' WHERE ordernumber = 'P2502050000223' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '148716' WHERE ordernumber = 'P2502050000226' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '454887' WHERE ordernumber = 'P2502050000228' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '454889' WHERE ordernumber = 'P2502050000229' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '454682' WHERE ordernumber = 'P2502050000232' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '325003' WHERE ordernumber = 'P2502050000233' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '111709' WHERE ordernumber = 'P2502050000236' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '282325' WHERE ordernumber = 'P2502050000237' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '116658' WHERE ordernumber = 'P2502050000241' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '111709' WHERE ordernumber = 'P2502050000242' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '423437' WHERE ordernumber = 'P2502050000243' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '454892' WHERE ordernumber = 'P2502050000247' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '423437' WHERE ordernumber = 'P2502050000249' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '423048' WHERE ordernumber = 'P2502050000251' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '454893' WHERE ordernumber = 'P2502050000254' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '454894' WHERE ordernumber = 'P2502050000256' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '454896' WHERE ordernumber = 'P2502050000258' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '454897' WHERE ordernumber = 'P2502050000260' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '110093' WHERE ordernumber = 'P2502050000262' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '454898' WHERE ordernumber = 'P2502050000263' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '142903' WHERE ordernumber = 'P2502050000264' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '454899' WHERE ordernumber = 'P2502050000265' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '147325' WHERE ordernumber = 'P2502050000266' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '352257' WHERE ordernumber = 'P2502050000267' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '454903' WHERE ordernumber = 'P2502050000278' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '454901' WHERE ordernumber = 'P2502050000279' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '454900' WHERE ordernumber = 'P2502050000281' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '292586' WHERE ordernumber = 'P2502050000283' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '422379' WHERE ordernumber = 'P2502050000284' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '454905' WHERE ordernumber = 'P2502050000290' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '431549' WHERE ordernumber = 'P2502050000291' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '399531' WHERE ordernumber = 'P2502050000293' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '283778' WHERE ordernumber = 'P2502050000295' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '337221' WHERE ordernumber = 'P2502050000296' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '386961' WHERE ordernumber = 'P2502050000300' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '454906' WHERE ordernumber = 'P2502050000303' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '422789' WHERE ordernumber = 'P2502050000305' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '387120' WHERE ordernumber = 'P2502050000315' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '454907' WHERE ordernumber = 'P2502050000319' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '380348' WHERE ordernumber = 'P2502050000320' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '48899' WHERE ordernumber = 'P2502050000323' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '228119' WHERE ordernumber = 'P2502050000326' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '454910' WHERE ordernumber = 'P2502050000327' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '454911' WHERE ordernumber = 'P2502050000328' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '454912' WHERE ordernumber = 'P2502050000330' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '454913' WHERE ordernumber = 'P2502050000332' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '76352' WHERE ordernumber = 'P2502050000334' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '454914' WHERE ordernumber = 'P2502050000335' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '454915' WHERE ordernumber = 'P2502050000336' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '388031' WHERE ordernumber = 'P2502050000337' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '69217' WHERE ordernumber = 'P2502050000338' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '454918' WHERE ordernumber = 'P2502050000341' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '454917' WHERE ordernumber = 'P2502050000342' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '454919' WHERE ordernumber = 'P2502050000345' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '361975' WHERE ordernumber = 'P2502050000348' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '257296' WHERE ordernumber = 'P2502050000351' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '454920' WHERE ordernumber = 'P2502050000352' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '454921' WHERE ordernumber = 'P2502050000353' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '454922' WHERE ordernumber = 'P2502050000355' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '454923' WHERE ordernumber = 'P2502050000356' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '454924' WHERE ordernumber = 'P2502050000361' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '454925' WHERE ordernumber = 'P2502050000362' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '304511' WHERE ordernumber = 'P2502050000366' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '324602' WHERE ordernumber = 'P2502050000367' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '97572' WHERE ordernumber = 'P2502050000370' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '454926' WHERE ordernumber = 'P2502050000377' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '315722' WHERE ordernumber = 'P2502050000379' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '116975' WHERE ordernumber = 'P2502050000387' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '251234' WHERE ordernumber = 'P2502050000389' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '452598' WHERE ordernumber = 'P2502050000394' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '116975' WHERE ordernumber = 'P2502050000396' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '222161' WHERE ordernumber = 'P2502050000409' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '445118' WHERE ordernumber = 'P2502050000414' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '445118' WHERE ordernumber = 'P2502050000416' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '454929' WHERE ordernumber = 'P2502050000426' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '454930' WHERE ordernumber = 'P2502050000429' 2025-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '454931' WHERE ordernumber = 'P2502050000430' 2025-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '168504' WHERE ordernumber = 'P2502050000431' 2025-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '378725' WHERE ordernumber = 'P2502050000432' 2025-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '87579' WHERE ordernumber = 'P2502050000435' 2025-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '454932' WHERE ordernumber = 'P2502050000438' 2025-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '426525' WHERE ordernumber = 'P2502050000441' 2025-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '454933' WHERE ordernumber = 'P2502050000447' 2025-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '431549' WHERE ordernumber = 'P2502050000460' 2025-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '50069' WHERE ordernumber = 'P2502050000465' 2025-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '427361' WHERE ordernumber = 'P2502050000473' 2025-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '143325' WHERE ordernumber = 'P2502050000476' 2025-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '454935' WHERE ordernumber = 'P2502050000480' 2025-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '454935' WHERE ordernumber = 'P2502050000483' 2025-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '167388' WHERE ordernumber = 'P2502050000489' 2025-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '365482' WHERE ordernumber = 'P2502050000492' 2025-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '141618' WHERE ordernumber = 'P2502050000501' 2025-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '265748' WHERE ordernumber = 'P2502050000504' 2025-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '454940' WHERE ordernumber = 'P2502050000505' 2025-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '454942' WHERE ordernumber = 'P2502050000507' 2025-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '453971' WHERE ordernumber = 'P2502050000520' 2025-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '305876' WHERE ordernumber = 'P2502050000522'