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

July 9, 2024

Course Revealed for the 2024 Vinfast IRONMAN 70.3 World Championship In Taupō, New Zealand

TAUPŌ, New Zealand / TAMPA, Fla. (9 July, 2024) - With five months to go until more than 6,000 of the world’s top professional and age-group triathletes descend on Taupō, New Zealand for the 2024 VinFast IRONMAN® 70.3® World Championship triathlon, IRONMAN is excited to reveal the championship course that...

Events

Press Releases

Triathlon

July 9, 2024

Sold-Out 8-Hour Dream Endurance Race Primed for New Records at 10th Annual Race

CARMEL, Ind. (July 9, 2024) /ENDURANCE SPORTSWIRE/ - The 8-Hour Dream Endurance Race and Cat Nap 5K, the largest endurance running race in Central Indiana, returns on Saturday, July 13 with a sold-out field for the fifth consecutive year and registrants from 15 states. Event organizers CRRG Events increased event...

Events

Press Releases

Running

July 9, 2024

Perceev to Provide Event App for The Brownlee Foundation Events

Leeds, UK/Carlsbad, CA (July 9, 2024) /ENDURANCE SPORTSWIRE/ - Perceev, an innovative new software as a service platform for endurance races, is excited to announce its partnership with The Brownlee Foundation Events. TBF Events will utilize the Perceev platform to provide an engaging app experience for all participants of its...

Business

Events

Press Releases

Triathlon

July 8, 2024

Kinomap’s Multiplayer Sessions Enhance Interactive Fitness Experience

PARIS /ENDURANCE SPORTSWIRE/ – Kinomap, the leading innovative interactive fitness platform, announces the availability of new regular public multiplayer sessions, enhancing the way users engage with their workouts. This latest feature promises to bring a new level of excitement and motivation to users around the globe. Kinomap’s multiplayer sessions are...

Press Releases

Products

July 8, 2024

12th Annual Saints Kickoff Run Presented by Hancock Whitney Open for Registration

New Orleans, LA – July 8, 2024 /ENDURANCE SPORTSWIRE/ – The New Orleans Saints and Easy Day Sports announced today that online registration for the 12th Annual Saints Kickoff Run, presented by Hancock Whitney, is now open at saints5k.com. The race will take place on Saturday, September 7th, the day before...

Events

Giving

Press Releases

Running

July 8, 2024

Verge Announces Verge Racing Team’s Participation in the Junior Tour of Ireland

NEW YORK, JULY 8, 2024 /ENDURANCE SPORTSWIRE/ – Verge, the innovative leader in custom cycling apparel, is thrilled to announce that Verge Racing, based in New York City, will be competing in the prestigious Quanta Capital Junior Tour of Ireland. The 6-Day International Stage Race, renowned as one of the...

Cycling

Events

Press Releases

July 8, 2024

Embrace The Challenge: Spartan Week HIITS F45 Studios Worldwide Beginning July 15

Global, July 8, 2024/ENDURANCE SPORTSWIRE/ – Are you up for the challenge? F45 Training Holdings Inc., in partnership with Spartan, has announced the launch of Spartan Week and invites Spartan and DEKA racers looking to shake up their training routine and enhance their race day performance with a special week-long...

Events

Press Releases

Products

July 8, 2024

Fernanda Keller and Kathleen McCartney to be inducted into IRONMAN Hall of Fame

TAMPA, Fla. (July 8, 2024) /ENDURANCE SPORTSWIRE/ – IRONMAN is pleased to announce that icons of the sport Kathleen McCartney and Fernanda Keller will be inducted into the IRONMAN® Hall of Fame this year. An induction ceremony is planned for race week of the men’s 2024 VinFast IRONMAN World Championship®...

Awards

Events

Press Releases

Triathlon

July 8, 2024

Injinji partners with Ultrarunning Legend on a new collection

San Diego, Calif. (July 8, 2024) /ENDURANCE SPORTSWIRE/ - Injinji, the innovator of the patented five-toe Performance Toesock™, announced today the launch of The Courtney Crew in collaboration with Team Injinji Athlete, Ultrarunning legend and Triple Crown Winner, Courtney Dauwalter. This signature edition collection is made for runners and racers...

Business

Press Releases

Products

Running

Sponsorship

Triathlon