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

October 26, 2022

2022 Intermountain Healthcare IRONMAN 70.3 World Championship Presented By Utah Sports Commission Expected To Create Total Economic Impact Of More Than $30 Million Dollars

ST. GEORGE, Utah (Oct. 26, 2022) /ENDURANCE SPORTSWIRE/ – The top professional and age-group triathletes are once again in St. George, Utah for the 2022 Intermountain Healthcare IRONMAN® 70.3® World Championship presented by Utah Sports Commission, with this event making history as the third IRONMAN-branded World Championship event to be held...

Events

Press Releases

Triathlon

October 26, 2022

Chula Vista to Host Selection Camp for First-Ever USA Blind Soccer Men’s National Team

October 26, 2022/ENDURANCE SPORTSWIRE/ – The U.S. Association of Blind Athletes (USABA) is holding a team selection camp, Oct. 27-30, in Chula Vista, Calif., with 13 players with visual impairments and three sighted goalkeepers vying to earn a spot on the first-ever USA Blind Soccer National Team. From that pool of athletes,...

Events

Press Releases

October 26, 2022

Land of Endurance Daily: 2022 Intermountain Healthcare IRONMAN 70.3 World Championship Presented by Utah Sports Commission Daily Recap for Wednesday, October 26, 2022

ST. GEORGE, Utah (October 26, 2022) /ENDURANCE SPORTSWIRE/ –The Land of Endurance was buzzing today with activities, events, and athletes all around. From the Land of Endurance Fun Run to professional athletes discussing race day strategies, there was something for everyone when it came to experiences to get race day ready...

Events

Press Releases

Triathlon

October 26, 2022

Atlanta runners start the party at the Lululemon 10k Tour

Oct. 26, 2022. ATLANTA /ENDURANCE SPORTSWIRE/ – Thousand of runners took to the streets of Atlanta on Saturday for the first stop on the lululemon 10K Tour, a multi-city race series presented by lululemon and DMSE Sports. Participants crossed the starting line at 8 a.m., traveling from Georgia World Congress Center, past...

Events

Giving

Press Releases

Running

October 25, 2022

GFNY Florida Sebring: a hattrick – and an attempted escape from USADA

New York City, October 25, 2022 /ENDURANCE SPORTSWIRE/ – A sprint decided the male and female race at the 3rd GFNY Florida Sebring. The 95 miles long course makes the race Florida’s hardest bike race. After a string of attacks from the gun, it was at mile 20 when a group...

Cycling

Events

Press Releases

October 25, 2022

Showcased

Happy Hippie Harvest Run Welcomes Blind Runners

LAS VEGAS, NEVADA – October 25, 2022 /ENDURANCE SPORTSWIRE/ – Beyond Limits Running is pleased to announce over a dozen Southern Nevada blind runners and walkers, along with their running guides, will join a field of over 300 runners at the 4th Annual Happy Hippie Harvest Run taking place November 5, 2022...

Events

Press Releases

Running

October 25, 2022

Stevy Merrill Sets SuperHalf™ Course and Distance Standard at Inaugural Monarch Triathlon

KINGMAN, Ariz. /ENDURANCE SPORTSWIRE/ - Stevy Merrill was the champion of the first-ever SheStrong Inc Monarch Triathlon SuperHalf™, a women’s multisport event that debuted a brand new triathlon distance this past weekend. She set the course and distance standard with a time of 4:32:22. The Kingman local and healthcare worker...

Events

Press Releases

Triathlon

October 24, 2022

Seven Runners Complete First-Ever MassDash Relay Across the State of Massachusetts

Oct. 24, 2022. BOSTON /ENDURANCE SPORTSWIRE/ – On Sunday, a team of seven runners completed the inaugural MassDash Relay as they crossed the Boston Marathon finish line. The invitational event, which began 21 hours earlier in Great Barrington, spanned the entire state of Massachusetts. The team ran all through the day and...

Events

Giving

Press Releases

Running

October 24, 2022

Tuscaloosa Tourism & Sports Half Marathon and Publix 5K returns for the 11th year

October 24, 2022 /TUSCALOOSA, AL. /ENDURANCE SPORTSWIRE/ – Registration is now open for the 11th Annual Tuscaloosa Tourism & Sports Half Marathon + Publix 5K. Over 1000 runners from 28 different states participated in the 2022 event. The Tuscaloosa Tourism & Sports Half Marathon is the longest distance running race held...

Events

Press Releases

Running