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

July 30, 2024

All-Star Field and $100,000 Prize Purse Confirmed for Challenge Beijing

/ENDURANCE SPORTSWIRE/ – Challenge Family’s newest event, Challenge Beijing in China, has confirmed a US$100k prize purse with a world-class field of professional athletes already secured to attend the non-drafting Olympic distance race on 8 September. Among those racing is top-ranked New Zealand athlete, Kyle Smith, winner of The Championship...

Events

Press Releases

Triathlon

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

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 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

July 28, 2024

Results Of San Francisco Marathon 2024 Ultra and Full Marathon Divisions

San Francisco, CA - July 28, 2024 /ENDURANCE SPORTSWIRE/ - The San Francisco Marathon released official results of the ultra and full marathon divisions from the July 27 - 28, 2024 top races. Thousands of runners took to the streets to run some of the most incredible San Francisco histroical...

Events

Press Releases

Running

July 28, 2024

Mcfly’s Harry Judd Headlines London T100 Triathlon Amateur Races

London, UK /ENDURANCE SPORTSWIRE/ - Mcfly drummer Harry Judd, singer Tom Grennan, international marathon runner Anya Culling, autistic Guinness World Record Triathlete Sam Holness, influencer Tom Trotter and Dr Hussain Al-Zubaidi, a doctor and lifestyle coach, were amongst 4,500 amateur triathletes in the capital this morning taking on the London T100...

Business

Cycling

Events

Press Releases

Running

Sponsorship

Trade Shows

Triathlon