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

May 6, 2024

Registration for the 2025 Ascension Seton Austin Marathon Officially Opens May 13, 2024

AUSTIN, Texas, May 6, 2024 /ENDURANCE SPORTSWIRE/ – Registration for the 2025 Ascension Seton Austin Marathon, Half Marathon & 5k ® officially opens Tuesday, May 13th. To mark the opening, there will be a week-long celebration that includes giveaways, promotions, group runs, and social gatherings. In addition, for each registration...

Events

Press Releases

Running

May 5, 2024

Sam Long (USA) Repeats While Paula Findlay (CAN) Tops the Field at the 2024 Intermountain Health IRONMAN 70.3 North American Championship St. George Triathlon

ST. GEORGE, Utah /ENDURANCE SPORTSWIRE/ - Stunning St. George and Southwestern Utah played host to the 2024 Intermountain Health IRONMAN® 70.3® North American Championship St. George triathlon today, doubling as the third race of the IRONMAN Pro Series™. The race saw Sam Long (USA) repeat as a winner in St...

Events

Press Releases

Triathlon

May 3, 2024

Mongoose Launches National Partnership with DICK’S Sporting Goods

Madison, Wis. (May 2, 2024)/ENDURANCE SPORTSWIRE/ – Mongoose, the pioneering off-road bike brand founded in 1974, today announces a new partnership with DICK’S Sporting Goods (NYSE: DKS) to offer Mongoose bikes in over 650 storefronts nationwide as well as online at dicks.com. Available now, the assortment includes a complete range of mountain,...

Business

Cycling

Press Releases

May 3, 2024

Tomas Rodriguez Runs Away with April PTO Athlete of The Month

London, UK/ENDURANCE SPORTSWIRE/ – Tomas Rodriguez’s incredible performance at Ironman Texas has also landed him the top step for April’s PTO Athlete of the Month, in a month full of stand-out performances. The spring-heeled Mexican obliterated the run course record in The Woodlands, with his split of 2:34:14 was the fastest...

Awards

Events

Press Releases

Triathlon

May 3, 2024

Vittoria Unleashes Mostro: The Ultimate Tire for Gravity Mountain Bikers

BENTONVILLE (AR), 05/03/2024 /ENDURANCE SPORTSWIRE/ – Vittoria announces the arrival of Mostro, the newest addition to its renowned lineup of trail dominators. Born from a year of relentless product development and rigorous testing alongside the Commençal ICStudio downhill pro team and the Abetone Ancillotti Vittoria enduro pro team, Mostro emerges...

Cycling

Press Releases

Products

May 3, 2024

The Adventure Continues! Secure Your Spot for the Epic TCC 2025!

Costa Rica, May 2, 2024 /ENDURANCE SPORTSWIRE/ - The Coastal Challenge (TCC) Costa Rica, the premier endurance race that has captivated adventurers from around the globe, is excited to announce that registrations for its monumental 21st edition, set to take place in 2025, are officially open. This announcement comes on...

Events

Press Releases

Running

May 3, 2024

DATEV Challenge Roth and Condor take off together

ROTH / FRANKFURT. /ENDURANCE SPORTSWIRE/ - Stripes meet endurance sport - Condor, the German airline based in Frankfurt, is the new transport partner at the world's biggest long-distance triathlon. All triathletes as well as the volunteers in Roth can benefit directly from the new partnership. ‘With DATEV Challenge Roth, we...

Press Releases

Sponsorship

Triathlon

May 3, 2024

Lilac Bloomsday Run 12K Hosts 27th PRRO Championship

SPOKANE, WA /ENDURANCE SPORTSWIRE/ – The 27th PRRO Championship presented by the Lilac Bloomsday Run 12K will be contested on Sunday morning, May 5, and at the 48th race edition, a top international field will be vying for the $81,000 in prize money, including $20,000 U.S. prize money and $7000...

Events

Press Releases

Running

May 2, 2024

Two Decades of Dedication: Legends Celebrate 20th Year of HOAG OC Marathon

Orange County, California – May 2, 2024 /ENDURANCE SPORTSWIRE/ – This Sunday marks a special milestone for the Hoag OC Marathon Running Festival as 25 legacy runners, known as "marathon legends," prepare to participate for the 20th consecutive year. Among them are individuals whose lives are as varied as their...

Events

Press Releases

Running

May 2, 2024

Verge Cycling Apparel Announces Intermarché-Wanty “They Win! You Win!” Contest: Win a Limited Edition Team Kit

NEW YORK/ENDURANCE SPORTSWIRE/ – Verge, the proud custom kit supplier for UCI World Tour Team Intermarché-Wanty, is thrilled to announce the launch of the "They Win. You Win!" Contest, offering loyal fans an exclusive opportunity to win the limited-edition, one-off design worn by Intermarché-Wanty riders in the upcoming Giro d’Italia,...

Cycling

Events

Press Releases

Products