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

May 8, 2024

Ombraz Invites Armless Sunglass Enthusiasts to Take a Walk with the New Cammina

Bellevue, WA – May 8, 2024 /ENDURANCE SPORTSWIRE/ – Ombraz, the armless sunglass vanguard, is excited to introduce the latest addition to its award-winning collection of styles— the Cammina. Fully made in Italy, this contemporary frame takes inspiration from the Italian verb “to walk” and pays homage to timeless Italian flair....

Press Releases

Products

May 8, 2024

Ombraz Invites Armless Sunglass Enthusiasts to Take a Walk with the New Cammina

Bellevue, WA – May 8, 2024 /ENDURANCE SPORTSWIRE/ – Ombraz, the armless sunglass vanguard, is excited to introduce the latest addition to its award-winning collection of styles— the Cammina. Fully made in Italy, this contemporary frame takes inspiration from the Italian verb “to walk” and pays homage to timeless Italian flair....

Press Releases

Products

May 7, 2024

The Hydroshirt: A New Take on Hydration Gear for Runners Launches on Kickstarter

San Francisco, Calif. – May 7, 2024 /ENDURANCE SPORTSWIRE/ – Today, Vessel Athletics is debuting its first iteration of functional performance wear, introducing the world of runners to a fresh take on hydration gear. The Hydroshirt is a lightweight shirt that integrates a 1L water bladder, designed to let runners...

OSW Syndicated

Press Releases

Products

Running

SWW Syndication

May 7, 2024

Showcased

INFINIT Nutrition Introduces Personal Nutrition Coaching Services for Athletes

CINCINNATI, OHIO - May 7, 2024 /ENDURANCE SPORTSWIRE/ – INFINIT Nutrition, the trailblazer in customized nutrition solutions for athletes, proudly unveiled its new suite of Nutrition Coaching services, designed to improve athletic performance through personally tailored nutrition plans designed by a certified sports dietitian. With a focus on eliminating guesswork...

Business

Press Releases

Products

May 7, 2024

H2O Audio Partners with Ironman Champion Angela Naeth

SAN DIEGO, May 7, 2024/ENDURANCE SPORTSWIRE/ – H2O Audio, the innovator in waterproof audio technology, proudly announces a partnership with world-class professional triathlete Angela Naeth. As a three-time Ironman champion and with 19 half-Ironman victories, she is one of the most successful triathletes of her generation. Angela is also known...

OSW Syndicated

Press Releases

Products

Sponsorship

Triathlon

May 7, 2024

New Bikepacking Essentials Kits from Exploring Wild Give Riders Everything They Need for Problem Solving on the Trail

SAN JOSE, Calif., May 7, 2024 /ENDURANCE SPORTSWIRE/ - Veteran bikepacker and founder of Exploring Wild, Alissa Bell today announced first-of-its-kind bikepacking essentials kits. Available at exploringwild.com, The Fix it Kit and Tubeless Tire Repair Kit are curated kits with emergency essentials needed while bikepacking in remote locations. Bell has logged...

Press Releases

Products

May 3, 2024

Vittoria Unleashes Mostro: The Ultimate Tire for Gravity Mountain Bikers

BENTONVILLE (AR), 05/03/2024 /ENDURANCE SPORTSWIRE/ – Vittoria announces the arrival of Mostro, the newest addition to its renowned lineup of trail dominators. Born from a year of relentless product development and rigorous testing alongside the Commençal ICStudio downhill pro team and the Abetone Ancillotti Vittoria enduro pro team, Mostro emerges...

Cycling

Press Releases

Products