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

May 6, 2023

Sam Long (USA) And Jeanni Metzler (ZAF) Top Competition at Intermountain Health IRONMAN 70.3 North American Championship St. George Triathlon

ST. GEORGE, UTAH. (May 6, 2023) – Southwestern Utah and the Greater Zion region welcomed the return of Intermountain Health IRONMAN® 70.3® North American Championship St. George triathlon on Saturday, May 6. With some of triathlon’s best talent on hand, the event saw Sam Long (USA) capture the overall victory...

Events

Press Releases

Triathlon

May 5, 2023

General Registration For 2023 Kaiser Permanente IRONMAN California Triathlon, Part of The Vinfast IRONMAN North America Series, Officially Sold Out

SACRAMENTO, Calif. (May 5, 2023) /ENDURANCE SPORTSWIRE/ - IRONMAN announced today that general registration for the 2023 Kaiser Permanente IRONMAN® California triathlon, part of the VinFast IRONMAN North America Series, has officially sold out. Limited entries remain available through The IRONMAN Foundation and Enhanced Athlete Event Experiences powered by NIRVANA....

Events

Press Releases

Triathlon

May 5, 2023

Parkinson’s cyclists prepare to take on a 1000-mile Cycle Challenge to raise awareness for the debilitating disease

5th May 2023, UK/ENDURANCE SPORTSWIRE/ – Leading indoor cycling performance brand, Wattbike are excited to be supporting Sport Parkinson’s in a 1000-mile Cycle Challenge. On Saturday 6th May 2023 a team of four cyclists, all of whom have Parkinson's, will take on the grueling challenge of cycling 1000 virtual miles from...

Cycling

Events

Giving

Press Releases

May 5, 2023

2023 PTO Tour Goes Global – Each Round To Be Broadcast Live In 195 Territories Worldwide

Ibiza/ENDURANCE SPORTSWIRE/ – 2023 PTO Tour events will be broadcast live in a record 195 territories, reaching 425 million Households and be translated into 22 languages when the curtain rises on the first-ever PTO European Open in Ibiza tomorrow (6 May). Led by the PTO’s broadcast partnerships with Warner Bros. Discovery,...

Events

Press Releases

Triathlon

May 5, 2023

The Ascension Seton CapTex Tri and evamor Enhance Partnership

AUSTIN, Texas, May 5, 2023 /ENDURANCE SPORTSWIRE/ – The Ascension Seton CapTex Tri welcomes evamor for the second year in a row as Official Water sponsor. In addition to providing water to all finishers, the company will keep staff and volunteers hydrated as well as offer the public a chance to try...

Events

Press Releases

Sponsorship

Triathlon

May 5, 2023

Bee-utiful Sunflower Run Names Sonia Anderson Honorary Race Starter

LAS VEGAS, NEVADA – May 5, 2023 /ENDURANCE SPORTSWIRE/ – Beyond Limits Running today announced Sonia Anderson, Co-Founder & CEO of Southern Nevada based non-profit Andson, Inc., has been named the Honorary Race Starter for the 2th Annual Bee-utiful Sunflower Run taking place Sunday, May 14th at the nearly 100-year-old Gilcrease Orchard in...

Events

Press Releases

Running

May 4, 2023

Visit Panama City Beach IRONMAN Florida Triathlon, Part Of The VinfFast IRONMAN North America Series, Celebrates 25th Edition This November

PANAMA CITY BEACH, Fla. / TAMPA, Fla. (May 4, 2023) /ENDURANCE SPORTSWIRE/ – The Visit Panama City Beach IRONMAN® Florida triathlon, part of the VinFast IRONMAN North America Series, will celebrate the 25th edition when it returns on Nov. 4, 2023. Since its debut in 1999, the event has become the longest...

Events

Press Releases

Triathlon