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

March 23, 2022

Champions Return For Fast And Furious Head-to-Head Battles in Arena Games Triathlon powered by Zwift

/ENDURANCE SPORTSWIRE/ - Four former champions and an Olympic gold medallist are among the first wave of athletes confirmed for the Arena Games Triathlon powered by Zwift. There are two monumental clashes in the offing as Jess Learmonth, the first ever Arena Games winner, and fellow Brit Beth Potter, who took...

Events

Press Releases

Triathlon

March 23, 2022

Limited additional capacity released for Europe’s most popular IRONMAN® and IRONMAN® 70.3® triathlons

LONDON, UK /ENDURANCE SPORTSWIRE/ - The IRONMAN Group has today announced a limited release of additional race entries for 11 of the public’s favourite European races. Including the likes of Mainova IRONMAN European Championship Frankfurt, which has been the arena for some of the most memorable elite triathlon racing of the past...

Events

Press Releases

Triathlon

March 22, 2022

GFNY Super Sunday at the beaches

/ENDURANCE SPORTSWIRE/ - GFNY Punta del Este At the GFNY South American Championship Punta del Este in Uruguay, the 172km race with 1700m of climbing came down to sprint finishes both in the women’s and men's race. Brazilian National TT Champion Tamire Radatz edged out US elite racer Jill Patterson...

Cycling

Events

Press Releases

March 22, 2022

FloSports to Exclusively Stream Inaugural Life Time Grand Prix Series Kicking Off April 9

AUSTIN, Texas (March 22, 2021) /ENDURANCE SPORTSWIRE/ - FloSports, a leading sports streaming service, today announced an official broadcasting partnership with Life Time, the nation’s premier healthy lifestyle brand (NYSE: LTH), for the Company’s inaugural Life Time Grand Prix Series. The new event series—comprised of 60 elite cyclists from around the world...

Cycling

Events

Press Releases

Sponsorship

March 22, 2022

Ready to Run?

YAKIMA, WA. /ENDURANCE SPORTSWIRE/ - Make the Downtown Yakima Mile part of your Fourth of July weekend festivities! This year’s race will be held on Saturday, July 2, and will feature heats for kids, families, veterans, elite runners, and more. Walkers and dogs are welcome too! The Downtown Yakima Mile...

Events

Giving

Press Releases

Running

March 22, 2022

Ride Santa Barbara 100 Kicks Off Registration with 72-Hour Special Pricing and Announces 2022 Charity Partner

SANTA BARBARA, Calif. /ENDURANCE SPORTSWIRE/ - Ride Santa Barbara 100 (RideSB100), the premier cycling event on California’s Central Coast, today opened registration and announced plans to partner with the newly merged SB BIKE + COAST to support the local cycling community and help create healthy Santa Barbara communities. Taking place...

Cycling

Events

Giving

Press Releases