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

July 23, 2024

Alive in Death Valley: A Collaboration to Survive The World’s Toughest Foot Race

Melbourne, Victoria (July 22, 2024) /ENDURANCE SPORTSWIRE/ - Australian brand, 2XU, the global leader in compression apparel, and Los Angeles-based District Vision have collaborated on a new limited edition collection inspired by the Badwater 135 ultramarathon. The collaboration features three outfits from 2XU matched with a pair of ultra lightweight...

Business

Press Releases

Products

Running

Wire Syndication

July 22, 2024

The Countdown is on to Leadville Trail 100 MTB

Leadville, Colorado /ENDURANCE SPORTSWIRE/ – The Life Time Grand Prix presented by Mazda returns on Saturday, August 10th with the Life Time Leadville Trail 100 MTB presented by Kenetik. The renowned Colorado event – also known as the Race Across the Sky – is celebrating its 30th anniversary this year and...

Cycling

Events

Press Releases

July 22, 2024

Ahotu and The Feed announce new partnership to enhance athlete experience

/ENDURANCE SPORTSWIRE/ – As part of this partnership, the Ahotu Nutrition Club at The Feed will be launched, which offers significant savings on sports nutrition products. This initiative is tailored to help athletes fuel their journeys with high-quality nutrition, ensuring they perform at their best at every event. Club members...

Business

Press Releases

July 22, 2024

2025 Austin International Half Marathon Exhibitor Registration Open

Austin, Texas, July 22, 2024 /ENDURANCE SPORTSWIRE/ – The Austin International Half Marathon, formerly known as the 3M Half Marathon, is excited to announce that exhibitor registration is now open for the upcoming event’s Health and Fitness Expo, set to take place on Friday, January 17, and Saturday, January 18, 2025,...

Press Releases

Running

Trade Shows

July 22, 2024

Trevor Foley (USA) And Danielle Lewis (USA) Take Wins at the 25th Anniversary Edition of The Athletic Brewing IRONMAN Lake Placid Triathlon

LAKE PLACID, N. Y. /ENDURANCE SPORTSWIRE/ - The village of Lake Placid and New York’s stunning Adirondacks Mountains played host to the twelfth stop and fifth full-distance IRONMAN triathlon in the IRONMAN Pro Series™ today at the Athletic Brewing IRONMAN® Lake Placid triathlon, part of the VinFast IRONMAN North America...

Events

Press Releases

Triathlon

July 22, 2024

2024 XTERRA European Trail Run Championship Recap: A Spaniard Sweep

ARINSAL - LA MASSANA, ANDORRA /ENDURANCE SPORTSWIRE/ - On July 21, 2024, the XTERRA European Trail Run Championship was held in the Pyrenees, attracting trail runners from across Europe and beyond. In the 36K Trail Marathon, the winners were Martí Lázaro Cordero (ESP) and Roser Español Bada (ESP), while the...

Events

Press Releases

Running

July 22, 2024

31,000 Runners Register For 2024 San Francisco Marathon Weekend Events

San Francisco, CA. – [Jul 22, 2024] /ENDURANCE SPORTSWIRE/ - Jumping Fences, Inc., the organizers of the iconic San Francisco Marathon, officially announces its return July 27-28, 2024. Bringing together thousands of runners from across the globe to participate in one of the world's most scenic and challenging running events,...

Events

Press Releases

Running

July 21, 2024

Jack Moody and Valerie Barthelemy Win Big at SAIL Challenge Cap Québec powered by Argon 18

/ENDURANCE SPORTSWIRE/ - Athletes from around the world competed at the inaugural SAIL Challenge Cap Québec powered by Argon 18 in a race that marked Challenge Family’s long-awaited return to North American triathlon. The day delivered victory for Jack Moody (NZL) and Valerie Barthelemy (BEL), who established dominance on the...

Events

Press Releases

Triathlon

July 20, 2024

More Than 700 Cyclists Cross Finish Line at Life Time Tahoe Trail MTB Race

Truckee, Calif. (July 20, 2024) /ENDURANCE SPORTSWIRE/ - The 2024 Life Time Tahoe Trail MTB welcomed more than 700 cyclists to Tahoe’s Northstar Resort for a weekend of mountain biking adventure. Participants raced in one of two distances, either the 100 or 50-kilometer. In a world-class recreation destination like Lake...

Cycling

Events

Press Releases