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

June 3, 2024

Rock ‘n’ Roll Running Series San Diego Runners are on the rise with more participating in Race Weekend year over year

- Runners went the distance this year with a 21 percent increase in marathoners from last year; Over 30,000 registered participants over the weekend - Rene Ortiz (Rioverde, Mexico) and Dakota Bliler (Scottsdale, Ariz.) were winners in the Rock ‘n’ Roll Running Series San Diego Marathon - Ayrton Ledesma (Azusa,...

Events

Press Releases

Triathlon

June 3, 2024

It’s Time to Climb! Climb 4 Climate Boston 2024 Inaugural Event Comes to Harvard Stadium on August 10, 2024

BOSTON, MA – June 3, 2024 /ENDURANCE SPORTSWIRE/ – Climb 4 Climate, a non-profit on a mission to fight climate change, today announced its inaugural stadium stair-climbing event will be held on Saturday, August 10, 2024, at iconic Harvard Stadium. Climate change is the existential crisis of our time. Millions...

Events

Giving

Press Releases

Running

June 3, 2024

TrainingPeaks Partners with AusCycling as Official Software Provider

Louisville, Colo., June 3, 2024 /ENDURANCE SPORTSWIRE/ - TrainingPeaks, the industry-leading training app for endurance coaches and athletes, today announced an exclusive partnership with AusCycling — the national sports organization responsible for the development, facilitation and growth of all forms of cycling and riding in Australia. Under the new agreement,...

Business

Press Releases

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