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

August 3, 2022

Showcased

Elevate Women 4-Tri Malibu Triathlon Women’s Only Training Program

/ENDURANCE SPORTSWIRE/ – 2XU Malibu Triathlon is excited to announce the Elevate Women 4Tri 7-week triathlon training program will kick off the week off August 8th and lead right into race weekend September 17-18, 2022. The women’s only training program is designed to encourage participation for women learning the sport of...

Cycling

Events

Press Releases

Running

Triathlon

August 3, 2022

ENGO Eyewear Introduces ENGO 2, The Lightest Heads Up Display for Training and Competition for Endurance Athletes

BOSTON, Mass. (August 3, 2022)/ENDURANCE SPORTSWIRE/ – ENGO Eyewear, the leading manufacturer of connected eyewear for endurance athletes, today unveiled ENGO 2, the lightest, and most technologically advanced eyewear created specifically for endurance athletes. Developed to provide instant, intuitive, real-time access to performance data directly in the natural field of view,...

Cycling

Press Releases

Products

Running

Triathlon

August 3, 2022

World’s Most Exclusive Half Marathon is back and running

August 3, 2022 /ENDURANCE SPORTSWIRE/ –  RunningFlat and Pelee Island Winery team up again to offer the most exclusive running experience in the world—an island run through one of Canada’s oldest grape growing regions making this Half Marathon Canada’s most Southern. Pelee Island, Ontario June 3rd 2023 —Canada’s southernmost half marathon, the...

Events

Press Releases

Running

Wire Syndication

August 3, 2022

Virtual Badges Meh! Get Physical Rewards with Healthi and meSNAPS

/ENDURANCE SPORTSWIRE/ - Reward Your Weight Loss with Healthi and MeSnaps Diet and weight loss company, Healthi, offers clients a mobile app with six unique weight loss plans. Each curated weight loss plan addresses some the most common goals and hurdles that people face when trying to lose weight. Healthi has...

Press Releases

Products

August 2, 2022

IRONMAN Announces New IRONMAN 70.3 Morro Bay Triathlon in The Central Coast of California

MORRO BAY, Calif. / TAMPA, Fla. (Aug. 2, 2022) /ENDURANCE SPORTSWIRE/ - The IRONMAN Group, announced today that the seaside city of Morro Bay, California and the central California coastline will play host to the newest IRONMAN® 70.3® triathlon. The new IRONMAN 70.3 Morro Bay triathlon is schedule to take...

Events

Press Releases

Triathlon

August 2, 2022

Mazama Designs Launches New Soft Bottles

Bend, OR – August 2nd, 2022/ENDURANCE SPORTSWIRE/ – Mazama Designs, outdoor-products development company located in Bend, Oregon, recently announced the release of their new Soft Bottles to complement their ever-growing arsenal of hydration solutions for outdoor enthusiasts. Mazama is launching new soft bottles today on Amazon.com and their own website, www.mazamadesigns.com....

Press Releases

Products

August 2, 2022

GFNY back in Bali this Sunday

New York City, August 2, 2022/ENDURANCE SPORTSWIRE/ – This Sunday, the GFNY Championship Asia is held at GFNY Bali Element Camp on the ‘Island of the Gods’. The 136.9 km racecourse boasts 2126m of climbing in one of the most sought after travel destinations in the world. “The mere mention of...

Cycling

Events

Press Releases

August 2, 2022

Saucony® Launches All-New Endorphin 3 Collection

WALTHAM, MA (August 2, 2022)/ENDURANCE SPORTSWIRE/ – As the popularity of carbon-plated running shoes continues to surge, global performance running lifestyle brand Saucony announces the launch of the highly anticipated Endorphin 3 Collection, engineered with the brand’s signature SPEEDROLL™ Technology and high-performance PWRRUN PB™ foam cushioning. Leading the new generation Endorphin 3...

Press Releases

Products

Running

August 2, 2022

Tottenham Hotspur and Science in Sport Announce Industry-Leading Partnership

/ENDURANCE SPORTSWIRE/ – Tottenham Hotspur is pleased to announce Science in Sport (SiS) as the Club’s first Official Performance Solution Partner, working closely with the Nutrition and Sports Science teams for the next four seasons.  SiS have already played a part in shaping the Men’s First Team’s preparation for the upcoming...

Press Releases

Products

Sponsorship