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

June 22, 2023

Five World Champions in the Race for the Roth Crown

22 June 2023 / ROTH/ENDURANCE SPORTSWIRE/ – On 25 June 2023, five Hawaii champions - Patrick Lange, Anne Haug, Sebastian Kienle, Daniela Ryf and Chelsea Sodaro - will compete in Roth. Include Magnus Ditlev, Andi Dreitz and Nils Frommhold and seven athletes who have already stood at the top of the Roth...

Events

Press Releases

Triathlon

June 22, 2023

TCS Toronto Waterfront Marathon Celebrates Sustainability and Artistic Excellence with 2023 Medal Reveal Event

TORONTO, ON (June, 2023)/ENDURANCE SPORTSWIRE/ – Canada Running Series unveiled the highly anticipated 2023 TCS Toronto Waterfront Marathon medal this evening at the iconic CN Tower. The reveal took place as part of a special Canada Running Series event, with participants running from Great Lakes Brewpub to the CN Tower to...

Events

Press Releases

Running

June 21, 2023

2500 Participants from 130 Local Businesses Participate In The ADP Corporate 5K to Celebrate Corporate Wellness

NORFOLK, VIRGINIA /ENDURANCE SPORTSWIRE/ - The damp weather couldn’t dampen the spirit or energy of over 130 local businesses and 2,500 participants at the ADP Corporate 5K presented by Bon Secours. Upon completion of the race, coworkers were all invited to the post-race outdoor office party, where they were encouraged...

Events

Press Releases

Running

June 21, 2023

Nice, France Course Unveiled for 2023 VinFast IRONMAN World Championship

NICE, Fra. / TAMPA, Fla. (June 21, 2023) /ENDURANCE SPORTSWIRE/ – As preparations continue for the 2023 VinFast IRONMAN® World Championship triathlon, taking place in two locations for the first time in event history, IRONMAN has today revealed the Nice, France course the men’s field will swim, bike, and run in...

Events

Press Releases

Triathlon

June 21, 2023

Women’s Distance Running Stars Set the Stage for Legendary Matchups at the 45th Bank of America Chicago Marathon

June 21, 2023 / CHICAGO /ENDURANCE SPORTSWIRE/ – Today the Bank of America Chicago Marathon announced the return of two-time defending champion Ruth Chepngetich and American record holder Emily Sisson. Joining Chepngetich and Sisson is 2023 London Marathon champion Sifan Hassan, one of distance running’s most accomplished stars who will be making...

Events

Press Releases

Running

June 21, 2023

F45 Training Partners with Spartan Race to Become the Official 45-Minute Workout to Train like Obstacle Race Champions

AUSTIN, TX. – June 21, 2023 /ENDURANCE SPORTSWIRE/ – F45 Training Holdings Inc (“F45 Training” or “F45”), the global high-intensity interval training brand, and Spartan Race, the world’s largest endurance racing brand that also owns Tough Mudder, DEKA and SpartanTrail, have agreed to partner on the creation of Spartan-themed workouts for F45 studios and...

Events

Press Releases

Running

Sponsorship

June 21, 2023

Northwell Health To Serve as Title Partner for Northwell Health IRONMAN 70.3 New York – Jones Beach

TAMPA, Fla. / NEW YORK, N.Y. /ENDURANCE SPORTSWIRE/ - IRONMAN announced today that Northwell Health,New York’s largest healthcare provider will serve as the title partner of the inaugural Northwell Health IRONMAN® 70.3® New York – Jones Beach triathlon. Northwell will also serve as the Official Volunteer Partner and Official Medical...

Events

Press Releases

Sponsorship

Triathlon

June 21, 2023

The Stubborn Mule Adventure Race provides live tracking again in 2023

Front Royal, Va. /ENDURANCE SPORTSWIRE/ – The Stubborn Mule Adventure Race will once again be providing live tracking in 2023, thanks to Enabled Tracking. The event is scheduled for June 24, 2023, and is hosted by 180 Adventures, a Wisconsin-based adventure race organizer. During the 30-hour race, teams will bike between...

Events

Press Releases