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

September 10, 2023

Swenson and Stephens Win First-Ever Elite Gravel National Titles

GERING, Neb. /ENDURANCE SPORTSWIRE/ - The first-ever USA Cycling Gravel National Championships kicked off on Saturday morning in downtown Gering, Nebraska. In total, 41 separate categories competed for the opportunity to earn a gravel national title across four different courses: 131.4 miles, 88 miles, 52.6 miles, and 24.8 miles. The...

Cycling

Events

Press Releases

September 10, 2023

Spectacular European Championship at Challenge Almere-Amsterdam: Menno Koolhaas wins in new record, stunning victory for Els Visser

/ENDURANCE SPORTSWIRE/ - Two Dutchmen on the top step of the podium at Challenge Almere-Amsterdam: it hasn’t happened for more than ten years, but today of all days, during the European Championships, it happened. On an already historic day Menno Koolhaas broke the course record and finished in 7:36:36 to...

Events

Press Releases

Triathlon

September 9, 2023

Second India National AR Championship Starts at Goa

/ENDURANCE SPORTSWIRE/ – The second 2023 Adventure Racing Championship India (ARCI) takes place this weekend in Goa. The race is a National Championship event which is also the qualifier for the ARWS Asia Regional Championship and is hosted by NthAdventure, India’s only licensed ARWS organization. Adventure Racing is a fast-growing...

Events

Press Releases

September 8, 2023

The IRONMAN Foundation Announces Service Project and Community Giveback for 2023 VinFast IRONMAN World Championship

NICE, France (September 8, 2023)/ENDURANCE SPORTSWIRE/ – The IRONMAN Foundation, Inc., a non-profit organization aiming to create positive, tangible change in race communities through grants and volunteerism efforts, has continued its philanthropic efforts at the men’s edition of the 2023 VinFast IRONMAN® World Championship triathlon taking place in Nice, France on...

Giving

Press Releases

Triathlon

September 8, 2023

The Boston Run Show is shortlisted for the 2023 TSNN Innovation Awards

/ENDURANCE SPORTSWIRE/ – Raccoon Media Group has been shortlisted for this year’s Trade Show News Network (TSNN) Innovation Awards. The Boston Run Show has been recognized and is shortlisted as a finalist for the Consumer Shows category. The awards program will celebrate and honor the “Best of Innovation” – shows...

Awards

Press Releases

Running

Trade Shows

September 8, 2023

MYLAPS welcomes John Hovius

HAARLEM (September, 2023) /ENDURANCE SPORTSWIRE/ – MYLAPS Sports Technology is pleased to announce that John Hovius joined the company on 1 September. John will be part of the MYLAPS team to add knowledge and help us to continually raise the level of our timing and online services for sports events. Next...

Business

Press Releases

September 8, 2023

LOGE Camps Teams Up with Specialized Bikes to Deliver the Ultimate Two-Wheel Hotel Perk

8 September 2023 (NORTH BEND, WASHINGTON)/ENDURANCE SPORTSWIRE/ – LOGE Camps, the hotel that gets you outdoors, officially announced a partnership with Specialized Bicycles to bring a line of its Mountain, Kids, and Comfort bikes to all LOGE properties. Specialized joins other brands like Yeti, Rumpl, Biolite, and Traeger Grills as part...

Business

Cycling

Press Releases

September 8, 2023

OutThere USA Partners with Adventure Racing World Series

/ENDURANCE SPORTSWIRE/ – A backpack is a fundamental piece of equipment in Adventure Racing. It carries a variety of gear for sections of the race, from climbing harnesses and carabiners to mountain bike spares and crampons. Together with cold-weather gear, personal care, foot care and first aid kits, bivvy bags,...

Business

Cycling

Press Releases

Products

Running

September 8, 2023

6,000 Runners Ready to Race at 2023 Volvo Santa Monica Classic

SANTA MONICA, CA – September 08, 2023 /ENDURANCE SPORTSWIRE/ – The stage is set, registration is sold-out and an exhilarating day of running and breathtaking views are in store for more than 6,000 runners as the Volvo Santa Monica Classic presented by ASICS returns this Sunday, September 10. Featuring three distances...

Events

Press Releases

Running