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

September 9, 2024

Blue skies, large fields and record crowds mark 20th Anniversary Bucks County Classic

Doylestown, PA September 9, 2024/ENDURANCE SPORTSWIRE/ – After consecutive years of rain all were hopeful that the milestone 20th Anniversary Bucks County Classic would be accentuated with the predictions of sun and ideal racing weather. With a rainy setup the night before race day some had started preparing for a...

Cycling

Events

Press Releases

September 9, 2024

Pensacola Beach’s famed open-water swimming event back for 2025

Pensacola, FL (Sept. 9, 2024)/ENDURANCE SPORTSWIRE/ – Registration is now open for the storied Deluna’s Open Water Swim, On Saturday, April 12, Pensacola Beach will be awash with swimmers and firefighters from all over the country as they come to compete in two separate events on the island. The event this...

Events

Press Releases

September 9, 2024

Double Bridge Run registration open

Pensacola, FL (Sept. 9, 2024)/ENDURANCE SPORTSWIRE/ – Runner registration for the 2025 Pensacola Double Bridge Run presented by Publix is now open. The race, limited to 4,000 runners, is a local favorite that draws runners from all over the U.S. Dubbed “the race with a view,” the Pensacola Double Bridge Run...

Events

Press Releases

Running

September 9, 2024

Challenge Family Announces First for Middle East with Challenge Sir Bani Yas

9 September 2024. /ENDURANCE SPORTSWIRE/ – Global triathlon series, Challenge Family, has today announced Challenge Sir Bani Yas on 3-7 April 2025, marking the arrival of the Middle East’s first long distance triathlon over 226km with a 3.8km swim, 180m bike and 42.2km, alongside a middle distance option (1.9km swim,...

Events

Press Releases

Triathlon

September 9, 2024

Run Austin® Kickoff Week Brings a Week of Prizes and Running Excitement

Austin, TX - September 9, 2024 /ENDURANCE SPORTSWIRE/ - Run Austin® Kickoff Week is not just about the start of training for the two most exciting running events in Austin - it’s a celebration of the running community’s energy, camaraderie, and the thrill of winning exciting prizes! From September 9th...

Events

Press Releases

Running

Sponsorship

September 9, 2024

RBC GranFondo Whistler Celebrates a Record-Breaking 15th Anniversary Event

Vancouver/Whistler [Sept 7, 2024] /ENDURANCE SPORTSWIRE/ - The RBC GranFondo Whistler celebrated its 15th anniversary this Saturday with industry-leading participation and an unprecedented five-day celebration of cycling. The event, held on September 7, brought together 5,245 registered cyclists from around the world and an estimated 14,000+ combined riders and spectators, underscoring...

Cycling

Events

Press Releases

September 9, 2024

Taylor Knibb And Sam Long Headline US Pro Triathletes Competing At Inaugural Lake Las Vegas T100

Las Vegas, Nevada/ENDURANCE SPORTSWIRE/ – World #1 Taylor Knibb and World #3 Sam Long will spearhead the USA’s leading professional triathletes competing against the best in the world at the inaugural Lake Las Vegas T100 Triathlon on October 19-20. Lake Las Vegas is the sixth stop on the Professional Triathletes Organisation’s (PTO)...

Events

Press Releases

Triathlon

September 8, 2024

Blummenfelt Sets New Course Record, Madsen Dominates at Challenge Samarkand 2024

/ENDURANCE SPORTSWIRE/ - Kristian Blummenfelt (NOR) and Laura Madsen (DEN) secured decisive victories in the men’s and women’s pro races. Perfect conditions and the historic Silk Road greeted the world class field at the second edition of Challenge Samarkand. The race began with the 1.9km swim in the pristine, purpose-built...

Events

Press Releases

Triathlon

September 6, 2024

The Music Run To Make Its Dubai Debut At T100 Triathlon Festival

London, UK/ENDURANCE SPORTSWIRE/ – The Professional Triathletes Organisation (PTO) has announced that the world-renowned fun run series, The Music Run, is set to make its debut in the region as part of the Dubai T100 Triathlon weekend on Saturday 16 November 2024. Bringing its blend of music, fitness, and entertainment to...

Events

Press Releases

Running

Triathlon