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

August 26, 2024

KUIU Introduces New Kodiak 2000 Cooler Backpack

Aug. 26, 2024 -- Dixon, CA /ENDURANCE SPORTSWIRE/ –KUIU, the leading manufacturer of high-performance hunting apparel and gear, proudly introduces the Kodiak 2000 Cooler Backpack. Purpose-built to eliminate the need for multiple bags, this backpack combines wet and dry submersible storage into one versatile pack. The Kodiak 2000 Cooler Backpack...

Press Releases

Products

August 26, 2024

Redwood Outdoors Named the Official Sauna and Cold Plunge of Spartan Seattle and Spartan Los Angeles

BOSTON, MASS. /ENDURANCE SPORTSWIRE/ - In an exciting development for endurance athletes, Spartan Race, the global leader in obstacle course racing, is thrilled to announce Redwood Outdoors as the Official Sauna and Cold Plunge Partner for its upcoming Seattle and Los Angeles races. This partnership marks a significant step forward in...

Business

Events

Press Releases

Products

Running

Sponsorship

August 26, 2024

Experience the Paris 2024 Paralympic Games with New Connected Challenges on Kinomap

PARIS - August 26, 2024/ENDURANCE SPORTSWIRE/ – Get ready to immerse yourself in the excitement and inspiration of the Paris 2024 Paralympic Games with Kinomap’s exclusive virtual challenges. From August 28 to September 8, you can join the action from the comfort of your own home or gym, with new connected...

Press Releases

Products

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

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 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