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

July 10, 2022

Silver Rush 50 Weekend Welcomes 1,300 Runners and Riders to Leadville

Leadville, Colo., (July 10, 2022) /ENDURANCE SPORTSWIRE/ - The Life Time Silver Rush 50 Run presented by La Sportiva and Stages Cycling Silver Rush 50 Mountain Bike race events, owned and produced by Life Time (NYSE: LTH), took place in a back-to-back format this weekend, bringing more than 1,300 runners...

Cycling

Events

Press Releases

Running

July 10, 2022

Life Time Crusher in the Tushar presented by The Creamery Celebrates Ten Years with New Course Record

Beaver, Utah /ENDURANCE SPORTSWIRE/ - The Crusher in the Tushar presented by The Creamery, a gravel event owned and produced by Life Time, welcomed a field of approximately 800 riders representing 37 states and eight countries to Utah’s Tushar Mountains outside of Beaver, Utah this past Saturday, July 9. Crusher in...

Cycling

Events

Press Releases

July 10, 2022

Justin Metzler (USA) And Danielle Lewis (USA) Claim Victories at the 2022 IRONMAN 70.3 Oregon Triathlon

SALEM. Ore. (July 10, 2022) /ENDURANCE SPORTSWIRE/ - Salem, Oregon's capital city and the Willamette Valley hosted the IRONMAN 70.3 Oregon triathlon on Sunday, July 10 where thousands of athletes, including professional and age-group athletes took to the region for the second edition of the event. The event saw Justin...

Events

Press Releases

Triathlon

July 8, 2022

XTERRA USA Championship Celebration July 16 in Avon, CO

July 8, 2022 /ENDURANCE SPORTSWIRE/ - A new course, new format, and free community concert are generating a lot of excitement for the XTERRA USA Championship off-road triathlons at Beaver Creek Resort with its accompanying outdoor festival at Nottingham Park in Avon, Colorado on July 15-16, 2022. Thousands of participants...

Events

Press Releases

Triathlon

July 8, 2022

Boilermaker 15K Hosts 25th PRRO Championship

UTICA, NY /ENDURANCE SPORTSWIRE/ - The PRRO Circuit will celebrate its 25th PRRO Championship presented by Boilermaker 15K on Sunday, July 10. The 45th Boilermaker will offer $65,100 in prize money, including $14,500 U.S. prize money. In addition, at the 2022 PRRO Championship, seven PRRO Circuit winners, listed below with...

Events

Press Releases

Running

July 7, 2022

GFNY Grand Ballon: 13,307 feet of climbing

New York City, July 7, 2022/ENDURANCE SPORTSWIRE/ – This Sunday, the inaugural GFNY Grand Ballon offers racers a 147.1 km long course with 4056m of climbing in one of the most beautiful destinations in France. Host town Thann lies at the beginning of the Alsace Wine Route and will be the...

Cycling

Events

Press Releases