SELECT SQL_CALC_FOUND_ROWS  wp_posts.*, IF(wppm.meta_value= 1, 'YES', NULL) as showcased
			 FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_postmeta as wppm ON (wp_posts.ID = wppm.post_id AND wppm.meta_key = 'promoted')
			 WHERE 1=1  AND ( 
  wp_term_relationships.term_taxonomy_id IN (16)
) AND wp_posts.post_type = 'post' AND ((wp_posts.post_status = 'publish')) AND wp_posts.ID NOT IN ( SELECT ID FROM wp_posts WHERE post_type IN ('post','page','attachment','job_listing','podcasts','industry-news','product','business-directory','testimonial') AND ID IN ( SELECT post_id FROM wp_postmeta pm WHERE pm.meta_key = 'groups-read' AND pm.meta_value NOT IN (0) AND pm.meta_value IN ( SELECT group_id FROM wp_groups_group ) AND post_id NOT IN ( SELECT post_id FROM wp_postmeta pm WHERE pm.meta_key = 'groups-read' AND pm.meta_value IN (0) ) ) )  AND wp_posts.ID IN  (    SELECT ID FROM wp_posts WHERE ID NOT IN ( SELECT post_id FROM wp_postmeta WHERE wp_postmeta.meta_key = 'groups-groups_read_post' )    UNION ALL    SELECT post_id AS ID FROM wp_postmeta WHERE wp_postmeta.meta_key = 'groups-groups_read_post' AND wp_postmeta.meta_value IN ('')  ) 
			 GROUP BY wp_posts.ID
			 ORDER BY wp_posts.menu_order,  wp_posts.menu_order, wp_posts.post_date DESC
			 LIMIT 2930, 10

October 3, 2022

Pau Hana: 2022 VinFast IRONMAN World Championship Daily Recap for Monday, October 3, 2022

KAILUA-KONA, Hawai`i (October 3, 2022) /ENDURANCE SPORTSWIRE/ – Race week for the 2022 VinFast IRONMAN World Championship continued today in Kailua-Kona, Hawai`i as both race days inched closer with the Parade of Nations and opening of VinFast IRONMAN World Championship Village expo. Here is the daily Pau Hana, a Hawaiian phrase...

Events

Press Releases

Triathlon

October 3, 2022

For the First Time in Three Years, Athletes from Across the Globe Head to The Island of Hawai`i for The 2022 Vinfast IRONMAN World Championship

KAILUA-KONA, Hawai`i (October 3, 2022) /ENDURANCE SPORTSWIRE/ – More than 5,000 registered athletes from around the globe will converge on the Island of Hawai`i for the 2022 VinFast IRONMAN® World Championship triathlon. For the first time in the event’s 40-plus year history, the 2022 VinFast IRONMAN World Championship will take place as...

Events

Press Releases

Triathlon

October 2, 2022

“I Am True” Day Continues For 12th Year at the 2022 VinFast IRONMAN World Championship In Promotion of Clean Sport And Integrity of Racing

KAILUA-KONA, Hawai`i / TAMPA, Fla. (October 2, 2022) /ENDURANCE SPORTSWIRE/ - In conjunction with the 2022 VinFast IRONMAN® World Championship, today, Sunday, October 2nd marks the 12th I AM TRUE Day. The I AM TRUE initiative focuses on important work with athletes and the triathlon community to promote clean sport...

Events

Press Releases

Triathlon

October 2, 2022

IRONMAN Reveals Course and Community Enhancements in Anticipation of Return to Kailua-Kona for 2022 VinFast IRONMAN World Championship

KAILUA-KONA, Hawai`i /ENDURANCE SPORTSWIRE/ - As part of the return to Kailua-Kona, Hawai`i Island after a three-year hiatus, IRONMAN announced course modifications and community enhancements to the 2022 VinFast IRONMAN® World Championship triathlon. The course and transition adjustments are aimed to increase accessibility and traffic flow for the Kailua-Kona community...

Events

Press Releases

Triathlon

October 1, 2022

Record Setting Day at the Indy Half Marathon at Fort Ben

LAWRENCE, IN /ENDURANCE SPORTSWIRE/ - The 27th running of the Indy Half Marathon at Fort Ben took place this morning in record setting fashion at historic Fort Benjamin Harrison in Lawrence, Indiana. Four race distances were contested; a Half Marathon, a newly added 10K, a 5K, and a Kids One...

Events

Press Releases

October 1, 2022

Peter Johnsrud (St Louis, Mo.) and Kirsten Sass (Mckenzie Tenn.) Claim Victories at 2022 St. Jude IRONMAN 70.3 Memphis Triathlon

MEMPHIS, Tenn. (October 1, 2022) – Memphis, Tennessee and Shelby Farms Park played host to the second edition of the 2022 St. Jude IRONMAN® 70.3® Memphis triathlon on Saturday, October 1. With some of triathlon’s best on hand, the event benefiting St. Jude Children’s Research Hospital® saw the athletes attempt...

Events

Press Releases

Triathlon

September 30, 2022

Finsterwald and Dong take top honors in The Pikes Peak APEX presented by RockShox

Colorado Springs, CO, September 30, 2022 /ENDURANCE SPORTSWIRE/ – After 4 days of racing, Russell Finsterwald (Specialized Off Road) and Evelyn Dong (Juliana/SRAM) beat strong fields to win the overall general classification at the Pikes Peak APEX. Two brand new courses challenged the field of riders along with two courses used in...

Cycling

Events

Press Releases

September 30, 2022

Women’s Triathlon Coming to Nashville

  September 30, 2022 /ENDURANCE SPORTSWIRE/ - Team Magic has announced the addition of the Inaugural Nashville Women’s Triathlon to its 2023 race season, taking place at Music City’s central Centennial Park on Sunday, May 21. Nashville’s only women’s-focused triathlon will feature both Sprint and Super-Sprint distance options with a...

Events

Press Releases

Triathlon

September 30, 2022

City of Medford to name track in honor of Dave McGillivray

MEDFORD, Mass. /ENDURANCE SPORTSWIRE/ – As participants prepared to cross the starting line at the Run Medford 5k and 8k on Sept. 18, Medford Mayor Breanna Lungo-Koehn made a surprise announcement to the crowd. To thank Race Director and native son Dave McGillivray for his impact on the local community, she...

Events

Press Releases

Running

September 30, 2022

Paraguay Delivers a Dream Destination for the 2022 Adventure Racing World Championship

/ENDURANCE SPORTSWIRE/ – At the closing ceremony for the 2022 Adventure Racing World Championship, Race Director Gustavo Borgognon said, “Ten years ago I had a dream to bring the World Championship to Paraguay, to show my country to the world. People always asked me; ‘Where is Paraguay?’ and now I want...

Events

Press Releases