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

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 17, 2024

Head Of The Charles Regatta Names Tori Stevens as new Executive Director

June 17, 2024 / Boston, MA. /ENDURANCE SPORTSWIRE/ –The Head Of The Charles Regatta (HOCR), the world’s largest rowing regatta, announced today that Tori Stevens will assume the role of Executive Director beginning July 1, 2024. Succeeding Fred Schoch’s 33-year tenure leading the Regatta, Stevens comes to HOCR as its...

Business

Press Releases

June 17, 2024

KINeSYS Listed in Allergic Living’s Top Sunscreens for 2024

/ENDURANCE SPORTSWIRE/ - KINeSYS Performance Sunscreen is proud to announce that our SPF 30 Fragrance-Free Spray Sunscreen has been recognized in Allergic Living’s 2024 Top Allergy-Friendly Sunscreens. This marks the fourth consecutive year that our small, family-owned brand has received this prestigious honor. Allergic Living's list features only 19 sunscreens...

Awards

Business

Press Releases

Products

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

June 14, 2024

Norda Launches First Ever Bag to be made with Bio-Dyneema

Montreal, Canada /ENDURANCE SPORTSWIRE/ – Not content with setting the trail running industry on fire with the first shoe ever constructed with Bio-Dyneema®, the “norda™ 001”, the fairly young but arguably disruptive Canadian brand, norda has now created the world’s first duffel bag made entirely of Bio-Dyneema®, the most durable...

Press Releases

Products

Running

Triathlon

June 14, 2024

Challenge Family Announces Return to China with Challenge Beijing

14 June 2024 /ENDURANCE SPORTSWIRE/ – Challenge Family has announced Challenge Beijing, set to take place on 7 and 8 September 2024 over the Olympic and Sprint distances in the Beijing Expo Park, situated in the popular holiday region of Yanqing. Challenge Beijing has been certified as an A+ level...

Events

Press Releases

Triathlon

June 13, 2024

VITALOOP Named Finalist at Outdoor Retailer Innovation Awards in Salt Lake City

Salt Lake City, UT - June 13, 2024 /OUTDOOR SPORTSWIRE/ – VITALOOP is thrilled to announce its selection as a Finalist at the prestigious Outdoor Retailer Innovation Awards. This recognition marks a significant milestone as we take a major step into the US market. We will showcase our automated water...

Awards

Press Releases

Trade Shows

June 13, 2024

IRONMAN Pro Series Heads to Australia For The First Time for Cairns Airport IRONMAN Asia-Pacific Championship Cairns on Sunday, June 16

- The eighth stop for the IRONMAN Pro Series™ will see a number of the world’s top professional triathletes head to Cairns, Australia, to race for a piece of the $150,000 total event pro prize purse in the first Pro Series event in Oceania  - Free Live coverage of Sunday’s event...

Events

Press Releases

Triathlon