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

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

November 5, 2024

Polartec Shed Less Technology Debuts in Market with FORLOH

November 5th. Planet Earth, The Universe/ENDURANCE SPORTSWIRE/ - Polartec®, a Milliken & Company brand and the premium creator of innovative and more sustainable textile solutions, partners with elite USA-made hunting outfitter FORLOH to debut revolutionary Polartec® Shed Less technology. The advanced fabric launches to market in FORLOH's new Raider Vest,...

Business

Press Releases

Products

November 5, 2024

RunSignup Requests Nominations for 2025 Alan Jones Timer of the Year Award

Moorestown, NJ – November 5, 2024 /ENDURANCE SPORTSWIRE/ – RunSignup, the leading registration and technology provider for endurance events in the United States, is now accepting nominations for the 2025 Alan Jones Timer of the Year Award. In recognition of the remarkable efforts of race timers, this award honors those...

Awards

Business

Events

Press Releases

Running

Triathlon

November 5, 2024

Project:Moonshot

/ENDURANCE SPORTSWIRE/ - CUORE of Switzerland and VORTEQ Sports Limited are thrilled to unveil their collaboration on Project:Moonshot, a pioneering partnership dedicated to developing the world’s fastest and most efficient triathlon speed suits. By merging F1-level aerodynamics, advanced textile technology, and superior fabrication, this collaboration is set to revolutionize performance...

Business

Press Releases

Products