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

July 28, 2022

Challenge Family Partners with TrainingPeaks

/ENDURANCE SPORTSWIRE/ - Challenge Family and TrainingPeaks today announced a global partnership to help athletes of all abilities achieve their peak race condition for Challenge Family events around the world. The partnership further highlights Challenge Family’s commitment to the athlete journey throughout the year, from registration to race day. TrainingPeaks...

Press Releases

Sponsorship

Triathlon

July 27, 2022

BOA Nutrition Announces Official Brand Partnership With IRONMAN® Triathlon Series

RALEIGH, N.C. (July 27, 2022) /ENDURANCE SPORTSWIRE/ - Sports performance supplement company BOA Nutrition, inventor of the BOA Endure rapid sodium replenishment product, announced today that Endure has been selected as Official Endurance Salt of IRONMAN® in the North America region as well as the IRONMAN® World Championship and IRONMAN®...

Cycling

Events

Press Releases

Running

Sponsorship

Triathlon

July 27, 2022

BibRave Pumped to Launch Bike New York Ambassador Program

Portland, OR/ENDURANCE SPORTSWIRE/ – BibRave, the leading-edge endurance and fitness marketing agency, recently launched applications for the first-ever Bike New York ambassador program. “The Bike New York Roadies” will help spread excitement about the non-profit’s events and educational programming across the Tri-State area. Bike New York promotes and encourages bicycling and...

Cycling

Press Releases

Sponsorship

July 27, 2022

361° Announced as Presenting Sponsor of the Surf City Marathon

ORANGE COUNTY, Calif. – July 27, 2022/ENDURANCE SPORTSWIRE/ – 361°, an Irvine-based performance footwear brand, today announced a new partnership as the presenting sponsor of the Surf City Marathon. The 27th running of the Surf City Marathon and Half Marathon presented by 361° will take place in Huntington Beach on Sunday,...

Events

Press Releases

Running

Sponsorship

July 23, 2022

VinFast and IRONMAN Announce a Groundbreaking and Comprehensive Global Partnership

Tampa, Fla. / Nha Trang, Vietnam (July 23, 2022) /ENDURANCE SPORTSWIRE/ - VinFast, the world’s first automotive manufacturer to completely switch from internal combustion engines to electric vehicles, and IRONMAN, the global leader in long distance triathlon, have announced a global partnership for VinFast to become the first ever naming...

Business

Press Releases

Sponsorship

Triathlon

July 22, 2022

Kayakers Make Final Preparations To Attempt Record-Breaking One-Day Descent of the Bridge Creek

LOS ANGELES /ENDURANCE SPORTSWIRE/ - The inaugural recipients of the Punch Gunk Go Get It Grant have announced that they will be soon embarking on their expedition to set the fastest known time for a kayaking descent of North Cascades National Park’s Bridge Creek. Nick Terry, Rob Scanlon, Non Worasilpchai,...

Events

Press Releases

Products

Sponsorship

July 22, 2022

Team UCAN Runners Shine at World Athletics Championships

/ENDURANCE SPORTSWIRE/ – Team UCAN runners had a successful showing competing against the best in the world, with three Top-10 finishes at the 2022 World Athletic Championships in Eugene, OR. Sara Hall and Emma Bates led the charge for the American women in the marathon, finishing 5th and 7th respectively. They...

Events

Press Releases

Running

Sponsorship

July 21, 2022

Supersapiens Brings on US Olympian Ben Kanute as Ambassador and Advisor

Atlanta – 21 July 2022 /ENDURANCE SPORTSWIRE/ - Supersapiens, the world’s first energy management system designed for athletes to unlock higher performance and recovery, welcomes Ben Kanute as both an advisor and ambassador. Supersapiens, powered by the Abbott Libre Sense Glucose Sport Biosensor, plans to work with Ben to bring...

Press Releases

Sponsorship

Triathlon