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

November 12, 2024

Smash Your Fitness Launches With Nearly Unlimited Routes for Gamified Fitness Fun

TUCSON, AZ, Nov. 12, 2024 /ENDURANCE SPORTSWIRE/ - Launching Friday, the fitness gaming app Smash Your Fitness makes indoor cycling irresistibly fun by transporting cyclists to a near-limitless number of richly immersive worlds, multiple gaming modes – workouts, tours, races, and training programs – and a range of interactivity options...

Business

Cycling

Press Releases

Products

November 12, 2024

Silverback celebrates a record breaking 6 months producing and supporting major live events in San Francisco and abroad.

San Francisco, California (November 12, 2024) /ENDURANCE SPORTSWIRE/ - Silverback, a west-coast leader in large-scale production and event management closes out the third quarter supporting 20 clients and over 1,500,000 participants, attendees and spectators across the last 6 months of unique and iconic events. The dynamic SF based production agency...

Business

Events

Press Releases

Running

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