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

June 9, 2022

The Mountain Designs Geoquest 20th Anniversary race kicks off ARWS Oceania 2022

/ENDURANCE SPORTSWIRE/ – The 20th Mountain Designs Geoquest adventure race will take place this weekend with its headquarters in the coastal hamlet of Shoal Bay, NSW. The race is the first in the 2022 AR World Series Oceania Series, and teams of 4 will race for up to 48 hours; trekking,...

Events

Press Releases

June 9, 2022

The Virtual Tour de Suisse on ROUVY – Discover Beautiful Switzerland on Bike from Home

Grenchen, Switzerland / June 9th, 2022/ENDURANCE SPORTSWIRE/ –  The 85th edition of the Tour de Suisse starts with the men's first stage on Sunday 12th June in Küsnacht and the women begin their four-day tour on the following Saturday 18th June in Vaduz. Popular stars (among many others) are Peter Sagan,...

Cycling

Events

Press Releases

June 9, 2022

Get in the Water! Youth Invited to Kids Day at the Columbia Threadneedle Investments Boston Triathlon

BOSTON – June 9, 2022 – ethos, the mass participation event organization that presents the Columbia Threadneedle Investments Boston Triathlon, has announced plans for Kids Day at the 2022 Boston Triathlon. The annual event returns to the Massachusetts Department of Conservation and Recreation’s (DCR) Carson Beach in South Boston on...

Events

Press Releases

Triathlon

June 8, 2022

Enduro Bearings to Host ‘Bearings & Brews Speakeasy’ June 29 at Rapha’s San Francisco Clubhouse

Oakland, California (June 8, 2022) /ENDURANCE SPORTSWIRE/ - On the heels of Enduro Bearings’ info-rich website launch last week, they’ll be hosting a free-to-the-public ‘Bearings & Brews Speakeasy’ at the Rapha Clubhouse in San Francisco (2198 Filbert St.). The event will take place at 5:30pm on Wednesday, June 29. Enduro...

Business

Cycling

Events

Press Releases

Products

Triathlon

June 8, 2022

Salida76 Promises a New Twist on Gravel Riding and Racing

(Salida, CO) /ENDURANCE SPORTSWIRE/ - Team Evergreen is bringing the party back to gravel. The producers of Triple Bypass introduce Salida76, a gravel race and ride, slated for Sept. 17, 2022, in Salida, Colorado. With a “Timed” race category and an untimed “Party Pace” category, the objective is to keep...

Cycling

Events

Giving

Press Releases

June 8, 2022

GFNY Super Sunday with two brand new races

/ENDURANCE SPORTSWIRE/ GFNY Lourdes Tourmalet GFNY Lourdes Tourmalet is based in the famous pilgrimage town of Lourdes, Southwestern France, at the foothills of the Pyrenees. Riders will tackle major climbs, including the iconic Col du Tourmalet (2115m) and Col d’Aspin for a total of 157km with over 4064 meters of climbing....

Cycling

Events

Press Releases

June 8, 2022

The Giro d’Italia Virtual hosted by BKOOL arrives at the Montalcino sterratos

/ENDURANCE SPORTSWIRE/ – One month after the start of the last round of the Giro d'Italia Virtual hosted by BKOOL, this global virtual cycling event launches a new stage, with the finish in the town of Montalcino: the famous stage in which Egan Bernal launched a brutal attack in 2021, extending...

Cycling

Events

Press Releases

Triathlon

June 8, 2022

Laura Philipp Defends Her European Champion Title and Sets a World Best at The IRONMAN® European Championship Hamburg

Hamburg, Germany/ENDURANCE SPORTSWIRE/ – More than 2000 professional female athletes and female and male age group athletes celebrated the fifth edition of the IRONMAN European Championship Hamburg today. A day which saw Laura Philipp (GER) become crowned IRONMAN European Champion, with the fastest time a woman has ever completed a full...

Events

Press Releases

Triathlon

June 7, 2022

Inaugural Rush to Crush Cancer Expected to Raise Millions for UPMC Hillman Cancer Center

PITTSBURGH (June 7, 2022)/ENDURANCE SPORTSWIRE/ – UPMC Hillman Cancer Center, in partnership with P3R, announced today that they will host the first-ever Rush to Crush Cancer, a bike ride with the goal of raising millions for cancer research. Scheduled for Spring 2023, the bike event will be broken into three routes...

Cycling

Events

Giving

Press Releases