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

November 19, 2021

GFNY announces GFNY Villard de Lans (France)

/ENDURANCE SPORTSWIRE/ - Villard de Lans is the latest addition to the GFNY Global Endurance Sports Series, making it the fifth GFNY cycling race in France in 2022.  Scheduled for May 29, 2022, riders will get to experience a race that is equally hard as it is beautiful. Host town...

Cycling

Events

Press Releases

November 18, 2021

USA Triathlon Announces 2022 National Championships Calendar

COLORADO SPRINGS, Colo. /ENDURANCE SPORTSWIRE/ - USA Triathlon today unveiled the dates and locations for its 2022 National Championships, a robust calendar of triathlon and multisport events across the United States. At USA Triathlon National Championships, athletes will have the opportunity to compete against the top multisport athletes in the country,...

Events

Press Releases

Triathlon

November 18, 2021

NYCRUNS Announces Official Charity Partner Program for 2022 Brooklyn Marathon & Half Marathon

Brooklyn, NY November 18, 2021/ENDURANCE SPORTSWIRE/ - NYCRUNS, one of the fastest growing consumer health and wellness businesses and the organizer of the 2022 NYCRUNS Brooklyn Marathon & Half Marathon, today announced the Official Charity Partner Program. The 2022 NYCRUNS Brooklyn Marathon & Half Marathon, which will be the largest...

Events

Press Releases

Running

November 18, 2021

‘The Digital Swiss 5’ kicks off tomorrow – The Start List and Where to Watch

Zurich, Switzerland / November 18, 2021 /ENDURANCE SPORTSWIRE/  PRO RACE FORMAT Athletes will compete in five digital races of about one hour each (the first four being lapped races) in Swiss cities. Each team is named by  the respective host cities of Lucerne, Lugano, Lausanne, Basel and Zurich. With a...

Cycling

Events

Press Releases

Triathlon

November 18, 2021

Life Time Foundation Announces Commitment to Youth Movement with new “Get Kids Moving!” National Initiative

CHANHASSEN, Minn., Nov. 18, 2021 /ENDURANCE SPORTSWIRE/ - Life Time Foundation, the 501(c)(3) nonprofit charitable arm of Life Time (NYSE: LTH) today announced a massive commitment to improving children’s health with the launch of Get Kids Moving! The new youth movement focus will fund initiatives of schools and community organizations nationwide...

Events

Giving

Press Releases

November 18, 2021

Bearclaw Bicycle Co. Named ‘Ultra Series’ Sponsor for 2022 Michigan Gravel Race Series

/ENDURANCE SPORTSWIRE/ -As part of the upcoming 2022 Michigan Gravel Race Series (MGRS), Bearclaw Bicycle Co. has renewed its sponsorship for the second year running as the official Ultra Series sponsor. The Bearclaw Bicycle Co. Ultra Series includes seven 100+ mile gravel bike races among the 15 events within the...

Cycling

Events

Press Releases

Sponsorship

November 17, 2021

ELITE & Zwift Partner up for Midweek Mountain Massif TT

FONTANIVA, ITALY, November 17th, 2021 /ENDURANCE SPORTSWIRE/ - Elite Cycling and Zwift Insider are teaming up for two Thanksgiving Eve throw-downs in the mountains and you're invited. Midweek Mountain Massif TT What do you get if you cross a mountain race and a time trial? An absolutely intense, but highly...

Cycling

Events

Press Releases

November 16, 2021

World’s Toughest Mudder Record Shattered in Laughlin, Nev.

BOSTON, Mass. /ENDURANCE SPORTSWIRE/ - Tough Mudder, the global leader in obstacle course adventures, announced the results of its World’s Toughest Mudder event in Laughlin Nev., including a new World’s Toughest Mudder record of 115 miles set by first place men’s podium finisher Mark Batres. The tenth running of the...

Events

Press Releases

Running