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

July 17, 2024

2024 XTERRA European Trail Run Championship: Pyrenees Preview

/ENDURANCE SPORTSWIRE/ – On July 20-21, the untamed beauty of the Pyrenees will be conquered, not just admired. Selfie sticks will give way to trail running poles, and tour groups will be replaced by scores of Europe’s toughest competitors, each battling for the title of 2024 XTERRA European Trail Run...

Events

Press Releases

Running

July 17, 2024

Foil Race Kicks Off 25th Anniversary Molokaʻi 2 Oʻahu Paddleboard World Championships

Now over two weekends, the open ocean challenge begins on Sunday, July 21 with the foil race, followed by the prone and standup paddleboard race on July 28, 2024. Foil athletes will break in a new longer and faster course that will finish off the shore of Kaimana Beach in...

Events

Press Releases

Sponsorship

July 17, 2024

The Marin Mile Partners with Movemint for 2025

SAN FRANCISCO [07/17/24] /ENDURANCE SPORTSWIRE/ - The Marin Mile is set to join the Movemint event platform for the 2025 edition of the race. This exciting partnership marks a step forward in the evolution of The Marin Mile, ensuring the event continues to meet the evolving needs of its vibrant...

Events

Press Releases

Running

July 16, 2024

The IRONMAN Pro Series Heads to New York’s Adirondack Mountains for The 25th Anniversary Edition of The Athletic Brewing IRONMAN Lake Placid

- The twelfth stop for the IRONMAN Pro Series™ will see many of the world’s top professional triathletes descend on Lake Placid, New York to fight for a piece of the $125,000 total event pro prize purse - The “Voice of IRONMAN,” Mike Reilly, will return for a special occasion...

Events

Press Releases

Triathlon

July 16, 2024

SAIL Challenge Cap Québec powered by Argon 18 and Challenge New Jersey State Triathlon Will Kick Off This Weekend

/ENDURANCE SPORTSWIRE/ – The highly anticipated SAIL Challenge Cap Québec powered by Argon 18 will take place in Québec’s cultural heart of Québec City, featuring an impressive lineup of over 20 professional athletes from around the globe. Among the men’s professional field is Jack Moody (NZL), winner of Challenge Taiwan...

Events

Press Releases

Triathlon

July 16, 2024

Kerrville Triathlon Welcomes Back EIGHT Beer as Official Beer Sponsor

Kerrville, Texas July 16, 2024/ENDURANCE SPORTSWIRE/ – The Kerrville Triathlon, produced by High Five Events, is proud to announce the return of EIGHT Beer as the Official Beer for the second year in a row. This partnership celebrates the intersection of athletic achievement and community spirit, promising participants and spectators...

Events

Press Releases

Sponsorship

Triathlon