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 (21085)
) 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 390, 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

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

deboer swim Launches with Revolutionary Tridum Race Suit Collection and Training Line

/ENDURANCE SPORTSWIRE/ – In a groundbreaking move for the sport of swimming, deboer swim will officially launch as a new performance swimwear brand on June 8th, 2024. Their flagship product, the Tridum race suit collection, incorporates a pioneering 3D textured fabric called Tridium - the result of years of research...

Press Releases

Products

Triathlon

June 12, 2024

Electrolit Debuts Green Apple Flavor Exclusively in Texas

Houston, TX /ENDURANCE SPORTSWIRE/ – Electrolit – the preferred, premium hydration beverage crafted with pharmaceutical quality grade ingredients – is unveiling its latest limited edition flavor, Green Apple, hitting shelves at H-E-B, 7-Eleven and other TX retailers exclusively until the end of summer. Scientifically formulated with magnesium, sodium, potassium, calcium and...

Press Releases

Products

June 12, 2024

H2O Audio Partners with Inspiring Paralympic Medalist Jamal Hill

SAN DIEGO, June 12, 2024 /ENDURANCE SPORTSWIRE/ - H2O Audio, the leader in waterproof audio technology, proudly announces a strategic partnership with Jamal Hill, the inspirational Team USA Paralympic swimmer and Tokyo 2020 medalist. The collaboration combines H2O Audio's innovative technology with Hill's moving story and dedication to swim education...

Press Releases

Products

Sponsorship

Triathlon

Wire Syndication