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

September 21, 2023

Mark Allen Triathlon Retreats

/ENDURANCE SPORTSWIRE/ - Group Evolution and Mark Allen are pleased to announce their ‘Unlock your Potential’ training retreats for 2024, held at the stunning Chateau de la Motte Henry in the Loire, France. Mark’s retreats will run 11th-17th and 19th-23rd June and form a core part of Group Evolution’s triathlon...

Events

Press Releases

Triathlon

September 21, 2023

Billouin, Sloth Nielsen Win Final XTERRA World Cup Short Track In Trentino, Italy

/ENDURANCE SPORTSWIRE/ - Solenne Billouin (FRA) and Jens Emil Sloth Nielson (DNK) secured the win at the XTERRA Short Track Off-Road Triathlon beneath the Dolomites in Molveno on Thursday, September 21, 2023. The intense pace and lightning fast format finalised the conclusion of five XTERRA Short Track races in the...

Events

Press Releases

Triathlon

September 21, 2023

The Road to Wellness Attracts Record Attendance In Roxbury

ROXBURY (September 21, 2023) /ENDURANCE SPORTSWIRE/ – On Saturday, September 9th, The Dimock Center, HoodFit, and the Boston Athletic Association (B.A.A.) hosted the 9th Annual Road to Wellness 5K Run/2-Mile Walk. The race was once again held at The Dimock Center in Roxbury and welcomed a record number of participants. It...

Events

Press Releases

Running

September 21, 2023

IRONMAN 70.3 Maine Triathlon Extended In Augusta For An Additional Three Years

- IRONMAN and Kennebec Valley Chamber of Commerce agree to three-year host venue agreement to keep the IRONMAN 70.3 Maine triathlon in Augusta, Maine through 2027 - General registration for the 2024 IRONMAN 70.3 Maine triathlon scheduled to take place on July 28 is now open by visiting, www.ironman.com/im703-maine AUGUSTA,...

Events

Press Releases

Triathlon

September 21, 2023

Chicago State University Becomes 14th NCAA Division I School to Add Women’s Collegiate Triathlon

COLORADO SPRINGS, Colo./ENDURANCE SPORTSWIRE/ – USA Triathlon and Chicago State University today announced Chicago State University, a Predominantly Black Institution in Chicago, Illinois, will become the 14th NCAA Division I program to offer women’s triathlon at the varsity level. Chicago State begins competition in fall 2024 and will begin the search to...

Business

Press Releases

Triathlon

September 21, 2023

New NFL and NCAA Schools Join The Lineup for Second Annual Coach Knapp Stair Climb Initiative

New York, September 21, 2023/ENDURANCE SPORTSWIRE/ – The Coach Knapp Memorial Fund, named in honor of veteran NFL assistant coach Greg Knapp, today announced its expanded lineup of NFL and NCAA teams participating in this fall’s “Knapp Stair Climb.” Launched last fall, the initial project had seven NFL teams and close...

Events

Giving

Press Releases

September 21, 2023

Destination Sport Experiences announce strategic partnership with Tri Travel

21st September 2023 - UK /ENDURANCE SPORTSWIRE/ – Destination Sport Experiences promote comprehensive travel packages for runners, cyclists and triathletes, with guaranteed entry, transport, accommodation and expert team support for some of the world's most famous events around the world. In recent months the team have announced a series of acquisitions and...

Business

Events

Press Releases

Triathlon

September 21, 2023

Christie Clinic Illinois Race Weekend Participants and Distances To Be “REUNITED” at 2024 Running

CHAMPAIGN, Ill. /ENDURANCE SPORTSWIRE/ - Christie Clinic Illinois Race Weekend, Champaign-Urbana’s signature running event and one of the top 100 largest races in the United States, has officially announced its 2024 theme: “REUNITED.” Organizers say the theme was inspired by both the return of the cornerstone full marathon distance and...

Events

Press Releases

Running