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

August 31, 2022

Pikes Peak APEX Adds Three New Partners for September Event

Colorado Springs, CO, September 1, 2022 /ENDURANCE SPORTSWIRE/ - Sports Strategies announces three new partners of The Pikes Peak APEX presented by RockShox. REI, Fat Tire and Flow Formulas have all partnered with the APEX to provide an enhanced experience to racers this September 22-25. “We always want to partner...

Cycling

Events

Press Releases

Sponsorship

August 31, 2022

The UTMB Mont-Blanc 2022 ends after a week that will be remembered with incredible record times

Nearly 14M views and 100M minutes of videos viewed (UTMB Live and highlights) on the new live.utmb.world platform and the official social networks of the UTMB Mont-Blanc. This corresponds to 188 years of UTMB videos watched continuously! 650,000 fans on the official UTMB Mont-Blanc social networks, including 50.000 new fans...

Events

Press Releases

Running

August 31, 2022

Katie Schide Highlights Successful UTMB® Campaign for CTS Athletes

(Colorado Springs, CO – August 31, 2022) /ENDURANCE SPORTSWIRE/ - Seventeen CTS Athletes competed in the Ultra Trail du Mont Blanc (UTMB®) events held in Chamonix, France between August 22 – 28, 2022, with Katie Schide scoring a runaway victory in ultramarathon’s premier 171-kilometer event. As a testament to the...

Events

Press Releases

Running

August 31, 2022

ITERA Scotland Takes Expedition Adventure Racing to New Heights

/ENDURANCE SPORTSWIRE/ – The ITERA 2022 Expedition Adventure Race, the last ARWS Qualifier of 2022, was staged in the majestic wilderness of the Scottish Highlands and Islands. Race organisers Open Adventure delivered an ambitious course, through unforgettable scenery, visiting iconic landmarks, and taking teams to remote places, which few people ever...

Events

Press Releases

August 30, 2022

American Criterium Cup event number ten: Gateway Cup

Wednesday, August 30, 2022 /ENDURANCE SPORTSWIRE/ - On Sunday, September 4th, our final race in the American Criterium Cup takes place at the Giro Della Montagna criterium, part of the four-day Gateway Cup. The tenth and last stop for the ACC, the Giro became the cornerstone of the Gateway Cup in...

Cycling

Events

Press Releases

August 30, 2022

GFNY Alpes Vaujany: Schuller and Alleman take the win after 4000+ meters of climbing

New York City, August 30, 2022 /ENDURANCE SPORTSWIRE/ – The third annual GFNY Alpes Vaujany in the French Alps had a 119.6 km long course with 4023m of climbing including the legendary Col de la Croix de Fer and Col du Glandon on the menu. GFNY Alpes Vaujany started from the bottom...

Cycling

Events

Press Releases