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

July 3, 2024

2024 Maine Summer Adventure Race will go island hopping

/ENDURANCE SPORTSWIRE/ - The Maine Summer Adventure Race will take its participants island hopping in its eighth annual edition on July 13-14, 2024. The 3-hour, 8-hour, and 24-hour editions of Maine’s only U.S. Adventure Racing Association- and Adventure Race World Series-sanctioned adventure race will take teams of two to four...

Events

Press Releases

July 3, 2024

Registration now open for GranFondo Whistler – Riviera Nayarit 2025

Mexico City, July 2, 2024. /ENDURANCE SPORTSWIRE/ – We are pleased to announce the first edition in Mexico of the GranFondo Whistler – Riviera Nayarit, which will take place on Saturday, April 5, 2025, in Bahía de Banderas, Nayarit. The GranFondo Whistler, held for 15 years in Canada, is one of...

Business

Cycling

Events

Press Releases

July 3, 2024

The 11th Annual Swim for Alligator Lighthouse is Helping Save One of Florida’s Treasures

Fernandina Beach, Florida /ENDURANCE SPORTSWIRE/ - The Swim for Alligator Lighthouse, located in Islamorada, FL, is the fourth stop on the Speedo SALT Series. This international, 8-mile swim is a challenge unlike any other and is not for the faint of heart. During this bucket list, tropical open water swim,...

Events

Press Releases

July 2, 2024

DATEV Challenge Roth Set to Host One of The Greatest Professional Fields of the Year

Juny 12, 2024 - ENDURANCE SPORTSWIRE - This weekend, the triathlon world will gather in Roth, Germany, for DATEV Challenge Roth, the largest long-distance triathlon event globally. Roth, known as the home of triathlon, will welcome more than 90 professional athletes, including many of the top 10 athletes in the...

Events

Press Releases

Triathlon

July 2, 2024

New Leader in Challenge Family Pro Athlete World Bonus

/ENDURANCE SPORTSWIRE/ This weekend’s racing at Challenge Cagnes-sur-Mer saw Aurélia Boulanger (FRA) take the women’s lead in the Challenge Family Pro Athlete World Bonus rankings while Jack Moody (NZL) cemented his place at the top of the men’s league. Boulanger’s win on the French Riviera was her third of the...

Events

Press Releases

Triathlon

July 1, 2024

Denver Colfax Marathon Celebrates Race Director Creigh Kelley

DENVER, CO /ENDURANCE SPORTSWIRE/ - The Denver Colfax Marathon celebrates the career of its longtime race director, Creigh Kelley, as he transitions into a race director emeritus role. Kelley, who has been with the marathon since its inception 18 years ago, is stepping away from his official race director duties...

Awards

Business

Events

Giving

Press Releases

Running

Triathlon

July 1, 2024

Chicago Grit Announces Exciting Location Shift for Final Day of Racing

Chicago, IL – July 1, 2024 /ENDURANCE SPORTSWIRE/ Chicago Grit, formerly known as the Intelligentsia Cup, is thrilled to announce a significant location shift for the final day of its 2024 race series. For the first time, the capstone event will be held near Fulton Market, moving from its traditional...

Cycling

Events

Press Releases

July 1, 2024

CTS Athletes Katie Schide, Fuzhao Xiang, and Eszter Csillag Sweep Podium at Western States Endurance Run

(Colorado Springs, CO) /ENDURANCE SPORTSWIRE/ - Katie Schide (USA), Fuzhao Xiang (CHN), and Eszter Csillag (HUN) finished first, second, and third, respectively, at the 2024 Western States Endurance Run. All three athletes are coached by Jason Koop, Head Coach of CTS Ultrarunning, who integrated a network of registered dietitians, strength...

Events

Press Releases

Running