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

March 7, 2023

Tifosi Optics Partners with Cyclists Jeremiah Bishop and Tyler Pearce

Watkinsville, GA (March 7, 2023) /ENDURANCE SPORTSWIRE/ – Tifosi Optics, the #1 brand of cycling eyewear in the United States, has announced a partnership with two of the world’s premier cycling influencers, Jeremiah Bishop and Tyler Pearce. The duo will help Tifosi engage customers through high-quality content that inspires audiences to...

Cycling

Press Releases

Sponsorship

March 7, 2023

RunSignup Announces New Zapier App Integration

Moorestown, NJ /ENDURANCE SPORTSWIRE/ – RunSignup, the leading registration and technology solution for U.S. endurance events, announces its Zapier integration and partnership with Sidekick Solutions, a software consulting and integration developer. The companies have joined efforts to provide a simplified option for integrating RunSignup with a variety of other packaged applications...

Cycling

Press Releases

Products

Running

Triathlon

March 7, 2023

Carmel Marathon Presented by Franciscan Health Sold Out for Third Consecutive Year

CARMEL, Ind. (March 7, 2023) /ENDURANCE SPORTSWIRE/ – For the third consecutive year, the Carmel Marathon Presented by Franciscan Health has sold out. The 13th annual Carmel Marathon Weekend, held on Saturday, April 8, 2023, in Carmel, Indiana, also hosts the Carmel Half Marathon, Indiana Spine Group 10K, Indiana Members Credit...

Events

Press Releases

Running

March 7, 2023

Gran Fondo Florida Moves to Dade City, Florida for 2023

Gettysburg, PA – March 7, 2023 /ENDURANCE SPORTSWIRE/ – The SUAREZ Gran Fondo National Series is proud to announce the 2023 Gran Fondo Florida will be hosted by Dade City Brewhouse and start and finish in Dade City, Florida, on March 19, 2023. The annual event previously started and finished in San...

Cycling

Events

Press Releases

March 7, 2023

JT Holmes Joins Peak Ski Company Executive Leadership Team

  BOZEMAN, Montana (March 7, 2023) /ENDURANCE SPORTSWIRE/ - Peak Ski Company announced today that professional skier, and award-winning stunt coordinator, JT Holmes has joined the company’s leadership team as Senior Director of Innovation and Business Development. Launched by cofounders Bode Miller and Andy Wirth, Peak Ski Company’s 2022/23 lineup...

Business

Press Releases

March 7, 2023

Run Catalina welcomes SFuels as sponsor of 2023 Catalina Island Marathon

AVALON, Calif. /ENDURANCE SPORTSWIRE/ – A new sponsor has signed on to support the 2023 Hi-Tec Run Catalina series Catalina Island Marathon. SFuels will provide fueling electrolyte drinks at all of the water stations on the marathon route, as well as the 10K course and finish line. SFuels LIFE bars will...

Press Releases

Running

Sponsorship

March 6, 2023

Electrolit Activates Official Partnership for the Los Angeles Marathon

CERRITOS, Calif. (March 6, 2023) /ENDURANCE SPORTSWIRE/ - Electrolit – the preferred, premium hydration beverage made from pharmaceutical quality grade ingredients – has kicked off 2023 as the official hydration partner of the Los Angeles Marathon presented by ASICS. Just 30 days away from the big race, Electrolit is excited...

Business

Press Releases

Running

Sponsorship

March 6, 2023

Stages Cycling Dual Sided Power Meter for Ultegra 8100 Available Now

Boulder, CO – 6 March, 2023 /ENDURANCE SPORTSWIRE/ –Stages Cycling, a leading cycling technology company, today announced the launch of its dual sided power meter for Shimano’s latest 12-speed Ultegra 8100 cranksets. The drive-side Stages R crank arms and dual sided Stages LR cranksets for Shimano’s 12-speed groups feature a new power...

Cycling

Press Releases

Products

March 6, 2023

Science in Sport (SiS) announces a three-year strategic partnership with Manchester Metropolitan University

6th March - London, UK /ENDURANCE SPORTSWIRE/ – The partnership will bring together state-of-the-art facilities and best-in-class research techniques with a global brand at the heart of elite sport to develop new knowledge that will ultimately provide novel performance solutions to athletes. Science in Sport is the official sports nutrition partner to...

Business

Press Releases

Studies