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 (22)
) 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 580, 10

June 27, 2023

Join the Ride: Bike Fest 2023 Brings Cycling, Community, and Celebration to Asheville, NC

Asheville, NC, June 27, 2023 /ENDURANCE SPORTSWIRE/ - Asheville on Bikes (AoB) is thrilled to announce the return of the much-anticipated 2nd annual Bike Fest, presented by Cane Creek Cycling Components. The event kicks off in Asheville on Friday, July 14, and runs through Saturday, July 15. The Gran Fondo Asheville...

Business

Cycling

Events

Press Releases

Sponsorship

June 23, 2023

Wattbike support the first ever Esports Olympic Series

23rd June 2023 - UK/ENDURANCE SPORTSWIRE/ – The original, indoor smart bike innovator Wattbike is the choice of both elite athletes and fitness enthusiasts around the globe, and the team were delighted that the Olympic Esports Finals chose their award-winning Wattbike Atom for their cycling event which took place today. Presented...

Cycling

Events

Press Releases

Sponsorship

June 21, 2023

F45 Training Partners with Spartan Race to Become the Official 45-Minute Workout to Train like Obstacle Race Champions

AUSTIN, TX. – June 21, 2023 /ENDURANCE SPORTSWIRE/ – F45 Training Holdings Inc (“F45 Training” or “F45”), the global high-intensity interval training brand, and Spartan Race, the world’s largest endurance racing brand that also owns Tough Mudder, DEKA and SpartanTrail, have agreed to partner on the creation of Spartan-themed workouts for F45 studios and...

Events

Press Releases

Running

Sponsorship

June 21, 2023

Northwell Health To Serve as Title Partner for Northwell Health IRONMAN 70.3 New York – Jones Beach

TAMPA, Fla. / NEW YORK, N.Y. /ENDURANCE SPORTSWIRE/ - IRONMAN announced today that Northwell Health,New York’s largest healthcare provider will serve as the title partner of the inaugural Northwell Health IRONMAN® 70.3® New York – Jones Beach triathlon. Northwell will also serve as the Official Volunteer Partner and Official Medical...

Events

Press Releases

Sponsorship

Triathlon

June 20, 2023

Osmo Nutrition Announces Partnership with Pro Gravel Cyclist Brennan Wertz

Sausalito, CA. (June 20, 2023)/ENDURANCE SPORTSWIRE/ – Osmo Nutrition, a leading provider of hydration and nutrition products for athletes, is excited to announce a partnership with professional gravel cyclist, Brennan Wertz. This collaboration marks a significant milestone for Osmo as it continues to expand its presence in the gravel cycling community. With...

Cycling

Press Releases

Products

Sponsorship

June 20, 2023

Denver Colfax Marathon Awards Over $100,000 to Colorado Charities and Schools

Denver, CO /ENDURANCE SPORTSWIRE/ - The Denver Colfax Marathon concluded its 2023 marathon season by giving more than $100,000 to organizations within the Colorado community. The marathon awarded 75 checks this past week to local charities and schools at its annual awards celebration in Denver. “We are extremely proud to...

Awards

Business

Events

Giving

Press Releases

Running

Sponsorship

June 14, 2023

UltraSignup Announces Courtney Dauwalter will join as Commentator for Broken Arrow Skyrace Livestream

Nashville, TN/ENDURANCE SPORTSWIRE/ – UltraSignup, the leading online marketplace and registration platform for trail and ultra-running events, is thrilled to announce the addition of renowned ultra-runner Courtney Dauwalter as a commentator for this weekend’s livestream of the 23K at The Broken Arrow Skyrace. Additionally, the UltraSignup team is partnering with Tommie Runz,...

Press Releases

Running

Sponsorship

June 14, 2023

Frontwave Rides On With Bike The Coast As Title Sponsor

OCEANSIDE, Calif. /ENDURANCE SPORTSWIRE/ – Bike The Coast, Southern California’s premier coastal cycling event, has announced that Frontwave Credit Union has once again signed on as the ride’s title sponsor for 2023 and 2024. The longstanding partnership signals Frontwave’s continued dedication to the local community and events that bring visibility to...

Cycling

Events

Press Releases

Sponsorship