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

June 22, 2024

Vittoria Unveils An Exciting Addition to the Terreno Gravel Range: The Terreno T50 Mixed Gravel Endurance

Bentonville, AR – 06/22/2024 /ENDURANCE SPORTSWIRE/ –Vittoria unveils a new ground-breaking tire designed specifically for the adventurous gravel riding community: the Terreno T50 Mixed Gravel Endurance. As gravel riding continues to surge in popularity, Vittoria remains committed to pushing the boundaries of performance and reliability. The Terreno T50 Mixed Gravel...

Cycling

Press Releases

Products

June 22, 2024

Vittoria Introduces Air-Liner Light Gravel Insert for Enhanced Gravel Cycling Performance

Bentonville, AR– 06/22/2024 /ENDURANCE SPORTSWIRE/ – Vittoria, the leading manufacturer of bicycle tires and accessories, proudly announces the launch of the Air-Liner Light Gravel insert. Designed specifically for gravel tubeless tires, with tire widths ranging from 42-50mm, this innovative insert revolutionizes the wheel-tire system for gravel applications. Combining the success of...

Cycling

Press Releases

Products

June 20, 2024

Velocio Renewed Gives Reconditioned Cycling Apparel a Second Life in the Saddle

Londonderry, NH (June 20, 2024)/ENDURANCE SPORTSWIRE/ –Velocio, makers of performance cycling apparel, is pleased to announce the relaunch of Velocio Renewed with an all-new trade-in option. The refreshed program includes a collection of revived, repurposed, and reconditioned apparel that is ready for a second life in the saddle. Buying secondhand...

Cycling

Press Releases

Products

June 20, 2024

Rudy Project Unveils the Rebel: A Breakthrough in Road Helmet Design

San Clemente, CA, June 20, 2024 /ENDURANCE SPORTSWIRE/ - Rudy Project, renowned Italian creators of sports performance eyewear and helmets, is proud to announce the launch of the Rebel, a revolutionary road helmet that sets new standards in safety, sustainability, and performance. The Rebel is meticulously engineered to offer unmatched...

Cycling

Press Releases

Products

Triathlon

June 19, 2024

Kinomap’s Integration with the Technogym Ecosystem for Immersive Experiences

/ENDURANCE SPORTSWIRE/ – Kinomap – the platform & community providing the largest library of video footage from real- world locations for virtual cardio workouts – is now fully integrated within the one-and-only Technogym Ecosystem. The open-platform nature of the Technogym Ecosystem means that it seamlessly combines Artificial Intelligence, on-demand content,...

Press Releases

Products

June 19, 2024

Norda Finally Reveals Its First Equipment Piece – The World’s Strongest And Lightest Duffel

/ENDURANCE SPORTSWIRE/ - After a quick teaser campaign, Canadian brand norda™reveals the world’s first duffel bag made entirely of Bio-Dyneema®, the world’s strongest and lightest fiber™ - the “norda™ Toolbox”. Use without caution. Having already disrupted the trail running industry since 2021 with the first shoe ever constructed with Bio-Dyneema®,...

Business

Press Releases

Products

Running

June 18, 2024

DIOZ Group Designs, Manufactures COPA América Apparel and Merchandise

BEVERLY HILLS, CA (June 18, 2024)/ENDURANCE SPORTSWIRE/ – The Dioz Group is excited to partner with the upcoming COPA América international soccer tournament, supplying all of the off-field apparel, merchandise and souvenirs. The month-long tournament begins June 20 in Atlanta and will be played across the United States culminating with the...

Press Releases

Products