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

August 3, 2022

Showcased

Elevate Women 4-Tri Malibu Triathlon Women’s Only Training Program

/ENDURANCE SPORTSWIRE/ – 2XU Malibu Triathlon is excited to announce the Elevate Women 4Tri 7-week triathlon training program will kick off the week off August 8th and lead right into race weekend September 17-18, 2022. The women’s only training program is designed to encourage participation for women learning the sport of...

Cycling

Events

Press Releases

Running

Triathlon

August 3, 2022

World’s Most Exclusive Half Marathon is back and running

August 3, 2022 /ENDURANCE SPORTSWIRE/ –  RunningFlat and Pelee Island Winery team up again to offer the most exclusive running experience in the world—an island run through one of Canada’s oldest grape growing regions making this Half Marathon Canada’s most Southern. Pelee Island, Ontario June 3rd 2023 —Canada’s southernmost half marathon, the...

Events

Press Releases

Running

Wire Syndication

August 2, 2022

IRONMAN Announces New IRONMAN 70.3 Morro Bay Triathlon in The Central Coast of California

MORRO BAY, Calif. / TAMPA, Fla. (Aug. 2, 2022) /ENDURANCE SPORTSWIRE/ - The IRONMAN Group, announced today that the seaside city of Morro Bay, California and the central California coastline will play host to the newest IRONMAN® 70.3® triathlon. The new IRONMAN 70.3 Morro Bay triathlon is schedule to take...

Events

Press Releases

Triathlon

August 2, 2022

GFNY back in Bali this Sunday

New York City, August 2, 2022/ENDURANCE SPORTSWIRE/ – This Sunday, the GFNY Championship Asia is held at GFNY Bali Element Camp on the ‘Island of the Gods’. The 136.9 km racecourse boasts 2126m of climbing in one of the most sought after travel destinations in the world. “The mere mention of...

Cycling

Events

Press Releases

August 1, 2022

‘La Vuelta Virtual 22’ Warm-Up Racing Weekend #4 – August

Madrid, Spain / August 1st, 2022/ENDURANCE SPORTSWIRE/ – La Vuelta calls on cyclists and fans, of all fitness levels, to ride with the pros from Equipo Kern Pharma and Elisa Scarlatta to explore Spain. Elisa Scarlatta is a passionate Italian amateur cyclist, an influencer and a multi-brand ambassador on social media,...

Cycling

Events

Press Releases

August 1, 2022

Get Ready to Run with Marathon Legends

MEDIA ALERT Monday 1 August /ENDURANCE SPORTSWIRE/ – The AbbottWMM Global Run Club today launched Legends Week – a new free virtual Challenge taking place from 15-19 August. Runners must complete one challenge a day, for five days, to earn their Legends Week virtual badge and enter a prize draw for a...

Events

Press Releases

Running

August 1, 2022

Run Local Race Series registration now open

LITTLE ROCK, ARK (August 1, 2022) /ENDURANCE SPORTSWIRE/ - Registration is now open for the Run Local Race Series, which includes three different major races each calendar year. The Run Local Race Series is a Little Rock Marathon-led grassroots health initiative that focuses on promoting the benefits of a healthy...

Events

Press Releases

Running

August 1, 2022

Exploring the Amazon Rainforest of Ecuador at a Unique Edition of Huairasinchi

/ENDURANCE SPORTSWIRE/ – Huairasinchi (a Kichwa word meaning strength of the wind) is the oldest race in the Adventure Racing World Series, and always one of the toughest. The 19th edition started in the jungle town of Tena, from where teams began a 330km course which saw them paddle the remote...

Events

Press Releases

July 31, 2022

Felicia Stancil Wins Elite Women’s BMX Racing World Championship

NANTES, France /ENDURANCE SPORTSWIRE/ –  Team USA showed up to the second day of racing at the 2022 UCI BMX Racing World Championships with 12 riders heading in to the quarterfinals. The highlight of the day came from the Elite Women’s race with Felicia Stancil (Lake Villa, Ill.; Factory SSquared/Answer) winning the...

Awards

Cycling

Events

Press Releases