2025-02-05 01:00:02 -- 將會員中心id寫入data-lake 2025-02-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-02-04%'; 2025-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '454754' WHERE ordernumber = 'P2502040000013' 2025-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '448177' WHERE ordernumber = 'P2502040000018' 2025-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '448177' WHERE ordernumber = 'P2502040000019' 2025-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '102849' WHERE ordernumber = 'P2502040000020' 2025-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '454755' WHERE ordernumber = 'P2502040000022' 2025-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '357970' WHERE ordernumber = 'P2502040000024' 2025-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '454756' WHERE ordernumber = 'P2502040000026' 2025-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '454757' WHERE ordernumber = 'P2502040000027' 2025-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '454758' WHERE ordernumber = 'P2502040000032' 2025-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '209267' WHERE ordernumber = 'P2502040000033' 2025-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '449602' WHERE ordernumber = 'P2502040000035' 2025-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '228228' WHERE ordernumber = 'P2502040000036' 2025-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '245656' WHERE ordernumber = 'P2502040000037' 2025-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '454438' WHERE ordernumber = 'P2502040000038' 2025-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '247094' WHERE ordernumber = 'P2502040000039' 2025-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '127159' WHERE ordernumber = 'P2502040000047' 2025-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '126699' WHERE ordernumber = 'P2502040000049' 2025-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '447335' WHERE ordernumber = 'P2502040000051' 2025-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '454759' WHERE ordernumber = 'P2502040000052' 2025-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '454760' WHERE ordernumber = 'P2502040000057' 2025-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '454761' WHERE ordernumber = 'P2502040000059' 2025-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '289715' WHERE ordernumber = 'P2502040000061' 2025-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '385058' WHERE ordernumber = 'P2502040000063' 2025-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '454763' WHERE ordernumber = 'P2502040000064' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '454764' WHERE ordernumber = 'P2502040000065' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '454765' WHERE ordernumber = 'P2502040000067' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '453432' WHERE ordernumber = 'P2502040000072' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '454766' WHERE ordernumber = 'P2502040000073' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '454767' WHERE ordernumber = 'P2502040000074' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '454768' WHERE ordernumber = 'P2502040000075' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '102365' WHERE ordernumber = 'P2502040000078' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '454769' WHERE ordernumber = 'P2502040000081' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '454770' WHERE ordernumber = 'P2502040000082' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '345768' WHERE ordernumber = 'P2502040000083' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '45947' WHERE ordernumber = 'P2502040000084' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '433845' WHERE ordernumber = 'P2502040000086' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '117500' WHERE ordernumber = 'P2502040000087' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '348545' WHERE ordernumber = 'P2502040000091' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '160054' WHERE ordernumber = 'P2502040000092' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '454771' WHERE ordernumber = 'P2502040000096' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '117187' WHERE ordernumber = 'P2502040000097' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '454772' WHERE ordernumber = 'P2502040000098' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '454773' WHERE ordernumber = 'P2502040000100' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '365102' WHERE ordernumber = 'P2502040000101' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '454774' WHERE ordernumber = 'P2502040000102' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '454775' WHERE ordernumber = 'P2502040000107' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '403557' WHERE ordernumber = 'P2502040000108' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '454777' WHERE ordernumber = 'P2502040000110' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '454778' WHERE ordernumber = 'P2502040000112' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '39509' WHERE ordernumber = 'P2502040000114' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '299849' WHERE ordernumber = 'P2502040000115' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '219136' WHERE ordernumber = 'P2502040000116' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '290410' WHERE ordernumber = 'P2502040000118' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '412009' WHERE ordernumber = 'P2502040000120' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '379719' WHERE ordernumber = 'P2502040000121' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '454780' WHERE ordernumber = 'P2502040000124' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '454781' WHERE ordernumber = 'P2502040000125' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '238431' WHERE ordernumber = 'P2502040000127' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '454783' WHERE ordernumber = 'P2502040000134' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '430358' WHERE ordernumber = 'P2502040000135' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '104419' WHERE ordernumber = 'P2502040000140' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '384748' WHERE ordernumber = 'P2502040000142' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '380043' WHERE ordernumber = 'P2502040000143' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '327700' WHERE ordernumber = 'P2502040000144' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '208634' WHERE ordernumber = 'P2502040000147' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '248052' WHERE ordernumber = 'P2502040000148' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '37851' WHERE ordernumber = 'P2502040000151' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '379127' WHERE ordernumber = 'P2502040000152' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '160114' WHERE ordernumber = 'P2502040000157' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '452631' WHERE ordernumber = 'P2502040000162' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '224149' WHERE ordernumber = 'P2502040000163' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '454785' WHERE ordernumber = 'P2502040000167' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '453561' WHERE ordernumber = 'P2502040000169' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '454787' WHERE ordernumber = 'P2502040000173' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '454789' WHERE ordernumber = 'P2502040000177' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '417755' WHERE ordernumber = 'P2502040000181' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '454757' WHERE ordernumber = 'P2502040000185' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '433141' WHERE ordernumber = 'P2502040000186' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '349761' WHERE ordernumber = 'P2502040000187' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '438552' WHERE ordernumber = 'P2502040000189' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '294793' WHERE ordernumber = 'P2502040000192' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '454790' WHERE ordernumber = 'P2502040000195' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '351806' WHERE ordernumber = 'P2502040000198' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '237179' WHERE ordernumber = 'P2502040000205' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '217554' WHERE ordernumber = 'P2502040000209' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '454791' WHERE ordernumber = 'P2502040000210' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '103972' WHERE ordernumber = 'P2502040000217' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '454792' WHERE ordernumber = 'P2502040000222' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '454793' WHERE ordernumber = 'P2502040000225' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '343585' WHERE ordernumber = 'P2502040000229' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '422835' WHERE ordernumber = 'P2502040000232' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '454794' WHERE ordernumber = 'P2502040000239' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '445632' WHERE ordernumber = 'P2502040000242' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '454795' WHERE ordernumber = 'P2502040000243' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '412610' WHERE ordernumber = 'P2502040000245' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '401271' WHERE ordernumber = 'P2502040000247' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '454797' WHERE ordernumber = 'P2502040000249' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '424356' WHERE ordernumber = 'P2502040000255' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '122014' WHERE ordernumber = 'P2502040000256' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '424044' WHERE ordernumber = 'P2502040000257' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '454801' WHERE ordernumber = 'P2502040000259' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '454799' WHERE ordernumber = 'P2502040000260' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '349590' WHERE ordernumber = 'P2502040000262' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '376561' WHERE ordernumber = 'P2502040000264' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '423662' WHERE ordernumber = 'P2502040000267' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '449599' WHERE ordernumber = 'P2502040000269' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '454800' WHERE ordernumber = 'P2502040000271' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '454787' WHERE ordernumber = 'P2502040000272' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '454800' WHERE ordernumber = 'P2502040000273' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '454803' WHERE ordernumber = 'P2502040000275' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '430747' WHERE ordernumber = 'P2502040000278' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '266261' WHERE ordernumber = 'P2502040000279' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '454805' WHERE ordernumber = 'P2502040000280' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '453155' WHERE ordernumber = 'P2502040000287' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '454806' WHERE ordernumber = 'P2502040000288' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '453829' WHERE ordernumber = 'P2502040000295' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '221676' WHERE ordernumber = 'P2502040000296' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '454808' WHERE ordernumber = 'P2502040000300' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '409641' WHERE ordernumber = 'P2502040000304' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '375470' WHERE ordernumber = 'P2502040000305' 2025-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '121498' WHERE ordernumber = 'P2502040000310' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '38020' WHERE ordernumber = 'P2502040000315' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '382282' WHERE ordernumber = 'P2502040000324' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '433552' WHERE ordernumber = 'P2502040000326' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '433552' WHERE ordernumber = 'P2502040000327' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '454810' WHERE ordernumber = 'P2502040000329' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '454812' WHERE ordernumber = 'P2502040000332' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '341262' WHERE ordernumber = 'P2502040000334' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '160412' WHERE ordernumber = 'P2502040000335' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '397239' WHERE ordernumber = 'P2502040000341' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '237209' WHERE ordernumber = 'P2502040000343' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '454813' WHERE ordernumber = 'P2502040000344' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '444765' WHERE ordernumber = 'P2502040000345' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '421519' WHERE ordernumber = 'P2502040000346' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '444765' WHERE ordernumber = 'P2502040000347' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '237179' WHERE ordernumber = 'P2502040000351' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '429060' WHERE ordernumber = 'P2502040000364' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '454820' WHERE ordernumber = 'P2502040000368' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '415244' WHERE ordernumber = 'P2502040000371' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '311550' WHERE ordernumber = 'P2502040000394' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '454825' WHERE ordernumber = 'P2502040000397' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '454829' WHERE ordernumber = 'P2502040000400' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '371409' WHERE ordernumber = 'P2502040000403' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '454826' WHERE ordernumber = 'P2502040000404' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '454827' WHERE ordernumber = 'P2502040000406' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '454827' WHERE ordernumber = 'P2502040000407' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '388529' WHERE ordernumber = 'P2502040000409' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '454830' WHERE ordernumber = 'P2502040000411' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '274615' WHERE ordernumber = 'P2502040000419' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '406463' WHERE ordernumber = 'P2502040000420' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '403204' WHERE ordernumber = 'P2502040000421' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '454833' WHERE ordernumber = 'P2502040000422' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '345808' WHERE ordernumber = 'P2502040000423' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '363039' WHERE ordernumber = 'P2502040000424' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '454834' WHERE ordernumber = 'P2502040000425' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '276593' WHERE ordernumber = 'P2502040000429' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '428249' WHERE ordernumber = 'P2502040000430' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '110871' WHERE ordernumber = 'P2502040000434' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '277242' WHERE ordernumber = 'P2502040000435' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '301185' WHERE ordernumber = 'P2502040000443' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '441873' WHERE ordernumber = 'P2502040000445' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '454836' WHERE ordernumber = 'P2502040000455' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '141558' WHERE ordernumber = 'P2502040000462' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '448551' WHERE ordernumber = 'P2502040000464' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '454718' WHERE ordernumber = 'P2502040000466' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '453248' WHERE ordernumber = 'P2502040000468' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '454839' WHERE ordernumber = 'P2502040000469' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '93028' WHERE ordernumber = 'P2502040000470' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '454840' WHERE ordernumber = 'P2502040000471' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '454841' WHERE ordernumber = 'P2502040000475' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '454676' WHERE ordernumber = 'P2502040000480' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '228348' WHERE ordernumber = 'P2502040000481' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '454843' WHERE ordernumber = 'P2502040000489' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '439429' WHERE ordernumber = 'P2502040000493' 2025-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '380671' WHERE ordernumber = 'P2502040000498'