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

August 22, 2024

Double race weekend for GFNY in Europe

/ENDURANCE SPORTSWIRE/ – GFNY Sweden Uppsala The second edition of GFNY Uppsala offers racers a 133.5 km long course with 494m of climbing. Uppsala is less than an hour from Stockholm. The course will take riders along rolling hills of the Uppsala countryside. There will also be hard packed unpaved...

Cycling

Events

Press Releases

August 22, 2024

2024 XTERRA Costa Rica Preview: Lining Up at Las Catalinas

LAS CATALINAS, COSTA RICA /ENDURANCE SPORTSWIRE/ - Marking its return as the 18th stop on the 2024 XTERRA Americas Tour, XTERRA Costa Rica introduces a fresh team, course, and venue for an off-road racing weekend on August 24-25. Set in the holiday town of Las Catalinas, the Full Distance Triathlon...

Cycling

Events

Press Releases

Running

Triathlon

August 21, 2024

Challenge Samarkand Returns with World-Class Triathletes

/ENDURANCE SPORTSWIRE/ – Norwegian athletes Gustav Iden and Kristian Blummenfelt lead the men's field lineup. Iden, winner of The Championship 2023 and Hawaii champion 2022, is on a comeback and recently won Challenge Turku. Blummenfelt, the 2022 middle-distance world champion, comes fresh from competing in the Olympic Games. They are...

Events

Press Releases

Triathlon

August 21, 2024

More Than 20,000 Runners Confirmed For Inaugural Diplo’s Run Club Events In San Francisco And Seattle

August 20, 2024 /ENDURANCE SPORTSWIRE/ - More than 20,000 runners are registered for the first two installments of Diplo’s Run Club, Diplo’s new event series of 5K runs followed by an outdoor daytime concert. Blending two integral parts of Diplo’s life—fitness and music—the inaugural runs, slated for September 8 in...

Events

Press Releases

Running

August 20, 2024

IRONMAN World Champion Michellie Jones Joins Roster of IRONMAN U Master Coaches

TAMPA, Fla. (August 20, 2024) /ENDURANCE SPORTSWIRE/ - IRONMAN, together with TriDot, has announced that IRONMAN Hall of Famer Michellie Jones, an Olympic medalist and the first Australian woman to win the IRONMAN World Championship, has joined the IRONMAN U team as a Master Coach. IRONMAN U Master Coaches serve...

Events

Press Releases

Triathlon

August 20, 2024

IRONMAN Pro Series Start Lists Announced For IRONMAN 70.3 Zell Am See-Kaprun

- IRONMAN 70.3 Zell am See-Kaprun triathlon in Salzburg, Austria, offers a maximum of 2,500 points towards the IRONMAN Pro Series Standings and a total event pro prize purse of $50,000 - Defending champion Daniela Bleymehl (DEU) returns to the start line in the women’s race hoping to improve on...

Cycling

Events

Press Releases

Running

Triathlon

August 20, 2024

Challenge Sandefjord Set to Debut with Top International Athletes

/ENDURANCE SPORTSWIRE/ – The inaugural Challenge Sandefjord is set to take place this weekend. It will bring together a field of professional athletes, including local favourites and renowned international athletes. In the men's professional field, all eyes will be on Casper Stornes (NOR), a local favorite with an impressive short-course...

Events

Press Releases

Triathlon

August 20, 2024

Verge Launches “Red is Racing” Contest to Celebrate the Vuelta a España

NEW YORK, AUGUST 20, 2024 /ENDURANCE SPORTSWIRE/ – As the Vuelta a España kicks off, Verge is excited to support our sponsored team, Intermarché-Wanty, in the third and final Grand Tour of the year. To celebrate this prestigious event, Verge is launching the "Red is Racing" contest, offering fans a...

Cycling

Events

Press Releases

August 20, 2024

Crowd Energy Carries Athletes to Victory at the 52nd ASICS Falmouth Road Race

FALMOUTH, Mass. /ENDURANCE SPORTSWIRE/ - Under cloudy skies and at times a light drizzle, noteworthy and historic performances unfolded in front of this year’s more than 11,000 runners at the 52nd running of the ASICS Falmouth Road Race. Of the four professional races, two saw dominant performances from rising stars...

Events

Press Releases

Running