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 2950, 10

September 27, 2022

Top Professional Triathletes from Around the World Make Highly Anticipated Return to Kailua-Kona, Hawai`I For The 2022 VinFast IRONMAN World Championship

KAILUA-KONA, Hawai`i / TAMPA, Fla. (September 27, 2022) /ENDURANCE SPORTSWIRE/ - Triathlon’s top professional athletes will return to Kailua-Kona, Hawai`i for the first time in three years for the 2022 VinFast IRONMAN® World Championship triathlon. The most iconic endurance event in the world will bring together nearly 100 of the...

Events

Press Releases

Triathlon

September 27, 2022

Fifth Annual USABA National Blind Sports Week presented by Healthy Vision Association Slated for October 3-8

(Sept. 27, 2022) /ENDURANCE SPORTSWIRE/ – Join the U.S. Association of Blind Athletes for National Blind Sports Week presented by Healthy Vision Association (Oct. 3-8), a six-day celebration focused on participation and awareness of sports and opportunities available to athletes who are blind and visually impaired. The week culminates with the...

Events

Press Releases

September 27, 2022

U.S. Team Announced for Inaugural World Mountain & Trail Running Championship

/ENDURANCE SPORTSWIRE/ – Thirty-nine of the top off-road runners in the United States have been named to the 2022 U.S. Mountain & Trail Running Team scheduled to compete at the inaugural World Mountain & Trail Running Championships November 4-6 in Chiang Mai, Thailand. Hailing from twelve U.S. states, these talented athletes...

Events

Press Releases

Running

September 27, 2022

Abbott World Marathon Majors to award equal prize money to Series Champions

/ENDURANCE SPORTSWIRE/ – The Abbott World Marathon Majors (AbbottWMM) announced today that the Series XIV Champions will receive equal prize money across the elite and elite wheelchair competitions and the prize money fund will be extended to include the top five males and females in both categories. As the world’s biggest...

Events

Press Releases

Running

September 27, 2022

Zambrano and Molineros win 4th GFNY Ecuador Manta

New York City, September 27, 2022 /ENDURANCE SPORTSWIRE/ – Manta, located on the coast of Ecuador, hosted the 4th edition of GFNY Ecuador Manta 2022 this past Sunday. The racecourse was 142.2 km long with 2030m of climbing. The race started off at Barbasquillo Manta, where the first 5km were neutralised...

Cycling

Events

Press Releases

September 27, 2022

Challenge Family and ROUVY Host Indoor Training Camp This Weekend

/ENDURANCE SPORTSWIRE/ - As the Northern Hemisphere days get shorter and the weather gets cooler, Challenge Family and ROUVY have prepared an indoor training camp, using the most realistic virtual riding experience, available on three spectacular Challenge Family bike courses. Triathletes can look forward to a moderate intensity and fun...

Cycling

Events

Press Releases

Triathlon

September 26, 2022

Kū Like and Live Aloha: IRONMAN Introduces Event Theme and Initiative Aimed at A Mindful Return of Vinfast IRONMAN World Championship to Kailua-Kona, Hawai`I

KAILUA-KONA, Hawai`i / TAMPA, Fla. (September 26, 2022) /ENDURANCE SPORTSWIRE/ - In the return to Hawai`i Island for the 2022 VinFast IRONMAN® World Championship race after a three-year hiatus, IRONMAN announced the Live Aloha initiative to build upon and emphasize the Hawai`i Tourism Authority’s push for responsible tourism. For the...

Business

Events

Press Releases

Triathlon

September 26, 2022

Pho3nix Foundation Brings Futures Camp To Poland

/ENDURANCE SPORTSWIRE/ -The Pho3nix Foundation has concluded another successful Pho3nix Future Camp, bringing together 20 high-performing junior athletes in a six-day all expenses-paid experience from the 23rd to 28th of August 2022 in Poznan, Poland. The Pho3nix Future Camp Poland was hosted by MANA Global sports director, Commonwealth Games gold...

Events

Giving

Press Releases