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

August 3, 2022

USA Cycling Announces 2022 Mountain Bike Worlds Team

COLORADO SPRINGS, Colo./ENDURANCE SPORTSWIRE/ – USA Cycling announced today the athletes that will be representing the United States at the 2022 UCI Mountain Bike World Championships in Les Gets, France on August 22-28. After impressive results this past weekend at the UCI Mountain Bike World Cup in Snowshoe, W.V., the team...

Cycling

Events

Press Releases

August 3, 2022

IRONMAN 70.3 Boulder to shift dates on the calendar beginning in 2023

BOULDER, Colo. / TAMPA, Fla. (Aug. 3, 2022)/ENDURANCE SPORTSWIRE/ – IRONMAN today announced that the 2023 IRONMAN® 70.3®Boulder triathlon will be moving to a new date on the calendar beginning in 2023. A staple in Colorado and on the IRONMAN calendar since 2002, the long-standing event will now take place on...

Events

Press Releases

Triathlon

August 3, 2022

The RunnerBox and The RiderBox Keep it Fresh with Their Latest Editions

August 3, 2022 /ENDURANCE SPORTSWIRE/ – The RunnerBox and The RiderBox unveiled their latest editions which showcases featured picks to help subscribers stay fresh while turning up the heat on their late-summer workouts and races. Consistently named the top subscription box for athletes, The RunnerBox and The RiderBox deliver bi-monthly boxes to...

Cycling

Press Releases

Products

Running

Triathlon

August 3, 2022

Registration Open for the 2023 DICK’S Sporting Goods Pittsburgh Marathon Weekend of Events

PITTSBURGH, PA /ENDURANCE SPORTSWIRE/ – Registration for the 2023 DICK’S Sporting Goods Pittsburgh Marathon Weekend of Events is officially open. More than 40,000 MOVERS are expected to register for the 15th anniversary event, scheduled for May 6-7, 2023. P3R will celebrate the 15th anniversary with special one-day pricing at the lowest...

Events

Press Releases

Running

August 3, 2022

GFNY takes over Kuala Lumpur on February 12, 2023

/ENDURANCE SPORTSWIRE/ - GFNY Global Endurance Sports Series adds GFNY Kuala Lumpur, scheduled for February 12, 2023. Riders will get to experience a race that starts and finishes in the heart of Malaysia’s metropolis. The 138 km long course will take athletes from the heart of the city, into the...

Cycling

Events

Press Releases

August 3, 2022

Maryland Cycling Classic Supported by UnitedHealthcare Reveals Official Podium Awards Jerseys for America’s Top One Day Professional Cycling Race

BALTIMORE, Md. /ENDURANCE SPORTSWIRE/ – The Maryland Cycling Classic supported by UnitedHealthcare, America’s top-ranked professional road cycling race and highest-ranked UCI event, today revealed the five official podium awards jerseys and each sponsor for the inaugural event, which takes place Sunday, September 4, 2022. Designed by Athlos Sportswear, headquartered in Baltimore, the...

Cycling

Press Releases

Products

Sponsorship

August 3, 2022

Showcased

Elevate Women 4-Tri Malibu Triathlon Women’s Only Training Program

/ENDURANCE SPORTSWIRE/ – 2XU Malibu Triathlon is excited to announce the Elevate Women 4Tri 7-week triathlon training program will kick off the week off August 8th and lead right into race weekend September 17-18, 2022. The women’s only training program is designed to encourage participation for women learning the sport of...

Cycling

Events

Press Releases

Running

Triathlon

August 3, 2022

ENGO Eyewear Introduces ENGO 2, The Lightest Heads Up Display for Training and Competition for Endurance Athletes

BOSTON, Mass. (August 3, 2022)/ENDURANCE SPORTSWIRE/ – ENGO Eyewear, the leading manufacturer of connected eyewear for endurance athletes, today unveiled ENGO 2, the lightest, and most technologically advanced eyewear created specifically for endurance athletes. Developed to provide instant, intuitive, real-time access to performance data directly in the natural field of view,...

Cycling

Press Releases

Products

Running

Triathlon

August 3, 2022

World’s Most Exclusive Half Marathon is back and running

August 3, 2022 /ENDURANCE SPORTSWIRE/ –  RunningFlat and Pelee Island Winery team up again to offer the most exclusive running experience in the world—an island run through one of Canada’s oldest grape growing regions making this Half Marathon Canada’s most Southern. Pelee Island, Ontario June 3rd 2023 —Canada’s southernmost half marathon, the...

Events

Press Releases

Running

Wire Syndication