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

May 25, 2022

Showcased

100% and MLB All-Star Fernando Tatis, Jr. Debut 2022 Limited-Edition Sport Performance Eyewear Collection

SAN DIEGO, Calif. – May 25, 2022/ENDURANCE SPORTSWIRE/ – 100%®, the San Diego-based sports performance company, professional baseball All-Star and MVP Sports Group client, Fernando Tatis, Jr. have once again joined forces for their 2nd limited edition eyewear collaboration. Like Tatis, the 2022 100% x Tatis 23 Limited-Edition Eyewear Collection is sure to turn heads — featuring the energizing pinks and glowing yellows, colors that El Niño is well-known...

Press Releases

Products

Sponsorship

May 25, 2022

Salty Sports Society and Sharkbanz Form Partnership

Saint Augustine Beach, Florida/ENDURANCE SPORTSWIRE/ – Salty Sports Society today announced a new partnership with Sharkbanz aimed to increase peace of mind for ocean swimmers. This scientifically proven shark deterrent technology will have a strong brand presence on the Speedo SALT Series. The six-event statewide Series is the only points based,...

Press Releases

Products

Sponsorship

May 24, 2022

Wattbike Continue to Innovate on their Popular Training App, Wattbike Hub

/ENDURANCE SPORTSWIRE/ – Wattbike is a brand going from strength to strength and is now inviting users to enjoy an even better experience when using the Wattbike Hub App. With significant improvements around useability and navigation, the new home screen makes the app easier to track and measure your performance improvements...

Cycling

Press Releases

Products

May 23, 2022

ROUVY Ghosts’ Comeback – 10 Virtual Pace Bots to make the indoor cycling session more fun

Prague, Czech Republic / May 23, 2022 /ENDURANCE SPORTSWIRE/ – ROUVY, is an application and platform that turns what was formerly known as mundane stationary training into a fun and motivating virtual adventure around the world. The overlaid 3D avatars and objects, atop the real-life geo-synced video footage, create a realistic...

Cycling

Press Releases

Products

Triathlon

May 23, 2022

Microsoft Teams integration for CorporateFitness.app released

May 23, 2022 /ENDURANCE SPORTSWIRE/ – CorporateFitness.app is proud to announce the immediate availability of its Microsoft Teams integration. The brand new Microsoft Teams integration brings your corporate step or fitness challenge right inside the Microsoft Teams app everyone is already using all day long! Using this new integration your team can...

Press Releases

Products

May 19, 2022

Boa Nutrition Teams Up with Star Triathlete and Top Ironman Competitor Sam Long

RALEIGH, N.C. (May 19, 2022)/ENDURANCE SPORTSWIRE/ – BOA Nutrition announced today the sports performance supplement company signed an endorsement deal with top American triathlete and IRONMAN champion, Sam Long. Long will serve as brand ambassador in the sport of triathlon for BOA Endure, a rapid hydration oral aerosol. The Boulder, Colo., native...

Press Releases

Products

Sponsorship

Triathlon