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 (11)
) 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 1140, 10

June 4, 2024

Pelotan Welcomes Kristian Blummenfelt and Gustav Iden as Athlete Investors Amid U.S. Market Expansion

/ENDURANCE SPORTSWIRE/ – Pelotan, the high-performance sunscreen brand engineered for athletes, is proud to announce that world-renowned triathletes Kristian Blummenfelt and Gustav Iden have joined the Pelotan family as athlete investors. This exciting partnership comes at a pivotal moment as Pelotan embarks on an investment round aimed at expanding into...

Business

Press Releases

Triathlon

June 4, 2024

TriDot And 3x IRONMAN World Champion Craig Alexander Launch Exclusive Global Coaching Partnership

DALLAS, TX – JUNE 4, 2024 /ENDURANCE SPORTSWIRE/ – TriDot, an award-winning division of Predictive Fitness, Inc. and the Official Training Platform of IRONMAN®, and 3X Hawaii IRONMAN World Champion Craig “Crowie” Alexander, announced today an exclusive and wide-ranging global coaching partnership that includes Crowie’s renowned Sansego Triathlon Club. TriDot...

Business

Press Releases

Triathlon

June 3, 2024

TrainingPeaks Partners with AusCycling as Official Software Provider

Louisville, Colo., June 3, 2024 /ENDURANCE SPORTSWIRE/ - TrainingPeaks, the industry-leading training app for endurance coaches and athletes, today announced an exclusive partnership with AusCycling — the national sports organization responsible for the development, facilitation and growth of all forms of cycling and riding in Australia. Under the new agreement,...

Business

Press Releases

May 30, 2024

supertri Announces New Team Franchise Model and Podium Racing as First License Owner

/ENDURANCE SPORTSWIRE/ – supertri is making a departure from the traditional model of league-owned teams to a bold new structure of franchise-based ownership and can today announce the first of its four teams as Podium Racing. supertri’s new initiative is a strategic move designed to enhance the league's resonance with...

Business

Press Releases

Triathlon

May 30, 2024

BibRave Partners with Hydration Technology Pioneer, Water.io for North American Launch

Boston, MA /ENDURANCE SPORTSWIRE/ – BibRave, the leading-edge endurance and fitness marketing agency, recently launched a partnership with the groundbreaking Israeli technology company, Water.io - the powerhouse behind some of the world's most innovative smart water bottles. This collaboration marks a significant step forward in enhancing hydration technology and education...

Business

Events

Press Releases

Running

May 29, 2024

Suunto Named Presenting Sponsor of 2024 Hardrock Hundred Livestream

Silverton, COLORADO /ENDURANCE SPORTSWIRE/ - Mountain Outpost is excited to announce a partnership with Suunto, a global leader in the wearables space, for the 2024 Hardrock Hundred Livestream. This collaboration will help bring an elevated livestream experience to one of the most iconic 100-mile foot races in the world to...

Business

Events

Press Releases

Products

Running

Sponsorship