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

September 8, 2022

Olympic Triathlete Greg Billington to Guide Blind Paralympian Kyle Coon at Philadelphia Distance Run

Philadelphia, Pa. (Sept. 8, 2022)/ENDURANCE SPORTSWIRE/ – Elite-level talent will combine forces on the streets of Philadelphia for the Philadelphia Distance Run (PDR) on Sept. 18. 2016 Olympian and 2020 Paralympic gold medalist Greg Billington (Spokane, Wash.) will serve as a guide runner for 2020 Paralympian Kyle Coon (Carbondale, Colo.) during the half...

Events

Press Releases

Running

Triathlon

September 8, 2022

Olympic Legend Michael Johnson To Be Special Guest At Triathlon’s First-Ever PTO US Open In His Hometown Of Dallas

Thursday 8 September; Dallas, Texas/ENDURANCE SPORTSWIRE/ –Former Olympic sprint sensation turned respected TV commentator Michael Johnson will be a special guest of the Professional Triathletes Organisation at the first-ever PTO US Open (September 17-18) in his hometown of Dallas later this month. The four-time Olympic gold medal winner, who was born in...

Events

Press Releases

Triathlon

September 8, 2022

La Vuelta’s Virtual and Real Grand Final in Madrid – Ride along with the Champions from home!

Madrid, Spain / September 8th, 2022 /ENDURANCE SPORTSWIRE/ – ROUVY is the most realistic cycling simulator which requires real cycling effort and takes the ‘home cycling’ experience to the next level. La Vuelta Virtual 2022 is a special series of events organized by ROUVY in which anyone can compete alongside the pros...

Cycling

Events

Press Releases

September 7, 2022

IRONMAN Announces 2023 Global TriClub Championship Series Schedule

- 2023 IRONMAN TriClub Championship Series will include ten events across the Americas, Europe, Middle East, Africa, and Oceania regions  - Local clubs and community help craft unique experiences at each TriClub Championship event, which also feature exclusive athlete benefits  TAMPA, Fla. /ENDURANCE SPORTSWIRE/ IRONMAN today announced its 2023 global...

Events

Press Releases

September 7, 2022

Olympic Champion Duffy Highlights Unique Opportunity for Amateurs To ‘Race and Watch’ At The PTO US Open

Weds 7 September, London /ENDURANCE SPORTSWIRE/ -  The Professional Triathletes Organisation has announced a second group of professional triathletes who will compete in the women’s and men’s races at the inaugural $1 million PTO US Open (17-18 September), including Olympic Champion Flora Duffy. But whilst Bermuda’s finest will go head-to-head against...

Events

Press Releases

Triathlon

September 7, 2022

Close Battles Expected at Challenge Almere-Amsterdam:

/ENDURANCE SPORTSWIRE/ - Will it be Thomas Steger (AUT), Lukasz Wojt (GER), Kieran Lindars (GBR) or Tomas Renc (CZE) who returns home with the European Triathlon Long Distance title after Challenge Almere-Amsterdam this Saturday? Eyes are also on a number of Dutch favourites, including Evert Scheltinga, Milan Brons, Tristan Olij,...

Events

Press Releases

Triathlon

September 6, 2022

A Family Affair at She Tris

Charleston, SC (September 6, 2022) /ENDURANCE SPORTSWIRE/ - If you’re local to the Charleston, SC area, you’ve probably heard or read about the all-women short distance triathlon events called She Tris Sprint Triathlon. Started by Angela Klick of Mt. Pleasant, the event series is designed to welcome women to a...

Events

Press Releases

Triathlon

September 6, 2022

Cycling Enthusiasts from Around The World Able to Experience 2022 Wollongong UCI Road World Championships Courses through FulGaz

WOLLONGONG, Australia/TAMPA, Fla. (September 6, 2022) /ENDURANCE SPORTSWIRE/ – FulGaz®, The IRONMAN Group’s cutting-edge indoor virtual cycling app, announced today that it would be partnering with Wollongong 2022 for the upcoming 2022 UCI Road World Championships, bringing the excitement of the event into homes around the world. The 2022 UCI Road...

Cycling

Events

Press Releases

September 6, 2022

Specialized Supports The Cactus Cup For Iconic Mountain Bike Racing In 2023

/ENDURANCE SPORTSWIRE/ – Mountain bike racing returns to Arizona’s singletrack for a weekend of high-intensity racing and family fun at the 2023 Cactus Cup, March 10 through 12. Specialized Bicycles was the title sponsor of this iconic event throughout the 1990s and a supporter since its rebirth in 2017. Now, the...

Cycling

Events

Press Releases

Sponsorship