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

June 6, 2024

supertri Doubles Down On US Commitment With Stars & Stripes Racing Launch And Elite Athlete Opportunities

/ENDURANCE SPORTSWIRE/ – supertri can today unveil the second team taking part in its 2024 League season and a deepening of its commitment to growing short-course triathlon in the USA. Stars & Stripes Racing is managed by Parker Spencer, USAT Olympic Coach of the Year and the head coach of...

Business

Press Releases

Triathlon

June 6, 2024

Enabled Tracking to Provide Live GPS Tracking for June 2024 Endurance Events

Front Royal, VA – June 2024 /ENDURANCE SPORTSWIRE/ - Enabled Tracking, the timing and tracking division of Adventure Enablers, proudly announces its cutting-edge live GPS tracking services tailored for an array of endurance events slated throughout the month. From navigating rugged terrains to conquering multi-day challenges, Enabled Tracking stands poised...

Business

Events

Press Releases

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