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

January 6, 2025

Scarab Cycles Introduces the Scarab Coffee Club

January 6, 2025 /ENDURANCE SPORTSWIRE/ - Coffee, the most iconic element of Colombian culture, has always been deeply intertwined with Scarab Cycles. Often present at the start of Scarab’s shop rides, a sight along the routes around our hometown, and even inspiring our most popular paint schemes, coffee symbolizes the...

Cycling

Press Releases

Products

January 6, 2025

Garmin unveils the new HRM 200 – a heart rate monitor built to improve the training experience

OLATHE, Kan. (January 6, 20250 /ENDURANCE SPORTSWIRE/ – Garmin (NYSE: GRMN) today announced the HRM 200 — a heart rate monitor designed for athletes who want to improve their overall performance. From the bike trail to the gym and everywhere in between, HRM 200 provides accurate heart rate and heart rate...

Cycling

Press Releases

Products

Running

January 6, 2025

Chasing Watts releases version 4.0

/ENDURANCE SPORTSWIRE/ - Chasing Watts, the leading platform connecting cyclists with local group rides, is thrilled to announce the launch of its newest version, Chasing Watts 4.0. This latest iteration brings a suite of innovative features and enhanced functionality designed to make finding and creating great, safe rides easier than...

Cycling

Press Releases

Products

January 6, 2025

Introducing the Instinct 3 Series from Garmin: rugged smartwatches now with AMOLED displays

OLATHE, Kan.(January 6, 2025) /ENDURANCE SPORTSWIRE/ – Garmin (NYSE: GRMN) today announced the Instinct® 3 Series, its newest lineup of rugged smartwatches, now offered with a brilliant AMOLED or solar-powered display for maximum battery life. Designed with adventurers in mind, Instinct 3 Series adds a metal-reinforced bezel for extreme durability and...

Cycling

Press Releases

Products

Running

January 3, 2025

2025 Bicycle Owner’s Guide to the Best Bike & eBike Insurance

Washington, D.C. - January 3, 2025 /ENDURANCE SPORTSWIRE/ - BikeInsure, an insurtech company specializing in bicycle insurance for cyclists in the United States, has released the "2025 Bicycle Owner's Guide to the Best Bike & eBike Insurance." Today's cyclists must opt for separate bike insurance to protect their new or...

Business

Cycling

Press Releases

Products

Triathlon

December 23, 2024

WISEcode Launches First App to Decode Hidden Truths in Your Food!

RENO, NV /ENDURANCE SPORTSWIRE/ – WISEcode, pioneer in food transparency, has launched the WISEcode app to transform how consumers understand the quality and safety of their foods. “Until 30 years ago, nutrition disclosure was voluntary," Tolga Erdogus, WISEcode’s CTO, remarked. “The current Nutrition Facts Panel shows just 15 attributes—less than...

Press Releases

Products

December 21, 2024

Polartec Releases the Final Episode of ‘Beyond Begins Today’ Mini Series – Chapter 3: Product

Planet Earth /ENDURANCE SPORTSWIRE/ - Polartec®, a Milliken™ & Company brand and premium creator of innovative textile solutions for future thinking, introduces Product, the third and final chapter in Polartec’s multifaceted Beyond Begins Today mini-series. Within the rich tapestry of Polartec’s legacy, threads of innovation weave together the past, present, and...

Press Releases

Products

December 19, 2024

Reviewed: Sumarpo Race Wetsuit

December 19, 2024 /ENDURANCE SPORTSWIRE/ - Rating: ★★★★☆ Best For: Competitive triathletes, Confident open-water swimmers, Sleek, Fast, and Affordable Notable Features: Slip Skin technology, Yamamoto SCS coating, 5mm leg buoyancy, flattering fit If you’re looking for a wetsuit that performs as well as it looks, the Sumarpo Race Wetsuit might...

Press Releases

Products

Triathlon