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

June 14, 2022

GFNY Super Sunday results

New York City, June 14, 2022/ENDURANCE SPORTSWIRE/ – For the inaugural edition of GFNY Lourdes Tourmalet (France) racers tackled 157km with 4064m of climbing in the legendary French Pyrenees. Col d’Aspin was the first real obstacle of the day - and it didn’t disappoint. The peloton split into groups with the...

Cycling

Events

Press Releases

June 14, 2022

Pre-registration open for UTMB Mont-Blanc 2023 and the first ever UTMB World Series Finals

(Chamonix, France) 14 June 2022/ENDURANCE SPORTSWIRE/ – Pre-registration is officially open for the UTMB ®, CCC® and OCC races of UTMB® Mont-Blanc 2023, giving runners around the world over 6 months to qualify for the first ever UTMB® World Series Finals. Taking place from 28 August to 3 September 2023, trail...

Events

Press Releases

Running

June 14, 2022

The APEX Outdoor Festival & Expo Returns to Colorado Springs Sunday, September 25th

Colorado Springs, CO, June 14, 2022 /ENDURANCE SPORTSWIRE/ - Sports Strategies announces the return of The APEX Outdoor Festival & Expo in September, marking the final stage of highest profile mountain bike event on The Front Range - The Pikes Peak APEX presented by RockShox. In addition to the 4-Day...

Cycling

Events

Giving

Press Releases

Running

Sponsorship

Trade Shows

June 14, 2022

Denver Colfax Marathon Awards $100,000 to Colorado Charities and Schools

Denver, CO /ENDURANCE SPORTSWIRE/ - The Denver Colfax Marathon concluded its 2022 marathon season by awarding $100,000 to nonprofits and schools across Colorado. The marathon recently handed out over 75 checks to dozens of its charity partners at its annual Marathon Awards Celebration in June. “It’s such a unique program,”...

Awards

Events

Giving

Press Releases

Running

June 14, 2022

2022 Buffalo Marathon Weekend Highlights

/ENDURANCE SPORTSWIRE/ - The Buffalo Marathon Weekend kicked off festivities with a newly added street party on Friday, May 27, 2022, where athletes could shop local vendors and enjoy live music and happy hour specials. Event weekend festivities concluded on Sunday, May 29, with an all-new closing celebration street concert...

Events

Press Releases

Running

June 14, 2022

Speedo SALT Series Acquires Swim with Nick Memorial Race

Saint Augustine Beach, Florida/ENDURANCE SPORTSWIRE/ – Salty Sports Society, a leading open water swimming race company, has acquired the management contract for the 2nd Annual Swim With Nick memorial race in Dania Beach, FL. With the success of the inaugural event last year, the acquisition adds another stop to the extensive...

Business

Events

Press Releases