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

April 4, 2023

ROLL Recovery Partners with Ragnar Relay as Official Sponsor for 2023 Season

BOULDER, Colo. (April 04, 2023)/ENDURANCE SPORTSWIRE/ – ROLL Recovery, a leader in recovery and athletic performance and innovators of deep tissue massage therapy tools, is delighted to announce its partnership with Ragnar Relays as their official recovery sponsor for 2023. ROLL Recovery, together with selected sponsors, will support the launch of...

Press Releases

Sponsorship

April 4, 2023

Pho3nix Foundation announces elite team

/ENDURANCE SPORTSWIRE/ - The Pho3nix Foundation is proud to announce its 2023 athlete ambassadors on the Pho3nix Team. The Pho3nix Team are an elite squad from across multiple sports who embody the Pho3nix ideals of triumph through adversity, staying true to one’s dreams, and paying forward the gift of sport...

Cycling

Press Releases

Sponsorship

Triathlon

April 3, 2023

B. Draddy & Zero Restriction Sign Ambassador Deal with Patrick Cantlay

NEW YORK, April 3, 2023 /ENDURANCE SPORTSWIRE/ – Summit Golf Brands, the leading manufacturer of high-end golf apparel and sportswear, today announced a partnership between two of their notable brands, B.Draddy and Zero Restriction, and world-renowned professional golfer, Patrick Cantlay.  Patrick is currently the 4th ranked golfer in the world. Patrick’s first tournament...

Press Releases

Sponsorship

March 31, 2023

Science in Sport (SiS) announces an exclusive partnership with Eilish McColgan, Britain’s top female long-distance runner

31st March - London, UK /ENDURANCE SPORTSWIRE/ – Science in Sport (SiS) has signed an exclusive partnership with Eilish McColgan. The global endurance nutrition brand will support Britain’s top female long-distance runner as she builds up to her eagerly awaited marathon debut at the London Marathon at the end of April -...

Press Releases

Running

Sponsorship

March 29, 2023

The IRONMAN Foundation Announces 2023 Ambassador Team and Service Project Schedule

TAMPA, Fla. (March 29, 2023) /ENDURANCE SPORTSWIRE/ – The IRONMAN Foundation, Inc., which aims to create positive, tangible change in race communities through grants and volunteerism efforts, announced today its 2023 IRONMAN Foundation Ambassador Team, along with 18 service project initiatives for the season. Leading the team as The IRONMAN Foundation...

Giving

Press Releases

Running

Sponsorship

Triathlon

March 28, 2023

VIBRAM and UTMB World Series announce a global partnership

Albizzate (Varese, Italy) / Chamonix (France), March 28th, 2023 /ENDURANCE SPORTSWIRE/ – UTMB® World Series and Vibram SpA, the global leader in the production of high-performance rubber soles, are proud to announce a new global partnership that will extend across all 35 UTMB World Series events including the most iconic trail...

Press Releases

Sponsorship

March 28, 2023

Selle Italia and Primal Wear team up to provide leader jerseys for the American Criterium Cup 2023 season.

/ENDURANCE SPORTSWIRE/ - Selle Italia and Primal Wear team up to provide the series leader jerseys for the American Criterium Cup 2023 season. Primal Wear is the Official Jersey Supplier, providing the overall and sprint leader jerseys. Primal helps partners pursue their passion by blending design, craftsmanship, and service to create...

Cycling

Events

Press Releases

Sponsorship

March 27, 2023

UTMB® World Series welcomes Näak as Official On Course Sports Nutrition and Sports Hydration Supplier

Chamonix (France) March 2023 /ENDURANCE SPORTSWIRE/ – UTMB ® World Series has partnered with Näak, the performance nutrition and hydration brand made for trail and ultra-runners, to bring sustainable fuel to the global trail running community. As Official On Course Sports Nutrition and Sports Hydration Supplier of the UTMB World Series,...

Press Releases

Sponsorship

March 27, 2023

Athletic Brewing Company continues partnership with Canada Running Series, Named Official Non-Alcoholic Beer of 3 Marquee Races

TORONTO, CAN (March 27, 2023) /ENDURANCE SPORTSWIRE/ – Athletic Brewing Company, America’s leading producer of non-alcoholic craft beer, has renewed its partnership with Canada Running Series (CRS), today announcing its return as the official non-alcoholic beer partner of the 2023 TCS Toronto Waterfront Marathon, and the 2023 Vancouver Half Marathon. Additionally,...

Events

Press Releases

Running

Sponsorship