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

February 21, 2023

IRONMAN Announces 2023 Race Schedule For Events Across The United States And Canada

TAMPA, Fla. (Feb. 21, 2023) /ENDURANCE SPORTSWIRE/ - IRONMAN has announced its 2023 season calendar of racing in the United States and Canada mixing some iconic longstanding favorites with a variety of new host communities across the VinFast IRONMAN® North America Series and IRONMAN® 70.3® Series. Athletes looking to experience...

Events

Press Releases

Triathlon

February 21, 2023

Shamrock Run Portland Announces Shamrock Showdown 8K

PORTLAND /ENDURANCE SPORTSWIRE/ – If the calendar reads that spring is knocking on the door, that can only mean one thing to the Pacific Northwest running community. The 2023 Shamrock Run Portland is preparing to welcome more than 20,000 runners for Oregon’s favorite St. Patrick’s Day tradition. The 45th edition of...

Events

Press Releases

Running

February 21, 2023

Nearly 100 Elite Runners to compete in Half Marathon at 2023 Rock ‘n’ Roll Running Series Las Vegas

LAS VEGAS, Nev. (Feb. 21, 2023) /ENDURANCE SPORTSWIRE/ – As the heralded running series celebrates its 25th anniversary in 2023, the iconic Rock ‘n’ Roll® Running Series Las Vegas event makes its annual return to the famed Las Vegas Strip this weekend. Nearly 100 elite runners from around the world will...

Events

Press Releases

Running

February 21, 2023

USA Triathlon Announces 2023 U.S. Elite Triathlon National Team

COLORADO SPRINGS, Colo. /ENDURANCE SPORTSWIRE/ – USA Triathlon today announced the 11 members of the 2023 U.S. Elite Triathlon National Team, the group of athletes who will represent the U.S. at the highest levels of elite triathlon competition during the 2023 season. “Our 2023 U.S. Elite Triathlon National Team is incredibly talented,...

Events

Press Releases

Triathlon

February 21, 2023

Life Time Sea Otter Classic to Host First-Ever Industry Day on April 20

MONTEREY, Calif. (Feb. 21, 2023) /ENDURANCE SPORTSWIRE/ - Life Time (NYSE: LTH), the nation's premier healthy lifestyle brand, and the Sea Otter Classic announced details for the first-ever Sea Otter Classic Industry Day set for April 20, 2023. Programming includes VIP tours, a networking social and a one-day intensive retail...

Events

Press Releases

February 21, 2023

Supersapiens Proudly Continuing Mallorca 312 Partnership

ATLANTA, 21 February 2023 /ENDURANCE SPORTSWIRE/ – The Spanish event features stunning roads and some of the toughest climbs on the island, meaning glucose management is essential for all participants. “The synergies between Supersapiens as a product and Mallorca 312 as an event are clear and evident. Add in Phil’s cycling...

Cycling

Events

Press Releases

February 20, 2023

Jack Moody and Grace Thek Race to Resounding Victory at Challenge Wanaka

/ENDURANCE SPORTSWIRE/ - In a race filled with excitement, thrills and spectacle, Jack Moody and Grace Thek took the win at Challenge Wanaka. While there was plenty of action throughout the race, the two strongest athletes both won the race with their unrivalled runs. In the men's race Mike Phillips...

Events

Press Releases

Triathlon

February 20, 2023

Showcased

Charm City Run Events Launches 2023 the ASICS Susquehanna River Running Festival

Baltimore, MD — February 20, 2023 /ENDURANCE SPORTSWIRE/ – Charm City Run Events announces their newest signature race in partnership with the Al Cesky Scholarship Fund, the ASICS Susquehanna River Running Festival on September 23, 2023. Featuring Half Marathon, 10K, and 5K races, participants will enjoy the small-town hospitality and waterfront views...

Events

Press Releases

Running

February 18, 2023

12 Finishers of the Original 1978 Hawaii Ironman Triathlon to be Inducted into USA Triathlon Hall of Fame

COLORADO SPRINGS, Colo. – The 12 finishers of the original Hawaii Ironman Triathlon held 45 years ago today, Feb. 18, off the coast of Hawaii’s Waikiki Beach today were announced as the 12th induction class of the USA Triathlon Hall of Fame. The 12 finishers of the original Hawaii Ironman...

Awards

Events

Giving

Press Releases

Triathlon