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

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

March 15, 2023

GFNY announces second race in Thailand

/ENDURANCE SPORTSWIRE/ - GFNY Global Endurance Sports Series adds GFNY Khao Yai, scheduled for October 8, 2023. It’s one of now five GFNY races in Asia aside from the Indonesian races in Bali and Mandalika, Kuala Lumpur (Malaysia) and Krabi (Thailand). The competitive long distance is 166.8km with 2179m of...

Cycling

Events

Press Releases

March 15, 2023

Newport Rhode Races takes first step towards becoming a zero-waste event, partners with Epic Renewal

NEWPORT, R.I. /ENDURANCE SPORTSWIRE/ – The Newport Rhode Races Marathon, Half Marathon and 5K returns to the “city-by-the-sea” on Apr. 15. Organizers have announced a new sustainability initiative, partnering with zero-waste consultants and composting provider Epic Renewal to work towards becoming a zero waste event. “Rhode Races aims to be responsible...

Business

Events

Press Releases

Running

March 15, 2023

Oakland Running Festival Set to Kick Off Sunday with NFL Star Najee Harris

OAKLAND, Calif. – (March 15, 2023) /ENDURANCE SPORTSWIRE/ – The 14th Annual Oakland Running Festival (ORF) will welcome over 7,000 participants during a week’s long celebration of the community culminating on Sunday, March 19 with events including the Marathon (26.2 Miles), Half Marathon (13.1 Miles), 10K (6.2 Miles) and the Total...

Events

Press Releases

Running

March 15, 2023

REI Joins the Denver Colfax Marathon Sponsor Team

Denver, CO /ENDURANCE SPORTSWIRE/ - The Denver Colfax Marathon welcomes REI to their marathon sponsor line up to give athletes access to training support, knowledge, and merchandise like never before. “We’re beyond excited to have partnered with the Denver Colfax Marathon on their 17th anniversary,” said Josh Millward, REI’s Regional Manager...

Business

Events

Giving

Press Releases

Running

Sponsorship

March 14, 2023

Pensacola Beach Firefighters Challenge April 14 and 15

Pensacola, FL (March 14, 2023) /ENDURANCE SPORTSWIRE/ - Brawn, axes, hoses, sweat and sand — it’s what makes up the storied Pensacola Beach Firefighters Challenge, a competition of brute strength, sheer will, finesse and determination where we find out who’s the best of best. Pensacola Sports is hosting the 7th...

Events

Press Releases

March 14, 2023

Jack Moody, Maeve Kennedy rally to win XTERRA Rotorua

/ENDURANCE SPORTSWIRE/ – Jack Moody and Maeve Kennedy captured the 19th annual XTERRA Rotorua Festival off-road triathlon elite titles with winning times of 2:06:16 and 2:26:35, respectively, on a beautiful blue sky day at Lake Tikitapu in the Bay of Plenty region of New Zealand's North Island on March 11, 2023....

Events

Press Releases

Triathlon