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

November 12, 2021

Challenge Family Announces Challenge Malta for Early 2022

12 November 2021./ENDURANCE SPORTSWIRE/ - The Mediterranean island of Malta was today announced as the latest destination in Challenge Family’s global triathlon series. The inaugural Challenge Malta will take place on Sunday 15 May 2022 with a 113km coast-to-coast course that includes the country’s most spectacular scenery. Malta packs a...

Events

Press Releases

Triathlon

November 12, 2021

GFNY Chile racers to tackle infamous Muro de Tunquen

/ENDURANCE SPORTSWIRE/ - After a two year hiatus due to the pandemic, the 3rd edition of GFNY Chile is expecting 1000 riders. Start and finish of the race will be at Viñedos Veramonte close to Casablanca just outside the capital Santiago de Chile. The race offers a long, competitive route of...

Cycling

Events

Press Releases

November 11, 2021

GFNY Cozumel decided in incredible sprint finish

In the early hours of last Sunday, 2000 riders started at what we can probably call one of the hardest editions of GFNY Cozumel so far. The long, competitive 100-mile course is a double-loop around the beautiful island of Cozumel, with two 40 km long King of the Wind (KOW)...

Cycling

Events

Press Releases

November 11, 2021

Argentinian Azzem takes the win at first GFNY Colonia

Last weekend marked a comeback of GFNY in Uruguay with the first GFNY Colonia del Sacramento. Beautiful sunny weather and unusual calm winds blessed the race that offered a long, competitive route of 148km with 1122m of elevation. Already 32k into the race things got pretty heated at the San...

Cycling

Events

Press Releases

November 11, 2021

Nelson Mandela Bay welcomes a new IRONMAN 70.3 Triathlon

NELSON MANDELA BAY, LONDON, TAMPA (November 11, 2021) /ENDURANCE SPORTSWIRE/ - IRONMAN announced today that it will add a brand-new event to its 2022 race calendar with the IRONMAN® 70.3® Nelson Mandela Bay in South Africa. The inaugural IRONMAN 70.3 Nelson Mandela Bay triathlon will take place on Sunday, April 3,...

Events

Press Releases

Triathlon

November 11, 2021

Showcased

“The Last Best Ride” Gravel Race Transitions to 501(c)(3) Nonprofit Status and Announces 2022 Event Registration Opening Veteran’s Day

Whitefish, Montana — November 11, 2021 /ENDURANCE SPORTSWIRE/ - Montana Native and professional gravel cyclist Jess Cerra, and her partner Sam Boardman, announced today that they have transformed “The Last Best Ride” (TLBR) into a 501(c)(3) nonprofit supporting scholarships for local, financially-qualified high school women seeking post-secondary education. At the...

Cycling

Events

Press Releases

November 11, 2021

Austin Marathon, Ascension Seton Agree to Title Sponsor Extension

AUSTIN, Texas, November 11, 2021 /ENDURANCE SPORTSWIRE/ - The Austin Marathon and Ascension Seton have agreed to a long-term title sponsor extension. The agreement will allow the collaboration to continue to grow, further benefiting the fitness community. In addition to growing secondary community events and expanding content creation opportunities, Ascension...

Business

Events

Press Releases

Running

Sponsorship