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

October 31, 2024

Inaugural GFNY Bahamas this Sunday

New York City, October 31, 2024 /ENDURANCE SPORTSWIRE/ - This Sunday, Nassau, the vibrant capital of The Bahamas, will host the highly anticipated inaugural edition of GFNY Bahamas. Riders will take on a flat 60.8-mile course, offering a unique blend of challenge and stunning scenery. GFNY Bahamas will offer participants...

Cycling

Events

Press Releases

October 31, 2024

Missoula Marathon Announces Three-Year Partnership with New Title Sponsor, Young Mazda Missoula

Missoula, MT. /ENDURANCE SPORTSWIRE/ - The Missoula Marathon, renowned for its scenic course and vibrant community support, is excited to announce a three-year partnership with new title sponsor Young Mazda Missoula. This dynamic collaboration injects fresh energy into Montana’s iconic running event, solidifying Young Mazda Missoula as the official title...

Business

Press Releases

Running

Sponsorship

October 31, 2024

TREW Gear Brings “TREW To You” Film Project to Truckee, CA

Tahoe, CA /OUTDOOR SPORTSWIRE/ - TREW Gear is thrilled to announce the Tahoe, CA screening of TREW To You on Tuesday, November 5th, at the Tahoe Art Haus and Cinema. This unique film contest celebrates skiing and snowboarding communities across North America and brings their stories to life. TREW To...

Events

Press Releases

October 31, 2024

TREW Gear Brings “TREW To You” Film Project to Bozeman, MT

Portland, OR – /ENDURANCE SPORTSWIRE/ – TREW Gear is excited to announce the final screening of its TREW To You film contest tour in Bozeman, Montana, on Friday, November 8th, at the Emerson Theatre. This special event marks the culmination of a journey that has celebrated skiing and snowboarding communities...

Events

Press Releases

October 30, 2024

DATEV Challenge Roth Elevated To Platinum Tier For Professional Triathletes Organisation World Rankings

ROTH, GER / LONDON, UK /ENDURANCE SPORTSWIRE/ – The Professional Triathletes Organisation (PTO) and TEAMCHALLENGE are delighted to announce that the iconic DATEV Challenge Roth, known as the ‘Home of Triathlon’, has been elevated to Platinum status for the PTO’s 2025 World Ranking System. This prestigious recognition comes following a...

Business

Press Releases

Triathlon

October 30, 2024

Golden Gate Half Marathon Celebrates Fall Running Tradition with Local Brews at Finish Line

SAN FRANCISCO – October 30, 2024 /ENDURANCE SPORTSWIRE/ – The sold-out Golden Gate Half Marathon & 5k is proud to announce the return of San Francisco Brewing Co. as the Official Beer Sponsor for the 2024 event scheduled for this weekend on Sunday, November 3. All runners aged 21 and over will be...

Events

Press Releases

Running

Sponsorship

October 30, 2024

Norwegian Outdoor Brand Norrøna Announces Varg: A Luxury, Adventure Sail Yacht

OSLO, Norway (Oct. 30, 2024) /ENDURANCE SPORTSWIRE/ — Heritage Norwegian adventure and outdoor brand Norrøna is pleased to announce the expansion of its adventure travel offerings with the upcoming launch of the Varg sailing yacht in 2025. The luxury sailing yacht will bring outdoor enthusiasts to stunning, remote locations across...

Business

Press Releases

October 30, 2024

DPS and PHANTOM Glide Enlist Billy Demong for Product Development

SALT LAKE CITY (Oct. 30, 2024) /ENDURANCE SPORTSWIRE/ — PHANTOM Glide announces the hire of former World Cup Nordic Combined champion, Billy Demong, as head of strategic product development. Demong, who has been an active PHANTOM Glide tester since its invention more than seven years ago, will formally join fellow recent hire, Ted...

Business

Press Releases

Products

October 30, 2024

‘Hit Play Not Pause,’ the Ground-Breaking Podcast for Active Performance-Minded Menopausal Women Celebrates 200 Episodes

October 30th, /ENDURANCE SPORTSWIRE/ - Started in 2020, the Hit Play Not Pause podcast, hosted by Selene Yeager and produced by Feisty Media, released its 200th episode today. In that time, the pioneering show has reached over 2.9 million listeners and helped redefine the conversation around menopause. “I knew how...

Business

Press Releases

SWW Syndication