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

January 26, 2024

Showcased

Quintana Roo debuts V-PRi Flagship Triathlon Bike

Chattanooga, TN /ENDURANCE SPORTSWIRE/ - The pursuit of perfection doesn’t stop for any triathlete — against the clock, against competition, toward personal glory. At Quintana Roo, this pursuit has been a constant for decades. We design, develop and bring to market bikes that represent the best in aerodynamic efficiency, weight...

Cycling

Press Releases

Products

Triathlon

January 26, 2024

Celebrate the 40th Anniversary of the Boulevard Road Race Est. 1984

San Diego, CA – January 25, 2024 /ENDURANNCE SPORTSWIRE/ - KOZ Events, is thrilled to announce the much-anticipated 40th anniversary of the Boulevard Road Race. Set against the breathtaking backdrop of San Diego County's backcountry, this legendary event will unfold on Saturday, May 11, 2024, promising an unforgettable blend of...

Cycling

Press Releases

January 26, 2024

RunSignup Image Gallery to Release in February with Race Websites V2

Moorestown, NJ /ENDURANCE SPORTSWIRE/ - RunSignup, the leading registration and technology provider for races in the U.S, announces the release of Image Gallery with the beta release of Race Websites V2 in February. Image Gallery, already a part of RunSignup’s Email V2, is a powerful way to use, manage, and...

Events

Press Releases

Products

Running

Triathlon

January 26, 2024

Challenged Athletes Foundation Rolls Out Five Top-Notch Cycling Experiences in 2024 to Raise Crucial Funds for Athletes with Physical Disabilities

SAN DIEGO, CA. /ENDURANCE SPORTSWIRE/ - Celebrating its 30th anniversary of empowering individuals through sports, the Challenged Athletes Foundation (CAF) proudly announces the launch of the 2024 CAF Cycling Challenge, a series of first-class riding experiences that embody inclusivity, celebrate community, and provide hope and inspiration for athletes with physical...

Cycling

Giving

OSW Syndicated

Press Releases

January 26, 2024

Track Shack Partners With Brooks to Host Group Run Ahead of Trials Weekend

ORLANDO, Fla. /ENDURANCE SPORTSWIRE/ - Track Shack, an Orlando-based specialty running retail store and producer of notable running events, is hosting a group run in partnership with Brooks and Ivanhoe Park Brewing Company ahead of the Marathon Trials and the Orlando Magic 5K, 1 Mile & Kids’ Run. The run...

Events

Press Releases

Running

January 26, 2024

US Trail Running Conference Announces Enhanced Free Webinar Series

/ENDURANCE SPORTSWIRE/ - US Trail Running Conference organizers announce that the popular webinar series for race directors and event organizers returns in 2024 with a new name. The series will now be known as the RD Master Class Series, and will start in February and run through September with 9...

Press Releases

Running

Trade Shows

January 26, 2024

Inspired by Elite Road Runners, HydraPak Launches Tempo Squeeze Bottle to Support Hydration Strategies

OAKLAND, Calif. (Jan. 26 , 2024) /ENDURANCE SPORTSWIRE/ - HydraPak®, global leader of high-performance hydration solutions, today launched its Tempo squeeze bottles, a durable, ergonomic product collection designed to help runners build effective hydration strategies. Influenced by the fueling habits and product preferences of top marathoners, HydraPak created the Tempo...

Press Releases

Products

January 25, 2024

RaceTimes Magazine launches RaceTimes Dash Email Column

St. Louis MO/ ENDURANCE SPORTSWIRE/ - RaceTimes Magazine proudly announces that Hilary JM Topper joined us as a columnist for our new email column, RaceTimes Dash. This new column will launch the first week of February 2024 and be emailed to more than 760,000 subscribers: endurance sport enthusiasts, runners, cyclists,...

Business

Cycling

Press Releases

Running

Triathlon

January 25, 2024

Explore Orange County While Pedaling For a Cause at Tour de Saddleback

IRVINE, Calif. /ENDURANCE SPORTSWIRE/ – The Tour de Saddleback returns for its annual event and will be offering 50, 35 and 15-mile ride options through scenic parts of Orange County. Participants have the opportunity to ride through seven different communities and cities, including Laguna Hills, Santiago Canyon, Rancho Santa Margarita and...

Cycling

Events

Giving

Press Releases