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

July 29, 2024

Last Chance to Sign Up for the Paris 2024 connected Marathon Pour Tous in Conjunction with the 2024 Summer Olympic Games

Paris, France /ENDURANCE SPORTSWIRE/ – Time is running out for those eager to participate in the Paris 2024 connected Marathon For All (or as they say in Paris, Marathon Pour Tous), an extraordinary virtual event happening alongside the 2024 Paris Summer Olympic Games. This is your final opportunity to join...

Events

Press Releases

Products

July 28, 2024

Laidlow Wins London T100 Triathlon to Prove He’s Very Much Still Around

London, UK /ENDURANCE SPORTSWIRE/ - Sam Laidlow claimed his first T100 win and then let out a roar of relief that echoed all around a jumping ExCel Centre in London this afternoon. It was a very emotional victory for the Frenchman, who has had to deal with a challenging season...

Business

Cycling

Events

Press Releases

Products

Running

Trade Shows

Triathlon

July 24, 2024

Nix Biosensors Integrates with TrainingPeaks for Seamless Hydration Monitoring

BOSTON, MASS — July 24, 2024 /ENDURANCE SPORTSWIRE/ - Nix Biosensors, the leading provider of cutting-edge hydration monitoring technology, is proud to announce its latest integration with TrainingPeaks, the world's most popular training and coaching platform for endurance athletes. This strategic partnership solidifies Nix's commitment to partnering with industry leaders...

Cycling

Press Releases

Products

Running

Triathlon

July 23, 2024

Alive in Death Valley: A Collaboration to Survive The World’s Toughest Foot Race

Melbourne, Victoria (July 22, 2024) /ENDURANCE SPORTSWIRE/ - Australian brand, 2XU, the global leader in compression apparel, and Los Angeles-based District Vision have collaborated on a new limited edition collection inspired by the Badwater 135 ultramarathon. The collaboration features three outfits from 2XU matched with a pair of ultra lightweight...

Business

Press Releases

Products

Running

Wire Syndication

July 20, 2024

SylvanSport Celebrates 20 Years of Innovating Camping Experiences with Micro Adventure Series

Brevard, NC – July 20, 2024 /ENDURANCE SPORTSWIRE/ – SylvanSport, the Brevard, NC-based innovator and manufacturer of renowned adventure travel trailers, pop-up campers, rooftop tents, and outdoor gear, celebrates its 20th anniversary with the launch of its latest product line, the 2025 Micro Adventure Series (MAS). Maintaining the brand’s commitment to...

Press Releases

Products

July 18, 2024

BOA Fit System Proven to Enhance Cycling Footwear Performance

Denver, CO (July 18, 2024)/ENDURANCE SPORTSWIRE/ – BOA® Technology, the creators of the award-winning patented BOA® Fit System, partners with leading brands to create high performance fit solutions that enable the world’s best athletes in Cycling, Snow, Athletic, and Outdoor sports to get dialed in and perform at their peak....

Business

Cycling

Press Releases

Products