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

April 28, 2024

Tomas Rodriguez Hernandez (MEX) And Kat Matthews (GBR) Victorious at 2024 Memorial Hermann IRONMAN North American Championship Texas Triathlon Claiming Maximum IRONMAN Pro Series Points

THE WOODLANDS, Texas /ENDURANCE SPORTSWIRE/ - The Lone Star state and The Woodlands, Texas played host to the 2024 Memorial Hermann IRONMAN® North American Championship Texas, part of the VinFast IRONMAN North America Series, doubling as the second event of the IRONMAN Pro Series™, on April 27. In the first...

Events

Press Releases

Triathlon

April 28, 2024

Wins for Jack Moody and Els Visser at Challenge Taiwan

/ENDURANCE SPORTSWIRE/ - Over 8,000 athletes lined up in spectacular Taitung this weekend with Jack Moody (NZL) and Els Visser (NED) taking out the 12th Challenge Taiwan titles in 3:49:16 and 4:08:39 respectively. The day started overcast and warm with high humidity levels and a water temperature of 24C meaning...

Events

Press Releases

Triathlon

April 26, 2024

Denver Colfax Marathon Introduces New “Colfax FLY Feet” Program

Denver, CO /ENDURANCE SPORTSWIRE/ - The 18th Denver Colfax Marathon, presented by Cigna Healthcare, is thrilled to introduce a new youth-focused element to its race weekend in May. In its inaugural year, the “Colfax FLY Feet” program, is a platform for at-risk Colorado kids to participate in Denver’s largest running...

Business

Events

Giving

Press Releases

Running

Sponsorship

April 25, 2024

HOKA Kodiak Ultra Marathons by UTMB Designated as UTMB World Series Major for 2025

- 2025 HOKA Kodiak Ultra Marathons by UTMB to serve as the UTMB World Series Americas Major in 2025, giving all finishers more opportunities to qualify for the iconic UTMB World Series Finals at HOKA UTMB Mont-Blanc - 2024 UTMB World Series Americas Major takes place at HOKA Canyons Endurance...

Events

Press Releases

April 25, 2024

The Armed Forces Cycling Classic Returns for the 26th Edition in Arlington June 1st and 2nd

ARLINGTON, VA /ENDURANCE SPORTSWIRE/ - The Armed Forces Cycling Classic (AFCC), presented by The Boeing Company, celebrates its 26th Edition as the DMV region’s most prestigious cycling event when it returns to Arlington, VA the weekend of June 1st and 2nd. Saturday’s Challenge Ride, for cyclists of all abilities, will kick...

Cycling

Events

Press Releases

April 25, 2024

Ascension Seton CapTex Tri and GU Energy Labs Continue Partnership to Fuel Athletes

Austin, Texas, April 25, 2024 /ENDURANCE SPORTSWIRE/ - The Ascension Seton CapTex Tri is delighted to announce the continuation of its partnership with GU Energy Labs, who will once again serve as the event's official Energy Gel and Chew sponsor of the premier downtown triathlon. Athletes participating in the triathlon...

Events

Press Releases

Sponsorship

Triathlon

April 24, 2024

Sprint finish at inaugural Michelob Ultra GFNY Miami

New York City, April 24, 2024 /ENDURANCE SPORTSWIRE/ - Miami hosted the highly lauded first edition of the Michelob Ultra GFNY Miami this past Sunday. 700 riders from over 30 countries tackled the closed to traffic, completely flat and very fast long racecourse of 70.7 miles with start and finish...

Cycling

Events

Press Releases

April 24, 2024

2024 XTERRA World Cup Heats Up with Stop #2 in Greece

Key Points: Vouliagmeni set to host stop #2 of the series amidst crystal-clear waters and fast, flowing trails. Series leaders Solenne Billouin and Felix Forissier face stiff competition from 2024 newcomers including Arthur Serrières and Sandra Mairhofer. Over 50 elite competitors will battle for series points, heightening the intensity of...

Cycling

Events

Press Releases

Running

Triathlon

April 24, 2024

Top Contenders Line Up for The Championship 2024

/ENDURANCE SPORTSWIRE/ – The Challenge Family flagship event over the middle distance, The Championship, is less than a month away. More than 80 professional athletes will line up alongside over 1,600 age group athletes from 57 nations to decide Challenge Family’s ultimate accolade, Champion of The Championship, on 19 May...

Events

Press Releases

Triathlon