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

March 22, 2023

Reyes and Otero win GFNY República Dominicana

New York City, March 22, 2023 /ENDURANCE SPORTSWIRE/ – Punta Cana hosted the third edition of GFNY República Dominicana this past Sunday. The long challenging racecourse was 149.7 km with an elevation gain of 962 m Under perfect weather conditions, the race started off fast with over 500 racers at BlueMall...

Cycling

Events

Press Releases

March 22, 2023

Ironman World Champion British Olympic Hero to Race Arena Games Triathlon London

/ENDURANCE SPORTSWIRE/ – Ironman World Champion Gustav Iden and three-time Olympic gold medallist Jonathan Brownlee are among the star names ready to race as Arena Games Triathlon powered by Zwift prepares for its World Championship Series final in London on April 8. Norwegian star Iden, who won the coveted title in...

Events

Press Releases

Triathlon

March 22, 2023

GoFundraise Becomes Official Fundraising Provider for the San Francisco Marathon

22th March 2023 - San Francisco, CA /ENDURANCE SPORTSWIRE/ – This partnership will help to raise much-needed funds for important causes while also promoting physical fitness and healthy lifestyles. The San Francisco Marathon is one of the most iconic races in the world, drawing runners from around the globe to compete on...

Events

Giving

Press Releases

Running

March 22, 2023

Maryland Cycling Classic Extends Broadcast Partnership with GCN+

BALTIMORE, Md. /ENDURANCE SPORTSWIRE/ – The Maryland Cycling Classic, presented by UnitedHealthcare, America’s top-ranked cycling race, is extending its partnership with GCN+ for two more years, including exclusive live streaming rights internationally and non-exclusive rights in the United States. The deal also includes distribution of highlights packages on GCN+ and Global Cycling...

Cycling

Events

Press Releases

March 22, 2023

The hype is real – Anfi Challenge Mogán-Gran Canaria prepares for battle of the giants

/ENDURANCE SPORTSWIRE/ - We are counting down the days to Anfi Challenge Mogán-Gran Canaria. Not only because it is the next Challenge Family race to take place, on an island paradise and in the perfect location to experience with the whole family, but because the pro race is promising fireworks...

Events

Press Releases

Triathlon

March 22, 2023

The 2023 Adventure Racing World Series Starts in Australia and Brazil

/ENDURANCE SPORTSWIRE/ – The 2023 Adventure Racing World Series had got off to a spectacular start with two new races in Australia and Brazil in a year when race destinations also include the USA, Croatia, Canada, Colombia, Ecuador, the Faroe Islands, Paraguay, Poland, Mexico and South Africa. Australia and Brazil have...

Events

Press Releases

March 21, 2023

CCB – Alpine Carbon to Partner with Foundation Cycling for National Cycling League Series Events

BOSTON, Mass. (March 21, 2023)/ENDURANCE SPORTSWIRE/ – CCB - Alpine Carbon Elite Women’s Cycling is pleased to announce a collaboration with Foundation Cycling to participate in the new National Cycling League race series. The revolutionary new series requires women’s and men’s teams to partner together with combined scoring in a points-based format,...

Cycling

Events

Press Releases

March 21, 2023

Peoples Pace Team Will Offer More Pace Groups Than Ever Before at 2023 DICK’S Sporting Goods Pittsburgh Marathon

PITTSBURGH, PA (March 21, 2023) /ENDURANCE SPORTSWIRE/ – P3R has partnered with Peoples, an Essential Utilities company, to expand the pace team at the 2023 DICK’S Sporting Goods Pittsburgh Marathon Weekend of Events. By offering more pace groups than ever before, the Peoples Pace Team will help more MOVERS reach their...

Events

Press Releases

Running