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 (21085)
) 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 0, 10

December 4, 2024

Sumarpo Launches Prana Core Triathlon Wetsuit Limited Edition

December 4 /ENDURANCE SPORTSWIRE/ - Sumarpo, a leading name in eco-friendly triathlon gear, proudly announces the release of its newest innovation, the Prana Core Triathlon Wetsuit Limited Edition. This latest addition to Sumarpo's triathlon lineup is a game-changer, offering unmatched performance, advanced features, and stunning aesthetics. The Prana Core Triathlon...

Press Releases

Products

Triathlon

December 4, 2024

Best Bike Split Enhances Training Precision with Direct Zwift Integration

Austin, TX (December 3, 2024) /ENDURANCE SPORTSWIRE/ - Best Bike Split (BBS), the premier platform for athlete race day planning and course-specific training, is excited to announce a new integration with Zwift, the leading indoor cycling application. This collaboration enables athletes to seamlessly transfer race plans, AI-generated workouts, and sessions...

Business

Cycling

Press Releases

Products

Triathlon

December 3, 2024

Launch of the Ubidium Ground Antenna//Redefining Efficiency and Performance in Sports Timing

December 3. /ENDURANCE SPORTSWIRE/ - The official launch of the Ubidium Ground Antenna marks a significant milestone for RACE RESULT and the evolution of sports timing worldwide. With its cutting-edge technology, event timing is now more efficient, user-friendly, and adaptable than ever. After years of development, hundreds of test events,...

Business

Cycling

Events

Press Releases

Products

Running

Trade Shows

Triathlon

December 2, 2024

Step into the Future of Winter Trail Running with Ulu at ISPO 2024

Munich, Germany – [Monday 2nd December 2024] /ENDURANCE SPORTSWIRE/ – Ulu Outdoor, a pioneer in winter-ready athletic footwear, proudly announces its debut at ISPO Munich 2024 with the launch of the groundbreaking Amak Arctic Stride Winter Trail Running Shoes. Recently honored with the prestigious ISPO Award, the Amak Arctic Stride embodies Ulu’s...

Press Releases

Products

Running

Trade Shows

November 28, 2024

Datasport Germany to time the 2025 Regensburg and Luxembourg Marathons using MYLAPS technology

November 18 /ENDURANCE SPORTSWIRE/ - Datasport Germany GmbH, a company specializing in sports timing, accurately times a wide range of sporting events in Germany and its surrounding countries. In 2025, they will provide timing services for two additional marathons using MYLAPS BibTag technology. The Regensburg Marathon and the Luxembourg Marathon,...

Business

Press Releases

Products

Running

November 26, 2024

Celebrating 15 Years of Striker: A Legacy of Safety and Innovation

November 26, 2024 - Hudson, WI -/ENDURANCE SPORTSWIRE/ -  Striker, a brand renowned for industry-leading fishing apparel, proudly celebrates 15 years of providing anglers with the most trusted fishing apparel on the market. Since the development of the brand in 2009 by Jim Poucher, Striker has been dedicated to equipping anglers...

Business

Press Releases

Products

November 26, 2024

Gift Health, Happiness, and AI Innovation with Humango

Boulder, CO. (November 26, 2024) /ENDURANCE SPORTSWIRE/ – As the holiday and gift-giving season approaches, Humango™, a digital training platform for endurance athletes that provides personalized and adaptive training plans, is set to release a series of incredible discounts for the health and wellness enthusiast close to you. In a...

Press Releases

Products