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

July 9, 2024

Penticton To Host Its Final IRONMAN Canada Event In 2024; Ottawa To Carry On The Legacy Of IRONMAN Canada Beginning In 2025

- Final edition of IRONMAN Canada and IRONMAN 70.3 Canada in Penticton, B.C., Canada to take place on August 25, 2024; registration for final event in Okanagan Valley is available by visiting www.ironman.com/im-canada and www.ironman.com/im703-canada - First edition of IRONMAN Canada triathlon in Ottawa, part of the VinFast IRONMAN North...

Events

Press Releases

Triathlon

July 9, 2024

La Sala Named Emerging Industry Leader By NCS4

/ENDURANCE SPORTSWIRE/ - Blistering Pace Race Management President Michelle La Sala will be recognized with the 2024 Emerging Industry Leader Award by the National Center for Spectator Sports Safety and Security. The award is given to a professional who has demonstrated outstanding leadership in addressing safety and security issues. The...

Awards

Business

Events

Press Releases

Running

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

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