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

October 7, 2024

Colnago introduces Retrofitting, an innovative system for certifying the authenticity of vintage frames, opening up a world of new opportunities for Colnago bike owners.

Cambiago /ENDURANCE SPORTSWIRE/ In the world of cycling, the Colnago brand guarantees excellence, quality, and tradition. The legendary Italian company, founded in 1954, has written essential pages in the history of this sport, winning the hearts of professional cyclists and enthusiasts worldwide. Today, Colnago is ready to launch an ambitious...

Business

Cycling

Press Releases

Products

October 3, 2024

Ciele Athletics Debuts a Joint Adventure From Its Conceptual Lab, gry©

MONTREAL (Oct. 3, 2024) ENDURANCE SPORTSWIRE — Performance running brand Ciele Athletics is proud to announce the debut joint adventure from its conceptual lab, gry©, and multidisciplinary creator, designer and adventurer Colin Meredith. This collaboration, inspired by Meredith’s own running and adventure needs in Vancouver, British Columbia, presents a collection...

Press Releases

Products

Running

October 3, 2024

Internationally Renowned Neuroscientist Dr. Scott Frey to Host Special Webinar this Thursday, October 3

BOULDER, CO. (October 3, 2024) – ENDURANCE SPORTSWIRE - Neuroscientist Dr. Scott Frey Ph.D., Ed.M., as well as Humango’s Master Triathlon Coach Raeleigh Harris, will team up to host an online virtual webinar this Thursday, October 3, beginning at 1:00pm ET. The latest in Humango’s virtual webinar series, Thursday’s session...

Cycling

Press Releases

Products

Running

Triathlon

October 3, 2024

KÜHL Launches Episode Three of The Road Less Traveled Video Series and Alaska Trip Giveaway

SALT LAKE CITY, Utah (October 3, 2024) /ENDURANCE SPORTSWIRE/ - KÜHL, a premium independent outdoor brand, announces episode three of The Road Less Traveled: Alaska Aviation, continuing the new video series that dives into the lives of those who forge their own paths. Following trailblazers, rebels and renegades, each episode features...

Press Releases

Products

October 2, 2024

Chargel Extends Southern California Sponsorships and Samplings at the Long Beach Marathon and Xterra Wetsuits Mission Bay Tri

IRVINE, Calif. /ENDURANCE SPORTSWIRE/ - Chargel®, a first-of-its-kind, refreshing Gel Drink that delivers convenient and delightfully unexpected instant pre-workout energy with zero caffeine, today announced its October competitive event station lineup. Chargel will showcase its half drink, half snack, all delicious energy source at the Long Beach Marathon and Xterra...

Cycling

Events

Press Releases

Products

Running

Triathlon

October 1, 2024

Discover What’s Inside with the All-New Palmer Clear from The James Brand

PORTLAND, OR (October 1, 2024) /ENDURANCE SPORTSWIRE/ - The James Brand - makers of modern, minimal everyday carry products - launches the all-new Palmer Clear, a 100% translucent and post-consumer recycled version of the brand’s best-selling utility knife. A throwback to 90s vibes when the iMac G3 and Conair Clear...

Press Releases

Products

October 1, 2024

Altra Launches the FWD VIA Road Shoe

DENVER, Colo. (October 1, 2024) /ENDURANCE SPORTSWIRE/ - Altra, a leading innovator in performance running, is proud to unveil the all-new FWD VIA—a road shoe designed to deliver premium comfort, high cushioning, and a smooth, efficient ride for everyday runners. The FWD VIA is built for runners who prioritize soft...

Press Releases

Products