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

April 10, 2024

4iiii and BMC collaborate to integrate the new PRECISION 3+ PRO Powermeter into 2024 road bike range.

COCHRANE, ALBERTA/ENDURANCE SPORTSWIRE/ –  4iiii is proud to announce their collaboration with BMC, which will see the integration of their new PRECISION 3+ PRO Powermeter across the 2024 range of BMC road bikes, specifically the Teammachine R 01 and Teammachine SLR 01 and the just recently launched new Roadmachine 01....

Cycling

Press Releases

Products

Triathlon

April 10, 2024

SFuels launches industry first ZONE based nutrition utilizing, SFuels new Extended Substrate

RALEIGH, North Carolina /ENDURANCE SPORTSWIRE/ - The unique SFuels system of specifically formulated fuels combined with the RIGHT FUEL RIGHT TIME ® approach, supports a strong aerobic base, a resilient gut and delivers consistent stable high-intensity finishes. The new product portfolio includes ZONE 2 Aerobic Training Fuel, ZONE 4 Threshold and...

Cycling

Press Releases

Products

Running

Triathlon

April 9, 2024

HydraPak® Invites Outdoor Enthusiasts to Upcycle Used Sports Bottles

OAKLAND, Calif. (April 9, 2024) /OUTDOOR SPORTSWIRE/ - HydraPak®, global leader of high-performance hydration solutions, is excited to announce Re_Pak, a recycling initiative with a goal to upcycle used sports bottles. The Oakland-based company will distribute approximately 30 boxes at select retailers and outdoor industry events where outdoor enthusiasts are...

Business

Press Releases

Products

April 9, 2024

Norco Is Bringing It Home with Bosch for a Complete Full-Power E-MTB Lineup

April 9, 2024 - PORT COQUITLAM, BC. /ENDURANCE SPORTSWIRE/ - When it looked like the roster was complete, Norco announced two more models to round out the stable in a powerful way. Design and technology come together for a cohesive full-power lineup consisting of three Range VLTs and one Sight...

Cycling

Press Releases

Products

April 9, 2024

Tracksmith Launches Global Twilight 5000 Track Races on Movemint

SAN FRANCISCO [04/09/24] /ENDURANCE SPORTSWIRE/ – Movemint, the platform for athletic events, is excited to announce its partnership with Tracksmith to host on its platform the sixth edition of the Twilight 5000 summer races. Tracksmith is an independent running brand offering well-considered and authentic products for training, racing, and rest...

Events

Press Releases

Products

Running

April 9, 2024

2024 Indoor: Off-Season Updates by ROUVY

Pause Subscription in new Loyalty Program Workout improvements Drafting modelling refined New routes including Oatman, Arizona on Route 66 New and retro bikes added to virtual garage Prague, April 9th/ENDURANCE SPORTSWIRE/ – ROUVY, the indoor cycling app that lets you ride real routes around the world, presents a bundle of product...

Cycling

Press Releases

Products

Triathlon

April 9, 2024

Introducing The Brand Leader’s Dynamic Online Presence

Greenville, SC – April 9, 2024/ENDURANCE SPORTSWIRE/ – The Brand Leader®, a renowned advertising, branding, and creative integrated marketing agency that creates what’s impossible to forget, launches their updated innovative website, ushering in a new era of brand engagement and connectivity. This dynamic online platform is designed to elevate user...

Business

Press Releases

Products

April 9, 2024

Liv Introduces the New Intrigue X Range

NEWBURY PARK, Calif. (April 9, 2024) /ENDURANCE SPORTSWIRE/ - Liv, the company dedicated to getting more women on bikes, today launched the new Intrigue X Advanced and Intrigue X series. Designed for intermediate and expert trail riders, the Intrigue X is a standout performance mid-travel trail bike, perfect for navigating...

Business

Cycling

Press Releases

Products