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

June 2, 2024

In Her First Full Distance Triathlon Since 2015, Jackie Hering (USA) Takes the Crown at the 2024 IRONMAN European Championship Hamburg

HAMBURG, Germany (June 2, 2024) /ENDIRANCE SPORTSWIRE/ - Hamburg today hosted the sixth IRONMAN Pro Series™ event of the year with the IRONMAN® European Championship for female professional triathletes. The race saw Jackie Hering (USA) crowned IRONMAN European Champion in her first full distance IRONMAN triathlon since 2015. Her epic...

Events

Press Releases

Triathlon

June 2, 2024

Life Time UNBOUND Gravel 2024 Crowns Finishers After an Epic Day in the Flint Hills

EMPORIA, Kan., (June 2, 2024) /ENDURANCE SPORTSWIRE/ - With over 4,000 riders representing all 50 states and 44 countries, Life Time UNBOUND Gravel 2024 marks the largest field size in the event’s history. The weekend commenced with the All-Things Gravel Expo presented by the City of Emporia, with hundreds of...

Cycling

Press Releases

June 2, 2024

Life Time Unbound Gravel 200: Lachlan Morton and Rosa Klöser Conquer The Flint Hills Of Kansas

Emporia, KS /ENDURANCE SPORTSWIRE/ - An unprecedented nine-rider sprint finish resulted in a stunning debut win for German PhD student, Rosa Klöser, in the women's elite UNBOUND Gravel 200. Australian fan-favorite Lachlan Morton (EF Education-EasyPost) took his first victory in the men's race following a thrilling long-range breakaway alongside second-place finisher, Chad Haga (USA). A...

Cycling

Press Releases

June 2, 2024

Guillem Montiel and Aurélia Boulanger Triumph at OTSO Challenge Salou

/ENDURANCE SPORTSWIRE/ - Salou's sun-soaked Spanish holiday town was the perfect backdrop for the OTSO Challenge Salou triathlon, which brought together athletes from 43 nations. With a competitive field of professional and age-group athletes, the race delivered stunning performances and a dramatic sprint finish, with Guillem Montiel (ESP) and Aurélia...

Events

Press Releases

Triathlon

May 31, 2024

USABA and PlayLA Adaptive Sports Blind Soccer Experience Slated for June 6

May 31, 2024/ENDURANCE SPORTSWIRE/ – LA City Recreation and Parks PlayLA Youth Adaptive Sports Program and the U.S. Association of Blind Athletes (USABA) are holding a blind soccer clinic experience for the Los Angeles Unified School District (LAUSD) blind and visually impaired students on Thursday, June 6. The students will learn...

Events

Press Releases

May 31, 2024

San Jose Half & 8K presented by Kaiser Permanente celebrates Running is for Everyone

SAN JOSE, Calif. – (May 31, 2024) /ENDURANCE SPORTSWIRE/ – The San Jose Half & 8K presented by Kaiser Permanente benefiting Special Olympics Northern California celebrates Running is for Everyone in its 12th edition. The revamped event will provide a unique three-day festival at Santana Row, open to the public,...

Events

Press Releases

Running

May 31, 2024

Salty Sports Society Announces Another Successful AMI Hogfish Swim

Fernandina Beach, Florida /ENDURANCE SPORTSWIRE/ – The 5th Annual Speedo SALT Series, AMI Hogfish Swim took place during challenging weather conditions leading to course changes. Facing a westward wind direction, with gusts of up to 22 miles per hour, on Anna Maria Island, FL, Salty Sports Society staff made several...

Events

Press Releases

May 31, 2024

CapTex Tri 2024 Celebrates Triumphs and Community Spirit

AUSTIN, Texas /ENDURANCE SPORTSWIRE/ - The Ascension Seton CapTex Triathlon drew in over 2,000 triathletes from more than 34 states and 11 countries. Participants took on the challenge, navigating a swim in Lady Bird Lake, cycling through downtown streets, and taking on the run along Auditorium Shores. Athletes showcased their...

Events

Press Releases

Triathlon

May 31, 2024

Introducing Ultra X I Feel Slovenia

/ENDURANCE SPORTSWIRE/ – Global ultra-marathon events series, Ultra X announced I Feel Slovenia as headline partner for Ultra X Slovenia 2024. Ultra X Slovenia is a multi-stage ultra-marathon taking place over five days with options for competitors to join for five, two or one stage (s). The race will take...

Press Releases

Running

Sponsorship