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

September 26, 2024

USARA National Championship Almost Underway in Almost Heaven

/ENDURANCE SPORTSWIRE/ - The US Adventure Racing National Championship begins on Friday morning, September 27th in Snowshoe, West Virginia. Launching out of Snowshoe Mountain Resort, elevation 4,848’, the race will take 74 teams of three from across the country on a journey through the heart of the Monongahela National Forest,...

Cycling

Events

Press Releases

Running

Triathlon

September 26, 2024

GFNY Super Sunday with two races in South America

/ENDURANCE SPORTSWIRE/ - GFNY Chile The course of the 6th GFNY Chile offers riders a 127.9km race course with an elevation gain of 1832m. It includes the infamous Muro de Tunquen, a 27% steep wall that forces many riders off their bike every year. Host of start and finish is...

Cycling

Events

Press Releases

September 26, 2024

Sunita Williams to run Medford Celebrity Mile race from space

BOSTON /ENDURANCE SPORTSWIRE/ – This weekend at Run Medford, local celebrities, leaders and media personalities will compete on the Dave McGillivray Track at Hormel Stadium. The following field will compete in a one-mile race as part of the Run Medford track festival, which kicks off a weekend-long celebration of community,...

Events

Giving

Press Releases

Running

September 25, 2024

2024 XTERRA World Championship Preview: A Battle of the Ages

MOLVENO, TRENTINO, ITALY /ENDURANCE SPORTSWIRE/ – The 28th XTERRA World Championship returns on September 28, uniting the world's best off-road triathletes for the pinnacle event of the 2024 season. The village of Molveno with just over 1,000 inhabitants located beneath the UNESCO World Heritage-listed Brenta Dolomites in the northern Italian...

Cycling

Events

Press Releases

Running

Triathlon

September 25, 2024

Las Vegas Marathon Announces Amazon as Presenting Sponsor

LAS VEGAS, Nevada /ENDURANCE SPORTSWIRE/ – The Las Vegas Marathon, the premier and city-signature road running event for the city of Las Vegas, has announced Amazon as their presenting sponsor of the Gear Check Program ahead of its inaugural event on Nov. 3, 2024. Each participant will be receiving an...

Events

Press Releases

Sponsorship

September 25, 2024

Healdsburg Turkey Trot Runs on Thanksgiving Day

Healdsburg, CA /ENDURANCE SPORTSWIRE/ – The Healdsburg Turkey Trot tradition continues for 2024! Now in its thirteenth year and truly a Healdsburg family tradition, the 5k fun run/walk on Thanksgiving Day, November 28th kicks off at 8am. Start and finish are at 333 Center Street in front of Healdsburg Running...

Events

Press Releases

Running

September 24, 2024

41st Kaiser Permanente Run Walk Roll Corporate 5K returns to Piedmont Park Wednesday

ATLANTA, GA /ENDURANCE SPORTSWIRE/ – The 41st annual Kaiser Permanente Run, Walk & Roll is back in Piedmont Park this Wednesday, September 25, promising a vibrant celebration of corporate health, fitness, and community. Created by Olympian Jeff Galloway, this iconic 5K continues to unite Atlanta's corporate teams, promoting camaraderie and wellness...

Events

Press Releases

Running

Sponsorship

September 24, 2024

Tough Mudder London South Has Record Participants

/ENDURANCE SPORTSWIRE/ – The ultimate test of grit, mud, and teamwork unfolded at Holmbush Estate on 21-22nd  September, as over 15,000 participants gathered for the largest Tough Mudder event of the season. Tough Mudder London South was a true spectacle of endurance and camaraderie, attracting a record number of attendees...

Events

Press Releases