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

June 2, 2023

inGamba Partners with Gran Fondo National Series through 2024

Gettysburg, PA – June, 2023/ENDURANCE SPORTSWIRE/ – Gran Fondo National Series is proud to announce a new partnership with inGamba, the world’s premier cycling touring company. In addition to inGamba having a prominent presence at all 2023-2024 SUAREZ Gran Fondo National Series events, riders will have opportunities to win inGamba prizes...

Cycling

Events

Press Releases

June 2, 2023

The Ultimate Scottish Adventure

/ENDURANCE SPORTSWIRE/ – Ultra X, the leading global ultra-marathon series, is thrilled to announce the launch of Ultra X Scotland 2024, an exhilarating trail running challenge set amidst the breath-taking landscapes of Scotland. This epic event will take place the weekend of the 4th and 5th of May 2024 and will...

Events

Press Releases

Running

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