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

July 12, 2022

Mountain Magic at Raid in France – Savoie Mont Blanc

/ENDURANCE SPORTSWIRE/ - Raid in France returned to the international stage and the Adventure Racing World Series this year, with their 11th edition in the majestic Savoie Mont Blanc region of the Alps. It was the first Raid in France since the organisation staged the AR World Championship on Reunion...

Events

Press Releases

July 12, 2022

Super League Triathlon delivers New Audiences for the sport with Huge Broadcast Numbers

/ENDURANCE SPORTSWIRE/ – Super League Triathlon (SLT) is delivering on its promise to make triathlon a spectator sport as it releases broadcast viewing figures which show that 21.7 million people watched Arena Games Triathlon powered by Zwift. The first ever esports World Championship Series for triathlon, a mix of real life...

Events

Press Releases

Triathlon

July 11, 2022

8-Hour Dream Endurance Race Sold Out for Third Year in a Row

CARMEL, Ind. (July 11, 2022)/ENDURANCE SPORTSWIRE/ – The 8-Hour Dream Endurance Race and Cat Nap 5K, one of CRRG Events’ signature races and the largest endurance running event in Central Indiana, returns on Saturday, July 16 with a sold-out SOLO division for the third year in a row with registrants from...

Events

Press Releases

Running

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