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

September 16, 2024

XTERRA Ruidoso Brings the Off-Road Challenge to New Mexico’s Sierra Blanca

RUIDOSO, NEW MEXICO, USA /ENDURANCE SPORTSWIRE/ – The first ever XTERRA event in Lincoln National Forest set in the Sierra Blanca mountain range will take place from August 15-17 as a major addition to the 2025 XTERRA Americas Tour. Off-road triathletes, trail runners and their families are invited to Grindstone...

Cycling

Events

Press Releases

Running

Triathlon

September 14, 2024

Svensson and de Boer Crowned European Champions at Challenge Almere-Amsterdam

/ENDURANCE SPORTSWIRE/ - With a European Long Distance title at stake, dozens of professional athletes took off Saturday morning at Challenge Almere-Amsterdam. After a spectacular race, decided only in the final stages, Jesper Svensson (SWE) and Marlene de Boer (NED) earned the European Champion titles. De Boer not only won...

Events

Press Releases

Triathlon

September 14, 2024

Thousands of Riders Participate in 41st Annual Life Time Chequamegon MTB Festival presented by Trek

Cable, Wis., (Sept. 14, 2024) /ENDURANCE SPORTSWIRE/ - The 2024 Life Time Chequamegon MTB Festival presented by Trek, owned and produced by Life Time (NYSE: LTH), brought more than 2,800 riders to northern Wisconsin on Saturday. The Chequamegon MTB Festival is the oldest and longest-running mountain bike race in the...

Cycling

Events

Press Releases

September 13, 2024

Polartec Wins 2024 R&D 100 Award for Power Shield Pro

Planet Earth, The Universe (September 13, 2024) /OUTDOOR SPORTSWIRE/ - Polartec, a Milliken & Company brand and the premium creator of innovative and more sustainable textile solutions, is proud to announce that its Power Shield™ Pro fabric, which incorporates Biolon™* plant-based nylon, has won the prestigious 2024 R&D 100 Award...

Awards

Press Releases

September 13, 2024

IRONMAN Launches Brand-New Docuseries: AN IRON WILL

- Season 1 of ‘AN IRON WILL’ launches today with five episodes available to view now on the IRONMAN YouTube channel www.youtube.com/@ironmantriathlon, on Outside TV and DAZN - As a prelude to the 2024 IRONMAN World Championship season, ‘AN IRON WILL’ follows five of the world’s best professional triathletes –...

Press Releases

Products

Triathlon

September 13, 2024

Snowbound Expo 2024 Announces Full Speaker Agenda

Boston, MA/ENDURANCE SPORTSWIRE/ – Snowbound Expo, the leading annual event for winter sports enthusiasts, is thrilled to announce its speaker agenda in its entirety for its long-standing ski and snowboard expo taking place November 15-17, 2024 at the Boston Convention & Exhibition Center. The highly anticipated speaking program celebrates New England...

Press Releases

Trade Shows

September 13, 2024

Sportive Breaks and Team Visma | Lease a Bike come together to offer fans the ultimate cycling experiences

September 2024, Manchester UK /ENDURANCE SPORTSWIRE/ – Cycling travel experts Sportive Breaks are excited to announce that they are the exclusive fan and hospitality travel partner of Team Visma | Lease a Bike. They will be teaming up with the world’s most successful cycling team to offer fans a way...

Cycling

Press Releases

Sponsorship

September 13, 2024

Official Nonprofits Selected for 2025 Austin Marathon®

AUSTIN, Texas, September 13, 2024 /ENDURANCE SPORTSWIRE/ – The Ascension Seton Austin Marathon is excited to announce the full roster of charities selected for their 2025 Austin Marathon Gives program. Austin Marathon Gives is the Official Charity Program for the Austin Marathon®. Each non-profit will raise awareness for their mission...

Events

Giving

Press Releases

Running