2025-02-08 01:00:02 -- 將會員中心id寫入data-lake 2025-02-08 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-07%'; 2025-02-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '455068' WHERE ordernumber = 'P2502070000011' 2025-02-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '163712' WHERE ordernumber = 'P2502070000014' 2025-02-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '298853' WHERE ordernumber = 'P2502070000016' 2025-02-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '436336' WHERE ordernumber = 'P2502070000017' 2025-02-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '378451' WHERE ordernumber = 'P2502070000018' 2025-02-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '249481' WHERE ordernumber = 'P2502070000023' 2025-02-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '455071' WHERE ordernumber = 'P2502070000028' 2025-02-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '57329' WHERE ordernumber = 'P2502070000031' 2025-02-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '275459' WHERE ordernumber = 'P2502070000032' 2025-02-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '97517' WHERE ordernumber = 'P2502070000034' 2025-02-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '455072' WHERE ordernumber = 'P2502070000038' 2025-02-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '381145' WHERE ordernumber = 'P2502070000039' 2025-02-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '283840' WHERE ordernumber = 'P2502070000040' 2025-02-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '283689' WHERE ordernumber = 'P2502070000041' 2025-02-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '163712' WHERE ordernumber = 'P2502070000044' 2025-02-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '110061' WHERE ordernumber = 'P2502070000045' 2025-02-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '94143' WHERE ordernumber = 'P2502070000046' 2025-02-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '455073' WHERE ordernumber = 'P2502070000053' 2025-02-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '289050' WHERE ordernumber = 'P2502070000054' 2025-02-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '455074' WHERE ordernumber = 'P2502070000055' 2025-02-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '238090' WHERE ordernumber = 'P2502070000062' 2025-02-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '455076' WHERE ordernumber = 'P2502070000063' 2025-02-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '454886' WHERE ordernumber = 'P2502070000064' 2025-02-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '381594' WHERE ordernumber = 'P2502070000075' 2025-02-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '455079' WHERE ordernumber = 'P2502070000080' 2025-02-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '455077' WHERE ordernumber = 'P2502070000083' 2025-02-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '389788' WHERE ordernumber = 'P2502070000084' 2025-02-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '380655' WHERE ordernumber = 'P2502070000086' 2025-02-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '455082' WHERE ordernumber = 'P2502070000091' 2025-02-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '455081' WHERE ordernumber = 'P2502070000097' 2025-02-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '286567' WHERE ordernumber = 'P2502070000099' 2025-02-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '277148' WHERE ordernumber = 'P2502070000100' 2025-02-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '163199' WHERE ordernumber = 'P2502070000101' 2025-02-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '432511' WHERE ordernumber = 'P2502070000102' 2025-02-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '380655' WHERE ordernumber = 'P2502070000105' 2025-02-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '455083' WHERE ordernumber = 'P2502070000106' 2025-02-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '209443' WHERE ordernumber = 'P2502070000110' 2025-02-08 01:00:03 -- UPDATE `omo_order_list` SET userId = '420802' WHERE ordernumber = 'P2502070000111' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '455084' WHERE ordernumber = 'P2502070000112' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '455085' WHERE ordernumber = 'P2502070000113' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '32906' WHERE ordernumber = 'P2502070000114' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '142524' WHERE ordernumber = 'P2502070000117' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '455086' WHERE ordernumber = 'P2502070000119' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '455087' WHERE ordernumber = 'P2502070000121' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '455088' WHERE ordernumber = 'P2502070000124' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '455089' WHERE ordernumber = 'P2502070000126' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '423434' WHERE ordernumber = 'P2502070000129' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '455091' WHERE ordernumber = 'P2502070000130' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '429254' WHERE ordernumber = 'P2502070000133' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '453400' WHERE ordernumber = 'P2502070000136' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '455092' WHERE ordernumber = 'P2502070000139' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '295651' WHERE ordernumber = 'P2502070000142' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '455093' WHERE ordernumber = 'P2502070000151' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '376600' WHERE ordernumber = 'P2502070000156' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '118407' WHERE ordernumber = 'P2502070000161' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '246892' WHERE ordernumber = 'P2502070000171' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '100788' WHERE ordernumber = 'P2502070000178' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '455000' WHERE ordernumber = 'P2502070000179' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '455096' WHERE ordernumber = 'P2502070000181' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '367339' WHERE ordernumber = 'P2502070000182' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '455098' WHERE ordernumber = 'P2502070000191' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '455099' WHERE ordernumber = 'P2502070000193' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '300465' WHERE ordernumber = 'P2502070000201' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '455100' WHERE ordernumber = 'P2502070000202' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '455101' WHERE ordernumber = 'P2502070000203' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '427023' WHERE ordernumber = 'P2502070000213' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '455103' WHERE ordernumber = 'P2502070000216' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '427379' WHERE ordernumber = 'P2502070000228' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '296543' WHERE ordernumber = 'P2502070000229' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '451191' WHERE ordernumber = 'P2502070000230' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '384019' WHERE ordernumber = 'P2502070000231' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '379086' WHERE ordernumber = 'P2502070000232' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '183185' WHERE ordernumber = 'P2502070000238' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '453812' WHERE ordernumber = 'P2502070000239' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '268183' WHERE ordernumber = 'P2502070000245' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '455080' WHERE ordernumber = 'P2502070000246' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '301776' WHERE ordernumber = 'P2502070000249' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '431543' WHERE ordernumber = 'P2502070000255' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '453136' WHERE ordernumber = 'P2502070000256' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '455106' WHERE ordernumber = 'P2502070000258' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '455108' WHERE ordernumber = 'P2502070000267' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '228801' WHERE ordernumber = 'P2502070000268' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '455109' WHERE ordernumber = 'P2502070000269' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '455110' WHERE ordernumber = 'P2502070000271' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '455111' WHERE ordernumber = 'P2502070000276' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '87785' WHERE ordernumber = 'P2502070000277' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '424029' WHERE ordernumber = 'P2502070000280' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '266356' WHERE ordernumber = 'P2502070000282' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '451439' WHERE ordernumber = 'P2502070000300' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '451439' WHERE ordernumber = 'P2502070000303' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '455113' WHERE ordernumber = 'P2502070000305' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '65477' WHERE ordernumber = 'P2502070000306' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '275397' WHERE ordernumber = 'P2502070000307' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '384251' WHERE ordernumber = 'P2502070000308' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '455114' WHERE ordernumber = 'P2502070000312' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '455115' WHERE ordernumber = 'P2502070000313' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '377350' WHERE ordernumber = 'P2502070000314' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '455116' WHERE ordernumber = 'P2502070000316' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '285547' WHERE ordernumber = 'P2502070000319' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '81896' WHERE ordernumber = 'P2502070000324' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '455119' WHERE ordernumber = 'P2502070000325' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '113482' WHERE ordernumber = 'P2502070000328' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '386723' WHERE ordernumber = 'P2502070000340' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '373295' WHERE ordernumber = 'P2502070000343' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '392618' WHERE ordernumber = 'P2502070000344' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '148024' WHERE ordernumber = 'P2502070000346' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '150074' WHERE ordernumber = 'P2502070000348' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '455122' WHERE ordernumber = 'P2502070000356' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '106086' WHERE ordernumber = 'P2502070000357' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '207380' WHERE ordernumber = 'P2502070000360' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '455124' WHERE ordernumber = 'P2502070000364' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '455125' WHERE ordernumber = 'P2502070000366' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '455126' WHERE ordernumber = 'P2502070000367' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '455019' WHERE ordernumber = 'P2502070000370' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '455129' WHERE ordernumber = 'P2502070000375' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '87789' WHERE ordernumber = 'P2502070000376' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '455130' WHERE ordernumber = 'P2502070000377' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '455131' WHERE ordernumber = 'P2502070000384' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '455132' WHERE ordernumber = 'P2502070000389' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '455133' WHERE ordernumber = 'P2502070000393' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '401933' WHERE ordernumber = 'P2502070000394' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '99477' WHERE ordernumber = 'P2502070000400' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '99477' WHERE ordernumber = 'P2502070000403' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '322324' WHERE ordernumber = 'P2502070000404' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '239611' WHERE ordernumber = 'P2502070000405' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '455134' WHERE ordernumber = 'P2502070000407' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '455135' WHERE ordernumber = 'P2502070000409' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '455136' WHERE ordernumber = 'P2502070000410' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '423113' WHERE ordernumber = 'P2502070000411' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '455137' WHERE ordernumber = 'P2502070000414' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '396700' WHERE ordernumber = 'P2502070000415' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '208555' WHERE ordernumber = 'P2502070000417' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '455138' WHERE ordernumber = 'P2502070000424' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '313606' WHERE ordernumber = 'P2502070000425' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '455139' WHERE ordernumber = 'P2502070000426' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '455140' WHERE ordernumber = 'P2502070000430' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '455141' WHERE ordernumber = 'P2502070000433' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '220798' WHERE ordernumber = 'P2502070000434' 2025-02-08 01:00:04 -- UPDATE `omo_order_list` SET userId = '455142' WHERE ordernumber = 'P2502070000443' 2025-02-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '117366' WHERE ordernumber = 'P2502070000444' 2025-02-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '442190' WHERE ordernumber = 'P2502070000445' 2025-02-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '455143' WHERE ordernumber = 'P2502070000451' 2025-02-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '455145' WHERE ordernumber = 'P2502070000457' 2025-02-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '455146' WHERE ordernumber = 'P2502070000459' 2025-02-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '455032' WHERE ordernumber = 'P2502070000466' 2025-02-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '302047' WHERE ordernumber = 'P2502070000477' 2025-02-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '454979' WHERE ordernumber = 'P2502070000483' 2025-02-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '455148' WHERE ordernumber = 'P2502070000485' 2025-02-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '128867' WHERE ordernumber = 'P2502070000486' 2025-02-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '109872' WHERE ordernumber = 'P2502070000487' 2025-02-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '392062' WHERE ordernumber = 'P2502070000491' 2025-02-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '455149' WHERE ordernumber = 'P2502070000500' 2025-02-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '379256' WHERE ordernumber = 'P2502070000503' 2025-02-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '403226' WHERE ordernumber = 'P2502070000505' 2025-02-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '125486' WHERE ordernumber = 'P2502070000508' 2025-02-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '455150' WHERE ordernumber = 'P2502070000512' 2025-02-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '337787' WHERE ordernumber = 'P2502070000519' 2025-02-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '319280' WHERE ordernumber = 'P2502070000523' 2025-02-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '262949' WHERE ordernumber = 'P2502070000525' 2025-02-08 01:00:05 -- UPDATE `omo_order_list` SET userId = '433440' WHERE ordernumber = 'P2502070000531'