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

September 3, 2024

Almaty Marathon: the largest running event in Central Asia to be held on September 29

Almaty, Kazakhstan, 03 September 2024/ENDURANCE SPORTSWIRE/ – On 29 September 2024, Almaty will host for the thirteenth time the Almaty Marathon, the largest running event in Central Asia. More than 15,000 athletes from 50 countries will be brought together to run through the city's most important landmarks. The start and...

Events

Press Releases

Running

September 3, 2024

Alete Active Nutrition Brands SaltStick® and Bonk Breaker® Join Forces with Diplo’s Run Club for First-Ever 5K and Music Festival Experience

[Thousand Oaks, CA] /ENDURANCE SPORTSWIRE/ - Get ready to run, dance, and hydrate as SaltStick and Bonk Breaker proudly announce their sponsorship of Diplo's Run Club, a reimagined series of runs and mini-music festivals hosted by Grammy-winning DJ and producer, Diplo. With events in San Francisco on September 8th and in...

Events

Press Releases

Running

Sponsorship

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