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

May 3, 2023

Pirelli Launches the P ZERO Race 4S TLR Road Bicycle Tire, The All Season Tubeless Tire that Performs in any Weather Condition

Milan (Italy), May 3, 2023 /ENDURANCE SPORTSWIRE/ – Pirelli presents the P ZERO Race 4S TLR road bicycle tire, the tubeless version of the Pirelli all season tire, produced in the renovated Milano-Bollate facility. The new all-round tire follows the success of the P ZERO Race 4S clincher version. The new tire has...

Cycling

Press Releases

Products

Triathlon

May 3, 2023

CEP Launches the Next Generation in Running Socks with the Mid-Cut and No-Show Training Socks

Whitsett, NC. (May 3, 2023) /ENDURANCE SPORTSWIRE/ – Today, CEP Compression, a world leader in compression products for athletes, announces their first ever max cushion sock with the Mid-Cut and No-Show Training Sock. The Training Sock is designed for those who prefer a thicker sock during workouts. The Training Sock will help...

Press Releases

Products

Running

May 3, 2023

Showcased

Aquaglide Launches the Ultimate Lightweight Packable and Performance Touring Kayaks

Bend, Oregon. — May 3, 2023 /ENDURANCE SPORTSWIRE/ – Aquaglide, a leading innovator in the inflatable kayak industry, has launched the highly anticipated Cirrus Ultralight Series, consisting of the Cirrus UL 110 and Cirrus UL 150. These kayaks are designed for high-performance touring with supreme weight savings and packability, not to be confused...

OSW Syndicated

Press Releases

Products

May 2, 2023

Tifosi Optics Adds Versatility to it’s Endurance Line with Rivet

Watkinsville, GA (May 2, 2023) /ENDURANCE SPORTSWIRE/ – Tifosi Optics, celebrating 20 years as a leading sport and lifestyle eyewear brand, is happy to announce the latest style in its endurance lineup: Rivet. The perfect companion for a range of outdoor activities, Rivet offers simplicity in a lightweight and durable sunglass. While Rivet...

Cycling

Press Releases

Products

Running

Triathlon

May 2, 2023

Innovators join forces for UltraSwim 33.3

/ENDURANCE SPORTSWIRE/ – THEMAGIC5, the most comfortable swimming goggle, has joined the UltraSwim 33.3 family as its first Official Partner. In addition to supporting participants at this new category of open water swim event, THEMAGIC5 Co-founder Niklas Hedegaard, retired professional short course pool breaststroke specialist, will also compete in UltraSwim 33.3...

Press Releases

Products

Sponsorship

Triathlon

May 2, 2023

BibBoards Launches New Strategy to Combat Bib Bandits

SAN RAMON, CALIFORNIA May 2, 2023 /ENDURANCE SPORTSWIRE/ – Racing is a huge way for enthusiasts to participate in their favorite outdoor activity with other likeminded individuals and the volunteers who put these events together. Standard practices require racers to wear bibs with numbers in order to track their progress from beginning...

Events

Press Releases

Products

May 2, 2023

VELOUS Footwear Introduces New Hoya Adjustable Slide Designed for Active Individuals

PORTLAND, Ore., May 2, 2023 /ENDURANCE SPORTSWIRE/ – VELOUS Footwear, a leader in recovery footwear, has expanded its line of sandals designed to promote and optimize active recovery for athletes of all levels with the new Hoya Adjustable Slide. Created to help feet, ankles, knees and legs recover quickly from participation in...

Press Releases

Products

May 2, 2023

COROS unveils the second generation of its VERTIX 2 Carabiner

IRVINE, California / May 2nd, 2023 /ENDURANCE SPORTSWIRE/ – COROS Wearables Inc., makers of GPS sports wearables and training software for adventure and pro athletes, today announced the launch of its second generation VERTIX 2 carabiner, made explicitly for climbers and mountaineers wishing to wear their VERTIX 2 off-wrist for more technical pursuits....

Press Releases

Products

May 2, 2023

Pressio Launches a Custom Apparel Program for Partners

Asheville, N.C. (May 2, 2023) /ENDURANCE SPORTSWIRE/ - Pressio, a U.K.-based technical apparel company committed to unparalleled performance and the unwavering pursuit of sustainable procurement, announces its Custom Apparel Program offering fully customizable athletic apparel for retailer and partner needs. The program aims to further the mission of providing world-leading,...

Business

Events

Press Releases

Products

Running

Trade Shows