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

September 11, 2022

Over 2,400 Athletes Converge in Madison, Wisconsin for a Festival Weekend of Racing

MADISON, Wisc. (Sept.11, 2022) – The Wisconsin State Capitol and scenic Dane County played host to over 2,400 athletes from around the world for the 2022 IRONMAN Wisconsin, a part of the VinFast U.S. Series, and IRONMAN 70.3 Wisconsin triathlons as part of a festival weekend of racing on Saturday,...

Events

Press Releases

Triathlon

September 9, 2022

Electrolit Announces Official Partnership with The McCourt Foundation

September 9, 2022, CERRITOS, Calif. --/ENDURANCE SPORTSWIRE/ - Electrolit – the preferred, premium hydration beverage made from pharmaceutical quality grade ingredients – is delighted to announce a multiyear partnership with The McCourt Foundation, becoming the official hydration partner for the Los Angeles Marathon presented by ASICS and other major running events...

Events

Press Releases

Running

Sponsorship

September 9, 2022

Velo Saddles Introduces Nitrogen-Infused AtmosFoam to The Cycling Industry

/ENDURANCE SPORTSWIRE/ – Leading saddles manufacturer, Velo Saddles, introduces their new Velo AtmosFoam (VAF), a nitrogen-infused foam designed to enhance performance and durability attributes in their products while minimizing the environmental impact of the production process. Velo AtmosFoam is lightweight and provides incredible support for the rider’s sit bones to improve...

Cycling

Press Releases

Products

September 9, 2022

Arena Games Triathlon Handed Prestigious SVG Europe Sports TV Award

Arena Games Triathlon has been recognised with a prestigious SVG Europe Sports TV Award. Super League Triathlon’s innovative hybrid race format, which this year was held in partnership with World Triathlon to crown the sport’s first esports world champions, was handed the Outstanding Production Achievement – Innovation trophy at the...

Awards

Press Releases

Triathlon

September 9, 2022

Run Catalina Announces Lightfoot Coaching Training Programs for Run Catalina Athletes as the Official Coach of Run Catalina events

/ENDURANCE SPORTSWIRE/ - Run Catalina announced today the addition of Lightfoot Coaching training programs for its trail athletes. “Proper trail training is crucial for runners competing on any of our Run Catalina courses, which are filled with challenging peaks, elevation changes, and rewarding views of Catalina Island. We are offering...

Business

Events

Press Releases

Running

Sponsorship

September 9, 2022

Inaugural Monarch Triathlon champions women fighting cancer and their families

KINGMAN, Ariz. /ENDURANCE SPORTSWIRE/ - SheStrong Inc. has opened registration for the Monarch Triathlon SuperHalf™, a brand new women’s multisport event that will take to the waterways and roadways of Kingman and Bullhead City, Ariz. on Oct. 22. The nonprofit’s inaugural race will be the first-ever USA Triathlon Sanctioned Event...

Events

Giving

Press Releases

Triathlon

September 9, 2022

rabbit Co-Founders Keep Dreaming at Cascade Express Marathon

/ENDURANCE SPORTSWIRE/ -Monica DeVreese and Jill Deering, co-founders of rabbit, the free-spirited, California running apparel brand, know what it means to dream. Their original dream? To create a running apparel brand that married style, function and fit. When they first concocted the idea years ago, they utilized their 30-plus years...

Business

Events

Press Releases

Running

September 9, 2022

Defiant Hauser Has a Point to Prove as Super League Triathlon Returns to Munich

/ENDURANCE SPORTSWIRE/ – Defiant Matt Hauser insists his recovery from an incorrect penalty proves he is a genuine title contender as Super League Triathlon returns to Munich, Germany, this weekend. The Australian was second out of the water of the Stage 1 swim in the Championship Series opener in London, but...

Events

Press Releases

Triathlon

September 9, 2022

Dave McGillivray Finish Strong Foundation Names Beneficiaries of Upcoming Run Medford 8k and 5k

BOSTON /ENDURANCE SPORTSWIRE/ - The Dave McGillivray Finish Strong Foundation has announced the beneficiaries of funds raised through Run Medford, a brand new weekend-long celebration of community, running, and the City of Medford produced by DMSE Sports and hosted by the foundation. The event highlights founder and race director Dave McGillivray’s...

Giving

Press Releases

Running