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 (8742)
) 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 550, 10

August 22, 2024

PAYNTR Golf and Carbitex Debut The TRAINER CARBON X

Portland, OR /ENDURANCE SPORTSWIRE/ – PAYNTR Golf, North America’s fastest growing golf footwear brand, today announces the launch of the TRAINER CARBON X, a revolutionary training shoe developed in collaboration with Carbitex®, a leading expert in high-performance materials. Engineered to elevate both on and off-course performance, the TRAINER CARBON X is...

Press Releases

Products

August 22, 2024

BibBoards Introduces Plant-Based Core Materials and Reduced Pricing for Events and Runners

San Ramon, CA] – [8/22/2024]/ENDURANCE SPORTSWIRE/ – BibBoards, the leading provider of innovative, eco-friendly race bib fasteners, is excited to announce a significant milestone in our commitment to sustainability and affordability. We are proud to introduce plant-based core materials in our products, reinforcing our dedication to protecting the environment while enhancing...

Press Releases

Products

Running

Triathlon

August 22, 2024

Double race weekend for GFNY in Europe

/ENDURANCE SPORTSWIRE/ – GFNY Sweden Uppsala The second edition of GFNY Uppsala offers racers a 133.5 km long course with 494m of climbing. Uppsala is less than an hour from Stockholm. The course will take riders along rolling hills of the Uppsala countryside. There will also be hard packed unpaved...

Cycling

Events

Press Releases

August 22, 2024

H2O Audio Launches TRI 2 Multi-Sport Series

SAN DIEGO, Aug. 22, 2024 /ENDURANCE SPORTSWIRE/ - H2O Audio, the leader in waterproof audio technology, proudly announces its latest innovation, the TRI 2 Multi-Sport Series. Building on over two decades of pioneering technology, these headphones set a new standard in bone conduction audio and represent the pinnacle of H2O...

Press Releases

Products

Wire Syndication

August 22, 2024

2024 XTERRA Costa Rica Preview: Lining Up at Las Catalinas

LAS CATALINAS, COSTA RICA /ENDURANCE SPORTSWIRE/ - Marking its return as the 18th stop on the 2024 XTERRA Americas Tour, XTERRA Costa Rica introduces a fresh team, course, and venue for an off-road racing weekend on August 24-25. Set in the holiday town of Las Catalinas, the Full Distance Triathlon...

Cycling

Events

Press Releases

Running

Triathlon

August 22, 2024

BibRave Steps Up to the Plate to Elevate The Giant Race

San Francisco, CA /ENDURANCE SPORTSWIRE/ – BibRave, the leading-edge endurance and fitness marketing agency once again partnered with Giants Enterprises, the entrepreneurial arm of the San Francisco Giants Major League Baseball franchise, to elevate the 15th annual Giant Race, presented by Alaska Airlines. This successful collaboration resulted in an impressive...

Business

Press Releases

Running

August 21, 2024

TAXA Outdoors Unveils New TAXA X Off-Road Models

Houston, Texas – August 21, 2024 /ENDURANCE SPORTSWIRE/ – TAXA Outdoors, the leading manufacturer of lightweight, minimalist mobile habitats for outdoor adventure, proudly announces TAXA X – next-generation off-road habitats designed to conquer the most rugged terrain. TAXA X trailers include Mantis X, Cricket X, TigerMoth X, and Woolly Bear X,...

Press Releases

Products

August 21, 2024

Danny Pate Joins BaseCamp as Lead Coach

Carlisle, Pennsylvania, August 21, 2024/ENDURANCE SPORTSWIRE/ – BaseCamp, the premier cycling community dedicated to helping athletes achieve their highest potential, is thrilled to announce the addition of renowned cyclist Danny Pate as a lead coach. With a professional career spanning over fifteen years, Pate brings unparalleled experience and expertise to BaseCamp,...

Business

Cycling

Press Releases

August 21, 2024

Challenge Samarkand Returns with World-Class Triathletes

/ENDURANCE SPORTSWIRE/ – Norwegian athletes Gustav Iden and Kristian Blummenfelt lead the men's field lineup. Iden, winner of The Championship 2023 and Hawaii champion 2022, is on a comeback and recently won Challenge Turku. Blummenfelt, the 2022 middle-distance world champion, comes fresh from competing in the Olympic Games. They are...

Events

Press Releases

Triathlon