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

September 13, 2023

Introducing Solarcore®, a Thermal Solutions Company that Leverages NASA-inspired Aerogel

PORTLAND, Ore. (Sept. 13, 2023)/ENDURANCE SPORTSWIRE/ – Today, Solarcore® officially launches as a standalone materials technology brand, leveraging the thermal properties of NASA-licensed Aerogel, the world’s lowest thermally conductive solid, to revolutionize insulation for a multitude of applications – from structures and packaging to cold weather apparel and footwear. By combining cutting-edge...

Business

Press Releases

Products

Wire Syndication

September 12, 2023

Combining Striking Style and Innovative Technology; Rudy Project North America Releases Groundbreaking Kelion Sunglasses

San Clemente, CA, September 12, 2023 /ENDURANCE SPORTSWIRE/ - Rudy Project, Italian designers of sports performance eyewear and helmets, announces the release of Kelion, a new premier, sports sunglass designed to elevate the performance of athletes. The Kelion features a sleek, wrap-around cylindrical lens with a 5.2 base curve for...

Cycling

Press Releases

Products

Running

Triathlon

September 12, 2023

The RunnerBox and The RiderBox Help Athletes Finish the Season Strong with Their Latest Edition

/ENDURANCE SPORTSWIRE/ – The RunnerBox and The RiderBox unveiled their latest editions which showcases featured picks to help subscribers finish strong as they take on their late-summer workouts and races. Consistently named the top subscription box for athletes, The RunnerBox and The RiderBox deliver bi-monthly boxes to subscribers that highlight...

Cycling

Press Releases

Products

Running

Triathlon

September 11, 2023

RACE RESULT Introduces Groundbreaking Timing System “Ubidium” to Redefine Race Timing Standards

/ENDURANCE SPORTSWIRE/ – RACE RESULT, the pioneering force in sports timing technology, has now officially launched "Ubidium", the most advanced and accurate timing system on the market. This cutting-edge solution promises to elevate the experience for timekeepers and event organizers alike, introducing numerous innovative features and streamlining the processes at...

Cycling

Events

Press Releases

Products

Running

Triathlon

September 8, 2023

OutThere USA Partners with Adventure Racing World Series

/ENDURANCE SPORTSWIRE/ – A backpack is a fundamental piece of equipment in Adventure Racing. It carries a variety of gear for sections of the race, from climbing harnesses and carabiners to mountain bike spares and crampons. Together with cold-weather gear, personal care, foot care and first aid kits, bivvy bags,...

Business

Cycling

Press Releases

Products

Running