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

January 26, 2022

La Sportiva’s Fall 2022 Footwear Demonstrates Commitment to the Mountain Athlete

January 26th, 2022 (Boulder, Colo.) /ENDURANCE SPORTSWIRE/ - La Sportiva, makers of the world’s finest mountain footwear, has been dedicated to producing high-performance shoes and boots for the mountain athlete since 1928. For Fall 2022, the brand introduces several new footwear models that meet the demands of climbers and runners. The...

Business

Press Releases

Products

January 26, 2022

Outside And IRONMAN Kick-Off Content Partnership by Bringing The Sights, Sounds, and Stories from The 2021 Intermountain Healthcare IRONMAN 70.3 World Championship to a Global Audience

TAMPA, Fla. / BOULDER, Colo. (Jan. 26, 2022) /ENDURANCE SPORTSWIRE/ - The documentary special of the 2021 Intermountain Healthcare IRONMAN® 70.3® World Championship Presented by Utah Sports Commission will premiere worldwide on Thursday, January 27 at 8:00 p.m. ET on Outside, as part of The IRONMAN Group’s recently announced partnership...

Business

Press Releases

Triathlon

January 26, 2022

Cirrus Cycles’ KINEKT Launches New Website to Enhance Consumer and Dealer Experience

BELLINGHAM, Wash. January 26th, 2022 /ENDURANCE SPORTSWIRE/ - Cirrus Cycles, the maker of the KINEKT suspension post and KINEKT suspension stem, is pleased to announce the launch of their new website in the US. The newly designed platform will greatly enhance the shopping experience, while educating both consumers and dealers...

Business

Cycling

Press Releases

Products

January 26, 2022

WaterMonster Mini Manifold

Kerrville, Texas (January 2022) /ENDURANCE SPORTSWIRE/ - Event Hydration Solutions introduces its newest touch-free mass hydration solution, the Mini Manifold. Event Hydration Solutions, also known as WaterMonster is reinventing how the common water cooler is utilized. In 2020 when everything changed, they introduced the UltraSpout and FootPedal. A rapid fill...

Business

Cycling

Events

Press Releases

Products

Running

Triathlon

January 25, 2022

iFIT-Powered NordicTrack Commercial 1750 Treadmill Named “Best Treadmill” by The New York Times’ Wirecutter

(Logan, UT) - January 25, 2022 /ENDURANCE SPORTSWIRE/ - NordicTrack’s Commercial 1750 Treadmill with iFIT interactive fitness technology has been named “Best Treadmill” by The New York Times’ Wirecutter, a popular review site. The highly coveted “Best Treadmill” title was awarded following a rigorous testing and review process, including interviews...

Awards

Business

Press Releases

Products

Running