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

June 1, 2023

Registration Now Open for the 2023 EQT Pittsburgh 10 Miler and 10K

PITTSBURGH (June 1, 2023)/ENDURANCE SPORTSWIRE/ – Registration is now open for the 2023 EQT Pittsburgh 10 Miler and 10K, one of Pittsburgh’s largest fall running events. The 10K option returns with a brand new walking division to inspire even more people to MOVE at the event on Nov. 5. “We launched...

Events

Press Releases

Running

June 1, 2023

Elite continues with GFNY

NEW YORK CITY, June 1, 2023 /ENDURANCE SPORTSWIRE/ - Italy based Elite specializes in the research, development and production of smart trainers, sports bottles, and bottle cages. It’s the number one bike bottle supplier for professional cycling. “Our unwavering dedication to developing products that maximize performance and elevate user experience...

Business

Cycling

Events

Press Releases

June 1, 2023

History & Heritage Race Showcases C-124 Cargo Aircraft

WRIGHT- PATTERSON AIR FORCE BASE, Ohio /ENDURANCE SPORTSWIRE/ - The Douglas C-124 Globemaster II will be the fourth retired aircraft to headline the 2023 History & Heritage Race Series, powered by the Air Force Marathon, beginning July 1. The event marks the fourth of six virtual races during the series’s...

Events

Press Releases

Running

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