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

September 20, 2021

Kerrville Triathlon Expects Record Numbers for 10th Anniversary Celebration

AUSTIN, Texas, September 20, 2021 -- The Kerrville Triathlon Festival is ready to welcome the largest field in its 10-year history for triathlon’s return to the Texas Hill Country. With close to 1800 registrants from 20 states bringing their friends and families, Kerrville Tri continues to showcase why it’s a...

Events

Press Releases

Triathlon

September 20, 2021

Mongoose Resurrects Legendary Designs In Classics Collection

MADISON, Wis. (September 20, 2021) – Few bikes have defined a generation of innovation and design the way Mongoose’s iconic designs of the 1970’s and 1980’s did for BMX. The brand’s Supergoose and California Special inspired generations of cyclists with new technologies, unique styling, and the professional athletes who rode them....

Cycling

Press Releases

Products

September 18, 2021

Gustav Iden (NOR) And Lucy Charles-Barclay (GBR) Utilize Dominant Performances to Take the Titles at The Intermountain Healthcare IRONMAN 70.3 World Championship Presented by Utah Sports Commission

St. GEORGE, Utah / TAMPA, Fla. (September 18, 2021) - After two-years of anticipation for a world championship event, St. George, Utah, took the global spotlight this week as fans and athletes alike witnessed the remarkable lineup of pro athletes at the 2021 Intermountain Healthcare IRONMAN® 70.3® World Championship presented...

Events

Press Releases

Triathlon

September 18, 2021

Leadville Race Series Podcast Grit, Guts and Determination Now Available

LEADVILLE, Colo., Sept. 18 2021 – Life Time, the premier healthy lifestyle brand, today announced the launch of Grit, Guts and Determination: The Leadville Race Series Podcast. Hosted by Cole Chlouber, son of Leadville Race Series co-founder Ken Chlouber, each episode highlights inspirational, historical, and transformative experiences that comprise the...

Business

Events

Press Releases

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