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

June 2, 2023

Ride For Change Embarks on a Cross-Country Cycling Expedition for You Can Ride 2

TORONTO, CANADA – June, 2023 /ENDURANCE SPORTSWIRE/ – In an extraordinary demonstration of resilience and transformation, Ride for Change is currently on an ambitious cross-country cycling expedition, spearheaded by the tenacious Matt Devine. The 13,000-kilometer odyssey across Canada supports You Can Ride 2 – a charity dedicated to dissolving the barriers...

Cycling

Events

Press Releases

June 2, 2023

CapTex Tri Continues to Grow and Welcome New Athletes

AUSTIN,Texas, June 2, 2023/ENDURANCE SPORTSWIRE/ – More than 2300 triathletes from over 26 states and 4 countries registered for the 2023 Ascension Seton CapTex Tri. In addition, over 300 volunteers came out to support the participants. The annual Memorial Day event took place in downtown Austin and featured a swim in...

Events

Press Releases

Triathlon

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