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

May 18, 2023

XTERRA World Cup LIVE makes U.S. debut in Shelby County, AL on Sunday

/ENDURANCE SPORTSWIRE/ – The adrenaline-fueled XTERRA Oak Mountain Short Track race will be streamed live on Sunday at 4pm EST with two triathlon Hall of Famers, Bob Babbitt and Jamie Whitmore, calling all the action. Watch it live: https://www.xterraplanet.com/watch-live Round two of the 2023 XTERRA World Cup at Oak Mountain State...

Events

Press Releases

Triathlon

May 18, 2023

Live this Sunday: 11th GFNY World Championship NYC

NEW YORK CITY, May 18, 2023 /ENDURANCE SPORTSWIRE/ – The 11th GFNY World Championship NYC will be broadcast live on Sunday May 21 from 6am ET until noon on GFNY.COM, Youtube and Facebook. Thousands of riders including pros and amateurs alike fight for the GFNY World Championship crown on the 85.1...

Cycling

Events

Press Releases

May 17, 2023

Carmel Marathon Weekend to Return for 14th Annual Event Under New Management

CARMEL, Ind. (May 17, 2023)/ENDURANCE SPORTSWIRE/ – CRRG Events announced today that Full Circle Events has acquired the Carmel Marathon Weekend. Full Circle Events, based in central Indiana, will produce and manage the popular springtime race held annually in Carmel, Indiana. CRRG Events will work with Full Circle Events through the...

Business

Events

Press Releases

Running

May 17, 2023

11th GFNY World Championship NYC on May 21, 2023

NEW YORK CITY /ENDURANCE SPORTSWIRE/ - The 11th GFNY World Championship NYC represents the pinnacle of GFNY Endurance Sports Series and its 30+ races in 2023. GFNY is now the world's largest cycling marathon series with over 40 races expected to be held in 2024. Get the official GFNY NYC...

Cycling

Events

Press Releases

May 17, 2023

Military Veterans and Veteran Runners to Run 100-Mile Relay Up The Coast of Massachusetts

BOSTON/ENDURANCE SPORTSWIRE/ – Starting in Veterans Park in Hyannis and ending in Boston Common, a new relay race event will take more than a dozen runners 100 miles up the coast of the state of Massachusetts. The TREK Relay for Veterans features two teams: one comprised of military veterans and the...

Events

Giving

Press Releases

Running

May 16, 2023

Panamá to Host the IRONMAN 70.3 Latin America Triclub Championship in 2024

PANAMÁ CITY, Panamá / TAMPA, Fla. (May 16, 2023)/ENDURANCE SPORTSWIRE/ – IRONMAN today announced that the IRONMAN® 70.3® Panamá triathlon presented by Heineken 0.0 taking place on February 25, 2024, will be designated as the 2024 Latin America TriClub Championship. Panamá will be stop #1 on the 2024 Global IRONMAN TriClub...

Events

Press Releases

Triathlon

May 16, 2023

Whitefish Marathon Preparing for New Course Records, Championship-Level Competition and Festive Atmosphere

WHITEFISH, Mont. (May 16, 2023)/ENDURANCE SPORTSWIRE/ - Participants from nearly 40 states will be vying for personal bests and course records at the 16th annual Whitefish Marathon, Half Marathon and 5K Powered by Hammer Nutrition this Saturday, May 20, 2023 in Whitefish, Montana. Held in the shadows of Glacier National...

Events

Press Releases

Running