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

June 18, 2024

Skratch Labs Bolsters International Presence with European Headquarters and Distribution Facility

June 18, 2024 — Boulder, CO /ENDURANCE SPORTSWIRE/ – Skratch Labs, the Boulder, CO-based leader in performance nutrition, expands its distribution network to Europe. The new distribution capabilities enable Skratch Labs Europe to serve endurance sports retailers across the continent and establish Skratch’s direct-to-consumer online sales capabilities through their new...

Business

Press Releases

Products

June 18, 2024

Professional Dancer Emma Slater Partners With Active Recovery Footwear Leader OOFOS

June 18, 2024 /ENDURANCE SPORTSWIRE/ – OOFOS, the global leader in Active Recovery footwear, today announces a new partnership with renowned dancer, choreographer and style icon, Emma Slater. Known for her exciting career on stage and screen, including the film adaptation of Mamma Mia! and many years on the hit show,...

Press Releases

Sponsorship

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