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 (11)
) 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 290, 10

June 11, 2024

Jetboil® Embarks on Adventure with Bound For Nowhere Partnership

June 11, 2024 -- Racine, WI /ENDURANCE SPORTSWIRE/ - Jetboil®, the #1 choice of backpackers, campers, and adventurers*, proudly unveils its collaboration with the renowned adventurers behind Bound For Nowhere, MAK and Owen. This first-of-its-kind partnership from Jetboil includes sponsorship of the couple’s latest film, “Press On: A High Sierra...

Business

Press Releases

June 11, 2024

New Anthony Walsh Podcast launches – featuring John McAvoy, Valtteri Bottas, and Prof. Ian Robertson

Tuesday, 11th June 2024 /ENDURANCE SPORTSWIRE/ – Anthony Walsh, the podcast’s creator and host, brings a wealth of experience from his diverse background. After qualifying as a barrister he quickly discovered the legal profession wasn’t his true calling, and set out to pursue a career in professional cycling. His cycling...

Business

Cycling

Press Releases

Running

Triathlon

June 11, 2024

Jetboil® Embarks on Adventure with Bound For Nowhere Partnership

June 11, 2024 -- Racine, WI /ENDURANCE SPORTSWIRE/ - Jetboil®, the #1 choice of backpackers, campers, and adventurers*, proudly unveils its collaboration with the renowned adventurers behind Bound For Nowhere, MAK and Owen. This first-of-its-kind partnership from Jetboil includes sponsorship of the couple’s latest film, “Press On: A High Sierra...

Business

Press Releases

Products

Sponsorship

June 11, 2024

TrainingPeaks and Fast Talk Laboratories Partner to Offer Free Business of Coaching Courses through TrainingPeaks University

June 11, 2024 – Boulder, Colorado, USA /ENDURANCE SPORTSWIRE/ - TrainingPeaks and Fast Talk Laboratories have partnered to offer two free courses on The Business of Coaching through TrainingPeaks University. Adapted from The Craft of Coaching with Joe Friel, these two online education courses will help coaches to set up...

Business

Cycling

Press Releases

Products

Running

Triathlon

June 11, 2024

Introducing GranFondo Riviera Nayarit

Riviera Nayarit, Mexico /ENDURANCE SPORTSWIRE/ - Cycling enthusiasts around the globe have a new reason to celebrate. The team behind the world-renowned RBC GranFondo Whistler is proud to announce the launch of GranFondo Riviera Nayarit, set to take place on April 5, 2025, in the stunning region of Riviera Nayarit, Mexico....

Business

Cycling

Events

Press Releases

June 10, 2024

Shimano Returns as Official Technical Support Partner for 2024 Chicago Grit

Chicago, IL – June 10, 2024 /ENDURANCE SPORTSWIRE/ - Chicago Grit, formerly known as the Intelligentsia Cup, is proud to announce that Shimano is returning as the Official Technical Support Partner for the 2024 race series. This marks Shimano's fourth year in this critical role, underscoring their unwavering dedication to...

Business

Cycling

Events

Press Releases

Products

Sponsorship

June 10, 2024

GOREWEAR Introduces New Ultimate Bib Short as Its Premium Cycling Apparel

Elkton, MD (June 10, 2024) /ENDURANCE SPORTSWIRE/ - GOREWEAR, the leading innovator in high-performance running and cycling apparel, announces the newest addition to its cycling collection, the Ultimate Bib Shorts+. The Ultimate Bib Shorts+ are intended for the most demanding road and gravel rides featuring a custom-designed, multi-layer 3D printed...

Business

Cycling

Press Releases

Products

Triathlon

Wire Syndication