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

July 3, 2024

2024 XTERRA France Preview: Xonrupt Eruption

XONRUPT, VOSGES, FRANCE /ENDURANCE SPORTSWIRE/ - XTERRA France gears up for its 17th annual off-road triathlon, set in the scenic Vosges mountains and Lake Longemer. The Full Distance race on Sunday, July 7th, is the 13th stop of the 2024 XTERRA EMEA Tour and a crucial qualifier, offering 58 World...

Events

Press Releases

Triathlon

July 3, 2024

2024 Maine Summer Adventure Race will go island hopping

/ENDURANCE SPORTSWIRE/ - The Maine Summer Adventure Race will take its participants island hopping in its eighth annual edition on July 13-14, 2024. The 3-hour, 8-hour, and 24-hour editions of Maine’s only U.S. Adventure Racing Association- and Adventure Race World Series-sanctioned adventure race will take teams of two to four...

Events

Press Releases

July 3, 2024

Showcased

All-new Parlee Taos Gravel Bike Brings Next-Level Traction

JULY 3, 2024 - Beverly, MA /ENDURANCE SPORTSWIRE/ - “Gravel” has become more than just riding on dirt roads. More than a way to escape traffic and routine. It’s how we immerse ourselves in our environment, and the all-new Parlee Taos delivers an entirely new level of compliance that not only...

Business

Cycling

Press Releases

Products

July 3, 2024

Registration now open for GranFondo Whistler – Riviera Nayarit 2025

Mexico City, July 2, 2024. /ENDURANCE SPORTSWIRE/ – We are pleased to announce the first edition in Mexico of the GranFondo Whistler – Riviera Nayarit, which will take place on Saturday, April 5, 2025, in Bahía de Banderas, Nayarit. The GranFondo Whistler, held for 15 years in Canada, is one of...

Business

Cycling

Events

Press Releases

July 3, 2024

The 11th Annual Swim for Alligator Lighthouse is Helping Save One of Florida’s Treasures

Fernandina Beach, Florida /ENDURANCE SPORTSWIRE/ - The Swim for Alligator Lighthouse, located in Islamorada, FL, is the fourth stop on the Speedo SALT Series. This international, 8-mile swim is a challenge unlike any other and is not for the faint of heart. During this bucket list, tropical open water swim,...

Events

Press Releases

July 2, 2024

TrainingPeaks Partners with the Elite Trail Team to Support the Growth of Trail and Ultra Running

Media Contact: Sean VanHorn, Backbone Media Phone: 970-963-4873 ext. 1806 Email: sean.vanhorn@backbone.media Louisville, Colo., July 2, 2024 — TrainingPeaks, the industry-leading training app for endurance coaches and athletes, announced today a new partnership with the Elite Trail Team (ETT) — a team of trail and ultra runners who compete in...

Press Releases

Running

Sponsorship

July 2, 2024

DATEV Challenge Roth Set to Host One of The Greatest Professional Fields of the Year

Juny 12, 2024 - ENDURANCE SPORTSWIRE - This weekend, the triathlon world will gather in Roth, Germany, for DATEV Challenge Roth, the largest long-distance triathlon event globally. Roth, known as the home of triathlon, will welcome more than 90 professional athletes, including many of the top 10 athletes in the...

Events

Press Releases

Triathlon

July 2, 2024

New Leader in Challenge Family Pro Athlete World Bonus

/ENDURANCE SPORTSWIRE/ This weekend’s racing at Challenge Cagnes-sur-Mer saw Aurélia Boulanger (FRA) take the women’s lead in the Challenge Family Pro Athlete World Bonus rankings while Jack Moody (NZL) cemented his place at the top of the men’s league. Boulanger’s win on the French Riviera was her third of the...

Events

Press Releases

Triathlon

July 2, 2024

Borah Teamwear Unveils Eco-Conscious Retail Line: Embracing Sustainability, One Stitch at a Time

Media Contact: Chris Jackson chrisj@mtborahllc.com Coon Valley, Wisconsin, July 2, 2024 - ENDURANCE SPORTSWIRE/ In a groundbreaking move that marries sustainability with high-performance athletic wear, Borah Teamwear is proud to announce the reintroduction of its retail product line, now entirely crafted from recycled materials. This innovative collection, designed and manufactured...

Cycling

Press Releases

Products

Running

Triathlon

July 2, 2024

USA Cycling and Fast Talk Laboratories Launch Two New CEU Courses for Coaches

July 2, 2024 – Boulder, Colorado, USA /ENDURANCE SPORTSWIRE/ USA Cycling and Fast Talk Laboratories have partnered to launch two new Continuing Education Unit (CEU) courses for USA Cycling coaches. Focused on developing communication skills and building more effective training plans, these two courses can help coaches meet USA Cycling’s reinstated...

Cycling

Press Releases

Products