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

July 28, 2025

Showcased

Have you ever ridden One of the Top 25 Rides in the World?

July 28, 2025 /ENDURANCE SPORTSWIRE/ – From challenging climbs to scenic coastal roads, participants can choose from five route options. The event is not only a celebration of cycling but also an opportunity to promote healthy living and showcase the beauty of Marin County. It is recognized by Outside Magazine...

Cycling

Events

Press Releases

SWW Syndication

July 27, 2025

The 48th San Francisco Marathon Celebrates 33,000 Runners, Sold Out Full Marathon and Epic Finishers

San Francisco, CA – [July 27, 2025] /ENDURANCE SPORTSWIRE/ - Today, the San Francisco Marathon announced the successful conclusion of the 2025 event. The event, which saw over 33,000 registrations from all 50 states and numerous countries, underscored the vibrant spirit of the running community and the enduring appeal of...

Events

Press Releases

Running

July 27, 2025

Volár and de Boer Take 10th Anniversary Victories at Challenge Turku

/ENDURANCE SPORTSWIRE/ - Challenge Turku celebrated it's 10th anniversary edition with Jan Volár  (CZE) securing the first professional win of his career in 3:49:37 and Marlene de Boer dominating the women's field, taking the title in 4:05:48. As the men exited the water, surrounded by the historic ships that make this...

Events

Press Releases

Triathlon

July 27, 2025

Sam Appleton (AUS) and Paula Findlay (CAN) Earns Wins at the return of the IRONMAN 70.3 Boise triathlon

BOISE, Idaho /ENDURANCE SPORTSWIRE/ - The City of Trees provided a picturesque backdrop for the return of the IRONMAN® 70.3® Boise triathlon on Sunday. Sam Appleton (AUS) took the overall win in the men’s race with a finishing time of 03:40:33, while Paula Findlay (CAN) topped the podium in the...

Events

Press Releases

Triathlon

July 25, 2025

For the First Time in History: The 48th San Francisco Marathon Full Marathon Race Sells Out

SAN FRANCISCO, CA (July 25, 2025) /ENDURANCE SPORTSWIRE/ – The San Francisco Marathon today announced that its iconic full marathon race has officially sold out, marking a historic first in the event's long-standing history. This unprecedented achievement underscores the growing popularity of the race and its unique appeal to runners worldwide....

Events

Press Releases

Running

July 24, 2025

Hemingway 5K Sunset Run Returns To Key West This Weekend

KEY WEST, Fla. (July 24, 2025) /ENDURANCE SPORTSWIRE/ — On July 26, the 36th edition of the Hemingway 5K Sunset Run will return as part of Key West’s annual Hemingway Days celebration. The festival, which takes place each July, salutes the life and work of the author who lived and...

Events

Press Releases

Running

July 24, 2025

GFNY France-Orcières in the Haute Alpes this Sunday

New York City, July 24, 2025 /ENDURANCE SPORTSWIRE/ - This Sunday, the alpine village of Orcières Merlette will host GFNY Orcières which offers riders a 158 km long course with a whopping 4,461 meters of elevation gain. Nestled in the stunning Champsaur Valley in the French Hautes-Alpes, Orcières Merlette sits...

Cycling

Events

Press Releases

July 24, 2025

PRRO Circuit 2025-26 Season Opens at Quad-City Times Bix 7

BETHESDA, MD (July 24, 2025) /ENDURANCE SPORTSWIRE/– The PRRO Circuit, America’s Classic Road Races™, will open its 2025-26 season at the 51st Quad-City Times Bix 7 on Saturday morning, July 26 in Davenport, IA. Like past editions, a world class field, including defending champions Wesley Kiptoo of Kenya and Rachael...

Events

Press Releases

Running