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 (8742)
) 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 4660, 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

Injinji Launches Merino Wool Collection For Fall 2022

San Diego, Calif. (September 7, 2022)/ENDURANCE SPORTSWIRE/ – Injinji, the innovator of the patented five-toe Performance Toesock™, launches new merino wool styles in their Run, Liner and Outdoor collections for Fall 2022, allowing runners to continue towards their goals in a way that is sustainable, long-lasting, and eco-friendly. Merino wool is a...

Press Releases

Products

Running

September 7, 2022

TriDot Welcomes Michellie Jones, Olympic Silver Medalist & IRONMAN World Champion, to the TriDot Coach Community

DALLAS, TX – September 7, 2022/ENDURANCE SPORTSWIRE/ – Michellie Jones, acclaimed triathlete and coach, has joined TriDot’s growing community of coaches that also includes ESPN’s “Greatest Endurance Athlete of All Time,” Mark Allen, who adopted the TriDot platform earlier this year. “I have been competing and coaching for over 30 years, and...

Press Releases

Sponsorship

Triathlon

September 7, 2022

Lisa Foxx to Host the 2XU Malibu Triathlon

Malibu, CA – September 7, 2022 /ENDURANCE SPORTSWIRE/ – The 2XU Malibu Triathlon is excited to announce 104.3 MYfm radio personality, Lisa Foxx, as the host of its 36th annual event taking place at Zuma Beach in Malibu, CA on September 17 and 18. Lisa Foxx joins Super League Triathlon athletes...

Giving

Press Releases

Triathlon

September 7, 2022

The Running Event Announces 2022 Educational Program

PORTLAND, Maine (September 7, 2022)/ENDURANCE SPORTSWIRE/ – The Running Event (TRE), North America’s premier specialty retail conference and trade show, has announced its 2022 educational program. The Running Event will be held November 29 through December 1 in Austin, TX. “Our team has built an actionable, relevant, and impactful educational program with...

Press Releases

Running

Trade Shows

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 7, 2022

Run • Tri • Bike Announces Sponsorship of MMTC Youth Team

PHOENIX – September 2022 /ENDURANCE SPORTSWIRE/ - Endurance Sports Investment Group, LLC (“ESIG”) dba Run • Tri • Bike moves forward with a youth initiative by becoming the presenting sponsor of the Mid-Maryland Triathlon Club (“MMTC”) Youth Team for the remainder of 2023. “I received an email from Lisa Steptoe...

Press Releases

Sponsorship

September 7, 2022

KX3 Lifestyle + Coaching Guides Athletes to Reach Their Personal Gold

BOISE, ID - September 7, 2022/ENDURANCE SPORTSWIRE/ – Under the leadership of three-time Olympic gold medalist, Kristin Armstrong, KX3 Lifestyle + Coaching (KX3) introduced one-on-one cycling coaching services at the start of this year. The current KX3 coach roster includes recent Olympians, World Champions, and National Champions—all looking to help others reach...

Cycling

Press Releases

Products