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

August 30, 2023

Plan Your Race Calendar: IRONMAN Launches Summer 2024 IRONMAN 70.3 Triathlon Race Schedule in The United States, Canada, And Europe

- General registration for select summer 2024 IRONMAN 70.3 events now open by visiting, www.ironman.com/na-open-2024 or www.ironman.com/emea-open-2024 - Remaining 2024 IRONMAN 70.3 event schedule and on-sale dates to be released in coming months TAMPA, Fla. (August 30, 2023) /ENDURANCE SPORTSWIRE/ – IRONMAN is pleased to unveil its summer 2024 IRONMAN® 70.3®...

Events

Press Releases

Triathlon

August 30, 2023

25 Age-Group Athletes From Around The Globe Claim Division Titles At The 2023 VinFast IRONMAN 70.3 World Championship Triathlon In Lahti, Finland

LAHTI, Finland. (Aug. 30, 2023) /ENDURANCE SPORTSWIRE/ – Following another historic week of racing that saw Taylor Knibb (USA) and Rico Bogen (DEU) take professional titles at the 2023 VinFast IRONMAN® 70.3® World Championship, 25 other IRONMAN 70.3 World Champions were crowned in the amateur divisions on Saturday Aug. 26 and...

Events

Press Releases

Triathlon

August 30, 2023

Registration Open for the 2023 YMCA Turkey Trot Presented by UPMC Health Plan

PITTSBURGH (August 30, 2023) /ENDURANCE SPORTSWIRE/ – Registration is open for the 2023 YMCA Turkey Trot presented by UPMC Health Plan, a beloved Pittsburgh tradition that inspires families to move together on Thanksgiving day. This year’s event will offer a 5-mile, 5K and 1-mile fun run, while raising funds to help...

Events

Press Releases

Running

August 30, 2023

Virginia’s Blue Ridge TWENTY24 Melisa Rollins Wins Belgian Waffle Ride Utah

ROANOKE, Virginia — August 30, 2023/ENDURANCE SPORTSWIRE/ – The Belgian Waffle Ride, affectionately known as the BWR, is undoubtedly the most unique cycling event series in North America. The Cedar City race was the fifth of seven BWR events in 2023 and offered the essential elements of a proper BWR with waffles,...

Cycling

Events

Press Releases

August 30, 2023

Two GFNY Europe races this past Sunday

New York City, August 30, 2023 /ENDURANCE SPORTSWIRE/ - For the inaugural edition of GFNY Sweden Uppsala racers tackled 133.8km with 1592m of climbing along the rolling hills of the wild Uppsala countryside. Under perfect late summer conditions, 14 riders formed the lead group after the first unpaved section, including...

Cycling

Events

Press Releases

August 30, 2023

Georgia Communities Welcome Back Athens to Savannah Ride

Sandersville, GA, August 30, 2023 /ENDURANCE SPORTSWIRE/ - Georgia Hi-Lo Trail Inc. and Sports Strategies announce the 2023 edition of the Athens to Savannah Ride, taking cyclists on their choice of a 4-day Gravel Ride or a 3-day Road Ride across rural Georgia. The ride starts from Athens on October...

Business

Cycling

Events

OSW Syndicated

Press Releases

August 30, 2023

GSI Outdoors and Buck Knives Partner to Celebrate Outdoor Cooking with Exclusive Prize Pack Giveaway

Spokane, Wash. — August 30, 2023 /ENDURANCE SPORTSWIRE/ - GSI Outdoors and Buck Knives are thrilled to announce an exciting partnership that celebrates the joy of cooking in the great outdoors. In collaboration with renowned outdoor cooking chefs, Adam and Jessica Cheek of @adam.northwest, the brands are set to launch...

Awards

Business

Events

OSW Syndicated

Press Releases

Products

Sponsorship

August 30, 2023

BibRave Creates an Unforgettable Strava Community Activation

Portland, OR /ENDURANCE SPORTSWIRE/ – BibRave, the leading-edge endurance and fitness marketing agency, expertly executed a short-timeline, high-profile collaboration event for the connected fitness platform, Strava. Featuring a midnight group run and watch party, the event supported the U.S. Women’s National Soccer Team during their Round 16 match. The event was...

Events

Press Releases

Running

August 29, 2023

IRONMAN Comes to The Dominican Republic for The First Time with the Addition of The 2024 IRONMAN 70.3 Cap Cana Triathlon Taking Place in Cap Cana

- Cap Cana will host the first-ever IRONMAN 70.3 triathlon in the Dominican Republic with the inaugural edition taking place on April 28, 2024 - IRONMAN 70.3 Cap Cana triathlon general registration is open by visiting www.ironman.com/im703-cap-cana CAP CANA, Dominican Republic / TAMPA, Fla. (Aug. 29, 2023)/ENDURANCE SPORTSWIRE/ – IRONMAN announced...

Events

Press Releases

Triathlon