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 (8742)
) 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 3680, 10

February 17, 2023

The IRONMAN Foundation Celebrates 20th Anniversary

TAMPA, Fla. (Feb. 17, 2023) /ENDURANCE SPORTSWIRE/ - This month, The IRONMAN Foundation, whose mission is to create positive, tangible change in IRONMAN® and Rock ‘n’ Roll® Running Series race communities through grant funding and volunteerism, kicks off the celebration of its 20th anniversary of service. Since its inception in...

Giving

Press Releases

Running

Triathlon

February 17, 2023

Non-Executive Board Established for the Adventure Racing World Series

/ENDURANCE SPORTSWIRE/ - Following the announcement of new ownership for the Adventure Racing World Series, under the leadership of Heidi Muller, a new Non-Executive Board has been formed and held their first meetings and discussions. The formation of the new board and its inaugural meeting on February 9th, took place...

Business

Press Releases

February 17, 2023

Best Bike Split Announces 2023 Season Partners

Austin, TX /ENDURANCE SPORTSWIRE/ - Best Bike Split, the leading provider of race-pacing technology and analysis, is proud to announce its continued support of the World's top Men's and Women's cycling teams in 2023. The company will sponsor teams competing at the highest UCI World Tour level, including CANYON//SRAM, Trek-Segafredo,...

Cycling

Press Releases

Sponsorship

Triathlon

February 17, 2023

The Ascension Seton Austin Marathon Weekend Kicks Off Today

AUSTIN, Texas, February 17, 2023 /ENDURANCE SPORTSWIRE/ – The Ascension Seton Austin Marathon, Half Marathon and 5k is set to take place this weekend in Austin, Texas. Highlights of this world-class event include three race distances for participants of all speeds and abilities, the Health & Fitness Expo, and a 3-block-long...

Events

Press Releases

Running

February 16, 2023

AbbottWMM Global Run Club launches The Road to the Majors

MEDIA ALERT February 16, 2023 /ENDURANCE SPORTSWIRE/ – The AbbottWMM Global Run Club today launched a virtual six-race half marathon series - The Road to the Majors – to give runners on their Six Star journey additional chances to enter draws for the Abbott World Marathon Majors they still need to accomplish. For each...

Events

Press Releases

Running

February 16, 2023

SMITH Announces New Partnership with Santa Cruz RockShox Pro XC Team

Portland, Oregon (February 16, 2023) /ENDURANCE SPORTSWIRE/ – Smith is excited to announce this week its global partnership with the Santa Cruz RockShox Pro XC team as the official supplier of bike helmets and performance eyewear for the 2023-2024 seasons. The UCI World Cup Santa Cruz RockShox Pro XC team is...

Cycling

Press Releases

Sponsorship

February 16, 2023

GFNY Mandalika: bikes meet Superbikes

NEW YORK CITY, February 16, 2023 /ENDURANCE SPORTSWIRE/ – GFNY Global Endurance Sports Series announces GFNY Mandalika, scheduled for May 28, 2023. The competitive long distance stretches over 136km with 1675m of climbing. Start and finish will be hosted at the international race track at Mandalika Street Circuit. The one year...

Cycling

Events

Press Releases

February 16, 2023

Kane Footwear Brings Recovery Footwear to Nordstrom

Westport, CT /ENDURANCE SPORTSWIRE/ - Kane Footwear, a leader in active recovery footwear, is now available in 12 select Nordstrom stores and Nordstrom.com, having expanded to six additional brick and mortar stores this week. In celebration of launching with their first major retailer, Kane has designed an exclusive Olive colorway...

Business

Press Releases

Products