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

August 22, 2023

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

BOSTON, MASS. (08/22/2023)/ENDURANCE SPORTSWIRE/ – Spartan, the world’s leading endurance sports and extreme wellness brand, announced that the U.S. Air Force Special Warfare will return as an Official Partner of select races in August 2023 to April 2024. “At Spartan, we pride ourselves on promoting the same traits military recruiters...

Events

Press Releases

Running

Sponsorship

August 22, 2023

RunSignup Launches Apple Pay and Apple Wallet Integration

Moorestown, N.J. - August 22, 2023 /ENDURANCE SPORTSWIRE/ – RunSignup, the leading registration and technology provider for endurance events in the U.S., announces the integration of Apple Pay and Apple Wallet for efficient registration, donations, and race check-ins. With Apple Pay, registering for events becomes even faster and more seamless, and...

Press Releases

Products

Running

August 22, 2023

CFG Bank to Serve as Official Banking Partner of Baltimore Running Festival

August 22, 2023- (Baltimore, MD)/ENDURANCE SPORTSWIRE/ – Corrigan Sports Enterprises (CSE) announced today CFG Bank will serve as the official banking partner of the Baltimore Running Festival and as CSE’s new corporate banking partner. The exclusive two-year deal kicks off with the 22nd running of Charm City’s biggest running event...

Press Releases

Running

Sponsorship

August 21, 2023

Miami Nights Crowned Champions of the NCL Cup Series After Electrifying Weekend of Racing in Atlanta

ATLANTA /ENDURANCE SPORTSWIRE/ – The National Cycling League (NCL) wrapped up its thrilling three-part race series this weekend in Atlanta. On Saturday, Aug. 19, fans gathered at Bearings Bike Works for the Team Qualifier. The event was an embodiment of community spirit, where families came together to watch competitors push their...

Cycling

Events

Press Releases

August 21, 2023

XTERRA Costa Rica joins 2024 Americas Tour

/ENDURANCE SPORTSWIRE/ – XTERRA, the global leader in off-road triathlon, is pleased to announce the addition of XTERRA Costa Rica, presented by Coopenae, to the 2024 XTERRA Americas Tour. The three-day outdoor sports festival will be held August 23-25, 2024, at Las Catalinas, a beautiful car-free beach town in the...

Events

Press Releases

Triathlon

August 21, 2023

Team Novo Nordisk and Novo Nordisk confirm three-year renewal of historic partnership

Atlanta, GA/August 21, 2023/ENDURANCE SPORTSWIRE/ – The world’s only all-diabetes professional cycling team is excited to confirm the extension of their successful partnership with principal sponsor Novo Nordisk for another three years carrying Team Novo Nordisk into 2026. In 2021, Novo Nordisk & Team Novo Nordisk celebrated the discovery of insulin. This...

Cycling

Press Releases

Sponsorship

August 21, 2023

COROS announces large firmware update for its GPS watches

IRVINE, California / AUGUST 21st, 2023/ENDURANCE SPORTSWIRE/ – COROS Wearables Inc., makers of GPS sports wearables and training software for performance and adventure, today announced the launch of its August 2023 firmware update, which brings many exciting new features to the APEX Pro 1, VERTIX 1, PACE 2, APEX 2, APEX 2...

Cycling

Press Releases

Products

Running

Triathlon

August 21, 2023

Rachel Zilinskas From the United States and Elliot-Olivier Pellerin from Canada Claim Victories At 2023 IRONMAN Mont-Tremblant Triathlon, Part of The Vinfast IRONMAN North America Series

MONT-TREMBLANT, QUEBEC, CANADA /ENDURANCE SPORTSWIRE/ - The picturesque international Resort of Tremblant and Quebec’s stunning Laurentian mountains provided a spectacular backdrop for the return of the IRONMAN® Mont-Tremblant triathlon, part of the VinFast IRONMAN North America Series as well as the IRONMAN 70.3® Mont-Tremblant triathlon which was originally due to take place...

Events

Press Releases

Triathlon

August 21, 2023

Athletes prepare to conquer world-famous Flüela Pass at Challenge Davos

/ENDURANCE SPORTSWIRE/ - With a double climb of the world-famous Flüela Pass featuring 1,770m of vertical, Challenge Davos on 26 August is one of the toughest and most iconic races on the Challenge Family calendar. After the 1.9km swim, athletes first climb the Flüela Pass from Davos: an ascent of...

Events

Press Releases

Triathlon

August 21, 2023

Rock ‘N’ Roll Running Series Continues Celebration of 25 Year Anniversary with Running Tour of Salt Lake City, Utah

SALT LAKE CITY, Utah /ENDURANCE SPORTSWIRE/ - The Rock ‘n’ Roll® Running Series is a best-in-class running series Bringing Fun to the Run® through music, entertainment, and community immersion all combining in Utah to provide an unforgettable running tour of Utah’s capital city. Rock ‘n’ Roll Salt Lake City presented...

Events

Press Releases

Running