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

January 22, 2025

Want to ride one of the top 25 rides in the world? Then you’ve got to ride the Marin Century

/ENDURANCE SPORTSWIRE/ - From challenging climbs to scenic coastal roads, participants can choose from five route options. The event is not only a celebration of cycling but also an opportunity to promote healthy living and showcase the beauty of Marin County. It is recognized by Outside Magazine as one of...

Cycling

Press Releases

Products

January 22, 2025

Reflo Introduces “Reloop” Sustainable Technology Into Teamwear to Radically Reduce Sportswear Waste

January 22, 2025 /ENDURANCE SPORTSWIRE/ - Reflo, the sustainable performancewear brand, has introduced its pioneering Reloop by Reflo technology to teamwear in a move set to redefine the sportswear industry. Recycled and recyclable, Reloop garments are crafted from 100% mono-fibre recycled materials, specifically designed to be recycled at the end...

Press Releases

Products

January 21, 2025

Expand Your 2025 Fitness Journey with Kinomap’s New Passport Feature

PARIS (January 21, 2025) /ENDURANCE SPORTSWIRE/ - Kinomap, the innovative and immersive training app for cycling, running, and indoor rowing, has introduced a new feature that will revolutionize your 2025 workouts: the Kinomap Passport. Designed to transform every training session into a global adventure, the Passport offers a unique blend...

Press Releases

Products

January 20, 2025

4iiii Expands Dual-Sided Power Meter Factory Install Program into Benelux, UK and Germany

COCHRANE, ALBERTA, January 20, 2025 /ENDURANCE SPORTSWIRE/ - 4iiii Innovations Inc., a global leader in cycling performance technology, is thrilled to announce the expansion of its Factory Install Program to Benelux, the UK, and Germany. Cyclists in these regions can now have a 4iiii dual-sided PRECISION 3+ PRO Powermeter locally...

Business

Cycling

Press Releases

Products

January 17, 2025

Mankerlight Unveils MK39 II: The Ultimate High-Performance Flashlight with Extreme Long-Range and Brightness

/ENDURANCE SPORTSWIRE/ - Mankerlight, a pioneer in advanced lighting solutions, proudly announces the launch of the MK39 II, a cutting-edge, high-performance flashlight that combines extreme long-range spotlighting with an incredibly bright floodlight. Engineered with the latest LED technology, a powerful 24,000mAh 4680 lithium battery, and a robust aluminum housing, the...

Press Releases

Products

January 16, 2025

Strong Girl Publishing Celebrates National Girls & Women in Sports Day with Inspiring Books for Young Athletes

January 16, 2025 /ENDURANCE SPORTSWIRE/ - With National Girls & Women in Sports Day (NGWSD) coming up on February 5, 2025, Strong Girl Publishing is ready to celebrate with our collection of empowering middle grade and young adult books featuring girls who love to play. As we approach the 39th...

Press Releases

Products

January 16, 2025

deboer releases the FJORD 3.1: A Sleeveless Wetsuit Revolutionizing Open Water Performance

Gran Canaria (January 16, 2025) /ENDURANCE SPORTSWIRE/ - deboer, a leading innovator in high-performance wetsuits, announces the launch of the FJORD 3.1, a sleeveless wetsuit engineered to redefine freedom and efficiency in the water. Building on the legacy of the acclaimed Fjord 3.0 and 4.0, the FJORD 3.1 incorporates the...

Press Releases

Products

Triathlon