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

November 11, 2024

FasCat now Connects Directly to Zwift

BOULDER, CO, NOV. 11, 2024 /ENDURANCE SPORTSWIRE/ - Cyclists who use the CoachCat app for training can now send workouts directly to Zwift, the #1 cycling app. Similarly, rides, races and workouts completed on Zwift will sync directly to CoachCat for analysis and coaching. CoachCat is the first hardware-agnostic AI...

Business

Cycling

Press Releases

Products

November 8, 2024

Sumarpo Brings Sustainable Triathlon Gear to ISPO Munich 2024

Sumarpo Brings Sustainable Triathlon Gear to ISPO Munich 2024 November 8th. /ENDURANCE SPORTSWIRE/ - Sumarpo is excited to announce its participation at ISPO Munich 2024, from December 3-5, where it will unveil a new line of triathlon gear crafted with a 100% eco-friendly approach. As a trailblazer in sustainable water...

Business

Press Releases

Trade Shows

November 7, 2024

Shop Women-Led Wednesday To Support Women In Business This Spending Season

Sun Valley, ID (Nov. 7, 2024) /ENDURANCE SPORTSWIRE/ - Women-Led Wednesday, the annual purpose-driven holiday that urges the public to shop women-led businesses, returns for the seventh year, calling on consumers to be mindful of their purchasing power leading up to popular eCommerce holidays like Black Friday and Cyber Monday....

Business

Events

Press Releases

Products

November 6, 2024

Wattbike appoints new Commercial Sales Director to drive global health club expansion

/ENDURANCE SPORTSWIRE/ - With over 25 years of experience working with industry giants such as Life Fitness, Fitness First, Ezdihar Sports, and LA Fitness, Sam brings a deep understanding of the fitness sector and a wealth of international connections. His extensive expertise in managing major international accounts and fostering strategic...

Business

Cycling

Press Releases

Products

November 6, 2024

Tough Mudder UK Wraps Up an Epic 2024 Season with Mud, Milestones, and Unforgettable Moments

November 6th. /ENDURANCE SPORTSWIRE/ - Tough Mudder UK is celebrating the close of another electrifying season, filled with incredible camaraderie, heart-pounding obstacles, and unforgettable memories. From mud-soaked courses to finish line proposals, the 2024 season saw over 80,000 mudders push themselves to the limit and conquer the ultimate tests of...

Business

Events

Press Releases