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

June 2, 2023

Outside Interactive Renews PTO Partnership to Broadcast Full Tour Live Across US & Canada

London, UK/ENDURANCE SPORTSWIRE/ – The Professional Triathletes Organisation (PTO) has announced that Outside Interactive, Inc. will broadcast all its 2023 PTO Tour race live across the United States and Canada on Outside Watch, along with all race preview shows and the 2023 PTO Tour docuseries Beyond Human. Outside Watch is a multi-broadcast...

Business

Events

Press Releases

Triathlon

June 2, 2023

Multi-Year Partnership for realbuzz and The World-Famous Irish Life Dublin Marathon

/ENDURANCE SPORTSWIRE/ – Charity running platform, realbuzz, has signed a multi-year deal with the prestigious Irish Life Dublin Marathon to continue delivering its fast-growing charity programme. This extended commitment to the partnership comes after realbuzz first teamed up with Dublin’s famous marathon in 2019 to develop its official charity programme. Over...

Events

Giving

Press Releases

Running

June 2, 2023

Big Sur International Marathon Named Best Marathon in California By Race Raves

CARMEL, CA /ENDURANCE SPORTSWIRE/ - The runners have spoken, and the Big Sur Marathon has been named the top marathon in California. RaceRaves, the leading online race finder and reviews community for runners and endurance athletes, has announced the winners of its 2023 “Runners Choice: Best Marathons in the U.S.”...

Awards

Events

Press Releases

Running

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