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

January 20, 2022

deboer wetsuits introduced the Flōh 2.0 wetsuit

Stamford, CT, Release: January 20, 2022 /ENDURANCE SPORTSWIRE/ - deboer wetsuits is proud to introduce the Flōh 2.0 wetsuit.  The Flōh 2.0 shares much of its DNA with the Fjord 2.0, the exception being the material used in the sleeves. The Flōh 2.0 utilizes 1.5mm UltraFlex™ sleeves for near zero...

Press Releases

Products

Triathlon

January 19, 2022

Showcased

ROUVY and Garmin customers can now seamlessly sync their activities through new API integration

Prague, Czech Republic / January 18, 2022 /ENDURANCE SPORTSWIRE/ ROUVY, an indoor cycling platform, and Garmin® International, Inc., a global leader of GPS-enabled products, today announced API integration support between ROUVY and Garmin Connect™. The integration enables users to seamlessly sync their activities created in the ROUVY app directly to their...

Cycling

Press Releases

Products

Running

Triathlon

January 19, 2022

Showcased

Black Rifle Coffee to be Named the Official Coffee of Spartan US Across 10 Races Starting in 2022

Boston, Mass. (January 19, 2022) /ENDURANCE SPORTSWIRE/ - Black Rifle Coffee (BRCC), a rapidly growing and mission-driven premium coffee company founded to support Veterans, active-duty military, and first responders, is prepared to caffeinate the Spartan community starting in 2022. The BRCC mission harmonizes perfectly with the prominent military ties blended...

Business

Events

Press Releases

Products

Sponsorship

January 19, 2022

GO Sleeves Signs Pro Contract with Skyrunner Hillary “Hillygoat” Allen

San Jose, CA (January 19, 2022) /ENDURANCE SPORTSWIRE/ - GO Sleeves, the company that introduced the world’s first and only compression sleeve with built-in kinesiology strips, announced today the signing of Skyrace Endurance Runner Hillary “Hillygoat” Allen to an ongoing partnership contract. “I’m so inspired and proud to welcome Hillary...

Press Releases

Products

Running

Sponsorship

January 14, 2022

Obstacle Course Racing Superstar, Hunter McIntyre and World’s Toughest Mudder Champion, Katie Knight Sign with BOA Nutrition

(RALEIGH, NC) January 14, 2022 /ENDURANCE SPORTSWIRE/ - BOA Nutrition announced it has inked a deal with the 7-time champion and world-record-holder in multiple obstacle course racing disciplines. Hunter McIntyre  holds titles from Hyrox,  Tough Mudder X , OCR , the Murph Challenge , and Broken Skull Ranch . Sports Illustrated  has called him one...

Press Releases

Products

Sponsorship

January 13, 2022

Data Driven Sports/ShotTracker to Provide Data and Advanced Analytics for Big 12 Basketball

KANSAS CITY, Mo. – (January 13, 2022) /ENDURANCE SPORTSWIRE/ - Data Driven Sports (DDSports), the parent company of ShotTracker, today announced they have entered into an agreement with ESPN to provide data and analytics for Big 12 Conference basketball games. The multi-year deal gives ESPN the opportunity to integrate ShotTracker data...

Business

Press Releases

Products

January 11, 2022

Showcased

NordicTrack from iFIT Unveils Voice-controlled Adjustable Dumbbells — The First to Offer “Works with Alexa”

(Logan, UT) - January 11, 2022 /ENDURANCE SPORTSWIRE/ - Today, NordicTrack from iFIT, a leader in connected fitness innovation, unveiled its latest, patent-pending product: the NordicTrack iSelect™ Adjustable Dumbbells—the first voice-controlled dumbbells to work with Alexa. While traditional adjustable dumbbells offer the benefit of multiple weights, they come at the...

Press Releases

Products