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 (22)
) 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 1050, 10

March 7, 2023

Super League Triathlon Partner with ASICS for 2023

/ENDURANCE SPORTSWIRE/ – Super League Triathlon (SLT) can today announce ASICS as an official partner for 2023. Super League Triathlon (SLT) is the world's premier swim-bike-run Series, pitching the very best athletes against each other in quick and exciting race formats in fantastic destinations across the globe. It’s Arena Games Triathlon...

Press Releases

Sponsorship

Triathlon

March 7, 2023

Altra Announces New Athletes to Elite Team

DENVER (March 7, 2023) /ENDURANCE SPORTSWIRE/ - Altra, a leading innovator in performance running, is excited to welcome its newest trail athletes, Careth Arnold and JP Giblin, to the Altra Elite Athlete Team. Throughout the year, these athletes – among the rest of the team – will wear Altra footwear...

Business

Press Releases

Sponsorship

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

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 2, 2023

Miami Nights Cycling Club Announces 2023 Race Schedule and Team Sponsors

Miami, Florida – March 2, 2023 /ENDURANCE SPORTSWIRE/ – The Miami Nights Professional Cycling Team, one of the premier professional teams in the National Cycling League, today announced their 2023 competition schedule and the list of world-class sponsors supporting their bid to win the $1 Million NCL prize purse, the largest in...

Cycling

Press Releases

Sponsorship

March 2, 2023

LA Sweat and Vittoria Tires announce continued multi-year partnership

/ENDURANCE SPORTSWIRE/ – We are proud to announce our continued partnership between LA Sweat Racing and Vittoria Tires. LA Sweat Racing is a professional women’s cycling team that competes in the US National Calendar. Vittoria Tires is a world-renowned tire manufacturer, known for its quality and performance. “Vittoria is proud to...

Cycling

Press Releases

Sponsorship

March 1, 2023

Caliente Pizza & Draft House Named Official Pizza of The Pittsburgh Marathon

Pittsburgh, PA (February 28, 2023) /ENDURANCE SPORTSWIRE/ – Pizza and sports fans in Pittsburgh have a new reason to celebrate as Caliente Pizza & Draft House has been named the Official Pizza of The Pittsburgh Marathon. The announcement comes after an exciting 2022 that included the successful launches of Caliente locations...

Events

Press Releases

Running

Sponsorship

March 1, 2023

UnitedHealthcare Renews as Presenting Sponsor of Maryland Cycling Classic, America’s Top Cycling Race

BALTIMORE, Maryland /ENDURANCE SPORTSWIRE/ – The Maryland Cycling Classic, recognized as America’s top-ranked cycling race following a highly successful inaugural event in 2022, today announced UnitedHealthcare will renew as presenting sponsor in 2023. The Maryland Cycling Classic, presented by UnitedHealthcare, is set to return to Maryland on Sunday, September 3, 2023...

Cycling

Press Releases

Sponsorship

March 1, 2023

Denver Disruptors Cycling Club Announces 2023 Race Schedule and Team Sponsors

Denver, Colorado – March 1, 2023 /ENDURANCE SPORTSWIRE/ – The Denver Disruptors Cycling Club, one of the premier professional teams in the National Cycling League, today announced their 2023 competition schedule as well as the list of world-class sponsors supporting their ride to the top of professional cycling in the United...

Cycling

Events

Press Releases

Sponsorship