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

May 31, 2023

Challenge Kaiserwinkl-Walchsee 2023 announces pro field

/ENDURANCE SPORTSWIRE/ – Challenge Kaiserwinkl-Walchsee today announced its 30-strong professional field at a live press conference at Das Walchsee Aktivresort in the host village of Walchsee in the Austrian Alps. Heading the men’s field is defending champion and current course record holder, Frederic Funk (GER) who is looking forward to a...

Events

Press Releases

Triathlon

May 31, 2023

Belgian and French win GFNY Villard de Lans after 3973m of climbing

New York City, May 31, 2023 /ENDURANCE SPORTSWIRE/ – The mountainous Vercors national park hosted the second edition of GFNY Villard de Lans this past Sunday. The long challenging racecourse was 163.4 km with an elevation gain of 3973 m. After the neutralized descent from the start in the ski resort,...

Cycling

Events

Press Releases

May 31, 2023

XTERRA Colombia joins 2024 XTERRA Americas Tour

/ENDURANCE SPORTSWIRE/ - XTERRA, the global leader in off-road triathlon, is pleased to announce the addition of XTERRA Colombia to the 2024 XTERRA Americas Tour. In partnership with XPORTIVA, a well-respected endurance events production company based in Bogota, the first-ever XTERRA weekend of events in Colombia will be held May...

Business

Events

Press Releases

Running

Triathlon

May 30, 2023

Mississippi Gulf Coast Marathon and Louisiana Marathon Voted as Best Marathons in Their States named by RaceRaves

Biloxi, MS | Baton Rouge, LA /ENDURANCE SPORTSWIRE/ - The running community has spoken, and the Mississippi Gulf Coast Marathon and the Louisiana Marathon have emerged as the top marathons in their respective states. RaceRaves, the leading online race finder and reviews community for runners and endurance athletes, has unveiled...

Awards

Business

Events

Press Releases

Running

May 30, 2023

Showcased

Half-Marathon Walking Division Added to Probility Ann Arbor Marathon Event Lineup

ANN ARBOR, MI /ENDURANCE SPORTSWIRE/ - Epic Races announced a new walking category to The Ann Arbor Half Marathon which is part of the Probility Ann Arbor Marathon weekend of events. Walkers can now comfortably participate in this annual community event, walking the 13.1-mile course through the city of Ann...

Events

Press Releases

Running

May 30, 2023

EventPower’s Long Island Triathlon Tour Announces i-tri as the Mighty Hamptons Steve Tarpinian Memorial Triathlon Beneficiary for 2023

Sag Harbor, New York /ENDURANCE SPORTSWIRE/ – EventPower, Long Island's premiere race company will be donating proceeds from the iconic Mighty Hamptons Steve Tarpinian Memorial Triathlon, September 10th, 2023 to i-tri, an East-End based non-profit program that empowers adolescent girls through the sport of triathlon. Located in the heart of The Hamptons, Long Island's world...

Events

Giving

Press Releases

Triathlon

May 30, 2023

Daniela Ryf, Laura Phillip, Ashley Gentle, Daniela Bleymehl, and Anne Reischmann set for a Mouthwatering Showdown at 2023 IRONMAN 70.3 Switzerland Rapperswil-Jona

RAPPERSWIL-JONA, Switzerland (May 30, 2023)/ENDURANCE SPORTSWIRE/ – The IRONMAN 70.3 Switzerland Rapperswil-Jona triathlon will feature a small but strong and exciting women’s professional field as the 16th edition of the event is set to take place on June 11, 2023. The twenty-one professional women who will line up in Switzerland will...

Events

Press Releases

Triathlon

May 30, 2023

RaceRaves announces Best Marathons in the U.S.

Los Angeles, CA (May 30, 2023) /ENDURANCE SPORTSWIRE/ - The runners have spoken and RaceRaves, the premier global race finder and reviews community, has announced the much-anticipated results of its 2023 initiative to crown the best marathon in every U.S. state. The company’s authoritative new guide, which features a profile...

Awards

Events

Press Releases

Running

May 29, 2023

Dead Sea Marathon Israel

Tamar Regional Council proudly presets: DEAD SEA MARATHON ISRAEL FRIDAY 2/2/2024 - EIN BOKEK /ENDURANCE SPORTSWIRE/ – Get ready to lace up your running shoes and experience the exhilarating Dead Sea Marathon, a Spectacular Running Event at the Lowest Point on Earth. Returning for its fifth edition, at the stunning backdrop...

Events

Press Releases

Running