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

May 5, 2023

Skratch Labs Introduces Seasonal Flavor of Hydration Sport Drink Mix: Mango + Tangerine

Boulder, CO /ENDURANCE SPORTSWIRE/ - Skratch Labs, an innovator in performance nutrition, announces the release of a new, limited time flavor of Hydration Sport Drink Mix: Mango + Tangerine. This seasonal flavor brings a refreshing, tropical twist to their sport drink mix. Made with real fruit, sugar and the optimal...

Cycling

Press Releases

Products

Running

May 4, 2023

Showcased

Any Distance Launches Social Network to Encourage Healthy, Active Lifestyles for All

Any Distance launches a brand new social network designed for your active life focused on positivity, inclusion and motivation. No algorithms, no ads, no competition or comparison. Featured by Apple as one of the best running apps, it’s new close friend network is designed to help tackle the global epidemic...

Cycling

Press Releases

Products

Running

Triathlon

May 3, 2023

Pirelli Launches the P ZERO Race 4S TLR Road Bicycle Tire, The All Season Tubeless Tire that Performs in any Weather Condition

Milan (Italy), May 3, 2023 /ENDURANCE SPORTSWIRE/ – Pirelli presents the P ZERO Race 4S TLR road bicycle tire, the tubeless version of the Pirelli all season tire, produced in the renovated Milano-Bollate facility. The new all-round tire follows the success of the P ZERO Race 4S clincher version. The new tire has...

Cycling

Press Releases

Products

Triathlon

May 3, 2023

CEP Launches the Next Generation in Running Socks with the Mid-Cut and No-Show Training Socks

Whitsett, NC. (May 3, 2023) /ENDURANCE SPORTSWIRE/ – Today, CEP Compression, a world leader in compression products for athletes, announces their first ever max cushion sock with the Mid-Cut and No-Show Training Sock. The Training Sock is designed for those who prefer a thicker sock during workouts. The Training Sock will help...

Press Releases

Products

Running

May 3, 2023

Showcased

Aquaglide Launches the Ultimate Lightweight Packable and Performance Touring Kayaks

Bend, Oregon. — May 3, 2023 /ENDURANCE SPORTSWIRE/ – Aquaglide, a leading innovator in the inflatable kayak industry, has launched the highly anticipated Cirrus Ultralight Series, consisting of the Cirrus UL 110 and Cirrus UL 150. These kayaks are designed for high-performance touring with supreme weight savings and packability, not to be confused...

OSW Syndicated

Press Releases

Products

May 2, 2023

Tifosi Optics Adds Versatility to it’s Endurance Line with Rivet

Watkinsville, GA (May 2, 2023) /ENDURANCE SPORTSWIRE/ – Tifosi Optics, celebrating 20 years as a leading sport and lifestyle eyewear brand, is happy to announce the latest style in its endurance lineup: Rivet. The perfect companion for a range of outdoor activities, Rivet offers simplicity in a lightweight and durable sunglass. While Rivet...

Cycling

Press Releases

Products

Running

Triathlon

May 2, 2023

Innovators join forces for UltraSwim 33.3

/ENDURANCE SPORTSWIRE/ – THEMAGIC5, the most comfortable swimming goggle, has joined the UltraSwim 33.3 family as its first Official Partner. In addition to supporting participants at this new category of open water swim event, THEMAGIC5 Co-founder Niklas Hedegaard, retired professional short course pool breaststroke specialist, will also compete in UltraSwim 33.3...

Press Releases

Products

Sponsorship

Triathlon