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

September 9, 2022

Defiant Hauser Has a Point to Prove as Super League Triathlon Returns to Munich

/ENDURANCE SPORTSWIRE/ – Defiant Matt Hauser insists his recovery from an incorrect penalty proves he is a genuine title contender as Super League Triathlon returns to Munich, Germany, this weekend. The Australian was second out of the water of the Stage 1 swim in the Championship Series opener in London, but...

Events

Press Releases

Triathlon

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