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

September 18, 2024

Nouveau Souffle Daily: 2024 Vinfast IRONMAN World Championship Race Week Recap for Tuesday, September 17

NICE, France /ENDURANCE SPORTSWIRE/ - Race week is officially here! Excitement and suspense is building as the very best female professional triathletes and age-groupers descend on the city of Nice for the women's 2024 VinFast IRONMAN® World Championship triathlon, taking place on Sunday, Sept 22. This will be the first time...

Events

Press Releases

Triathlon

September 18, 2024

Top Female Triathletes from Around the World to Descend on The French Riveria for the 2024 VinfasT IRONMAN World Championship Triathlon

NICE, France / TAMPA, Fla. (Sept. 17, 2024) – The best female triathletes from around the world are set to take centre stage on Sunday 22 September as they line up on the shores of the Côte d’Azur for the 2024 VinFast IRONMAN ® World Championship® triathlon in Nice, France....

Events

Press Releases

Triathlon

September 18, 2024

Introducing the greatest in on-the-go recovery

FORT WAYNE, Ind. — September 18, 2024 /ENDURANCE SPORTSWIRE/ – Master Spas, a leading manufacturer of hot tubs and swim spas, is proud to announce the latest product from Michael Phelps Chilly GOAT Cold Tubs. The Chilly GOAT GO! is perfect for athletes, fitness enthusiasts, and wellness seekers who are...

Press Releases

Products

September 18, 2024

The Hi Tec Catalina Island Half Marathon & 10K Will Provide Participants with Exclusive Trail Running Access

AVALON, Calif. /ENDURANCE SPORTSWIRE/ - The Hi Tec Catalina Island Half Marathon & 10K will be hosting hundreds of participants on Catalina Island on Saturday, Nov. 9. The event will include a half marathon distance (13.1 miles) and a 10K distance (6.2 miles), both providing scenic tours on exclusive trail...

Press Releases

Running

September 17, 2024

GOREWEAR Unveils New Technical and Thermal Run and Bike Styles for Fall 2024

Elkton, MD (September 17, 2024) /ENDURANCE SPORTSWIRE/ - GOREWEAR, the leading innovator in high-performance running and cycling apparel, introduces its new Fall/Winter 2024 product lineup, including updates to the brand’s popular Concurve and Spinshift collections. Each collection expands upon its technical performance adding new fall/winter specific thermal styles. Starting with...

Press Releases

Products

September 17, 2024

Maven Adds To Its C Series Spotting Scope Line With The CS.2A

LANDER, Wyo. (Sept. 17, 2024) /ENDURANCE SPORTSWIRE/ - Maven, a Wyoming-based direct-to-consumer brand known for offering world-class optics at affordable prices, has added to its award-winning line of C Series spotting scopes with the CS.2A. The CS.2A is the brand’s first expansion of the C series spotting scopes since the...

Press Releases

Products

September 17, 2024

GFNY comes to The Bahamas this November 3rd

New York, September 17, 2024 /ENDURANCE SPORTSWIRE/ - GFNY Global Endurance Sports Series adds The Bahamas to the 2024 race schedule on November 3. The competitive long distance is 60.8 miles long with 1392 ft of climbing. GFNY Bahamas will offer participants two race options, catering to both seasoned athletes...

Cycling

Events

Press Releases

September 17, 2024

Stellar Line Up at the Third Edition of Challenge Sanremo

/ENDURANCE SPORTSWIRE/ – The third edition of Challenge Sanremo is set to take place on 21 and 22 September 2024, with two days of racing featuring a complete programme and a stellar field of over 60 professional athletes. The middle-distance race on Sunday promises to be a highlight, with standout...

Events

Press Releases

Triathlon

September 17, 2024

Northern California’s Prestigious Endurance Race Returns to Cool, California

Cool, California /ENDURANCE SPORTSWIRE/ - Click here to register today for the 35th Annual Way Too Cool 50K & Inaugural 10 Mile Endurance Runs Presented by Altra. Registration is now open, and we expect both distances to sell out before the end of year. Secure early bird pricing through September...

Events

Press Releases

Running