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

February 23, 2023

U.S. Air Force Special Warfare to Partner with Spartan

BOSTON, MASS. (02/23/2023)/ENDURANCE SPORTSWIRE/ – Spartan, the world’s leading endurance sports and extreme wellness brand, announced that the U.S. Air Force Special Warfare will be an Official Partner of select races in 2023. “At Spartan, we pride ourselves on grit, toughness, resiliency, and finding comfort in discomfort. By partnering with...

Press Releases

Running

Sponsorship

February 23, 2023

BOA Nutrition Announces New Board Members and Retail Expansion adding to Brand’s Momentum

RALEIGH, N.C. (February 23, 2023) /ENDURANCE SPORTSWIRE/ – North Carolina-based sports supplement company BOA Nutrition continues to race forward with the announcement that its innovative oral aerosol products will soon be available in brick-and-mortar retail locations in addition to existing e-commerce channels. Since launching in 2021, BOA products have been sold...

Business

Press Releases

Products

February 23, 2023

INFINIT Nutrition Announces 2023 Team INFINIT Elite Roster

Cincinnati, OH, February 23, 2023 /ENDURANCE SPORTSWIRE/ - INFINIT Nutrition, the original custom sports nutrition company is excited to unveil its 2023 Team INFINIT Elite roster, composed of seventeen athletes representing a variety of endurance disciplines including triathlon, cycling, mountain biking, and running. “At INFINIT we have always felt that...

Cycling

Press Releases

Products

Running

Sponsorship

Triathlon

February 23, 2023

Walmart Joe Martin Stage Race Returns to Fayetteville with Amateur Criterium

  FAYETTEVILLE, Ark. (Feb. 23, 2023) /ENDURANCE SPORTSWIRE/ - Registration opens today for two cycling events taking place in Fayetteville on the weekend of the professional and elite Walmart Joe Martin Stage Race. The first event will be the all-new Bike City Fondo presented by Experience Fayetteville to be held...

Cycling

Events

Press Releases

February 23, 2023

Expedition Africa – Mnweni Starts the 2023 ARWS Africa Series

/ENDURANCE SPORTSWIRE/ – The towering peaks, cliffs and rock towers of the dramatic Mnweni-Drakensberg area will stand sentinel when the first event of the 2023 Adventure Racing World Series (ARWS) Africa Regional Circuit sponsored by Merrell begins on Friday. Expedition Africa - Mnweni is ready to welcome the teams of two...

Events

Press Releases

February 23, 2023

National Cycling League Announces Strategic Partnership with Wahoo Fitness

Miami, FL. February 23, 2023 /ENDURANCE SPORTSWIRE/ – The National Cycling League, the first of its kind professional sports league built around values of diverse ownership, gender equality, technology, and sustainability, today announced a 2-year strategic partnership with leading endurance athlete fitness technology company Wahoo Fitness. The NCL’s two co-ed professional...

Cycling

Press Releases

Sponsorship

February 23, 2023

The Legend Expedition Race in Australia Starts the 2023 Adventure Racing World Series

/ENDURANCE SPORTSWIRE/ – This year’s Adventure Racing World Series spans 10 countries and the new Legend XPD race in Australia is the first, taking place from February 25th to March 4th. The expedition adventure race is based in Jindabyne, a popular alpine town that sits on the shores of the picturesque...

Events

Press Releases

February 22, 2023

IRONMAN Announces New 5150 Cartagena Triathlon Taking Place in Cartagena De Indias, Colombia

CARTAGENA, Colombia / TAMPA, Fla. (Feb. 22, 2023) /ENDURANCE SPORTSWIRE/ - IRONMAN announced today the addition of the 5150™ Cartagena triathlon in the city of Cartagena de Indias, Colombia on September 17, 2023. With a beautiful colonial port with so much history to discover, athletes will have the opportunity to...

Events

Press Releases

Triathlon