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 (8742)
) 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 3430, 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 3, 2023

Sprint finish after racing above 3000m

New York City, May 3, 2023 /ENDURANCE SPORTSWIRE/ – A head to head sprint decided the male race at the 7th GFNY Bogotá after 101.1 km with an elevation gain of 2321 m and a hilltop finish at iconic El Águila, situated above 3100m. The race started fast inside the famous...

Cycling

Events

Press Releases

May 3, 2023

Ultimate Direction Athletes Climb to the Top at USATF Mountain Championship Races

BOULDER – May, 2023/ENDURANCE SPORTSWIRE/ – Grayson Murphy and Joseph Gray, long-standing members of the Ultimate Direction athlete team, took home wins and earned spots on Team USA at this past weekend’s USA Track and Field (USATF) Vertical Mountain Running Championship hosted at New Hampshire’s Sunapee Scramble. Both Murphy, based in Arizona,...

Events

Press Releases

Running

May 3, 2023

Boulderthon® Speeds Towards Continued Growth with the Launch Of Small Business Bonds™ With SMBX

Boulder, Colorado, May 3, 2023 /ENDURANCE SPORTSWIRE/ - Boulderthon®, the fastest-growing running series in Colorado, is giving people a chance to invest through a crowdfunding campaign on the SMBX marketplace. The race is the first running event to launch on the platform, marking a new growth strategy for the running...

Business

Events

Press Releases

Running

May 2, 2023

Garmin Signs Up As New Sponsor of 2023 PTO Tour

London, UK /ENDURANCE SPORTSWIRE/ – The Professional Triathletes Organisation (PTO) today announced a new sponsorship with Garmin, who will become the Official Transition Sponsor of the 2023 PTO Tour. Starting with the PTO European Open in Ibiza on 6 May, the sponsorship will see Garmin champion the fastest transition times through graphics...

Events

Press Releases

Sponsorship

Triathlon

May 2, 2023

Tifosi Optics Welcomes Veteran of Cycling Industry to Lead Sales

Watkinsville, GA (May 2, 2023) /ENDURANCE SPORTSWIRE/ – Tifosi Optics, the #1 selling brand of cycling eyewear in the United States, is pleased to announce the recent hiring of Rick Dyer, as Director of Sales. A staple of the cycling industry, Dyer will bolster existing partnerships while expanding Tifosi’s presence in other...

Business

Press Releases

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

UTMB World Series expands North American offering with Kodiak Ultra Marathons by UTMB

BIG BEAR LAKE, Cali. / CHAMONIX, France / TAMPA, Fla. /ENDURANCE SPORTSWIRE/ – Kodiak Ultra Marathons™ by UTMB® has become the latest trail running event to be added to the 2023 UTMB® World Series. Kodiak Ultra Marathons by UTMB will take place in Big Bear Lake, California on October 13-15 and will feature...

Events

Press Releases