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 (16)
) 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 440, 10

September 2, 2024

Challenge Beijing – World-Class Triathletes to Compete in High-Stakes Race This Weekend

/ENDURANCE SPORTSWIRE/ – There's US$100k on the line and some of the world's top triathletes are chasing it at Challenge Family's first race back on mainland China - the non-drafting Olympic distance, Challenge Beijing. The race features top-ranked athlete Kyle Smith (NZL), the winner of The Championship 2024 and Challenge...

Events

Press Releases

Triathlon

September 2, 2024

Thunderbolt AR Wins 2024 X-Marathon Oceania ARWS Championship

Lake Macquarie, NSW /ENDURANCE SPORTSWIRE/ – Hosted around the beautiful yet treacherous terrains of Lake Macquarie, the event brought together some of the toughest adventure racers from across the region. Thunderbolt Adventure Racing (AR) emerged victorious in the Full course, demonstrating exceptional navigation, endurance, and strategy. Team captain Hugh Stodart...

Events

Press Releases

September 2, 2024

2024 XTERRA Trail Run World Champions Crowned: Patterson & Colligan in Full; Dowe & Leroux in Half

CARRABASSETT VALLEY, Maine /ENDURANCE SPORTSWIRE/ – The 15th XTERRA Trail Run World Championship was held at Sugarloaf Mountain on September 1, drawing participants from 28 countries. Caitlin Patterson (USA) won the women's Full Marathon with a time of 4:11:06, Grant Colligan (USA) clinched the men's title in 3:34:45. In the...

Events

Press Releases

Running

September 2, 2024

Victory for The Germans: Caroline Pohle and Mika Noodt Take The Tape at IRONMAN 70.3 Zell Am See-Kaprun Triathlon

- Pohle and Noodt both take home 2,500 points in last IRONMAN Pro Series Race before the 2024 VinFast IRONMAN World Championship races begin - Jelle Geens (BEL) and Gregor Payet (LUX) complete the men’s professional podium, while Grace Thek (AUS) and Laura Masden (DEN) complete the women’s professional podium...

Cycling

Events

Press Releases

Running

Triathlon

August 29, 2024

San Andrés, Colombia Becomes Newest Host Venue on The Global IRONMAN 70.3 Circuit

SAN ANDRÉS, Colombia / MIAMI, Fla. / TAMPA, Fla. /ENDURANCE SPORTSWIRE/ - IRONMAN, SBR SPORTS and the Government of San Andrés, Colombia have announced that the Island of San Andrés will be the newest host location of an IRONMAN® 70.3® triathlon. The inaugural edition of the IRONMAN 70.3 San Andrés...

Events

Press Releases

Triathlon

August 29, 2024

5th GFNY Alpes Vaujany closing out France season with 7 races

New York City, August 29, 2024 /ENDURANCE SPORTSWIRE/ - This Sunday, GFNY Alpes Vaujany offers racers a 119.6 km long course with 4023 m of climbing across two major mountain passes and with a mountain finish in Vaujany. Host town Vaujany is a charming mountain village in the French Alps...

Cycling

Events

Press Releases

August 28, 2024

First Horizon Bank IRONMAN Chattanooga, Part of The VinFast IRONMAN North America Series, to Celebrate 10 Years of Racing in 2024

- 2024 edition of the First Horizon Bank IRONMAN Chattanooga triathlon, part of the VinFast IRONMAN North America Series, to see over 2,100 registered participants converge in the Scenic City to compete on Sunday, Sept. 29 - New bike course unveiled for the event that passes throughout Chattanooga and Southeastern...

Events

Press Releases

Triathlon