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 (16)
) 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 170, 10

October 17, 2024

LA Tri-Series Offers Turkey Tri Option Going Into Thanksgiving Week

LOS ANGELES, Calif. /ENDURANCE SPORTSWIRE/ – The LA Tri-Series will be hosting its third and final event of the series on Nov. 24. The third race, referred to as the Turkey Tri, is the only triathlon happening in California as Thanksgiving week kicks off. The event stands out in the landscape...

Events

Press Releases

Triathlon

October 16, 2024

Snowbound Expo, New England’s Biggest Ski & Snowboard Show, Returns to Boston with All-Star Lineup of Speakers, Experiences and Gear for the 24/25 Season

Boston, MA, /ENDURANCE SPORTSWIRE/ – Snowbound Expo, the leading annual event for winter sports enthusiasts, will return to Boston on November 15-17, 2024 bringing together thousands of skiers, snowboarders, outdoor enthusiasts and families from New England to kick off the winter season. Attendees will have the opportunity to explore more than...

Events

OSW Syndicated

Press Releases

October 16, 2024

New US race: Michelob Ultra GFNY Pittsburgh-Monroeville on September 21, 2025

NEW YORK CITY, October 16, 2024 /ENDURANCE SPORTSWIRE/ - GFNY Global Endurance Sports Series adds a new race to the GFNY USA series: Michelob Ultra GFNY Pittsburgh - Monroeville, scheduled for September 21, 2025. The competitive long distance is 70 miles long with 7756 ft of climbing, making it the hardest...

Cycling

Events

Press Releases

October 16, 2024

Showcased

Belgian Waffle Ride Expands with the Quad-Tripel Crown of Gravel Series and New Events in 2025, Registration Open Now!

Del Mar, CA – [October 16, 2024] /ENDURANCE SPORTSWIRE/– The Belgian Waffle Ride (BWR) continues to redefine gravel cycling in 2025 with the launch of the Quad-Tripel Crown of Gravel Series and a thrilling new venue for the legendary Belgian Waffle Ride California (BWR CA) at the breathtaking Del Mar Polo Fields. This iconic...

Business

Cycling

Events

Giving

Press Releases

Products

Sponsorship

October 16, 2024

Gran Fondo National Series Opens 2025 Registration

(Gettysburg, PA – October 16, 2024) /ENDURANCE SPORTSWIRE/- Founded in 2012 by event director Reuben Kline, the Gran Fondo National Series is the largest and most competitive series of gran fondo cycling events in the United States. Registration for the six Series-owned events is open, along with registration for the...

Business

Cycling

Events

Press Releases

October 16, 2024

Charles Costa, UK Musician Formerly Known as King Charles, Completes 90 Marathons in 90 Days Challenge and Releases First Single Off New Album

San Diego, CA. (October 16, 2024) /ENDURANCE SPORTSWIRE/ — Today, Charles Costa, a UK musician formerly known as King Charles, is completing 90 marathons in 90 days along the PCT, and releasing his first single titled “Nothing at the Most” off his new self-titled album. Ten years ago, a skiing...

Events

Giving

Press Releases

Running

October 16, 2024

Showcased

Order Up- Tough Mudder To Partner With In-N-Out Burger For a Joint Obstacle Course Event in Big Bear

CALIFORNIA /ENDURANCE SPORTSWIRE/ - Two iconic brands collide for one incredible event as In-N-Out Burger unveils plans to host a custom Tough Mudder event in September 2025. The globally renowned obstacle course brand has announced today a deal that will see the team facilitate a first-of-its-kind custom event for California's...

Events

Press Releases

Running

Sponsorship