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 (8742)
) 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 5190, 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

TrainingPeaks Announces Five New Partnerships with Pro Cycling Teams and American Magic Sailing Team

Louisville, Colo., May 25, 2022 /ENDURANCE SPORTSWIRE/ - TrainingPeaks, a global leader in providing smart and effective digital training solutions for athletes and coaches of all levels, has added to its all-star list of partnerships with professional cycling teams. French cycling team AG2R CITROËN TEAM and Kazakhstan-based Astana Qazaqstan Team...

Cycling

Press Releases

Sponsorship

Triathlon

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 25, 2022

GFNY European Championship in Villard de Lans this Sunday

/ENDURANCE SPORTSWIRE/ - GFNY Villard de Lans, located in the Southeast of France in the mountainous Vercors region at an altitude of 1050m, is hosting the GFNY European Championship 2022 race season. The championship worthy racecourse is 163,4 km long with 3973m of climbing, “Villard de Lans has reached out...

Cycling

Events

Press Releases

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 24, 2022

The Giant Race Presented by Alaska Airlines Announces San Francisco Race on August 20-21, 2022

May 24, 2022 (San Francisco, Calif.)/ENDURANCE SPORTSWIRE/ – The Giant Race in partnership with Alaska Airlines is thrilled to announce the 13th Annual San Francisco Giant Race will be held on Sunday, August 21. This year, the Giant Race is offering 5K and 10K live race events, with a virtual option for...

Events

Press Releases

Running

May 24, 2022

Debut of Run Show USA for North American Running Community Set to Begin

LONDON (May 24, 2022)/ENDURANCE SPORTSWIRE/ – Raccoon Events, the dynamic UK-based events business with extensive experience in organizing and executing consumer expos worldwide, is set to bring their popular National Run Show to North American audiences with the inaugural Run Show, Chicago on June 4-5 at the DES Convention Center in Rosemont,...

Press Releases

Running

Trade Shows

May 24, 2022

Showcased

Ashley Addiction Treatment Invites Public to Movement For Recovery Event with Ultramarathoner Charlie Engle

HAVRE DE GRACE, Md. /ENDURANCE SPORTSWIRE/ - Ashley Addiction Treatment (Ashley), one of the world’s most recognized and respected names in the substance use disorder treatment industry, invites the public to join The Penguin: Movement for Recovery, a celebration of movement for and through recovery. On July 23 and 24,...

Events

Press Releases