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

March 26, 2024

Rudy Project North America Introduces Kelion Sunglasses in NEW Frame Colors

San Clemente, CA, March 26, 2024 /ENDURANCE SPORTSWIRE/ - Rudy Project, renowned Italian creators of sports performance eyewear and helmets, unveils the latest addition to the Kelion lineup with new frame colors including crystal blue and olive matte. Crafted to elevate athletes' performance, Kelion combines comfort, functionality, and striking design...

Cycling

Press Releases

Products

Running

March 26, 2024

BibRave Presents Exclusive Press Event for Haptic Technology Company, Mojawa

Los Angeles, CA /ENDURANCE SPORTSWIRE/ – BibRave, the leading-edge endurance and fitness marketing agency, recently launched a partnership with the ascendent bone conduction headphone company, Mojawa. To showcase and celebrate the launch of Mojawa’s revolutionary new fitness tracker, the HaptiFit Terra, BibRave is hosting an exclusive press event on March...

Events

Press Releases

Products

March 21, 2024

Article One Recruits Elite Endurance Athlete and Creative Designer César Villalba in Bespoke Performance Eyewear Collaboration

FLINT, Mich. (March 21, 2024) /ENDURANCE SPORTSWIRE/ - Article One, the independent eyewear brand creating handcrafted active and optical frames, and César Villalba, creative designer and elite triathlete, are excited to debut performance sunglasses crafted to counter traditional styles of eyewear in competitive fields. With flames emblazoned along the sides...

Cycling

Press Releases

Products

Running

Triathlon

March 21, 2024

Unleash Your Fitness Potential: Join a Connected Challenge on Kinomap and Experience the Ultimate Workout Adventure

March 21, 2024/ENDURANCE SPORTSWIRE/ – Kinomap, the leading platform for interactive training and immersive fitness experiences, is excited to share how to participate in Kinomap Connected Challenges. Connected Challenges are a thrilling opportunity for individuals around the world to test their fitness limits and have a blast while breaking a sweat....

Press Releases

Products

March 21, 2024

All New Norco Fluid VLT E-MTB Blends Power and Lightweight Performance

PORT COQUITLAM, BC. /ENDURANCE SPORTSWIRE/ - In a year when many bike brands have slowed their pace, Norco continues to innovate and push the boundaries of bike design. Today, the brand is pleased to release the completely reimagined Carbon Fluid VLT E-MTB, now available at dealers and for order online...

Cycling

Press Releases

Products

March 21, 2024

Humango Partners with “From The Ground Up” For Season 4 of Epic Gravel Training

BOULDER, CO. (March 21, 2024)/ENDURANCE SPORTSWIRE/ – Humango™, a revolutionary training platform integrating AI-powered technology, is thrilled to announce their partnership with "From The Ground Up", a groundbreaking documentary series that chronicles the journeys of four novice athletes, tackling some of the toughest rides in the U.S. The collaboration marks a...

Cycling

Press Releases

Products

Sponsorship

March 21, 2024

Charge into Spring: Murf Electric Bikes Unleashes the Alpha ST

San Clemente, CA /ENDURANCE SPORTSWIRE/ – Murf Electric Bikes, a leading innovator in the e-bike industry, proudly introduces its latest addition to the lineup: the Alpha ST. This cutting-edge e-bike is set to redefine urban commuting and outdoor exploration with its unrivaled performance, more convenient access and sleek design. As the...

Press Releases

Products

March 20, 2024

Athlinks Surpasses 400 Million Results

[EVANSVILLE, IN] /ENDURANCE SPORTSWIRE/ - Athlinks, the premier destination for endurance athletes seeking to track their race results, proudly announces a monumental achievement: surpassing 400 million race results in its extensive database. This milestone not only cements Athlinks' position as the world's largest and most comprehensive results database for competitive...

Cycling

Events

Press Releases

Products

Running

Triathlon