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

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

August 29, 2023

The Running Event Announces 2023 Educational Program

PORTLAND, Maine (August 29, 2023)/ENDURANCE SPORTSWIRE/ – The Running Event (TRE), North America’s premier specialty retail conference and tradeshow, has announced its 2023 educational program. The Running Event will be held November 28-30 at the Austin Convention Center in Austin, TX. “Our educational program is once again packed with insights and actionable...

Press Releases

Running

Trade Shows

August 29, 2023

Historic West Virginia Race Partners with Kinomap to Gain Global Exposure

CHARLESTON, West Virginia (Aug. 29, 2023) – The Charleston Distance Run will mark 50 years running this Labor Day weekend, and its 5K event is taking an exciting step towards global participation thanks to the Kinomap app. The shorter race will be available on the Kinomap for Races platform later...

Events

Press Releases

Running