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

May 16, 2025

Start Lists Revealed for Qatar Airways IRONMAN Hamburg European Championship Triathlon, the Eighth Stop on the IRONMAN Pro Series Circuit

  Reigning IRONMAN European Champion Jackie Hering (USA) is back to defend her title, but will face fierce competition from the likes of 2024 IRONMAN World Champion, Laura Philipp (DEU), and 2024 IRONMAN Pro Series winner and three-time IRONMAN North American Champion, Kat Matthews (GBR) The IRONMAN Hamburg European Championship...

Events

Press Releases

Triathlon

May 16, 2025

The Championship 2025 Press Conference – What the Athletes Said

May 16, 2025 /ENDURANCE SPORTS/ - Some of the world’s top professional triathletes are gearing up for The Championship, kicking off this Sunday at 8:30 a.m. in Šamorín, Slovakia. At the recent pro press conference, the athletes shared their thoughts ahead of Sunday’s race. It was clear that no one...

Events

Press Releases

Triathlon

May 15, 2025

The Championship 2025 – Countdown to Race Weekend

May 15, 2025 /ENDURANCE SPORTSWIRE/ - The stage is set for The Championship 2025 with over 2,200 athletes from 66 nations lining up this weekend at the iconic x-bionic sphere near Bratislava for the largest-ever edition of Challenge Family’s flagship event. Headlining the flagship race on Sunday are some of...

Events

Press Releases

Triathlon

May 15, 2025

Electrolit & Spartan: Keeping Racers Hydrated for Another Season

BOSTON, MASS. (May 15, 2025) /ENDURANCE SPORTSWIRE/ — Spartan Race Canada and Electrolit Canada are pleased to announce the continuation of their successful partnership that originated in 2024, with Electrolit Canada returning as the Official Hydration Partner for the 2025 season. This ongoing collaboration unites two powerful forces, both dedicated...

Events

Press Releases

Sponsorship

May 15, 2025

The Bay Ride Partners with CalBike for 2025 Ride

SAN FRANCISCO, CA — May 15th, 2025 /ENDURANCE SPORTSWIRE/ - LiveTheBay.org, the non-profit organization behind The Bay Ride, is proud to announce a new partnership with CalBike for the 2025 event. This collaboration marks an exciting new chapter as The Bay Ride approaches its 11th annual circumnavigation of the San...

Business

Cycling

Events

Press Releases

Sponsorship

May 15, 2025

Nation’s Largest Adventure Race Celebrates Ten Years under Leadership

RIB MOUNTAIN (May 15, 2025) /ENDURANCE SPORTSWIRE/ – Race directors, Tim Buchholz and Anna Nummelin, are celebrities in the sport of adventure racing.  Not only is the couple perennial national contenders, but they have left a legacy as elite race directors.  When they decided to give back to the sport...

Cycling

Events

Press Releases

Running

Triathlon

May 15, 2025

13th Michelob ULTRA GFNY World Championship NYC and 2nd Gran Premio New York City this Sunday

NEW YORK CITY (May 15, 2025) /ENDURANCE SPORTSWIRE/ – The second annual UCI 1.2 men’s elite pro race Gran Premio New York City will take place this Sunday and will commence just ten minutes before the 13th Michelob ULTRA GFNY World Championship NYC, a mass participation race held on the...

Cycling

Events

Press Releases

May 15, 2025

Baltimore Running Festival to Host 25th Anniversary Health & Fitness Expo at Historic Harborplace

BALTIMORE, MD (May 15, 2025) /ENDURANCE SPORTSWIRE/ — The Baltimore Running Festival will celebrate its 25th anniversary with a nod to local history, announcing that this year’s Health & Fitness Expo will be held at the iconic Harborplace Light Street Pavilion at the Inner Harbor. The expo, scheduled for Friday,...

Business

Events

Press Releases

Running

May 14, 2025

Eight Initial Teams Announced for Inaugural 2025 Maryland Cycling Classic Women’s Race

BALTIMORE, May14, 2025 /ENDURANCE SPORTSWIRE/ - The Maryland Cycling Classic, America’s biggest and highest-ranked professional women’s road race, announced the participation of eight teams including top-ranked women’s World Tour team CANYON-SRAM zondacrypto (GER) and UCI Women Pro Team EF Education-Oatly (USA) as well as six other initial teams for the...

Cycling

Events

Press Releases