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

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

Ultimate Sport Service and MYLAPS join forces

NYBORG / HAARLEM (September 2024)/ENDURANCE SPORTSWIRE/ – Ultimate Sport Service and MYLAPS Sports Technology announce a strategic partnership. The companies, based in Denmark and The Netherlands, join forces to leverage expertise on sports timing and event services. This means that all races timed by Ultimate, will be timed with MYLAPS...

Business

Cycling

Press Releases

Products

Running

Triathlon

September 9, 2024

Wattbike launches Proton -– the most versatile smart bike for fitness enthusiasts

/ENDURANCE SPORTSWIRE/ – Designed for Effective and Efficient Training - Whatever the Goal. The Wattbike Proton can be easily and extensively adjusted without the use of tools, allowing users to seamlessly customise their position and optimise their workouts according to their individual training goals. Effective and time efficient training is...

Cycling

Press Releases

Products

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

deboer announces pre-order of FJORD 4.0: A Breakthrough in Wetsuit Technology

Norwalk, CT /ENDURANCE SPORTSWIRE/ – deboer, a leading innovator in wetsuit design, has announced the upcoming launch of their FJORD 4.0, representing the next evolution in wetsuit technology for triathletes and open water swimmers. Building on the success of its predecessor, the FJORD 4.0 incorporates advanced features that promise to...

Press Releases

Products

Triathlon