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

June 29, 2023

46th Crim 10-Mile Race Seeks Title Sponsor

Flint, MI /ENDURANCE SPORTSWIRE/ –The HAP Crim Festival of Races, the signature event of the Crim Fitness Foundation, is returning to the historic bricks of downtown Flint for the 46th time August 25-26. The Festival, home to one of the nation’s largest and oldest 10-mile races, the “Crim,” is seeking a...

Events

Press Releases

Running

Sponsorship

June 29, 2023

Chasing Watts releases new details of their Chasing Watts Century Challenge.

/ENDURANCE SPORTSWIRE/ - Chasing Watts, the leading app for connecting cyclists with group rides, is thrilled to announce the fourth edition of the highly anticipated Chasing Watts Century Challenge. This year, the challenge takes on a new and exciting twist, as it puts the power in the hands of ride...

Cycling

Events

Press Releases

Sponsorship

June 29, 2023

Two-Time MLB All-Star Justin Turner Creates Signature Collection with Kaenon Sunglasses

Irvine, Calif (June 29, 2023)/ENDURANCE SPORTSWIRE/ – Kaenon is releasing its first signature sunglass collection with two-time MLB All-Star Justin Turner. The first installment of the Justin Turner Signature Collection from Kaenon includes two versions of the Arcata SR, Turner's preferred model for on-field play. Unlike typical athlete-endorsement relationships, Turner has a...

Press Releases

Sponsorship

June 28, 2023

BibRave Elevates Brooks Running Reach to Lifestyle Consumers

Honolulu, HI/ENDURANCE SPORTSWIRE/ – BibRave, the leading-edge endurance and fitness marketing agency, launched an Influencer campaign as part of their year-long retainer with Brooks Running, to position how Brooks performance running and walking shoes can transition to everyday life and be part of personal fashion expression. The campaign leveraged Brooks’ evergreen...

Press Releases

Running

Sponsorship

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