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

November 17, 2023

Exploring the Mountains of Mexico with La Ruta Madre Adventure Race

/ENDURANCE SPORTSWIRE/ – La Ruta Madre Expedition Race starts on Saturday and the new ARWS Demonstration race will give teams the chance to explore the mountains and canyons of Nuevo Leon province in Mexico. Teams from the US, Canada and Mexico can expect a great adventure on a tough 500km...

Events

Press Releases

November 17, 2023

BibRave Helps Strava Shine at the New York City Marathon

New York, NY /ENDURANCE SPORTSWIRE/ – BibRave, the leading-edge endurance and fitness marketing agency, recently crafted an engaging weekend of events at the New York City Marathon for the connected fitness platform, Strava. The multi-day event brought together athletes, creators, and spectators to celebrate running and women’s sports. The weekend of...

Events

Press Releases

November 17, 2023

Over 3000 racers at 10th edition of GFNY Cozumel

New York City, November 17, 2023 /ENDURANCE SPORTSWIRE/ - The completely closed to traffic 157.5km cycling long race course of the 10th GFNY Cozumel is flat yet windy and as such one of the toughest bike races in Latin America. 3000 riders were ready to race hard and play hard,...

Cycling

Events

Press Releases

November 16, 2023

USA Triathlon Announces 2024 State Championships Calendar

COLORADO SPRINGS, Colo. /ENDURANCE SORTSWIRE/ - USA Triathlon today unveiled the dates and locations for the 2024 USA Triathlon State Championships, a robust calendar of local, USA Triathlon sanctioned events across the United State that give athletes around the country the opportunity to race for state titles and qualify for...

Events

Press Releases

Triathlon

November 16, 2023

ORTLIEB Repair Week 2023 – Repair Rather Than Rebuy

AUBURN, Washington, USA /ENDURANCE SPORTSWIRE/ – Renowned for its unwavering commitment to durability and sustainability, ORTLIEB, the German manufacturer of premium waterproof backpacks, panniers, and travel bags, proudly announces the return of its annual Repair Weeks, running from November 13th to December 3rd, 2023. During this time, ORTLIEB will be offering...

Press Releases

Products

November 16, 2023

Destination Sport Experiences launches ultimate training camps programme, with seven world-class sports resorts

16th November 2023 - Manchester, UK/ENDURANCE SPORTSWIRE/ – Destination Sport Experiences takes athletes to participate in the best cycling, running and triathlon events all over the world. For 2024 it launches a programme of training camps at seven top sports resorts to help them prepare in the perfect environment. These work...

Business

Cycling

Press Releases

Running

Triathlon

November 16, 2023

Olympic Hopefuls, U.S. Olympian Carrie Tollefson Announced for Main Stage Panel at 2024 Running USA Industry Conference

ORLANDO (Nov. 16, 2023) – Running USA is excited to announce the first of many conference events connected to the U.S. Olympic Marathon Team Trials at the 2024 Industry Conference presented by haku in Orlando, Jan. 31-Feb. 2, 2023. Not registered for the world’s biggest and best running industry yet?...

Press Releases

Running

Trade Shows

November 16, 2023

A Gift Guide for Strong Girls from Strong Girl Publishing

The holiday season is here, and at Strong Girl Publishing, we've got the perfect gifts to inspire and empower the young girls and women in your life. Let's dive into our holiday gift guide and discover the perfect presents that will help your daughters, nieces, grandkids, friends and teammates become...

Cycling

Press Releases

Products

Running

November 16, 2023

IMBA Welcomes BikeInsure as Official Mountain Bicycle Insurance Partner

Boulder, Colorado / November 16, 2023 /ENDURANCE SPORTSWIRE/ – BikeInsure and IMBA announce a partnership bringing affordable, opt-in bicycle insurance to IMBA members. BikeInsure is a specialty bicycle insurance company that offers coverage to all adult residents in the United States. IMBA lives into its mission to create, enhance, and protect...

Business

Cycling

Press Releases

November 16, 2023

GROSCHE to be the Official Drinkware of Spartan U.S. and Canada

BOSTON, MASS. (November 16, 2023) — Spartan, the world’s leading endurance sports and extreme wellness brand, announced that GROSCHE is an official sponsor, and designated GROSCHE water bottles will be the official drinkware of Spartan U.S. and Canada. “We are excited to be Partnering with GROSCHE for a number of...

Press Releases

Running

Sponsorship