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

April 18, 2024

XTERRA Portugal Preview: An Off-Road Decade of Endurance

GOLEGÃ, PORTUGAL /ENDURANCE SPORTSWIRE/ – Revered as Portugal’s Capital of the Horse, the town of Golegã is set to host XTERRA Portugal for one of the most challenging off-road triathlons in Europe. The Full Distance race will take place on April 21, 2024 in the Jardim Equuspolis, a distinguished garden...

Cycling

Events

Press Releases

Running

Triathlon

April 18, 2024

XTERRA Australia Preview: An Elite Pursuit Through Paradise

DUNSBOROUGH, AUSTRALIA /ENDURANCE SPORTSWIRE/ – Outdoor sports reigns supreme in The Southern Hemisphere as XTERRA Australia hosts the Full Distance Triathlon taking center stage on April 21, 2024. The scenic Dunsborough Country Club and Meelup Regional Park marks the fourth stop on the XTERRA APAC Tour as a bucket list...

Cycling

Events

Press Releases

Running

Triathlon

April 18, 2024

Mortal Hydration Becomes The Official Sports Beverage and Hydration Partner of The IRONMAN and IRONMAN 70.3 North American Triathlon Series

TAMPA, Fla. / BOULDER, Colo. (April 18, 2024) /ENDURANCE SPORTSWIRE/ – IRONMAN and Mortal Hydration today announced Mortal Hydration as the official sports beverage and hydration partner for the IRONMAN® and IRONMAN® 70.3® North American Triathlon Series. Varieties of the Mortal Hydration Drink Mix will be available on-course, giving athletes...

Events

Press Releases

Sponsorship

Triathlon

April 18, 2024

OOFOS Unveils One-of-a-Kind Recovery Sponsorship at Boston Marathon Finish Line

BRAINTREE, MA /ENDURANCE SPORTSWIRE/ – OOFOS, the Boston-based global leader in Active Recovery footwear, confirms its commitment to recovery by implementing a completely unique sponsorship initiative that supports and celebrates “Real People” in their recovery journey following the Boston Marathon. With a pop-up retail store located by the Boston Marathon...

Events

Press Releases

Running

Sponsorship

April 18, 2024

Inaugural Michelob Ultra GFNY Miami this Sunday

/ENDURANCE SPORTSWIRE/ - This Sunday, Michelob Ultra GFNY Miami offers riders an entirely flat and fast racecourse of 70.7 miles completely closed to traffic. The North American Championship race starts and finishes at Miccosukee Resort & Casino on the western edge of Miami at the portal to the Everglades. Race...

Cycling

Events

Press Releases

April 17, 2024

Riviera Nayarit, Mexico Set To Host New IRONMAN 70.3 Triathlon

- Organizers of the IRONMAN 70.3 Acapulco, IRONMAN 70.3 Campeche, IRONMAN 70.3 Cozumel, IRONMAN 70.3 Monterrey, and IRONMAN Cozumel races to host new event - The inaugural IRONMAN 70.3 Riviera Nayarit triathlon is scheduled to take place on Sunday, Nov. 10, 2024; Registration is now available by visiting www.ironman.com/im703-riviera-nayarit MEXICO...

Events

Press Releases

Triathlon

April 17, 2024

Chevron Joins the Denver Colfax Marathon as the 2024 Race Volunteer Sponsor

Denver, CO /ENDURANCE SPORTSWIRE/ – The Denver Colfax Marathon, presented by Cigna Healthcare, welcomes Chevron as the 2024 race volunteer program sponsor. This partnership will allow for the marathon to continue its support of more than a thousand volunteers during the race weekend in May. “Our volunteers are a major...

Events

Press Releases

Running

Sponsorship