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

May 29, 2024

Inaugural Challenge Gallipoli Travels Through History

/ENDURANCE SPORTSWIRE/ – This Sunday marks the inaugural Challenge Gallipoli in Türkiye as athletes from around the world race in possibly one of the most evocative triathlon destinations. Set on the site of one of the most defining battles of the First World War, Challenge Gallipoli is a middle distance...

Events

Press Releases

Triathlon

May 29, 2024

Morales and Guzmán Medina Make History at Inaugural XTERRA Colombia

PAIPA, BOYACÁ, COLOMBIA /ENDURANCE SPORTSWIRE/ – May 26, 2024 marked a significant milestone on the 2024 XTERRA World Tour with the launch of the inaugural XTERRA Colombia event. Set in the high altitudes of Paipa, Boyacá, this Full Distance off-road triathlon introduced athletes to the season's highest elevation start at...

Cycling

Events

Press Releases

Running

Triathlon

May 29, 2024

DAZN and IRONMAN Partner to Increase Global Footprint of Premier Triathlon Series with Two-Year Broadcast Partnership

DAZN will showcase all of the IRONMAN Pro Series races as part of their free-tier including the split location women’s and men’s 2024 VinFast IRONMAN World Championship triathlons and the two-day women’s and men’s VinFast IRONMAN 70.3 World Championship triathlons LONDON, UK / TAMPA, Fla. (May 29, 2024) /ENDURANCE SPORTSWIRE/...

Events

Press Releases

Triathlon

May 29, 2024

Daytona Beach Half Marathon powered by CLASH Endurance Now Includes Relay Opportunity

May 29, 2024/ Daytona Beach, FL /ENDURANCE SPORTSWIRE/ – CLASH Endurance is excited to now offer a relay option for the Daytona Beach Half Marathon, taking place on February February 8, 2025. This new addition to next year’s event will provide opportunities where half-marathon teams can be comprised of two...

Events

Press Releases

Running

May 29, 2024

Kinomap Transforms Workouts with Global Videos, Taking Fitness Enthusiasts Around the World Virtually

/ENDURANCE SPORTSWIRE/ – Kinomap, the leading platform for interactive fitness training, is revolutionizing the way people exercise with its vast library of over 40,000 training route videos. By seamlessly blending technology and fitness, Kinomap offers users a unique opportunity to embark on virtual journeys around the globe, enhancing their workout...

Press Releases

Products

May 29, 2024

Long Beach Marathon Celebrates 40 Years of Running Excellence with Airport Partnership

LONG BEACH, CA – May 29, 2024 /ENDURANCE SPORTSWIRE/ – Long Beach Airport (LGB) and the Long Beach Marathon proudly announce the continuation of their longstanding partnership for the upcoming 40th anniversary of Southern California’s most prestigious fall marathon. Scheduled for the weekend of October 4-6, 2024, the milestone edition...

Events

Press Releases

Running

Sponsorship

May 28, 2024

4iiii Unveils Athlete and Team Roster for 2024 Racing Season

COCHRANE, ALBERTA, 28 MAY 2024 /ENDURANCE SPORTSWIRE/ – 4iiii Innovations Inc, a global leader in sports performance technology, continues to strengthen its position in the industry with the successful launch of the 4iiii PRECISION 3+ PRO Powermeter in February. This innovative product, which integrates Apple Find My technology for added...

Cycling

Press Releases

Sponsorship

May 28, 2024

Asia Pacific Champs at Challenge Gunsan-Saemangeum

/ENDURANCE SPORTSWIRE/ – This weekend, Challenge Gunsan-Saemangeum will host the Challenge Family Asia-Pacific Championships over 226km with an international field of professional athlete and over 1,000 age group athletes. The course includes the world’s longest seawall with its unique eco-environment and spectacular scenery. The Asia Pacific Championship edition in 2024 will...

Events

Press Releases

Triathlon

May 28, 2024

International Field at OTSO Challenge Salou 2024

/ENDURANCE SPORTSWIRE/ – An international field of professional and age group athletes from 43 nations will descend on the popular Spanish holiday town of Salou this weekend for OTSO Challenge Salou, drawn by the golden sands, fast bike course on a closed motorway and flat run along the palm tree-lined...

Events

Press Releases

Triathlon

May 28, 2024

PTO Announce Dubai T100 Triathlon Course to Take Place at Meydan Racecourse and Surrounding Area For The Inaugural Weekend Event In November 2024

Dubai, United Arab Emirates, 28 May 2024/ENDURANCE SPORTSWIRE/ – The Professional Triathletes Organisation (PTO) and World Triathlon have announced the unique and renowned Meydan Racecourse, Crystal Lagoon of District One and the surrounding area, to host the new T100 Triathlon World Tour when it visits Dubai on 15-17 November this year....

Events

Press Releases

Triathlon