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

July 14, 2022

Racing high at 6th GFNY Colombia Bogota this Sunday

/ENDURANCE SPORTSWIRE/ - Riders will tackle the legendary La Cuchilla mountain - twice! The 6th GFNY Bogota will be held just outside Colombia’s capital high up in the Andes. The 121 km racecourse in the cycling fanatic country has an elevation gain of 2565m and is entirely closed to traffic....

Cycling

Events

Press Releases

July 13, 2022

German and Belgian win GFNY Grand Ballon after 13,307ft of climbing

New York City, July 13, 2022/ENDURANCE SPORTSWIRE/ – The inaugural GFNY Grand Ballon challenged racers on a 147.1 km long course with 4056m of climbing in one of the most beautiful destinations in France. GFNY Grand Ballon started fast in the historic town center of Thann: ten riders formed an early...

Cycling

Events

Press Releases

July 13, 2022

Natural Grocers Supports Colorado Mountain Bike Championship, Hosted by Rattler Racing, July 16th, 2022

LAKEWOOD, Colo., July 13, 2022/ENDURANCE SPORTSWIRE/ – Natural Grocers® will be onsite support the Colorado Mountain Bike Championship, hosted by Rattler Racing on July 16, 2022 in Bailey, CO. Based in Colorado, Rattler Racing has had an amazing season so far with some stellar spring races, an action packed gravel weekend over...

Cycling

Events

Press Releases

Sponsorship

July 12, 2022

An action-packed weekend for the UTMB World Series in Europe

/ENDURANCE SPORTSWIRE/ - The first of two UTMB World Series Majors this year, Val d’Aran by UTMB, saw more than 3,700 runners from over 70 countries take on some of the most spectacular trails in Europe, with its flagship race – the VDA-161km – witnessing a double victory for French athletes...

Events

Press Releases

Running

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