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

May 26, 2022

“Journey to Pro Cycling” video series, Episode 1 – SARIS ROUVY SAUERLAND Team on GCN

Eslohe, Germany - May 26, 2022 /ENDURANCE SPORTSWIRE/ – The mission of Saris is to break down barriers to make cycling more inclusive. The SARIS ROUVY SAUERLAND Team is striving to break down their own barriers as they make their journey towards the pro tour. With GCN, the team released the...

Cycling

Press Releases

Products

May 26, 2022

Legacy Triathlon Women’s Training Program for Beginners

/ENDURANCE SPORTSWIRE/ - Elevate MultiSport Endurance Training 4 Women, Parathletes & Beginners (an affiliate of the LA Tri Club) is very excited to announce the inaugural Women’s only training program at the Toyota Legacy Triathlon and Paratriathlon National Championships in Long Beach, CA, July 15-17, 2022. The Elevate Women 4Tri...

Cycling

Press Releases

Products

Running

Triathlon

May 26, 2022

RunSignup Announces New Release of RaceDay Scoring

May 26, 2022 - Moorestown, NJ/ENDURANCE SPORTSWIRE/ – RunSignup, the leading registration provider for U.S. endurance events, announces its latest release of RaceDay Scoring, the next generation in scoring software. This new release of RaceDay Scoring includes backup to cloud functionality giving timers greater data security and flexibility. Participant scoring data...

Cycling

Press Releases

Products

Running

Triathlon

May 25, 2022

Stages Cycling Launches Data Solution for Rhythm-Style Indoor Cycling Classes

(Boulder, CO – 25, May 2022) /ENDURANCE SPORTSWIRE/ - Stages Cycling is proud to announce the launch of Stages Studio Boost, a new software solution that supports clubs/studios, instructors, and members through behind-the-scenes data collection and post-workout emails. Fitness tracking may be the number one fitness trend in the US, but...

Business

Cycling

Press Releases

Products

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