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

July 30, 2024

Lake Sonoma Race Series Honors Local Firefighters with New 100 Mile Event in 2025

/ENDURANCE SPORTSWIRE/ – The Lake Sonoma Race Series (LSRS) proudly announces the inaugural Lake Sonoma 100-mile race, scheduled for February 1, 2025. The race will be dedicated to Northern Sonoma County Fire (formerly known as the Geyserville Fire Department) who has confronted ongoing challenges posed by the many wildfires of...

Events

Press Releases

Running

July 30, 2024

Iden and Agnew Take Wins at Challenge Turku

/ENDURANCE SPORTSWIRE/ - Gustav Iden recorded his first victory of the season today in a thrilling race at Challenge Turku. In the women's race, no one was strong enough to keep an unleashed Milan Agnew from her first professional win. After the swim, it was Henry Räppo (EST) who led...

Events

Press Releases

Triathlon

July 29, 2024

Charles Costa, UK Musician to Run 90 Marathons in 90 Days Along the PCT to Raise Awareness for Mental Health

Seattle, WA. (July 29, 2024) /ENDURANCE SPORTSWIRE/ – Charles Costa, a UK based musician formerly known as King Charles, is on a mission to run 90 marathons in 90 days along the Pacific Crest Trail. Costa is running to support the invaluable work carried out by The Jed Foundation, a...

Giving

OSW Syndicated

Press Releases

Running

July 29, 2024

Long Beach Legacy Triathlon Records Incredible Numbers In supertri’s First Year

/ENDURANCE SPORTSWIRE/ – Long Beach Legacy Triathlon is now one of the fastest growing triathlons in the US after supertri’s first year of operating the event saw entry numbers soar and more than $600,000 raised for Children’s Hospital Los Angeles (CHLA). supertri are operating the event in California and partnering...

Events

Giving

Press Releases

Triathlon

July 29, 2024

Last Chance to Sign Up for the Paris 2024 connected Marathon Pour Tous in Conjunction with the 2024 Summer Olympic Games

Paris, France /ENDURANCE SPORTSWIRE/ – Time is running out for those eager to participate in the Paris 2024 connected Marathon For All (or as they say in Paris, Marathon Pour Tous), an extraordinary virtual event happening alongside the 2024 Paris Summer Olympic Games. This is your final opportunity to join...

Events

Press Releases

Products

July 29, 2024

PeopleForBikes Announced as Gran Fondo National Series’ Advocacy and Philanthropy Partner

(Gettysburg, PA ) /ENDURANCE SPORTSWIRE/ - Gran Fondo National Series today announced that PeopleForBikes will be the organization's Advocacy and Philanthropy Partner for 2024 and beyond. Series participants will have opportunities to donate to PeopleForBikes initiatives, and the two organizations intend to work together to raise awareness of the importance...

Business

Cycling

Events

Press Releases

Sponsorship

July 29, 2024

World’s Toughest Mudder 2025 Is Coming to the UK

29th July, 2024 /ENDURANCE SPORTSWIRE/ - For the first time ever, World’s Toughest Mudder, will be descending on European shores, as the pinnacle of obstacle course events debuts in the UK. Coming from its usual location in the U.S., this event is not for the faint of heart. It is the...

Events

Press Releases

July 29, 2024

Scott USA Appoints Jake Dudek as New Chief Operating Officer

Salt Lake City, Utah July 26th, 2024 /ENDURANCE SPORTSWIRE/ - SCOTT USA, the American subsidiary of SCOTT, today announced the appointment of Jake Dudek as the company's new Chief Operating Officer, effective immediately. Dudek brings over 15 years of diverse experience in operations, finance, and analytics in consumer product and...

Business

Press Releases

July 28, 2024

More than 300 Racers Cross Finish Line at Iconic Life Time Leadville Stage Race presented by Kenetik

Leadville, CO., (July 28, 2024) /ENDURANCE SPORTSWIRE/ - The Leadville Race Series continued this weekend with the Life Time Leadville Stage Race Presented by Kenetik. Owned and produced by Life Time (NYSE: LTH), the three day event tackles the iconic Life Time Leadville Trail 100 MTB course over three days,...

Cycling

Events

Press Releases