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

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

September 4, 2022

St. Jude Rock ‘n’ Roll Running Series Washington Welcomes Back Over 9,000 Registered Participants to The Pacific Northwest for The Ultimate Foot Tour of Bellevue

BELLEVUE, Wash. (September 4, 2022) /ENDURANCE SPORTSWIRE/ – The Rock ‘n’ Roll Running Series made its return to the Pacific Northwest for the first time since 2019 as the St. Jude Rock ‘n’ Roll® Running Series Washington took to the streets of Bellevue this weekend. Known for Bringing the Fun to...

Events

Press Releases

Running

September 1, 2022

Sea to Summit Triathlon moves to Kennebunkport, Maine

/ENDURANCE SPORTSWIRE/ – Maine’s coastal villages of Kennebunkport and Kennebunk will host the swim segment as well as the start of the bike leg for 2023’s Sea to Summit Adventure Triathlon. The announcement was made by the race organizer, New England Endurance Events. For the past decade the point-to-point race has...

Events

Press Releases

Triathlon