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

February 22, 2023

Challenge Family and ROUVY Stand Together for Türkiye/Syria

/ENDURANCE SPORTSWIRE/ - Challenge Family and ROUVY are deeply moved by the earthquakes in Türkiye and Syria, where tens of thousands of people have lost their lives and many more have been injured or lost their homes and livelihoods. The people of these countries need help urgently and so ROUVY...

Cycling

Giving

Press Releases

Triathlon

February 22, 2023

Independent Running Apparel Brands Janji and Oiselle Announce Merger

February 22, 2023 /ENDURANCE SPORTSWIRE/ - Janji, a Boston-based running apparel brand on a mission to expand access to safe drinking water worldwide, and Oiselle, a Seattle-based by and for women athletic apparel company, announced that they will enter a collaborative partnership through a merger, facilitated by Digsbury Ventures. The...

Business

Press Releases

Running

February 22, 2023

Distance Runner Kevin Salvano signs agency contract with Elite Runner Management

GROSSE POINTE (MI) /ENDURANCE SPORTSWIRE/ – Kevin Salvano, a Notre Dame graduate and Olympic Trials qualifier in the marathon, has signed an agency contract with Elite Runner Management (ERM), the Michigan based sports agency headed by Chris Mengel. “Kevin Salvano had a fabulous start to his pro career when he ran...

Business

Press Releases

Running

Sponsorship

February 21, 2023

IRONMAN Announces 2023 Race Schedule For Events Across The United States And Canada

TAMPA, Fla. (Feb. 21, 2023) /ENDURANCE SPORTSWIRE/ - IRONMAN has announced its 2023 season calendar of racing in the United States and Canada mixing some iconic longstanding favorites with a variety of new host communities across the VinFast IRONMAN® North America Series and IRONMAN® 70.3® Series. Athletes looking to experience...

Events

Press Releases

Triathlon

February 21, 2023

Shamrock Run Portland Announces Shamrock Showdown 8K

PORTLAND /ENDURANCE SPORTSWIRE/ – If the calendar reads that spring is knocking on the door, that can only mean one thing to the Pacific Northwest running community. The 2023 Shamrock Run Portland is preparing to welcome more than 20,000 runners for Oregon’s favorite St. Patrick’s Day tradition. The 45th edition of...

Events

Press Releases

Running

February 21, 2023

D•CURVE Optics and Race Across America Announce 2023 Partnership

Colorado (February 2023) /ENDURANCE SPORTSWIRE/ – D•CURVE Optics is pleased to announce a new partnership with Race Across America (RAAM). Both brands are recognized world-wide for their excellence in their respective industries. 2023 marks the 41st year for Race Across America – The World’s Toughest Bicycle Race. Riders come from around...

Cycling

Press Releases

Sponsorship

February 21, 2023

Nearly 100 Elite Runners to compete in Half Marathon at 2023 Rock ‘n’ Roll Running Series Las Vegas

LAS VEGAS, Nev. (Feb. 21, 2023) /ENDURANCE SPORTSWIRE/ – As the heralded running series celebrates its 25th anniversary in 2023, the iconic Rock ‘n’ Roll® Running Series Las Vegas event makes its annual return to the famed Las Vegas Strip this weekend. Nearly 100 elite runners from around the world will...

Events

Press Releases

Running

February 21, 2023

USA Triathlon Announces 2023 U.S. Elite Triathlon National Team

COLORADO SPRINGS, Colo. /ENDURANCE SPORTSWIRE/ – USA Triathlon today announced the 11 members of the 2023 U.S. Elite Triathlon National Team, the group of athletes who will represent the U.S. at the highest levels of elite triathlon competition during the 2023 season. “Our 2023 U.S. Elite Triathlon National Team is incredibly talented,...

Events

Press Releases

Triathlon

February 21, 2023

FASTFOOD to Fuel Human Powered Health Cycling Team with On-and-Off-Bike Nutrition during 2023 Race Season

BOSTON, Feb. 21, 2023 /ENDURANCE SPORTSWIRE/ – FASTFOODTM, a new groundbreaking line of high-performance nutrition products engineered to fuel elite and amateur athletes, today announced it has been selected as the official sports nutrition partner of the Union Cycliste Internationale (UCI) professional men’s ProTeam and women’s WorldTeam Human Powered Health™. The partnership...

Cycling

Press Releases

Sponsorship