2025-02-09 01:00:01 -- 將會員中心id寫入data-lake 2025-02-09 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-08%'; 2025-02-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '455174' WHERE ordernumber = 'P2502080000020' 2025-02-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '420641' WHERE ordernumber = 'P2502080000023' 2025-02-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '455175' WHERE ordernumber = 'P2502080000028' 2025-02-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '455176' WHERE ordernumber = 'P2502080000032' 2025-02-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '455178' WHERE ordernumber = 'P2502080000041' 2025-02-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '315109' WHERE ordernumber = 'P2502080000045' 2025-02-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '391920' WHERE ordernumber = 'P2502080000046' 2025-02-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '455180' WHERE ordernumber = 'P2502080000048' 2025-02-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '455181' WHERE ordernumber = 'P2502080000050' 2025-02-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '455051' WHERE ordernumber = 'P2502080000051' 2025-02-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '455051' WHERE ordernumber = 'P2502080000052' 2025-02-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '455182' WHERE ordernumber = 'P2502080000054' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '391920' WHERE ordernumber = 'P2502080000057' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '373869' WHERE ordernumber = 'P2502080000059' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '455183' WHERE ordernumber = 'P2502080000071' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '392030' WHERE ordernumber = 'P2502080000073' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '142518' WHERE ordernumber = 'P2502080000076' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '437636' WHERE ordernumber = 'P2502080000077' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '455186' WHERE ordernumber = 'P2502080000078' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '455187' WHERE ordernumber = 'P2502080000081' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '455188' WHERE ordernumber = 'P2502080000082' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '455189' WHERE ordernumber = 'P2502080000088' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '433748' WHERE ordernumber = 'P2502080000089' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '455192' WHERE ordernumber = 'P2502080000090' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '229425' WHERE ordernumber = 'P2502080000094' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '212237' WHERE ordernumber = 'P2502080000096' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '132889' WHERE ordernumber = 'P2502080000098' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '455193' WHERE ordernumber = 'P2502080000100' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '454789' WHERE ordernumber = 'P2502080000104' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '455195' WHERE ordernumber = 'P2502080000109' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '142066' WHERE ordernumber = 'P2502080000114' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '142066' WHERE ordernumber = 'P2502080000115' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '455196' WHERE ordernumber = 'P2502080000120' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '455197' WHERE ordernumber = 'P2502080000123' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '455198' WHERE ordernumber = 'P2502080000126' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '455200' WHERE ordernumber = 'P2502080000128' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '380797' WHERE ordernumber = 'P2502080000130' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '455201' WHERE ordernumber = 'P2502080000131' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '455202' WHERE ordernumber = 'P2502080000133' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '455203' WHERE ordernumber = 'P2502080000134' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '396718' WHERE ordernumber = 'P2502080000139' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '455199' WHERE ordernumber = 'P2502080000140' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '316385' WHERE ordernumber = 'P2502080000143' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '339872' WHERE ordernumber = 'P2502080000146' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '435040' WHERE ordernumber = 'P2502080000153' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '304317' WHERE ordernumber = 'P2502080000155' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '233829' WHERE ordernumber = 'P2502080000157' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '280922' WHERE ordernumber = 'P2502080000160' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '455205' WHERE ordernumber = 'P2502080000162' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '455206' WHERE ordernumber = 'P2502080000166' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '455207' WHERE ordernumber = 'P2502080000167' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '455208' WHERE ordernumber = 'P2502080000169' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '455209' WHERE ordernumber = 'P2502080000173' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '455210' WHERE ordernumber = 'P2502080000177' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '455211' WHERE ordernumber = 'P2502080000181' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '100034' WHERE ordernumber = 'P2502080000185' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '267870' WHERE ordernumber = 'P2502080000190' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '455213' WHERE ordernumber = 'P2502080000191' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '455212' WHERE ordernumber = 'P2502080000194' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '110935' WHERE ordernumber = 'P2502080000202' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '346834' WHERE ordernumber = 'P2502080000203' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '445269' WHERE ordernumber = 'P2502080000205' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '455214' WHERE ordernumber = 'P2502080000206' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '445269' WHERE ordernumber = 'P2502080000214' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '435396' WHERE ordernumber = 'P2502080000217' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '300147' WHERE ordernumber = 'P2502080000219' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '455215' WHERE ordernumber = 'P2502080000222' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '168878' WHERE ordernumber = 'P2502080000227' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '455216' WHERE ordernumber = 'P2502080000230' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '296288' WHERE ordernumber = 'P2502080000233' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '113482' WHERE ordernumber = 'P2502080000237' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '455217' WHERE ordernumber = 'P2502080000242' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '339488' WHERE ordernumber = 'P2502080000243' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '455218' WHERE ordernumber = 'P2502080000244' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '221939' WHERE ordernumber = 'P2502080000246' 2025-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '455220' WHERE ordernumber = 'P2502080000249' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '299880' WHERE ordernumber = 'P2502080000251' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '455221' WHERE ordernumber = 'P2502080000254' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '335693' WHERE ordernumber = 'P2502080000275' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '444037' WHERE ordernumber = 'P2502080000277' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '124017' WHERE ordernumber = 'P2502080000282' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '455226' WHERE ordernumber = 'P2502080000285' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '217445' WHERE ordernumber = 'P2502080000288' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '217445' WHERE ordernumber = 'P2502080000293' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '217445' WHERE ordernumber = 'P2502080000303' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '142556' WHERE ordernumber = 'P2502080000305' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '289319' WHERE ordernumber = 'P2502080000310' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '420968' WHERE ordernumber = 'P2502080000313' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '231930' WHERE ordernumber = 'P2502080000314' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '237468' WHERE ordernumber = 'P2502080000321' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '335023' WHERE ordernumber = 'P2502080000323' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '392688' WHERE ordernumber = 'P2502080000325' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '455229' WHERE ordernumber = 'P2502080000326' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '455230' WHERE ordernumber = 'P2502080000327' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '103510' WHERE ordernumber = 'P2502080000330' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '381359' WHERE ordernumber = 'P2502080000332' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '379013' WHERE ordernumber = 'P2502080000335' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '455232' WHERE ordernumber = 'P2502080000340' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '455233' WHERE ordernumber = 'P2502080000343' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '259709' WHERE ordernumber = 'P2502080000346' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '455234' WHERE ordernumber = 'P2502080000349' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '455235' WHERE ordernumber = 'P2502080000353' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '455236' WHERE ordernumber = 'P2502080000356' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '401945' WHERE ordernumber = 'P2502080000358' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '455160' WHERE ordernumber = 'P2502080000362' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '455238' WHERE ordernumber = 'P2502080000367' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '455240' WHERE ordernumber = 'P2502080000369' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '455241' WHERE ordernumber = 'P2502080000372' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '455242' WHERE ordernumber = 'P2502080000378' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '455243' WHERE ordernumber = 'P2502080000391' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '92895' WHERE ordernumber = 'P2502080000402' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '95519' WHERE ordernumber = 'P2502080000412' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '455174' WHERE ordernumber = 'P2502080000428' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '212696' WHERE ordernumber = 'P2502080000430' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '356333' WHERE ordernumber = 'P2502080000435' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '161640' WHERE ordernumber = 'P2502080000445' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '369507' WHERE ordernumber = 'P2502080000448' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '139551' WHERE ordernumber = 'P2502080000450' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '416497' WHERE ordernumber = 'P2502080000451' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '455222' WHERE ordernumber = 'P2502080000452' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '455222' WHERE ordernumber = 'P2502080000454' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '364203' WHERE ordernumber = 'P2502080000456' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '455245' WHERE ordernumber = 'P2502080000459' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '455245' WHERE ordernumber = 'P2502080000463' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '455245' WHERE ordernumber = 'P2502080000465' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '455246' WHERE ordernumber = 'P2502080000474' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '100750' WHERE ordernumber = 'P2502080000475' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '352250' WHERE ordernumber = 'P2502080000476' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '98323' WHERE ordernumber = 'P2502080000480' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '267984' WHERE ordernumber = 'P2502080000482' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '455247' WHERE ordernumber = 'P2502080000483' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '455248' WHERE ordernumber = 'P2502080000489' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '307021' WHERE ordernumber = 'P2502080000494' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '455249' WHERE ordernumber = 'P2502080000495' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '224390' WHERE ordernumber = 'P2502080000498' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '431883' WHERE ordernumber = 'P2502080000501' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '455251' WHERE ordernumber = 'P2502080000509' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '97572' WHERE ordernumber = 'P2502080000532' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '400072' WHERE ordernumber = 'P2502080000539' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '455168' WHERE ordernumber = 'P2502080000552' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '316303' WHERE ordernumber = 'P2502080000567' 2025-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '455252' WHERE ordernumber = 'P2502080000575' 2025-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '380301' WHERE ordernumber = 'P2502080000577' 2025-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '448607' WHERE ordernumber = 'P2502080000582' 2025-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '455253' WHERE ordernumber = 'P2502080000584' 2025-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '455254' WHERE ordernumber = 'P2502080000585' 2025-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '403465' WHERE ordernumber = 'P2502080000590' 2025-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '95106' WHERE ordernumber = 'P2502080000597' 2025-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '376155' WHERE ordernumber = 'P2502080000599' 2025-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '455255' WHERE ordernumber = 'P2502080000612' 2025-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '445769' WHERE ordernumber = 'P2502080000619' 2025-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '99941' WHERE ordernumber = 'P2502080000633' 2025-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '455258' WHERE ordernumber = 'P2502080000637' 2025-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '429676' WHERE ordernumber = 'P2502080000638' 2025-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '399413' WHERE ordernumber = 'P2502080000646' 2025-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '455259' WHERE ordernumber = 'P2502080000649' 2025-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '229957' WHERE ordernumber = 'P2502080000651' 2025-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '455261' WHERE ordernumber = 'P2502080000654' 2025-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '365387' WHERE ordernumber = 'P2502080000668' 2025-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '217317' WHERE ordernumber = 'P2502080000671' 2025-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '455265' WHERE ordernumber = 'P2502080000675' 2025-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '436839' WHERE ordernumber = 'P2502080000679'