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

May 19, 2023

The 2023 GFNY Hall of Fame Inductees

New York City, May 19, 2023/ENDURANCE SPORTSWIRE/ – On May 21, 2023, GFNY is holding the 11th edition of the GFNY World Championship NYC. On this occasion, the GFNY Hall of Fame will honor five new inductees to recognize their contribution to GFNY. In alphabetical order: Chris Geiser started at GFNY...

Cycling

Events

Press Releases

May 18, 2023

Davis Phinney Foundation Proudly Announces the 2023 Tour de Victory Cycling Challenge

Boulder, Colo. /ENDURANCE SPORTSWIRE/ - The Tour De Victory Cycling Challenge, a unique Colorado charity ride that raises funds and awareness for the Davis Phinney Foundation, is now open for registration and their list of 2023 sponsors and partners has been released. We are thrilled to announce that this year’s ride opening...

Business

Cycling

Events

Press Releases

May 18, 2023

XTERRA Portugal this Saturday in Golega

/ENDURANCE SPORTSWIRE/ – XTERRA Portugal, the sixth of 21 stops on the 2023 XTERRA EMEA Tour, takes place Saturday, May 20, in the beautiful countryside surrounding Golega. Horses rule the cobble-lined narrow streets in this historic village, which is known as the Portuguese capital of horses, so athletes can expect plenty...

Events

Press Releases

Triathlon

May 18, 2023

FRESHJUNKIE Racing named as a Finalist for Sports ETA – Event Partnership of the Year with the War Eagle Run Fest

AUBURN, AL./ENDURANCE SPORTSWIRE/ – FRESHJUNKIE Racing, a leading event management company, is proud to announce its recognition as a finalist for Sports Events and Tourism Association Event Partnership of the Year in markets under 500,000 with the War Eagle Run Fest. The annual event, which took place in its inaugural year...

Awards

Events

Press Releases

Running

Sponsorship

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