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

October 16, 2023

Showcased

Concept2 to Offer Kinomap Demonstrations at World’s Largest Regatta

BOSTON (Oct. 16, 2023) /ENDURANCE SPORTSWIRE/ - Kinomap is thrilled to announce that its groundbreaking interactive indoor training app for rowers will be available for demonstration at the Head of the Charles Regatta, taking place Oct. 20-22. The Concept2 demonstration area will be located in Attager Row: Rowing & Fitness...

Events

Press Releases

October 16, 2023

One For the Record Books: History Is Made at The First-Ever Women’s Only Vinfast IRONMAN World Championship in Kailua-Kona, Hawai`I

KAILUA-KONA, Hawai`i /ENDURANCE SPORTSWIRE/ - For the first time in IRONMAN’s 40+ year history, Kailua-Kona played host to a standalone women’s VinFast IRONMAN World Championship. Not only was this a moment for the record books, but history was also made on the course across both the women’s professional and age-group...

Events

Press Releases

Triathlon

October 16, 2023

Haley Batten and Keegan Swenson win inaugural Life Time Little Sugar MTB race to kick off Big Sugar Classic week

Bentonville/Bella Vista, Ark., (Oct. 15, 2023) /ENDURANCE SPORTSWIRE/ - Northwest Arkansas saw a stacked field of the world’s top mountain bike racers at the Life Time Little Sugar MTB, in which Haley Batten of Santa Cruz, Calif. and Keegan Swenson of Heber City, Utah took first in the elite 100K...

Cycling

Events

Press Releases

October 16, 2023

They Did It Again! Back-to-Back Win for Keulen and Simmonds at Challenge Peguera-Mallorca

/ENDURANCE SPORTSWIRE/ - It was a thrilling day of racing on the island of Mallorca with a new Challenge Peguera-Mallorca course record set by Youri Keulen (NED) and another convincing win for Imogen Simmonds (SUI), both taking back-to-back wins two weekends in a row. Both Keulen and Simmonds took the...

Events

Press Releases

Triathlon

October 15, 2023

Lucy Charles-Barclay (GBR) Soars atop Stellar Field to Become The 2023 Vinfast Ironman World Champion in Kailua-Kona, Hawai`I

KAILUA-KONA, Hawai`i  /ENDURANCE SPORTSWIRE/ - History was made today in Kailua-Kona, Hawai`i as the first-ever women’s-only VinFast IRONMAN World Championship unfolded on triathlon’s historic homeland, with Great Britain’s Lucy Charles-Barclay earning the crown in a perfectly executed performance. The female professional field featured defending and past IRONMAN World Champions, as...

Events

Press Releases

Triathlon

October 13, 2023

18,000 runners for Long Beach Marathon presented by Philips Sonicare

LONG BEACH/ENDURANCE SPORTSWIRE/ - As the Director of Partnerships for the 39th annual Long Beach Marathon presented by Philips Sonicare, Phyllis Blanchard sees her job in a much broader scope than selling sponsorships and filling expo booths. “Our industry is in a real good position right now,” said Blanchard. “We...

Events

Press Releases

Running

October 12, 2023

Life Time Big Sugar Classic Set to Deliver Week of Epic Off-Road Cycling Events in Northwest Arkansas

Bentonville, Ark., (Oct. 12, 2023) /ENDURANCE SPORTSWIRE/ - Concluding an epic year of off-road racing across the country, Life Time (NYSE: LTH) is set to host more than 3,200 mountain and gravel bikers for a week of fun, fast dirt in Northwest Arkansas October 14-21. The eight-day celebration includes bike...

Cycling

Events

Press Releases

October 12, 2023

Derby based boobydoo pledge to fit 1000 women with the best sports bras for them

12th October 2023 - Derby, UK /ENDURANCE SPORTSWIRE/ – boobydoo are the UK’s leading sports bra experts, offering fitting advice and education for active women, while providing access to some of the most popular sports bra brands, including Shock Absorber, Sportjock, Panache Sport and Freya Active. The choice of elite teams, athletes...

Events

Press Releases

Products

Running

October 12, 2023

How To Watch: Women’s 2023 VinFast IRONMAN World Championship Kailua-Kona, Hawai’i

- Live race day coverage for professional women will air globally on Saturday, October 14 beginning at 4:30 a.m. HAST / 10:30 a.m. ET / 4:30 p.m. CEST; full details found on IRONMAN Live - Live LÉquipe will begin their coverage at 6:00 p.m. CEST - HR Fernsehen and Sportschau...

Events

Press Releases

Triathlon

October 12, 2023

2nd edition of GFNY Bento Gonçalves this Sunday

New York City, October 12, 2023 /ENDURANCE SPORTSWIRE/ - Bento Gonçalves, located in the heart of Brazil's wine region, will host the 2nd edition of GFNY Bento Gonçalves, where riders will tackle a 135.9km long racecourse with 2721m of climbing. “GFNY has been popular with Brazilians since its inception so...

Cycling

Events

Press Releases