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

November 11, 2024

Challenge Family World Bonus Top Placings Decided at Challenge Xiamen

November 11th. /ENDURANCE SPORTSWIRE/ - After a thrilling day’s racing at yesterday’s Challenge Xiamen, it’s all change in the Challenge Family World Bonus, with Jack Moody (NZL) and Alanis Siffert (SUI) now confirmed as unbeatable for 2024. While the winning titles of the inaugural Challenge Xiamen were being contended, there...

Events

Press Releases

Triathlon

November 11, 2024

FasCat now Connects Directly to Zwift

BOULDER, CO, NOV. 11, 2024 /ENDURANCE SPORTSWIRE/ - Cyclists who use the CoachCat app for training can now send workouts directly to Zwift, the #1 cycling app. Similarly, rides, races and workouts completed on Zwift will sync directly to CoachCat for analysis and coaching. CoachCat is the first hardware-agnostic AI...

Business

Cycling

Press Releases

Products

November 10, 2024

More than 6,700 athletes take part in the 2024 Boston Half presented by Dana-Farber Cancer Institute and the Jimmy Fund

BOSTON /ENDURANCE SPORTSWIRE/ - The 2024 Boston Half presented by Dana-Farber Cancer Institute and the Jimmy Fund took place today under beautiful blue skies, starting and finishing within Boston’s Franklin Park. A total of 6,767 athletes started today’s race, with preliminary results for all finishers available here. It was an...

Events

Press Releases

Running

November 10, 2024

Memorable Wins for Stojanović and Siffert at Inaugural Challenge Xiamen

/ENDURANCE SPORTSWIRE/ - In his seventh Challenge Family race of the season, Ognjen Stojanović (SRB) took that elusive first Challenge win today at Challenge Xiamen in 3:41:02 and confirmed his second position in the Challenge Family World Bonus. And it was a faultless performance from Alanis Siffert (SUI) who dominated...

Events

Press Releases

Triathlon

November 8, 2024

Sumarpo Brings Sustainable Triathlon Gear to ISPO Munich 2024

Sumarpo Brings Sustainable Triathlon Gear to ISPO Munich 2024 November 8th. /ENDURANCE SPORTSWIRE/ - Sumarpo is excited to announce its participation at ISPO Munich 2024, from December 3-5, where it will unveil a new line of triathlon gear crafted with a 100% eco-friendly approach. As a trailblazer in sustainable water...

Business

Press Releases

Trade Shows

November 8, 2024

Frias, TenKate Win Santa Barbara Half Marathon presented by HOKA

SANTA BARBARA, Calif. November 8th /ENDURANCE SPORTSWIRE/ – On a spectacular sunny Sunday morning, November 3, Chris Frias, 33, of Ventura and Melissa TenKate, 35, of Arroyo Grande won the fourth Santa Barbara Half Marathon presented by HOKA, clocking 1 hour, 8 minutes, 33 seconds and 1:22:05, respectively. For Frias,...

Events

Press Releases

Running

November 7, 2024

Shop Women-Led Wednesday To Support Women In Business This Spending Season

Sun Valley, ID (Nov. 7, 2024) /ENDURANCE SPORTSWIRE/ - Women-Led Wednesday, the annual purpose-driven holiday that urges the public to shop women-led businesses, returns for the seventh year, calling on consumers to be mindful of their purchasing power leading up to popular eCommerce holidays like Black Friday and Cyber Monday....

Business

Events

Press Releases

Products

November 7, 2024

Life Time Announces Star-Studded Roster For 2025 Life Time Grand Prix

Chanhassen, Minn., (Thursday, November 7th) /ENDURANCE SPORTSWIRE/ -  Life Time, (NYSE: LTH), the nation’s premier healthy lifestyle brand and athletic event producer, has unveiled the men’s and women’s rosters for the 2025 Life Time Grand Prix. Returning for the fourth year, the Life Time Grand Prix is the premier elite...

Cycling

Events

Press Releases

November 7, 2024

Challenged Athletes Foundation’s Community Weekend Fueled by Toyota Raises Over $2.3m Through Spectacular Line-Up of Inclusive Events to Empower Individuals with Physical Disabilities

SAN DIEGO, CA /ENDURANCE SPORTSWIRE/ - The Challenged Athletes Foundation (CAF) successfully concluded its annual CAF Community Weekend fueled by Toyota, raising an impressive $2.3 million to support athletes with physical disabilities. Held in Mission Bay, San Diego, the weekend offered a packed schedule of inclusive events, including the San...

Events

Giving

Press Releases