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

February 21, 2023

Pro Cyclist Tom Pidcock Features in Safa Brian’s Series “Descent Disciples”

/ENDURANCE SPORTSWIRE/ – Brian "Safa" Wagner, cyclist and filmmaker, will live premiere "Descent Disciples ||Vol13|| Tom Pidcock vs. The Fish" on February 21st, 2023, at 8:00 am PST on YouTube. Volume 13's featured rider, Tom Pidcock, is a professional rider for Ineos Grenadiers and is often referred to as the best...

Cycling

Press Releases

Products

February 21, 2023

Pirelli Presents P ZERO Race TT, The Fastest and Lightest Clincher Tire of Its Range

Milan (Italy), 21 February 2023 /ENDURANCE SPORTSWIRE/ – Pirelli presents P ZERO Race TT, the top-performing clincher tire for professional riders and the sportiest amateurs. It is produced in the renovated Pirelli plant of Bollate, just outside Milan, and completes the racing tire range by taking over from the P ZERO...

Cycling

Press Releases

Products

Triathlon

February 20, 2023

Orbit Launches Bicycle Tracker with Apple Find My

Sydney, Australia /ENDURANCE SPORTSWIRE/ - Orbit Velo, a leading manufacturer of tracking devices, has just announced the launch of its latest innovation - a cutting-edge bike tracker that integrates with Apple Find My. The Orbit Velo tracker is designed to provide cyclists with a secure and convenient way to keep...

Press Releases

Products

February 17, 2023

Alchemy Bikes Increases Rear Travel on Two Arktos MTBs; Pre-Order Now

Golden, Colorado (February 17, 2023) /ENDURANCE SPORTSWIRE/ – Addressing what they see as the future of mountain bike design, Alchemy Bikes – a leading fabricator-to-rider boutique bike manufacturer – is updating its critically acclaimed Arktos line of full-suspension carbon mountain bikes for 2023 with longer rear travel on two of its most...

Cycling

Press Releases

Products

Triathlon

February 16, 2023

Kane Footwear Brings Recovery Footwear to Nordstrom

Westport, CT /ENDURANCE SPORTSWIRE/ - Kane Footwear, a leader in active recovery footwear, is now available in 12 select Nordstrom stores and Nordstrom.com, having expanded to six additional brick and mortar stores this week. In celebration of launching with their first major retailer, Kane has designed an exclusive Olive colorway...

Business

Press Releases

Products

February 16, 2023

RACE RESULT Unveils Fundamentally New Timing System “Ubidium”

Boulder, CO /ENDURANCE SPORTSWIRE/ – At its International Timers Conference, RACE RESULT presented a fundamentally new timing system. Ubidium redefines the industry standards in terms of user-friendliness, power supply and reliability. CTO Nikias Klohr describes the related new foldable ground antenna as a "revolution". The RACE RESULT development team has poured...

Press Releases

Products

February 15, 2023

Cannondale Unveils LAB71 – A New Ultra-Premium Tier of Performance Product

Wilton, Conn. – February 15, 2023 /ENDURANCE SPORTSWIRE/ – Today, Cannondale announced the launch of LAB71, a new, elevated tier of products representing the highest expression of craftsmanship and the culmination of more than fifty years of cycling innovation, performance, and design. Utilizing cutting-edge materials and processes, combined with stunning finishes...

Cycling

Press Releases

Products

February 15, 2023

P3R Celebrates International Women’s Day with a Limited-edition, Women’s Day-themed Box Filled with Fitness Items and Goodies

PITTSBURGH, PA /ENDURANCE SPORTSWIRE/ – Celebrating International Women’s Day, P3R will once again launch a limited-edition, Women’s Day-themed box curated with fitness items and goodies that will support and empower women along their wellness journeys. For each box sold, $10 will be donated directly to Girls on the Run of Magee-Womens...

Press Releases

Products

Running