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

March 15, 2023

REI Joins the Denver Colfax Marathon Sponsor Team

Denver, CO /ENDURANCE SPORTSWIRE/ - The Denver Colfax Marathon welcomes REI to their marathon sponsor line up to give athletes access to training support, knowledge, and merchandise like never before. “We’re beyond excited to have partnered with the Denver Colfax Marathon on their 17th anniversary,” said Josh Millward, REI’s Regional Manager...

Business

Events

Giving

Press Releases

Running

Sponsorship

March 14, 2023

Pensacola Beach Firefighters Challenge April 14 and 15

Pensacola, FL (March 14, 2023) /ENDURANCE SPORTSWIRE/ - Brawn, axes, hoses, sweat and sand — it’s what makes up the storied Pensacola Beach Firefighters Challenge, a competition of brute strength, sheer will, finesse and determination where we find out who’s the best of best. Pensacola Sports is hosting the 7th...

Events

Press Releases

March 14, 2023

Jeremy Dunn Named Bike Marketing Manager at SMITH

PORTLAND, Oregon (March 13, 2023) /ENDURANCE SPORTSWIRE/ - SMITH – global market leader in snow goggles and helmets and industry innovator across bike helmets, sport, lifestyle, and prescription eyewear – is excited to announce the appointment of Jeremy Dunn as Bike Marketing Manager. With over 15 years experience in the...

Business

Cycling

Press Releases

March 14, 2023

Jack Moody, Maeve Kennedy rally to win XTERRA Rotorua

/ENDURANCE SPORTSWIRE/ – Jack Moody and Maeve Kennedy captured the 19th annual XTERRA Rotorua Festival off-road triathlon elite titles with winning times of 2:06:16 and 2:26:35, respectively, on a beautiful blue sky day at Lake Tikitapu in the Bay of Plenty region of New Zealand's North Island on March 11, 2023....

Events

Press Releases

Triathlon

March 14, 2023

RBC GranFondo Whistler’s premiere cycling and lifestyle expo is now accepting booth applications

Vancouver, BC /ENDURANCE SPORTSWIRE/ – The RBC GranFondo Whistler (road cycling) event has partnered with Dilawri Automotive Group to kick-off GranFondo weekend in Vancouver with the VeloSpoke Expo at the Vancouver Convention Centre on Friday, September 8th, 2023. The respected Cycling and Lifestyle Expo, which is open to the public, has been the...

Cycling

Press Releases

Trade Shows

March 14, 2023

USA Cycling Announces 2023 Gravity Mountain Bike National Championships and National Downhill Series

COLORADO SPRINGS, Colo. /ENDURANCE SPORTSWIRE/ – USA Cycling is excited to announce that the 2023 Gravity Mountain Bike National Championship will take place July 12-16 at Ride Rock Creek in Zirconia, N.C. At this event, the stars-and-stripes will be up for grabs in Downhill, Dual Slalom, and Enduro racing for professional...

Cycling

Events

Press Releases

March 14, 2023

BikeExchange Signs as Sole Online Sales Platform for Basso, Berria, Lee Cougan

Asheville, North Carolina (March 14, 2023)/ENDURANCE SPORTSWIRE/ – If you’ve ever dreamed of owning a legendary custom Basso, stealthy Berria or iconic Lee Cougan bike, the process just got much easier in North America: Cycling Distribution Network (CDN), the US distributor of all three brands, has recently signed on with BikeExchange...

Business

Cycling

Press Releases

Products

Triathlon

March 14, 2023

Sprint finish at 6th GFNY Uruguay – Punta del Este last Sunday

New York City, March 14, 2023 /ENDURANCE SPORTSWIRE/ – Uruguay hosted the sixth edition of GFNY Punta del Este this past Sunday. The revamped racecourse was 146 km with an elevation gain of 1653 m. In hot late summer conditions, the race started off fast at Playa Mansa in the heart...

Cycling

Events

Press Releases

March 14, 2023

Wattbike steps in alongside Rapha to sponsor the Lincoln GP

/ENDURANCE SPORTSWIRE/ – The organisers of the Rapha Lincoln Grand Prix are delighted to announce that the 2023 edition taking place on May 14 – which will see the event into its 68th year – will be presented by Wattbike. The Nottingham-based indoor smart bike company has stepped in to support...

Cycling

Events

Press Releases

Sponsorship

March 14, 2023

Two-Time Paralympic Triathlon Medalist Grace Norman to Serve as Watch Us Thrive NIL Collective Ambassador

COLORADO SPRINGS, Colo. /ENDURANCE SPORTSWIRE/ – Two-time Paralympic triathlon medalist & 2022 world champion Grace Norman will serve as an ambassador for USA Triathlon’s Watch Us Thrive NIL Collective. As a Watch Us Thrive Ambassador, Norman will drive the collective’s resource needs and impact through social media promotion, speaking appearances, fundraising...

Giving

Press Releases

Sponsorship

Triathlon