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

March 21, 2023

RBC GranFondo Whistler innovates annual apparel product line to reduce costs while increasing quality, sales & profits

VANCOUVER, BC /ENDURANCE SPORTSWIRE/ – RBC GranFondo Whistler (road cycling) today announced early sales performance following a switch to white label apparel production for 2023. Following multiple years of partnerships with various apparel suppliers, this move has allowed the event company to keep quality high while reducing costs and passing the benefit on...

Cycling

Press Releases

Products

March 21, 2023

Sportive Breaks launches new website that makes it even easier to find the perfect cycling trip

21st March 2023 - Manchester, UK /ENDURANCE SPORTSWIRE/ – Sportive Breaks is launching an all-new website that not only captures the dramatic landscapes and iconic roads of the events it offers, but has also been designed to smooth the process from booking online to arrival on the startline. It’s all supported by inspirational...

Cycling

Events

Press Releases

Products

Triathlon

March 21, 2023

Peak Ski Company and Pebblebee® Introduce Innovative New Technology: Peak Lôc8™

BOZEMAN, Montana (March 21, 2023) /ENDURANCE SPORTSWIRE/ – Peak Ski Company and its strategic partner Pebblebee® unveiled PEAK Lôc8™, a first-of-its-kind locating and tracking device that will be embedded within certain models of Peak Ski Company’s 2023/24 line of innovative skis. PEAK Lôc8 provides users with the ability to locate their Peak...

OSW Syndicated

Press Releases

Products

March 21, 2023

H2O Audio Releases PLAYLIST+™, Groundbreaking Audio Technology Never-Seen-Before in Headphones, PRO Series Products, and a New App

SAN DIEGO, March 21, 2023 /ENDURANCE SPORTSWIRE/ - H2O Audio, a 20-year pioneer in developing superior waterproof audio products, is proud to debut its latest innovation. PLAYLIST+™ is groundbreaking technology that loads and stores content from any popular streaming app into the memory of headphones for offline play back later...

Press Releases

Products

Running

Triathlon

March 21, 2023

Tim and Rinny Launch Coaching Business Leveraging TriDot

DALLAS, TX – March 21, 2023 /ENDURANCE SPORTSWIRE/ - Mirinda (“Rinny”) Carfrae and Tim O’Donnell announced the launch of their coaching business that will leverage TriDot’s Optimized Triathlon Training®, technology driven by data and artificial intelligence. Their coaching business will focus on triathlon enhancing the lives of athletes through proper life...

Business

Press Releases

Products

Triathlon

March 20, 2023

Pirelli Presents The New P ZERO Race TLR, The Fastest Tubeless Tire of The Road Bike Range

Milan, Italy, 20th March 2023 /ENDURANCE SPORTSWIRE/ – Pirelli is launching its new P ZERO Race TLR, the tubeless version of its clincher tire for road bikes. This product has been redesigned with new technologies and is manufactured in the modernized and innovative Pirelli plant in Milan-Bollate. The new tubeless ready...

Cycling

Press Releases

Products

Triathlon

March 16, 2023

Pinarello Launches new Nytro E Road and Gravel E Bikes

/ENDURANCE SPORTSWIRE/ Pinarello is proud to announce the launch of the Pinarello Nytro E, an exciting range of road and gravel e-bikes designed without compromise to perform at a high-level and created with adventure in mind, allowing riders to tackle long rides and steep Alpine climbs with more agility and...

Cycling

Press Releases

Products