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 (16)
) 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 950, 10

May 15, 2024

Showdown in Alabama: XTERRA World Cup Intensifies the NA Champs at Oak Mountain

Key Points World Cup Stop #3 debuts the 2024 XTERRA North American Championship, featuring Full Distance and Short Track races. Elite athletes will vie for 175 total series points, with livestreaming of the Short Track race at 10:00 am EST on Sunday. Forissier brothers set to battle Serrières and Lagerstrom...

Cycling

Events

Press Releases

Running

Triathlon

May 15, 2024

The world’s most exciting track meet, Night of the 10,000m PB’s, is back!

London, UK /ENDURANCE SPORTSWIRE/ –  Building on the success of previous years, Swiss performance sportswear brand On has once again teamed up with the renowned running event Night of the 10,000m PB’s. The collaboration is part of the brand’s global On Track Nights series, bringing festival energy, fast times and...

Events

Press Releases

Running

May 15, 2024

Inaugural Gran Premio New York City and 12th Michelob Ultra GFNY World Championship New York City this Sunday

NEW YORK CITY, May 15, 2024 /ENDURANCE SPORTSWIRE/ - The 12th Michelob Ultra GFNY World Championship NYC represents the pinnacle of GFNY Global Endurance Sports Series and its 30+ races in 2024. This year, the Gran Premio New York City UCI professional race will be held on the same course,...

Cycling

Events

Press Releases

May 15, 2024

LA Tri-Series Announces Incorporation of IronBruin Collegiate Division into Fall Classic Event

LOS ANGELES, Calif. /ENDURANCE SPORTSWIRE/ – The LA Tri-Series is in the midst of its 42nd consecutive event, and has recently announced the addition of the IronBruin Collegiate Division into its Fall Classic event, taking place on Oct. 6. The Fall Classic is the second of three events that make...

Events

Press Releases

Triathlon

May 14, 2024

La Jolla Half Marathon Partners with HydraPak® and WaterMonster to Go Waste Free, Ditches Disposable Cups

OAKLAND, Calif. (May 14, 2024)/ENDURANCE SPORTSWIRE/ – In partnership with HydraPak®, global leader of high-performance hydration solutions, and water delivery services provider, WaterMonster, the La Jolla Half Marathon and 5K is excited to announce that it will remove disposable cups and transition to HydraPak's reusable SpeedCup at this year's race. The...

Events

Press Releases

Sponsorship

May 14, 2024

Empowering the Next Generation: Introducing the XTERRA Youth Tour

/ENDURANCE SPORTSWIRE/ – In 2024, XTERRA launched its inaugural Youth Tour designed to develop the next wave of world-class off-road triathletes. With over 40 events worldwide, the XTERRA Youth Tour connects young athletes to the world of cross-triathlon, offering a structured competitive path for anyone curious about the sport and...

Cycling

Events

Press Releases

Running

Triathlon

May 14, 2024

Chambers and Samosir win GFNY Kuala Lumpur

New York City, May 14, 2024 /ENDURANCE SPORTSWIRE/ – Kuala Lumpur hosted the second edition of the GFNY Kuala Lumpur this past Sunday. Riders from over 25 countries tackled the long racecourse of 129.1 km with 1726m of climbing. Malaysia’s Minister of Youth & Sports Malaysia Hannah Yeoh together with...

Cycling

Events

Press Releases