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

September 17, 2021

The Land of Endurance Daily Recap – Friday, September 17, 2021

St. GEORGE, Utah (September 17, 2021) – Race week for the 2021 Intermountain Healthcare IRONMAN® 70.3® World Championship presented by Utah Sports Commission continued today in St. George, Utah with the IRONKIDS Fun Run and athlete bike check-in. The Land of Endurance Daily Recap, which pays homage to this year's...

Events

Press Releases

Triathlon

September 17, 2021

The Apex Presented by Rockshox Welcomes EF Pro Cycling Riders Lachlan Morton and Alex Howes to Colorado Springs

Colorado Springs, CO, September 17, 2021 – Sports Strategies announces EF Pro Cycling riders Lachlan Morton and Alex Howes will be coming to Colorado Springs for the 2021 Pikes Peak APEX presented by RockShox. Morton, native of Australia, and Howes, from Colorado, are both living in Colorado and will have...

Cycling

Events

Press Releases

September 17, 2021

P3R CEO Troy Schooley Recognized with Pittsburgh Business Times 2021 Outstanding CEO and Top Executive Award

PITTSBURGH (September, 2021) – Troy Schooley, P3R’s CEO, was recognized as a top leader in the region with the Pittsburgh Business Times 2021 Outstanding CEO and Top Executive Award. This award celebrates western Pennsylvania’s leading business executives, and Schooley was selected by a panel of independent judges, all of whom...

Awards

Press Releases

Running

September 17, 2021

Girls Gone Gravel launches a women’s gravel team for female-identifying cyclists of all levels

Victoria, B.C. - September 17, 2021 - Girls Gone Gravel, in partnership with Feisty Media, is pleased to announce their private women’s gravel team, The Girls Gone Gravel Adventures Team. This newly-formed team is open to any female-identifying cyclist. Girls Gone Gravel founder, Kathryn Taylor feels like this team is...

Cycling

Press Releases

September 16, 2021

IRONMAN Adds New Races in France and Germany In 2022

TAMPA / LONDON / AIX-EN-PROVENCE / DRESDEN (September 16, 2021) – IRONMAN announced today that it will add two new events to its 2022 race calendar with the IRONMAN® Pays d'Aix-en-Provence triathlon in France and IRONMAN 70.3® Dresden triathlon in Germany. The inaugural full-distance race in Aix-en-Provence will be held on...

Events

Press Releases

Triathlon

September 16, 2021

Beti Bike Bash p/b Yeti Cycles Announces Toyota as Official Sponsor

EVERGREEN, COLO, Sept 16, 2021 – The Beti Bike Bash p/b Yeti Cycles, to be held on October 3rd in Lakewood, CO, proudly announces Toyota as a returning official sponsor. Toyota has continued to show its dedication to the community through supporting women’s specific events, including the Beti Bike Bash....

Cycling

Events

Press Releases

Sponsorship

September 16, 2021

TrainerRoad Announces Adaptive Training Open Beta and Free Trial, Providing Cyclists Early Access to the Future of AI-Powered Training

RENO, Nevada (September 16, 2021) – TrainerRoad, cycling’s most complete & effective training system and the market leader in making athletes faster, is excited to announce the open beta availability of their new Adaptive Training system, offering personalized training powered by advanced machine learning for every cyclist. TrainerRoad now offers...

Business

Cycling

Press Releases

Products

September 16, 2021

The Land of Endurance Daily Recap – Thursday, September 16, 2021

GEORGE, Utah (September 16, 2021) - Race week for the 2021 Intermountain Healthcare IRONMAN® 70.3® World Championship presented by Utah Sports Commission continued today with multiple events as the countdown to race day gets ever closer in St. George, Utah. The Land of Endurance Daily Recap, which pays homage to this...

Events

Press Releases

Triathlon