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 (16)
) 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 1990, 10

July 24, 2023

Squirt Cycling Products Partners with Adventure Racing World Series

/ENDURANCE SPORTSWIRE/ -The primary disciplines of the sport of Adventure Racing include trekking, mountain biking and paddling with map-and-compass navigation to bring them all together. It is in this environment that Squirt Cycling Products are well suited, making them a perfect partner for the Adventure Racing World Series (ARWS). Squirt’s...

Business

Cycling

Events

Press Releases

Products

Sponsorship

July 24, 2023

Competitors Battle Early Rain and Mud to Break Course Records at 8-Hour Dream Endurance Race

CARMEL, Ind. (July 24, 2023) /ENDURANCE SPORTSWIRE/ - The ninth annual 8-Hour Dream Endurance Race started with rain sprinkles but ended with sunshine and new course records on Saturday, July 15 in Indianapolis. The unique ultra distance event, created and managed by CRRG Events, is the largest endurance running event...

Events

Press Releases

Running

July 24, 2023

1,400 Registered Runners Took on Snowbird Ski Resort’s Toughest Trails at The Speedgoat Mountain Races by UTMB In Utah’s Wasatch Mountains

SNOWBIRD, Utah /ENDURANCE SPORTSWIRE/ - The 2023 UTMB® World Series continued with the 2023 Speedgoat Mountain Races by UTMB® on July 21-22. Celebrating its 16th anniversary, the iconic mountain race featured 1,400 registered runners from 48 states and 24 countries, regions and territories embarking on one of the four distances...

Events

Press Releases

Running

July 23, 2023

San Francisco Marathon 2023 Concludes with Record-Breaking 29,000 Total Participants

San Francisco, CA - July 23, 2023 /ENDURANCE SPORTSWIRE/ - The streets of San Francisco were alive with energy and excitement as thousands of runners from around the world participated in the highly anticipated San Francisco Marathon 2023. Under clear skies and favorable weather conditions, athletes displayed exceptional determination, pushing...

Events

Press Releases

Running

July 22, 2023

Carina Wasle, Michele Bonacina win XTERRA Lake Scanno

/ENDURANCE SPORTSWIRE/ - Carina Wasle (AUT) and Michele Bonacina (ITA) won the 10th annual XTERRA Lake Scanno off-road triathlon women’s and men’s elite titles on Saturday, July 22, 2023, at the famous heart-shaped lake in Southern Italy’s Abruzzo National Park. It’s the 24th career XTERRA World Tour win for Wasle...

Events

Press Releases

Triathlon

July 21, 2023

2023 USA Cycling Collegiate Mountain Bike National Championships Head to Ride Rock Creek

COLORADO SPRINGS, Colo. /ENDURANCE SPORTSWIRE/ – The 2023 USA Cycling Collegiate Mountain Bike National Championships will take place at Ride Rock Creek in Zirconia, N.C. on October 12-15, 2023. The Collegiate Mountain Bike National Championship is the largest collegiate cycling event that USA Cycling hosts. The event will crown varsity and...

Cycling

Events

Press Releases

July 21, 2023

Moloka’i 2 O’ahu Paddleboard World Championships Welcomes New partner dryrobe®

HONOLULU, HI (July 21, 2023)/ENDURANCE SPORTSWIRE/ – The Moloka'i 2 O'ahu Paddleboard World Championships (M2O) is excited to return to Hawai'i later this month for the 24th annual race featuring top athletes in prone paddleboarding, SUP, and FOIL. The race is excited to introduce these world class watermen and women...

Events

Press Releases

Sponsorship