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

September 24, 2024

Wild Rye Breaks Into Winter Mid-Layers Introducing a Synthetic Down Collection and Cold Weather Technical Pant

Sun Valley, ID (September 24, 2024) /ENDURANCE SPORTSWIRE/ - Wild Rye, the premiere active lifestyle apparel brand designed to empower women in the outdoors and beyond, launches its fall-winter 2024-25 collection, unveiling the brand’s first-ever synthetic down pieces, the Payette Collection, and a new technical pant for cold weather adventures,...

Press Releases

Products

September 23, 2024

Fjällräven Launches Resale Marketplace to Extend Product Lifespans and Reduce Waste

Louisville, CO. (September 23, 2024) /ENDURANCE SPORTSWIRE/ - Fjällräven, the iconic outdoor brand known for its commitment to sustainability and timeless design, is proud to announce the launch of Fjällräven Pre-Loved, a peer-to-peer resale marketplace where customers across the U.S. can buy and sell second hand Fjällräven apparel, bags and...

Business

Giving

Press Releases

Products

September 19, 2024

Daniela Ryf Goes All-In with AI

Boulder, CO (September 19, 2024) /ENDURANCE SPORTSWIRE/ – In a groundbreaking move that merges elite endurance sports with cutting-edge technology, Humango™ is thrilled to announce a partnership with triathlon icon, Daniela Ryf. The Swiss powerhouse, boasts an unprecedented ten Ironman World Championship titles, and is set to champion personalized triathlon...

Press Releases

Products

Triathlon

September 19, 2024

Paris 2024 Connected Marathon Pour Tous Sets New Milestone with Record-Breaking Global Participation

PARIS, Sept. 19, 2024/ENDURANCE SPORTSWIRE/ – The Paris 2024 Connected Marathon Pour Tous has concluded with unprecedented success, affirming its status as a groundbreaking virtual event that united people worldwide. This innovative marathon allowed participants to run, row, or cycle at their own pace from everywhere in the world while joining...

Events

Press Releases

Products

September 18, 2024

Suunto ZoneSense The new revolutionary way of understanding exercise intensity

September 18, 2024 /ENDURANCE SPORTSWIRE/ - We are proud to announce the launch of our latest innovation, the Suunto ZoneSense technology – a pioneering advancement in endurance training. ZoneSense uses novel heart rate variability (HRV) features to accurately detect exercise intensity, giving athletes real-time insights into their training. These features...

Press Releases

Products

September 18, 2024

Introducing the greatest in on-the-go recovery

FORT WAYNE, Ind. — September 18, 2024 /ENDURANCE SPORTSWIRE/ – Master Spas, a leading manufacturer of hot tubs and swim spas, is proud to announce the latest product from Michael Phelps Chilly GOAT Cold Tubs. The Chilly GOAT GO! is perfect for athletes, fitness enthusiasts, and wellness seekers who are...

Press Releases

Products

September 17, 2024

GOREWEAR Unveils New Technical and Thermal Run and Bike Styles for Fall 2024

Elkton, MD (September 17, 2024) /ENDURANCE SPORTSWIRE/ - GOREWEAR, the leading innovator in high-performance running and cycling apparel, introduces its new Fall/Winter 2024 product lineup, including updates to the brand’s popular Concurve and Spinshift collections. Each collection expands upon its technical performance adding new fall/winter specific thermal styles. Starting with...

Press Releases

Products

September 17, 2024

Maven Adds To Its C Series Spotting Scope Line With The CS.2A

LANDER, Wyo. (Sept. 17, 2024) /ENDURANCE SPORTSWIRE/ - Maven, a Wyoming-based direct-to-consumer brand known for offering world-class optics at affordable prices, has added to its award-winning line of C Series spotting scopes with the CS.2A. The CS.2A is the brand’s first expansion of the C series spotting scopes since the...

Press Releases

Products