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

March 17, 2023

Maxim Chane, Marta Menditto win XTERRA Oman

/ENDURANCE SPORTSWIRE/ - Maxim Chane from France and Marta Menditto from Italy won the inaugural XTERRA Oman off-road triathlon on a hot and sunny day at the Khasab Fort in Oman’s Musandam Governorate on Saturday, March 18, 2023. It’s the fifth career XTERRA World Tour win for Chane, and the...

Events

Press Releases

Triathlon

March 17, 2023

IRONMAN Athletes’ Choice Awards Announced for IRONMAN and IRONMAN 70.3 Triathlons around the Globe

TAMPA, Fla. (March 17, 2023) /ENDURANCE SPORTSWIRE/ – IRONMAN today announced the global results for the IRONMAN® and IRONMAN® 70.3® Athletes’ Choice Awards, highlighting the highest-scoring events in a variety of categories based on athlete surveys from all the 2022 IRONMAN® and IRONMAN 70.3® races from around the world. Out of...

Events

Press Releases

Triathlon

March 17, 2023

Ultra X Goes Loopy: The Ultimate Endurance Challenge Launches

/ENDURANCE SPORTSWIRE/ – Global ultra-marathon events series, Ultra X launch their latest format, Ultra X goes Loopy, a timed event where runners will aim to cover the most loops possible in 6 or 12 hours as individuals or teams. “Ultra X was setup because we wanted to make ultra running more...

Events

Press Releases

Running

March 17, 2023

More than 2,500 Runners Made the Inaugural Annapolis Running Festival a Resounding Success

March, 2023- Annapolis, MD /ENDURANCE SPORTSWIRE/ – The Inaugural Annapolis Running Festival was a huge success, reaching capacity in its first year. Held on Saturday, March 11 and starting and finishing at the famed Navy-Marine Corp Memorial Stadium, participants had the option of running a half-marathon, 10K, or 5K. All distances ran...

Events

Press Releases

Running

March 16, 2023

Inaugural USA Cycling Gravel National Championship Heads to Nebraska with Largest Gravel Prize Purse in American History

March 16, 2023 /COLORADO SPRINGS, Colo. /ENDURANCE SPORTSWIRE/– USA Cycling is pleased to announce that the inaugural Gravel National Championships will take place September 9, 2023 in Gering, Neb. with a $60,000 prize purse. The event will remain in Gering for 2024. “Over the last five years, the explosive growth of...

Cycling

Events

Press Releases

March 16, 2023

GFNY Republica Dominicana this Sunday

/ENDURANCE SPORTSWIRE/ – This Sunday, GFNY Republica Dominicana offers riders a challenging 149.7 km race course with an elevation gain of 962 m. Punta Cana with its white sand beaches, blue turquoise water and tropical weather, is the second most popular tourist destination in Latin America. “Within two editions only, GFNY...

Cycling

Events

Press Releases

March 15, 2023

New event: SwimRun Cape Cod set for Sept. 2023

BOSTON, MA/ENDURANCE SPORTSWIRE/- New England Endurance Events has added its first swimrun race to the company’s schedule of multisport events for 2023. SwimRun Cape Cod will be held on September 16; traversing the beaches, highlands, woods and glacier-formed kettle ponds within the Cape Cod National Seashore in Massachusetts. Two distances will...

Events

Press Releases