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

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

April 9, 2024

supertri E World Triathlon Championships powered by Zwift will be supported by Garmin products on the world stage

/ENDURANCE SPORTSWIRE/ - supertri E World Triathlon Championships powered by Zwift will be backed by the Garmin® ecosystem when it returns to the global stage on April 13. Garmin have been key to supertri E for the past three years, and is extending its support to again be at the...

Press Releases

Products

Sponsorship

Triathlon

April 9, 2024

Chargel Kicks Off with On-Site Samplings at Two California-Based Cycling Events: The Sea Otter Classic and The GranFondo San Diego

IRVINE, Calif. (April 9) /ENDURANCE SPORTSWIRE/ - Chargel®, a first-of-its-kind, delicious Gel Drink that delivers convenient and delightfully unexpected instant pre-workout energy before any workout with zero caffeine, today announced its April competitive race station lineup. Chargel will be showcasing its half drink, half snack, all delicious energy source at the...

Cycling

Press Releases

Products

Running

Wire Syndication