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

March 19, 2024

2024 XTERRA Asia-Pacific Championship: Triathletes & Trailblazers Ready for Battle

Key Points: XTERRA Taiwan to determine Asia-Pacific triathlon and trail running titles with limited slots for global championships in Trentino, Italy and Maine, USA. Sustainable trophies and medals from local wood sculptor emphasize XTERRA's eco-focus. Live commentary by XTERRA legends to offer in-depth analysis and historical insights for fans and...

Cycling

Events

Press Releases

Running

Triathlon

March 19, 2024

Men’s Singapore T100 Line Up Set To Continue Miami Rivalries

London, UK/ENDURANCE SPORTSWIRE/ – The Professional Triathletes Organisation (PTO) and World Triathlon have confirmed the line up for the men’s Singapore T100 triathlon on 14 April, 2024, the second stop on the new eight-leg T100 Triathlon World Tour. It features 15 of the world’s top 20 PTO Ranked athletes and...

Events

Press Releases

Triathlon

March 19, 2024

GoFundraise Announces New Partnership with IRONMAN UK

/ENDURANCE SPORTSWIRE/ – In an exciting milestone for both the world of endurance sports and charitable fundraising, GoFundraise announced its inaugural partnership with IRONMAN UK. For the first time, fundraising via the GoFundraise platform will be integrated into IRONMAN, marking a significant leap forward in connecting IRONMAN athletes with charitable...

Business

Giving

Press Releases

Running

Wire Syndication

March 19, 2024

Monuments of Cycling Announces Official Bike Tour Partnership With Thomson Bike Tours, The Premier Cycle Tour Operators

SAN DIEGO /ENDURANCE SPORTSWIRE/ - Monuments of Cycling (MoC), the renowned producer of the iconic Belgian Waffle Ride (BWR), is delighted to unveil its partnership with Thomson Bike Tours (TBT) as the Official Bike Tour Partner of the Belgian Waffle Ride series. Thomson Bike Tours holds the esteemed position as...

Business

Cycling

Events

Press Releases

Sponsorship

March 18, 2024

Gold’s Gym West Covina Gets a Makeover, Major Functional Upgrades Unveiled

Los Angeles, CA (March 18, 2024) /ENDURANCE SPORTSWIRE/ - Gold’s Gym SoCal – the original home of fitness workouts – unveils a state-of-the-art refit of its West Covina location. Today. The club opens the doors to its signature playground turf area, offering members a functional area to practice a wide...

Business

Press Releases

March 18, 2024

PTO Confirms ‘Battle of Champions’ for Women’s Singapore T100

London, UK /ENDURANCE SPORTSWIRE/ - The Professional Triathletes Organisation (PTO) and World Triathlon have confirmed a powerful line up for the women’s Singapore T100 triathlon on 13 April, 2024, the second stop on the new eight-leg T100 Triathlon World Tour. Included is Miami T100 champion India Lee, who will be...

Business

Press Releases

Triathlon

March 18, 2024

Paddle for a Cause: The Inaugural Around the World Paddle Classic

CORONADO, CA (March 18, 2024)/ENDURANCE SPORTSWIRE/ – On April 13, 2024, paddlers of all levels are invited to participate in the inaugural ‘Around the World’ Paddle Classic, a first of its kind water sports festival that includes current and former Navy SEALs. The event, based on a legendary workout SEAL...

Events

Giving

Press Releases

March 18, 2024

More Than 100 Professional Athletes to Race Boston 5K presented by Point32Health and B.A.A. Invitational Mile

BOSTON /ENDURANCE SPORTSWIRE/ – Fast fields featuring Olympians, Paralympians, rising stars, and recent B.A.A. event winners will take center stage at the Boston 5K presented by Point32Health and B.A.A. Invitational Mile on Saturday, April 13. The deepest professional field in race history will include more than 100 accomplished athletes from...

Events

Press Releases

Running

March 18, 2024

Cycling travel experts Sportive Breaks announce new self guided road cycling holidays

18th March 2024 - UK /ENDURANCE SPORTSWIRE/ – Cycling travel experts, Sportive Breaks promote bespoke premium travel packages for cyclists looking to take part in the world’s most prestigious grand tours, cycling classics and weekenders. The team offer a range of customised travel packages including cycling tours, training camps, hospitality,...

Business

Cycling

Press Releases

March 18, 2024

Stacy Ndiwa, Dominic Ngeno win the 2024 Los Angeles Marathon presented by ASICS

LOS ANGELES /ENDURANCE SPORTSWIRE/ – It was appropriate that there was a smiling Joan Benoit Samuelson holding the finishing tape as defending champ Stacy Ndiwa and fellow Kenyan Dominic Ngeno won the 39th annual Los Angeles Marathon presented by ASICS on Sunday. “It was Joanie who put us on the...

Events

Press Releases

Running