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 (8742)
) 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 6790, 10

June 21, 2022

Sprint finish after 11,000ft of climbing

New York City, June 21, 2022 /ENDURANCE SPORTSWIRE/ - After last week’s GFNY Lourdes Tourmalet in the Pyrenees, the GFNY peloton headed to the Alps. GFNY La Vaujany had 145.1km with 3663m of climbing including L’Alpe d’Huez on the menu. The first obstacles of the day were Col de la...

Cycling

Events

Press Releases

June 21, 2022

Pat Casey, Retains Head Coach Position for Upcoming World Triathlon Grand Finals Event

Salt Lake City, Utah. /ENDURANCE SPORTSWIRE/ - Coach Pat Casey of Salt Lake City is yet again named by USA Triathlon to serve as Team USA’s Head Coach for athletes participating in the 2022 World Triathlon Championships. The event will take place in Yas Island, Abu Dhabi, on November 23-26,...

Press Releases

Triathlon

June 21, 2022

USARA partnering with Adventure Racing World Series to launch ARWS North America Regional Series

Clarion, Pennsylvania, U.S.A./ENDURANCE SPORTSWIRE/ –The U.S. Adventure Racing Association and the Adventure Racing World Series have announced a collaborative partnership that will see the two organizations join forces to create the ARWS North America Regional Series. Announced on Sunday, June 19 at the start of the Endless Mountains Adventure Race in...

Events

Press Releases

June 21, 2022

150 Local Businesses Participate in The ADP Corporate 5K to Celebrate Corporate Wellness

June 21, 2022 – NORFOLK, VIRGINIA –  Over 150 local businesses came together to celebrate corporate wellness at the ADP Corporate 5K presented by Bon Secours. Over 2,000 race participants enjoyed a running tour of Downtown Norfolk with an exciting finish in Town Point Park. Upon completion of the race, coworkers...

Events

Press Releases

Running

June 21, 2022

Speedy Hoosiers and Returning Winners Highlight Carmel Marathon Weekend’s Age Group Records

CARMEL, Ind. (June 21, 2022) /ENDURANCE SPORTSWIRE/ - Twenty-nine age group records were broken on April 9 at the 2022 Carmel Marathon Weekend, in addition to five course records. The field of nearly 3,500 participants from 43 states and five countries braved the cold and windy weather to break previous...

Events

Press Releases

Running

June 21, 2022

Tourism Grant Helps CampgroundViews.com Bring Virtual Site Tours to Arizona

LARAMIE, Wyo. (June 21, 2022) /ENDURANCE SPORTSWIRE/ - CampgroundViews.com, the company committed to taking the guesswork out of campsite selection, is developing virtual tours of up to 250 campgrounds in Arizona to make trip planning easy for RV and tent campers. With CampgroundViews.com’s proprietary 360-degree virtual tours and searchable database,...

Press Releases

Products

June 21, 2022

MTB Giveaways is acquired by Endurance Zone, owners of Win Your Dream Bike

/ENDURANCE SPORTSWIRE/ – Endurance Zone have acquired MTB Giveaways to bolster their Win Your Dream Bike brand. After the purchase of Rafflebike in January, this is their second acquisition in 6 months in the bike prize competition space. MTB Giveaways, founded in 2020, is a UK bike prize competition specialising in...

Business

Cycling

Press Releases

June 21, 2022

California’s First-Ever Non-Binary+ Division Over 25k Expected to Run The 45th Annual San Francisco Marathon

June 21, 2022, San Francisco, Calif./ENDURANCE SPORTSWIRE/ – Jumping Fences Inc., the official event producers of The 45th San Francisco Marathon, have officially announced California’s first-ever non-binary+ division and awards. This meaningful move comes at a time when numerous anti-LGBTQIA+ legislations are sweeping the nation, and other running races are being...

Events

Press Releases

Running

Trade Shows