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

September 29, 2023

Ahotu is thrilled to announce a collaboration with Garmin

/ENDURANCE SPORTSWIRE/ – Ahotu, the world’s largest and most comprehensive calendar for endurance sports, are delighted to announce a collaboration with Garmin, a leading global provider of smartwatches and GPS-enabled devices across diverse markets. A new service to discover and train for events Users can easily discover events in the Garmin Connect™...

Business

Cycling

Events

Press Releases

Running

September 29, 2023

Stars Set To Collide As Super League Triathlon Heads To Malibu For Decisive Race

/ENDURANCE SPORTSWIRE/ – The stars of triathlon are set to collide at the stunning Zuma Beach in Malibu, USA, on Saturday, September 30, as Super League Triathlon’s Championship Series reaches a pivotal stage. With the majority of the sport’s short course aces having raced in either London or Toulouse in...

Events

Press Releases

Triathlon

September 29, 2023

Unveiling Earth’s Biodiversity at the Huairasinchi Adventure Racing World Championship 2024

Quito, Ecuador - September 28/ENDURANCE SPORTSWIRE/ – In 2014 Huairasinchi hosted the Adventure Racing World Championship, crossing the high Andes at latitude 0, with one checkpoint placed on the equator. A decade later, in November 2024, Huairasinchi will host the ARWC again, and this time the race will be different. Teams will...

Events

Press Releases

September 28, 2023

IRONMAN 70.3 Michigan Triathlon Returns to Frankfort, Michigan on Sunday, Sept. 15, 2024

FRANKFORT, Mich. (Sept. 28, 2023) /ENDURANCE SPORTSWIRE/ - It has been announced, the IRONMAN® 70.3® Michigan triathlon will return to Northern Michigan and the city of Frankfort on Sunday, Sept. 15, 2024. General registration for the 2024 IRONMAN 70.3 Michigan triathlon will open on Oct. 4* and can be accessed...

Events

Press Releases

Triathlon

September 28, 2023

Global Field of Qualifiers Notified of Acceptance into the 128th Boston Marathon presented by Bank of America

BOSTON /ENDURANCE SPORTSWIRE/ – The Boston Athletic Association (B.A.A.) today began notifying qualified applicants of their acceptance into the 128th Boston Marathon presented by Bank of America. The race will be run on Monday, April 15, 2024, and will mark the centennial anniversary of the event beginning in the town...

Events

Press Releases

Running

September 28, 2023

Showcased

The La Valette Marathon: Running History Alongside the Mediterranean Waves

/ENDURANCE SPORTSWIRE/ – Calling all runners, athletes, and running enthusiasts! Get ready to embark on an epic journey through 7000 years of history while enjoying the stunning Mediterranean coastline. The highly-anticipated third edition of the La Valette Marathon, a full or half marathon event, is set to take place on...

Events

Press Releases

Running

September 28, 2023

Super Sunday: two flat and fast GFNY races on same day

/ENDURANCE SPORTSWIRE/ - The inaugural edition of GFNY Cambridge Maryland starts in the heart of Cambridge downtown and offers racers a 92.4 mile long course with 481 ft of climbing, making it the flattest and likely fastest race of the GFNY circuit. It’s Maryland’s first ever mass participation cycling race....

Cycling

Events

Press Releases

September 27, 2023

Diplo, Chace Crawford, Trixie Mattel & More to Participate In Malibu Triathlon to Raise Funds for Children’s Hospital Los Angeles

MALIBU, Calif. – Sept. 27, 2023/ENDURANCE SPORTSWIRE/ – The Malibu Triathlon, presented by Super League Triathlon, announced the star-studded lineup for its Celebrity Division race that will take place on Sunday, Oct. 1 at Zuma Beach. Diplo, Chace Crawford, Trixie Mattel, Daniela Ruah, Jesse Metcalfe, Timothy Olyphant, Ben Higgins, ChefRush and more...

Events

Giving

Press Releases

Triathlon