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

June 18, 2024

Set records with Wattbike’s exciting new Leaderboards feature

Nottingham, UK, 18th June, 2024 /ENDURANCE SPORTSWIRE/ – The Leaderboards feature includes a variety of challenges, such as endurance tests, hill climbs, speed sprints, and distance goals. Wattbikers can easily participate by completing any workout in the 'Challenges' category or by taking part in selected tests and climbs via the free...

Cycling

Press Releases

Products

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 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