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

June 18, 2024

Quebec’s Laurentian Mountains to Welcome The IRONMAN Pro Series at The IRONMAN 70.3 Mont-Tremblant on Sunday, June 23

- The ninth stop on the IRONMAN Pro Series™ tour will see a high caliber field of professional triathletes converge in Canada to fight for a piece of the $50,000 total event pro prize purse and a maximum of 2,500 points towards IRONMAN Pro Series Standings - Free Live coverage...

Events

Press Releases

Triathlon

June 18, 2024

Strong Field Set to Compete at Challenge Kaiserwinkl-Walchsee

/ENDURANCE SPORTSWIRE/ – This Sunday, Challenge Kaiserwinkl-Walchsee will take place in the Austrian Alps. Exciting racing is promised in men's and women's races, featuring a deep field of 20 professional women and 44 professional men athletes. This year's Challenge Kaiserwinkl-Walchsee boasts a strong German presence in the professional men's field....

Events

Press Releases

Triathlon

June 18, 2024

Get ready for the Paris 2024 connected Marathon Pour Tous 5K Challenge, underway now on Kinomap app

PARIS – June 18, 2024/ENDURANCE SPORTSWIRE/ – Join fellow athletes and fitness enthusiasts from June 17 to 30 for the Paris 2024 connected Marathon Pour Tous 5K Challenge on the Kinomap app and experience the run, ride or row of a lifetime, from anywhere in the world. The 5K distance is...

Events

Press Releases

Running

June 18, 2024

Travis Barker’s Run Travis Run: A Run & Wellness Experience

[Los Angeles, California] /ENDURANCE SPORTSWIRE/ - Travis Barker’s Run Travis Run is coming to Los Angeles’ Kia Forum on July 6 and Queens’ Citi Field on July 21. Come join Travis Barker, with a morning run and wellness experience — offering attendees a 360-degree experience of health, wellness, and mindful exploration....

Events

Press Releases

Running

June 18, 2024

Steamboat Classic Celebrates 50 Years

/ENDURANCE SPORTSWIRE/ – On June 15th, the Steamboat Classic, in Peoria, IL celebrated 50 years of the event with participant numbers coming close to hitting pre-pandemic totals. Featuring a 4 Mile Run and 15K Run, the event started in 1974 by Steve Shostrom, former owner of Running Central, and founder...

Events

Press Releases

Running

June 17, 2024

Register today for Little Rock’s Dirtiest 5k, the Mud Run!

LITTLE ROCK, Ark. (June 17, 2024) /ENDURANCE SPORTSWIRE/ - Registration for the Mud Run – affectionately known as Little Rock’s Dirtiest 5K – opens today. The Mud Run is a project of Little Rock Parks & Recreation and will be held Saturday, Sept. 21 at War Memorial Park in Little...

Business

Events

Press Releases

Products

Running

June 17, 2024

IRONMAN Launches Spring 2025 IRONMAN 70.3 Race Schedule for The United States And Canada

- General registration for select spring 2025 IRONMAN 70.3 events open now - Remaining 2025 IRONMAN 70.3 event schedule and on-sale dates to be released in coming months TAMPA, Fla. (June 17, 2024) /ENDURANCE SPORTSWIRE/ – IRONMAN is pleased to unveil its spring 2025 IRONMAN® 70.3® race calendar for the...

Events

Press Releases

Triathlon

June 16, 2024

Matt Burton (AUS) And Hannah Berry (NZL) Claim Cairns Airport IRONMAN Asia-Pacific Championship Cairns Titles in Paradise

CAIRNS, Australia (June 16, 2024) /ENDURANCE SPORTSWIRE/ - The picture perfect Tropical North Queensland played host to the Cairns Airport IRONMAN Asia-Pacific Championship Cairns triathlon, the eighth stop and first in Oceania of the IRONMAN Pro Series™. The race saw Matt Burton (AUS) and Hannah Berry (NZL) claim the IRONMAN...

Events

Press Releases

Triathlon