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

August 17, 2022

XTERRA Germany Elite Preview

August 17, 2022 /ENDURANCE SPORTSWIRE/ -  XTERRA returns to Zittau, Germany for the 20th time with an action-packed weekend of Short Track and full distance off-road triathlon racing this Friday and Saturday, August 19-20. As the name suggests, Friday’s XTERRA Short Track race is a fast, multi-lap, made-for-TV event combining...

Events

Press Releases

Triathlon

August 17, 2022

Riders Around the World to Experience the Best Sights of Down Under with FulGaz Hope Cycle Tour of Australia

MELBOURNE, AUS/TAMPA, Fla. (August 17, 2022) ENDURANCE SPORTSWIRE/ - FulGaz®, The IRONMAN Group’s cutting-edge indoor virtual cycling app, announced today that cyclists from around the world will have the chance to experience the highlights of riding down under without leaving their homes with the Hope Cycle Tour of Australia. The...

Cycling

Giving

Press Releases

Products

August 17, 2022

1300 racers at Inaugural GFNY Oaxaca

New York City, August 17, 2022 /ENDURANCE SPORTSWIRE/ – A head to head sprint decided the male race at the Inaugural Ford GFNY Oaxaca after 116.5km with an elevation gain of 1850m. 1300 riders from more than 25 countries tackled the race that included iconic Ixtepeji which reaches an altitude of...

Cycling

Events

Press Releases

August 17, 2022

John Wall Teams Up With McDavid

/ENDURANCE SPORTSWIRE/ – McDavid, a global leader in sports medicine products and maker of best-selling McDavid HEX® padded basketball apparel, is excited to announce a partnership with NBA superstar John Wall. A five-time NBA All-Star, Wall has worn McDavid HEX® padded apparel throughout his professional basketball career and will now be...

Press Releases

Products

Sponsorship

Wire Syndication

August 16, 2022

Josiah Middaugh Joins GO Sleeves as Head of Performance Science

San Jose, CA (Aug 16, 2022) /ENDURANCE SPORTSWIRE/ – GO Sleeves, the company that introduced the world’s first and only kinesiology sleeve — a compression sleeve with built-in kinesiology strips, announced today that GO Sleeves athlete Josiah Middaugh will add his knowledge and experience to the improvement of GO Sleeves products and...

Business

Press Releases

Running