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

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

January 24, 2024

A UK team is racing at GP New York City

NEW YORK CITY, January 24, 2024 /ENDURANCE SPORTSWIRE/ - The inaugural UCI 1.2 men elite pro race Gran Premio New York City will be held on May 19, 2024 on the same course and same day as the 12th annual mass participation race Michelob ULTRA GFNY World Championship NYC. The...

Cycling

Events

Press Releases

January 24, 2024

BibRave and CAMA Bag Team Up to Redefine Brand Presence in Endurance Events

Chicago, IL /ENDURANCE SPORTSWIRE/ –BibRave, the leading-edge endurance and fitness marketing agency, partnered in 2023 with CAMA, the brand known for its elite odor-absorbing, moisture-wicking bag constructed with athletes and fitness enthusiasts in mind, to elevate brand integrations and partnerships at endurance events in ways that go outside of the booth....

Business

Press Releases

Products

Running