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

September 2, 2025

Cool Fall Temps Provides Fast Times at the 15th Indiana Women’s Running Festival

CARMEL, Ind. /ENDURANCE SPORTSWIRE/ - Sunshine, smiles and fast times were abundant as Indiana Women’s Running Festival kicked off Labor Day Weekend in Carmel, Ind. Ladies participated in three different race distances, the half marathon, 10K and the Get a MOVE on Cancer 5K, competing for the $4,600 in total...

Events

Press Releases

September 2, 2025

Van Rysel Makes Canadian Debut At The Grand Prix Cycliste De Montréal

Montréal, QC (Sept 2, 2025) /ENDURANCE SPORTSWIRE/ – Born in the wind, cold and cobblestones of Northern France, VAN RYSEL, the high-performance cycling brand and partner of the Decathlon AG2R La Mondiale World Tour team, will make its first appearance in Canada during the prestigious Grand Prix Cycliste de Montréal....

Business

Events

Press Releases

September 2, 2025

Okemos Wolf Run Medal Features Color-Changing Design — Wolf Puts on a Red Coat Under Sunlight

OKEMOS, Michigan /ENDURANCE SPORTSWIRE/ - The Okemos Wolf Run is taking finisher bling to the next level with a bold, color-changing medal. This year’s custom design features the race’s iconic wolf character, which appears in a white jersey indoors but transforms under sunlight — turning into a vivid red wolf,...

Events

Press Releases

Products

Running

September 1, 2025

Professional Triathletes Organisation & Visit Qatar Unviel Lusail Venue To Host 2025 Qatar T100 Triathlon World Championship Final

Lusail venue revealed as season-long ‘T100 Race to Qatar’ reaches its climax GCC festival of sport to inspire residents and visitors alike Dubai T100 sets the stage before the T100 World Champions are crowned in Qatar Doha, Qatar (September 1, 2025) /ENDURANCE SPORTSWIRE/ - The Professional Triathletes Organisation (PTO), World Triathlon,...

Events

Press Releases

Triathlon

August 31, 2025

Pimentel and Lopes Take Titles at Inaugural Challenge Fortaleza

/ENDURANCE SPORTSWIRE/ - Danilo Pimentel (BRA) and Vittoria Lopes (BRA) took the wins at the first-ever Challenge Fortaleza, overcoming tough conditions with strong winds, rain, and heat along the Brazilian coast. In the men’s race, it was a battle from the start between Danilo Pimentel (BRA) and Igor Amorelli (BRA),...

Events

Press Releases

Triathlon

August 31, 2025

Boxer Tommy Fury Takes On The T100 At This Weekend’s French Riviera T100 Triathlon

Saint Raphael-Frejus, France /ENDURANCE SPORTSWIRE/ - Boxer Tommy Fury followed in Team Ramsay’s London T100 footsteps by taking on the T100 this weekend at the French Riviera T100 Triathlon in Saint Raphael and Frejus on the Esterel Cote D’Azur. The T100 is a triathlon involving a 2km swim, 80km bike and 18km run. He battled in a sparkling...

Press Releases

Triathlon

August 30, 2025

The Executive Track Returns for Second Year as Outdoor Industry’s Only CEO-Focused Conference

DURANGO, CO /ENDURANCE SPORTSWIRE/ - The Executive Track, the outdoor industry's premier conference exclusively designed for CEOs of emerging product brands, announced its return for a second year and will be co-located with Outdoor Media Summit, October 27-29, 2025 in Durango, Colorado. Following a successful inaugural year that attracted 30 CEOs...

Business

Events

Press Releases

Trade Shows

August 29, 2025

Zoot Sports Launches 2026 Wetsuit Collection Featuring the Wikiwiki Aurora FLEX

Carlsbad, CA (August 29, 2025) /ENDURANCE SPORTSWIRE/ — Zoot Sports, the original triathlon brand from Kona, Hawaii, has unveiled its 2026 wetsuit collection led by the all-new Wikiwiki Aurora FLEX, the fastest and most advanced wetsuit the brand has ever created. Designed for elite athletes, the Aurora FLEX features Yamamoto FLEXskin BRS...

Press Releases

Products

Triathlon

August 28, 2025

Star-Studded Men’s Professional Field Revealed for 2025 IRONMAN World Championship in Nice, France

NICE, France (Aug. 28, 2025) /ENDURANCE SPORTSWIRE/ - The stage is set for a seismic showdown in Nice, France as the world’s best professional and amateur male triathletes are set to assemble for the men’s 2025 IRONMAN World Championship® triathlon on Sunday, 14 September. The star-studded pro list includes former...

Events

Press Releases

Triathlon