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

September 10, 2025

Zoot Sports Unveils the Ultra Tri P1x — Zoot’s Fastest Triathlon Racesuit Ever

Carlsbad, CA (September 10, 2025) /ENDURANCE SPORTSWIRE/ – Zoot Sports, the original triathlon brand born in Kona, Hawaii in 1983, proudly announces the launch of the Ultra Tri P1x, its most advanced race suit to date. Engineered through wind tunnel validation, race-course testing, and pro athlete feedback, the P1x redefines...

Press Releases

Products

Triathlon

September 10, 2025

Big Pumpkin Run 2025 Debuts “Five in One” Interactive Race Shirt

ORANGE, Texas (September 10, 2025) /ENDURANCE SPORTSWIRE/ — The Big Pumpkin Run, produced annually in Orange, Texas, will once again feature a standout piece of race-day apparel in 2025: the “Five in One” Magic Shirt. This marks the second collaboration between the event and X T-shirt, bringing runners a shirt...

Events

Press Releases

Products

Running

Sponsorship

September 9, 2025

CarMax Richmond Half Marathon Sells Out Ahead of November Race Day

RICHMOND, VA (September 9, 2025) /ENDURANCE SPORTSWIRE/ – The CarMax Richmond Half Marathon has reached its 10,000-participant capacity, officially selling out nearly 10 weeks before runners hit the streets on Saturday, November 15. Now in its 48th running, the Allianz Richmond Marathon remains the cornerstone of Richmond’s fall tradition, joined...

Events

Press Releases

Running

September 9, 2025

World’s Top Male Triathletes Return to the French Riviera for the 2025 IRONMAN World Championship Triathlon

NICE, France / TAMPA, Fla. (September 9, 2025) /ENDURANCE SPORTSWIRE/ – Top male triathletes from around the world are set to take center stage on the Côte d’Azur on Sunday, September 14 for the 2025 IRONMAN® World Championship® triathlon in Nice, France. More than 2,500 registered age-group and professional athletes...

Events

Press Releases

Triathlon

September 9, 2025

European Championship Titles on the Line at Challenge Almere-Amsterdam

September 9, 2025 /ENDURANCE SPORTSWIRE/ - This weekend, the spotlight is on Challenge Almere-Amsterdam, which hosts the European Championship Long Distance. With 50 professional athletes on the start line, Europe’s oldest long-distance triathlon promises an unforgettable race. Among the men, Britain’s Will Draper (GBR), who comes into Almere in strong...

Events

Press Releases

Triathlon

September 9, 2025

Ford Joins Spartan As Presenting Partner Of The New England Series

BOSTON, MA (SEPTEMBER 9, 2025) /ENDURANCE SPORTSWIRE/ - Spartan, the world’s leading endurance brand, has announced the return of its partnership with Ford, making the iconic automaker the Official and Exclusive Auto Partner of the Spartan New England Series. The deal will see Ford step up as Presenting Partner of the...

Press Releases

Sponsorship

September 9, 2025

TransRockies Run Returns with New 3-Day Stage Race Format: TransRockies Run, Pass to Pub. Registration Now Open on UltraSignup

Colorado (September 9, 2025) /ENDURANCE SPORTSWIRE/ — After 18 years as one of North America’s premier stage races, the legendary TransRockies Run is back with a fresh new format. The reimagined TransRockies Run Pass to Pub will debut July 19–21, 2026, showcasing the very best sections of the original six-day...

Events

Press Releases

Running

September 9, 2025

rabbit Launches The Chase, 2028 OTQ support program

Santa Barbara, CA (September 9, 2025) /ENDURANCE SPORTSWIRE/ — rabbit, the California-based running apparel brand, is proud to announce the launch of The Chase, its new OTQ (Olympic Trials Qualifier) program. The Chase program will offer various forms of support to 10 athletes along their journey to OTQ. “The Chase...

Press Releases

Running

Sponsorship