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

June 29, 2024

1,700 Runners Kick Off 2024 Leadville Race Series with Life Time Leadville Trail Marathon and Heavy Half presented by La Sportiva

Leadville, Colo./ENDURANCE SPORTSWIRE/ - The Life Time Leadville Race Series, consisting of both run and cycle events that take participants through the trails and hills of picturesque backdrop of Leadville, CO, will take place over five weekends throughout June, July and August. Kicking off with MTB and run training camps...

Events

Press Releases

Running

June 29, 2024

Nicolas Mann (DEU) and Laura Madsen (DNK) Take the Win at the 2024 IRONMAN 70.3 Les Sables d’Olonne-Vendée Triathlon

- Mann claims his second IRONMAN Pro Series victory, and Laura Madsen continues her winning streak with her second victory of the year - Mann and Madsen both secure the maximum 2,500 points and go home with $7,500 LES SABLES D’OLONNE, France. (June 29 2024) /ENDURANCE SPORTSWIRE/ The seaside town...

Events

Press Releases

Triathlon

June 28, 2024

Favorite Bikes Launches Brand New Hybrid CSC ST To COSTCO Canada Online

Favorite Bikes, Los Angeles, California /ENDURANCE SPORTSWIRE/ - Favorite Bikes, a pioneer in electric bike technology, proudly announces the launch of its newest model, the Hybrid CSC ST, available online at Favorite Bikes and through the newly formed relationship with Costco’s Canada and their online store for $1999 CAD. This cutting-edge...

Business

Cycling

Press Releases

Products

June 28, 2024

US Trail Running Conference RD Master Class Webinar Features Course Marking Innovations

/ENDURANCE SPORTSWIRE/ Mastering Course Marking Innovations was the subject for the sixth webinar in the nine-webinar RD Master Class series produced by the US Trail Running Conference presented by Marathon Printing, and was live on Tuesday, June 25. The webinar series is free for all race directors and event organizers...

Press Releases

Running

Trade Shows

June 28, 2024

Ultra X Announces Big Summer Sale

/ENDURANCE SPORTSWIRE/ - Ultra X, renowned for organizing world-class ultra-marathons, is thrilled to announce the launch of its highly anticipated Big Summer Sale. This exclusive sale offers participants a chance to enjoy a 20% discount on all 2024 events, making it the perfect opportunity to secure a spot in some...

Business

Events

Press Releases

Running

June 28, 2024

Hap Seliga Appointed President of Scott USA

/ENDURANCE SPORTSWIRE/ - SCOTT Sports, manufacturer and distributor of high-quality Bike and Outdoor equipment and apparel, welcomes industry veteran Hap Seliga as President of SCOTT USA, the United States subsidiary of SCOTT Corporation. Alongside teams based in Salt Lake City and Ogden, Utah, Seliga will work to drive growth in...

Business

Cycling

Press Releases

June 27, 2024

La Sportiva Launches the Prodigio Pro, A Supershoe for the Mountains

BOULDER, Colo. (Jun 27, 2024) /ENDURANCE SPORTSWIRE/ -  La Sportiva, makers of the world's finest mountain gear, today announced their Spring 2025 footwear line. The collection is highlighted by the Prodigio Pro, the most cushioned and responsive trail running shoe the brand has made to date. The Italian brand is...

Press Releases

Products

June 27, 2024

Verge Launches Tour de Verge Contest to Celebrate Tour de France Debut with Intermarché-Wanty

NEW YORK, June 27th 2024 /ENDURANCE SPORTSWIRE/ Verge, the innovative leader in custom cycling apparel, is thrilled to announce the launch of the Tour de Verge contest, celebrating our first-ever appearance in the Tour de France with our sponsored team, Intermarché-Wanty. This milestone marks a significant achievement for Verge, showcasing...

Awards

Cycling

Press Releases

Products

Sponsorship

June 27, 2024

Competitive Cyclist Named Official U.S. Retailer for A.S.O. Tour de France Products

PARK CITY, Utah (June 27, 2024) /ENDURANCE SPORTSWIRE/ Competitive Cyclist, the premier online retailer for premium cycling gear and apparel, proudly announced its partnership with Amaury Sport Organisation (A.S.O.) as the only official U.S. retailer for this year's Tour de France products. The distinguished collaboration underscores Competitive Cyclist’s commitment to...

Press Releases

Sponsorship

June 27, 2024

HeroAid Named Official Sports Drink Partner And Finish Line Beverage Of Spartan Race For The 2024 Season

[Boston, MA 06/27/2024] /ENDURANCE SPORTSWIRE/ - HeroAid, one of the leading premium hydration beverages, is thrilled to announce its partnership with Spartan Race as the Official Sports Drink and Finish Line Beverage Partner for the 2024 season. This strategic collaboration brings together two forces committed to promoting an active lifestyle,...

Events

Press Releases

Running

Sponsorship