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

July 28, 2022

2023 VinFast IRONMAN World Championship to Hold Dedicated Women’s and Men’s Race Days as Two-Day Format Continues in Kailua-Kona, Hawai`i for 2023

TAMPA, Fla. (July 28, 2022)/ENDURANCE SPORTSWIRE/ – IRONMAN, in collaboration with local and state officials in Hawai`i, announced today that the 2023 VinFast IRONMAN® World Championship triathlon will continue with a two-day format in Kailua-Kona, Hawai`i on October 12 & 14. This year, for the first time in the 40-plus year...

Events

Press Releases

Triathlon

July 28, 2022

Sydney Marathon Announced as An Abbott World Marathon Majors Candidate Race

(Sydney, 6am AEST, 28 July 2022) /ENDURANCE SPORTSWIRE/ - The Blackmores Sydney Marathon has officially been announced as a candidate race for the Abbott World Marathon Majors (AbbottWMM) - the first marathon in Oceania to be nominated. The announcement marks the commencement of a multi-year evaluation process by AbbottWMM. To...

Events

Press Releases

Running

July 28, 2022

Lizard Skins Launches New Monitor Glove, The 3 SZN

American Fork, Utah (July 28, 2022) /ENDURANCE SPORTSWIRE/ - Lizard Skins, a leader in grips and handlebar tape, knows a lot about a rider’s contact points, and their renowned Monitor line of gloves has been providing comfort and performance in the hands, perhaps the most important contact point, for years....

Cycling

Press Releases

Products

Triathlon

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 28, 2022

Nutrition Coaching App, Fuelin, Announces Integration with TrainingPeaks

(San Francisco, CA)/ENDURANCE SPORTSWIRE/ – Fuelin announced today the integration of its nutrition coaching app with sports technology platform, TrainingPeaks. Fuelin’s mission is to make personalized nutrition coaching available to all athletes and coaches at an affordable price point. Nutrition is a key pillar to performance in endurance training and racing,...

Cycling

Press Releases

Products

Running

Triathlon

July 28, 2022

Showcased

ElliptiGO® Launches Virtual Ride & Fundraiser and Limited-Edition Bikes Benefiting Stand Up To Cancer®

SAN DIEGO, Calif. /ENDURANCE SPORTSWIRE/ – ElliptiGO, the world leader and pioneer of both elliptical and stand up cycling, is rallying riders across the globe to make miles into meaningful contributions for Stand Up To Cancer® (SU2C). The ElliptiGO Virtual Stand Up & Ride Fundraiser to benefit Stand Up To Cancer...

Cycling

Events

Giving

Press Releases

July 28, 2022

Showcased

INFINIT Nutrition Unveils New and Improved Protein Recovery Drink Mixes

Cincinnati, Ohio, July 28, 2022/ENDURANCE SPORTSWIRE/ – INFINIT Nutrition, the industry leader in personalized sports nutrition, has announced the release of its new and improved recovery preset product line. Improving on the original formulas developed over a decade ago, REPAIR Complete Recovery and NOCTURNE Nighttime Recovery protein drink mixes will now feature:...

Press Releases

Products

July 27, 2022

Bivo Launches New 21 oz. Insulated Sports Bottle

RICHMOND, Vt. /ENDURANCE SPORTSWIRE/ – Following the success of the original Bivo One, and more recently the Bivo Duo, the stainless steel cycling bottle manufacturer is thrilled to debut its third, and first insulated, product—the Bivo Trio. The 21oz vacuum insulated bottle has all of the features that made Bivo’s other...

Cycling

Press Releases

Products