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

September 28, 2022

‘Ante Up’ for the TransRockies Gravel Royale 2023 Event with Registration opening on Sept. 28

Panorama, B.C. (Sept. 28, 2022) /ENDURANCE SPORTSWIRE/ - TransRockies Race Series just completed a successful inaugural TransRockies Gravel Royale presented by Felt Bicycles. The event brought 200 athletes from eight countries and 22 states and provinces to explore the vast gravel roads of the Kootenay Mountains in British Columbia, Canada....

Cycling

Events

Press Releases

September 28, 2022

Indiana Spine Group Extends Partnership with Carmel Marathon Weekend Through 2025

CARMEL, Ind. (Sept. 28, 2022)/ENDURANCE SPORTSWIRE/ – CRRG Events is proud to announce it has secured an extended three-year partnership with Indiana Spine Group for the Carmel Marathon Weekend through 2025. Indiana Spine Group, a longtime supporter of the event, will continue its title sponsorship of the 10K event as well...

Press Releases

Running

Sponsorship

September 27, 2022

Top Professional Triathletes from Around the World Make Highly Anticipated Return to Kailua-Kona, Hawai`I For The 2022 VinFast IRONMAN World Championship

KAILUA-KONA, Hawai`i / TAMPA, Fla. (September 27, 2022) /ENDURANCE SPORTSWIRE/ - Triathlon’s top professional athletes will return to Kailua-Kona, Hawai`i for the first time in three years for the 2022 VinFast IRONMAN® World Championship triathlon. The most iconic endurance event in the world will bring together nearly 100 of the...

Events

Press Releases

Triathlon

September 27, 2022

Fifth Annual USABA National Blind Sports Week presented by Healthy Vision Association Slated for October 3-8

(Sept. 27, 2022) /ENDURANCE SPORTSWIRE/ – Join the U.S. Association of Blind Athletes for National Blind Sports Week presented by Healthy Vision Association (Oct. 3-8), a six-day celebration focused on participation and awareness of sports and opportunities available to athletes who are blind and visually impaired. The week culminates with the...

Events

Press Releases

September 27, 2022

U.S. Team Announced for Inaugural World Mountain & Trail Running Championship

/ENDURANCE SPORTSWIRE/ – Thirty-nine of the top off-road runners in the United States have been named to the 2022 U.S. Mountain & Trail Running Team scheduled to compete at the inaugural World Mountain & Trail Running Championships November 4-6 in Chiang Mai, Thailand. Hailing from twelve U.S. states, these talented athletes...

Events

Press Releases

Running

September 27, 2022

Abbott World Marathon Majors to award equal prize money to Series Champions

/ENDURANCE SPORTSWIRE/ – The Abbott World Marathon Majors (AbbottWMM) announced today that the Series XIV Champions will receive equal prize money across the elite and elite wheelchair competitions and the prize money fund will be extended to include the top five males and females in both categories. As the world’s biggest...

Events

Press Releases

Running

September 27, 2022

Zambrano and Molineros win 4th GFNY Ecuador Manta

New York City, September 27, 2022 /ENDURANCE SPORTSWIRE/ – Manta, located on the coast of Ecuador, hosted the 4th edition of GFNY Ecuador Manta 2022 this past Sunday. The racecourse was 142.2 km long with 2030m of climbing. The race started off at Barbasquillo Manta, where the first 5km were neutralised...

Cycling

Events

Press Releases

September 27, 2022

The Running Event Announces Allyson Felix as 2022 Keynote Speaker

PORTLAND, Maine (September 27, 2022)/ENDURANCE SPORTSWIRE/ – The Running Event (TRE), North America’s premier specialty retail conference and trade show, today announced Olympian and Saysh Founder Allyson Felix as the 2022 Keynote Speaker. Felix will give her address, “Daring to Do Things Differently,” November 29 at 12:00 PM CT. “I’ve been around...

Press Releases

Running

Trade Shows

September 27, 2022

Challenge Family and ROUVY Host Indoor Training Camp This Weekend

/ENDURANCE SPORTSWIRE/ - As the Northern Hemisphere days get shorter and the weather gets cooler, Challenge Family and ROUVY have prepared an indoor training camp, using the most realistic virtual riding experience, available on three spectacular Challenge Family bike courses. Triathletes can look forward to a moderate intensity and fun...

Cycling

Events

Press Releases

Triathlon

September 27, 2022

INFINIT Nutrition Athlete Bradyn Lange Wins Chequamegon 40

Cincinnati, OH, September 27, 2022 /ENDURANCE SPORTSWIRE/ - INFINIT Nutrition athlete Bradyn Lange won the 2022 edition of the Chequamegon 40 in the men’s category, with a time of 2:05:54. The flagship event of the Chequamegon MTB Festival, the 40-mile race started in Hayward, Wisconsin, traveling through the picturesque Birkie...

Cycling

Press Releases

Products

Sponsorship