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 (8742)
) 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 7050, 10

May 6, 2022

The Land of Endurance Daily Recap – Friday May 6, 2022

ST. GEORGE, Utah (May 6, 2022)/ENDURANCE SPORTSWIRE/ –Race week festivities concluded today with bike and gear check-in and final event build out before race day for the 2021 Intermountain Healthcare IRONMAN World Championship presented by Utah Sports Commission in St. George, Utah. After a much anticipated two-year-plus wait, the countdown is...

Events

Press Releases

Triathlon

May 6, 2022

Skratch Labs Introduces its Newest Product Line: Clear Hydration Drink Mix

Boulder, CO (May 06, 2022)/ENDURANCE SPORTSWIRE/ – Skratch Labs, an innovator in performance nutrition, announces the release of Clear Hydration Drink Mix, a sports drink that tastes like water. Clear Hydration Drink Mix quenches thirst while providing the electrolytes plain water does not with just the slightest hint of flavor...

Cycling

Press Releases

Products

Running

Triathlon

May 6, 2022

2021 Intermountain Healthcare IRONMAN World Championship Presented By Utah Sports Commission Expected To Create Total Economic Impact Of More Than $35m Dollars

ST. GEORGE, Utah / TAMPA, Fla. /ENDURANCE SPORTSWIRE/ - Following the postponed IRONMAN World Championship events due to the COVID-19 pandemic, the 2021 Intermountain Healthcare IRONMAN® World Championship presented by Utah Sports Commission will take place on Saturday, May 7, 2022 in St. George, Utah, United States. This marks a...

Events

Press Releases

Triathlon

May 6, 2022

Wanjiku, Degefa Win PRRO Circuit 2022 Stop at Bloomsday 12K

SPOKANE, WA /ENDURANCE SPORTSWIRE/ – At the Lilac Bloomsday Run 12K on Sunday, May 1, under sunny, cool conditions, Charles Wanjiku (KEN) and Biruktayit Degefa (ETH) claimed the titles in 35 minutes, 7 seconds and 38:48, respectively. In a final sprint, Wanjiku, 21, edged Reid Buchanan (USA) in one of...

Events

Press Releases

Running

May 6, 2022

Master Spas launches series of pro tip videos

FORT WAYNE, Ind. — MAY 6, 2022 /ENDURANCE SPORTSWIRE/ - Master Spas, the world’s largest swim spa manufacturer, is excited to launch a new video series featuring pro tips from professional triathletes. The videos highlight how these athletes not only incorporate a Master Spas swim spa into their training routine...

Press Releases

Triathlon

May 5, 2022

United Sports Brands Acquires Iconic Cycling Brand PEARL iZUMi

FOUNTAIN VALLEY, CA and LOUISVILLE, CO (May 5, 2022) /ENDURANCE SPORTSWIRE/ - United Sports Brands (“USB”), a global leader in sports performance and protective products, today announced that it has acquired PEARL iZUMi USA (“PEARL iZUMi”), an iconic manufacturer and retailer of cycling apparel and accessories. PEARL iZUMi will join...

Business

Cycling

Press Releases

May 5, 2022

Showcased

Davis Phinney Foundation Proudly Announces the 2022 Tour de Victory Cycling Challenge Sponsored by Team Evergreen Cycling

Boulder, Colo., May 5, 2022/ENDURANCE SPORTSWIRE/ – The Tour De Victory Cycling Challenge, a unique Colorado charity ride that raises funds and awareness for the Davis Phinney Foundation, is now open for registration and their list of 2022 sponsors and partners has been released. This year marks the fourth that...

Cycling

Giving

Press Releases

Sponsorship

May 5, 2022

The Land of Endurance Daily Recap – Thursday, May 5, 2022

GEORGE, Utah (May 5, 2022)/ENDURANCE SPORTSWIRE/ – Race week for the 2021 Intermountain Healthcare IRONMAN World Championship presented by Utah Sports Commission continued today in St. George, Utah, bringing along a plethora of activities and events. After a much anticipated two-year-plus wait, the countdown continues to the world's most iconic...

Events

Press Releases

Triathlon