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

October 17, 2024

World’s Best Triathletes Ready To Roll The Dice At Lake Las Vegas T100 Triathlon

/ENDURANCE SPORTSWIRE/ - Lake Las Vegas, Nevada: The world’s best triathletes are ready to take on a challenging Lake Las Vegas T100 Triathlon 100km course this Saturday as the T100 Triathlon World Tour reaches its penultimate race in the 7-leg series. American favorites Jackie Hering, Chelsea Sodaro and Jason West...

Events

Press Releases

Triathlon

October 17, 2024

Ahead of another GFNY Super Sunday

/ENDURANCE SPORTSWIRE/ - The 5th Michelob Ultra GFNY Florida Sebring offers riders a flat and fast 95-mile cycling long course. The main challenges are length and race speed, making GFNY Sebring the hardest race in Florida. From the Barn at Paso Fino, the race enters the closed to traffic Highway...

Cycling

Events

Press Releases

October 17, 2024

Santa Barbara Half Marathon Announces Multi-Year HOKA Partnership

SANTA BARBARA, Calif. /ENDURANCE SPORTSWIRE/ - The 2024 Santa Barbara Half Marathon presented by HOKA & UCLA Health 5K, which impressively grew from 2,000 participants in 2021 to 6,000 in 2023, announces and warmly welcomes partnership renewals with companies with deep ties to Southern California and the local community. “We...

Events

Press Releases

Running

Sponsorship

October 17, 2024

12th Consecutive Sellout for the CNO Financial Indianapolis Monumental Marathon

INDIANAPOLIS, /ENDURANCE SPORTWIRE/ – The CNO Financial Indianapolis Monumental Marathon – the 15th largest marathon in the United States and the biggest in Indiana – has sold out the full marathon distance for the 12th consecutive year, earlier than ever. The 2024 CNO Financial Indianapolis Monumental Marathon Race Weekend will...

Events

Press Releases

Running

October 17, 2024

Tempo Launches Innovative Bike Theft Protection Service

SAN FRANCISCO, CA /ENDURANCE SPORTSWIRE/ - Tempo, the leading peace-of-mind service for bike and ebike owners, today announced the launch of its new Theft Protection offering. This innovative product and service combines deterrence, recovery assistance, and financial protection to give cyclists unprecedented security. Tempo's Theft Protection product includes: Unique security...

Cycling

Press Releases

Products

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

BUFF® Partners with Protect Our Winters and Artist Kate Zessel to Champion Climate Action

Santa Rosa, CA (October 16,  2024) /ENDURANCE SPORTSWIRE/ - BUFF®, a world leader in headwear and neckwear for outdoor enthusiasts, is thrilled to announce its 7th year of collaboration partnership with Protect Our Winters (POW), a movement empowering outdoor lovers to become climate champions. This season’s collaboration capsule aims to...

Business

Giving

Press Releases

Products

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