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

May 17, 2023

Carmel Marathon Weekend to Return for 14th Annual Event Under New Management

CARMEL, Ind. (May 17, 2023)/ENDURANCE SPORTSWIRE/ – CRRG Events announced today that Full Circle Events has acquired the Carmel Marathon Weekend. Full Circle Events, based in central Indiana, will produce and manage the popular springtime race held annually in Carmel, Indiana. CRRG Events will work with Full Circle Events through the...

Business

Events

Press Releases

Running

May 17, 2023

11th GFNY World Championship NYC on May 21, 2023

NEW YORK CITY /ENDURANCE SPORTSWIRE/ - The 11th GFNY World Championship NYC represents the pinnacle of GFNY Endurance Sports Series and its 30+ races in 2023. GFNY is now the world's largest cycling marathon series with over 40 races expected to be held in 2024. Get the official GFNY NYC...

Cycling

Events

Press Releases

May 17, 2023

Military Veterans and Veteran Runners to Run 100-Mile Relay Up The Coast of Massachusetts

BOSTON/ENDURANCE SPORTSWIRE/ – Starting in Veterans Park in Hyannis and ending in Boston Common, a new relay race event will take more than a dozen runners 100 miles up the coast of the state of Massachusetts. The TREK Relay for Veterans features two teams: one comprised of military veterans and the...

Events

Giving

Press Releases

Running

May 16, 2023

Panamá to Host the IRONMAN 70.3 Latin America Triclub Championship in 2024

PANAMÁ CITY, Panamá / TAMPA, Fla. (May 16, 2023)/ENDURANCE SPORTSWIRE/ – IRONMAN today announced that the IRONMAN® 70.3® Panamá triathlon presented by Heineken 0.0 taking place on February 25, 2024, will be designated as the 2024 Latin America TriClub Championship. Panamá will be stop #1 on the 2024 Global IRONMAN TriClub...

Events

Press Releases

Triathlon

May 16, 2023

Whitefish Marathon Preparing for New Course Records, Championship-Level Competition and Festive Atmosphere

WHITEFISH, Mont. (May 16, 2023)/ENDURANCE SPORTSWIRE/ - Participants from nearly 40 states will be vying for personal bests and course records at the 16th annual Whitefish Marathon, Half Marathon and 5K Powered by Hammer Nutrition this Saturday, May 20, 2023 in Whitefish, Montana. Held in the shadows of Glacier National...

Events

Press Releases

Running

May 15, 2023

Sportive Breaks announces launch of travel & spectator packages for the 2023 UCI Cycling World Championships

15th May 2023 - Manchester UK /ENDURANCE SPORTSWIRE/ – Sports travel experts Sportive Breaks offer bespoke premium travel packages for cyclists looking to take part in Europe’s most prestigious cycling events, cycling breaks and weekenders. Be it that you are looking for your next big endurance challenge or simply some time away...

Cycling

Events

Press Releases

Sponsorship

May 15, 2023

17th Annual Denver Colfax Marathon Returns to the Mile High City

Denver, CO/ENDURANCE SPORTSWIRE/ – For the first time in its 17-year race history, the Denver Colfax Marathon, presented by Cigna, has sold out the marathon (26.2 mile) race distance. The city’s only marathon weekend will take place May 19-21, 2023. While the marathon distance has reached its limit for registrants, people...

Events

Press Releases

Running

May 15, 2023

A Big International Entry for the Raid Lowlands – Race #2 for Adventure Racing World Series Europe

/ENDURANCE SPORTSWIRE/ – Sixty-eight teams with racers from 15 countries will be in the Netherlands next weekend for the Raid Lowlands, the second race in the Adventure Racing World Series calendar in Europe this year. Racers from Germany, Turkey, Netherlands, Luxembourg, France, UK, Poland, Finland, Belgium, Ireland, Sweden, Canada, Spain, Estonia...

Events

Press Releases

May 14, 2023

Aernouts and Nieuwoudt Take Inaugural Titles at Ekoï Challenge Fréjus

/ENDURANCE SPORTSWIRE/ - The French Riviera delivered world-class racing today at the inaugural Ekoï Challenge Fréjus with Bart Aernouts (BEL) and Magda Nieuwoudt (RSA) taking out the inaugural titles in 4:06:24 and 4:46:13 respectively. The day dawned with perfect race conditions, and it was Ognjen Stojanovic (SER) who led out...

Events

Press Releases

Triathlon