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 (8742)
) 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 460, 10

November 12, 2024

FinisherPix announced as official photography partner for the Denver Colfax Marathon, the largest marathon weekend in the Rocky Mountain Region

BOULDER, CO. /ENDURANCE SPORTSWIRE/ - FinisherPix, the premier provider of endurance sports photography, is thrilled to announce its latest partnership with the Denver Colfax Marathon, the largest marathon weekend in the Rocky Mountain Region. The Denver Colfax Marathon includes eight races over two days with 25,000 runners and a two-day...

Press Releases

Sponsorship

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 12, 2024

Short and Long Course Athletes to Go Head to Head at Challenge Canberra

/ENDURANCE SPORTSWIRE/ - Challenge Canberra is delivering a full festival of sport to Australia’s capital city this weekend, 16/17 November, with no less than six event over two days, including the Pro Open combining the Standard and Sprint distances, and age group worlds qualifying events. The Pro Open will be...

Events

Press Releases

Triathlon

November 12, 2024

Track Shack and AdventHealth Team Up to Champion Wellness and Help the Community Feel Whole

Orlando, FL. /ENDURANCE SPORTSWIRE/ - In a landmark announcement, Track Shack Events, the driving force behind the iconic Corporate 5k, and AdventHealth reveal a strategic partnership for Orlando’s largest workplace wellness initiative. This collaboration ushers in a new era for the event, now officially named the AdventHealth Corporate 5k happening...

Press Releases

Running

Sponsorship

November 12, 2024

JOIN Cycling App Announces Seamless Integration with Zwift Through New Zwift Link API Implementation

(AMSTERDAM, NETHERLANDS, 12 November 2024] /ENDURANCE SPORTSWIRE/ - JOIN, the leading online platform for cycling training content, today announced a major platform update featuring complete integration with Zwift through their newly implemented API, Zwift Link. This development marks a significant step forward in making structured training more accessible and enjoyable...

Cycling

Press Releases

Products

November 11, 2024

Pike on a Bike: Pi Kapa Alpha Fraternity Brothers Complete 8,423 Minutes Stationary Bike Ride, Raising $48,318 in Honor of The 8,423 Cyclists and Pedestrians Killed Last Year By Riders

November 11th. /OUTDOOR SPORTSWIRE/ - BOULDER, CO — In a powerful demonstration of endurance and purpose, Pi Kappa Alpha fraternity brothers completed an extraordinary 8,423-minute stationary bike ride – one minute for every cyclist and pedestrian killed on U.S. roads in 2023. Their wheels never stopped turning during the six-day...

Cycling

Events

Giving

Press Releases

November 11, 2024

The Monterey Bay Half Marathon Welcomes 8,000+ Runners for Its 19th Presentation

November 11th. /ENDURANCE SPORTSWIRE/ - MONTEREY, CA – The 19th Annual Monterey Bay Half Marathon, which took place on Sunday, November 10th, welcomed its largest field of participants in seven years to enjoy the dramatic beauty of the central coast. Race weekend included a two-day expo in downtown Monterey, the...

Events

Press Releases

Running

November 11, 2024

Challenge Family World Bonus Top Placings Decided at Challenge Xiamen

November 11th. /ENDURANCE SPORTSWIRE/ - After a thrilling day’s racing at yesterday’s Challenge Xiamen, it’s all change in the Challenge Family World Bonus, with Jack Moody (NZL) and Alanis Siffert (SUI) now confirmed as unbeatable for 2024. While the winning titles of the inaugural Challenge Xiamen were being contended, there...

Events

Press Releases

Triathlon

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