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

October 20, 2021

Des Moines, Iowa Announced as Newest Host of Full-Distance IRONMAN Triathlon and Will Be Designated as the IRONMAN North American Championship

DES MOINES, Iowa. / TAMPA, Fla. (October 20, 2021) /ENDURANCE SPORTSWIRE/ - IRONMAN announced today that Des Moines, Iowa will become the newest host of a full-distance IRONMAN® triathlon. Following the excitement built off the IRONMAN® 70.3® event in 2021, the new full-distance IRONMAN triathlon will take the place of...

Events

Press Releases

Triathlon

October 20, 2021

XTERRA Worlds is a GO for Dec. 4-5 in Maui

/ENDURANCE SPORTSWIRE/ - The XTERRA Trail Run and Off-Road Triathlon World Championship races have received the green light from Maui County to proceed as planned on December 4-5, 2021, at The Ritz-Carlton, Kapalua on Maui. All participants must be vaccinated OR test negative for COVID-19 every 72 hours (12 years...

Events

Press Releases

Running

Triathlon

October 20, 2021

The IRONMAN Group and Madison Area Sports Commission Celebrates 20 Years With Partnership Extension To Continue Hosting IRONMAN Events In Madison, Wisconsin

MADISON, Wis. / TAMPA, Fla. (Oct. 20, 2021) /ENDURANCE SPORTSWIRE/ - Celebrating 20 Years of IRONMAN Wisconsin, IRONMAN in partnership with the Madison Area Sports Commission have announced a multi-year extension for IRONMAN® and IRONMAN® 70.3® events to continue to be hosted in Madison, Wisconsin. As part of the agreement,...

Events

Press Releases

Triathlon

October 20, 2021

GFNY Italia races Tuscany’s historic strade bianche

/ENDURANCE SPORTSWIRE/ - GFNY was back on Italian soil with the GFNY Championship Europe at GFNY Italia last Sunday. The main challenge of the 101 km course with 1889m of climbing and gradients up to 20% were 26 km of “strade bianche” (white gravel road). The 5 km climb to...

Cycling

Events

Press Releases

October 20, 2021

BMW Dallas Marathon Festival Will Be First U.S. Marathon Course To Feature SuperStarch-based Energy Pouch ‘UCAN Edge’

(DALLAS) /ENDURANCE SPORTSWIRE/ - The UCAN Company will return this year as an official sponsor of the BMW Dallas Marathon Festival weekend, where it will debut its innovative new product UCAN Edge, the first and only SuperStarch-based energy product in a portable pouch. “Races are a wonderful opportunity to bring people...

Events

Press Releases

Products

Running

Sponsorship

October 20, 2021

National Champions, World Champions and Olympians Will Be Competing at The Into The Lion’s Den Powered By SRAM Women’s Race

SACRAMENTO, CA (October 20, 2021) /ENDURANCE SPORTSWIRE/ - Into the Lion’s Den powered by SRAM announced the women’s teams racing in Sacramento, CA on October 30th. The women’s race will feature top U.S. trade teams, including L39ION of Los Angeles, Rally Pro Cycling and Twenty-24 Cycling Team, plus international powerhouse Team...

Cycling

Events

Press Releases

October 19, 2021

Showcased

The Application Window for the 2022 Bank of America Chicago Marathon Opens Today

CHICAGO /ENDURANCE SPORTSWIRE/ - Today the Bank of America Chicago Marathon announced it is accepting applications for the 2022 event at chicagomarathon.com. The launch of the 2022 application continues Chicago’s return to racing and builds on the excitement seen over a week ago when 26,122 participants crossed the finish line...

Events

Press Releases

Running