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

January 25, 2024

Explore Orange County While Pedaling For a Cause at Tour de Saddleback

IRVINE, Calif. /ENDURANCE SPORTSWIRE/ – The Tour de Saddleback returns for its annual event and will be offering 50, 35 and 15-mile ride options through scenic parts of Orange County. Participants have the opportunity to ride through seven different communities and cities, including Laguna Hills, Santiago Canyon, Rancho Santa Margarita and...

Cycling

Events

Giving

Press Releases

January 25, 2024

Zoot Sports Signs World Champion Triathlete, Holly Lawrence

Carlsbad, California /ENDURANCE SPORTSWIRE/ – Zoot Sports, the global leader in triathlon apparel, is thrilled to announce the signing of elite professional triathlete Holly Lawrence in a multi-year sponsorship. Lawrence is a World Champion long-course triathlete, with a major victory at the IRONMAN 70.3 World Championships in 2016. As part of...

Press Releases

Sponsorship

Triathlon

January 25, 2024

RunSignup Releases Beta of Next Gen Membership Product

Moorestown, NJ - January 25, 2024 /ENDURANCE SPORTSWIRE/ – RunSignup, the leading registration and technology provider for races in the U.S, has released the beta version of their next generation Membership system to select customers. Memberships builds on the popular Clubs offering used by hundreds of running, cycling and triathlon clubs...

Business

Press Releases

Products

Running

Triathlon

January 25, 2024

The GFNY 2024 race calendar comes with a world premiere

NEW YORK CITY, January 25, 2024 /ENDURANCE SPORTSWIRE/ - GFNY, the Global Endurance Sports Series, announces its 2024 calendar which includes the inaugural Gran Premio New York City UCI pro race on May 19, the 12th annual edition of the Michelob ULTRA GFNY World Championship NYC on the same day...

Cycling

Events

Press Releases

January 25, 2024

Almost Heaven Adventure Race Unveils Transition from Adventure Enablers to Adventure Source

Davis, West Virginia /ENDURANCE SPORTSWIRE/ – Almost Heaven Adventure Race is thrilled to announce its transition to a new management company – moving from Adventure Enablers to Adventure Source Racing. This strategic change represents an exciting new chapter in the history of the race, promising a future filled with innovation, excitement,...

Business

Events

Press Releases

January 24, 2024

Chilly GOAT Cold Tubs and CrossFit athlete Justin Medeiros announce partnership

FORT WAYNE, Ind. — January 25, 2024 /ENDURANCE SPORTSWIRE/ - Master Spas, a leading manufacturer of hot tubs, cold tubs, and swim spas, is proud to announce its partnership with CrossFit athlete Justin Medeiros. This collaboration will allow Medeiros to incorporate the innovative Valaris contrast therapy system by Michael Phelps...

Press Releases

Sponsorship

January 24, 2024

2024 PTO Tour Heads To Fabulous Lake Las Vegas

London, UK /ENDURANCE SPORTSWIRE/ - The Professional Triathletes Organisation (PTO) has announced the 2024 PTO Tour will be going to Lake Las Vegas in Henderson, Nevada, with the creation of the inaugural PTO Lake Las Vegas Open on 19-20 October, 2024. Taking place around the picturesque Lake Las Vegas on the...

Business

Events

Press Releases

Triathlon

January 24, 2024

Marbella, Spain selected as Host for The 2025 VinFast IRONMAN 70.3 World Championship Triathlon

- The IRONMAN 70.3 World Championship triathlon’s global rotation format awards Spain host venue location for first time - Two-day world championship anticipated to welcome over 6,000 athletes from around the world MARBELLA, Spain / TAMPA, Fla. / LONDON, UK (January 24, 2024) /ENDURANCE SPORTSWIRE/ – IRONMAN announced today that Marbella,...

Events

Press Releases

Triathlon

January 24, 2024

Quality Combines in Partnership Between Challenge Family and Cádomotus

/ENDURANCE SPORTSWIRE/ – "Being a relatively new brand in the triathlon world, Cádomotus brings a rich legacy and innovation from the speedskating sport to triathlon. Our background in speed skating has given us unique insights into designing high-quality products tailored for triathletes,” said Diederik Hol, owner of Cádomotus. “Take, for...

Press Releases

Sponsorship

Triathlon