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

December 13, 2023

GFNY closed 2023 with Kota Kinabalu race in Malaysia

/ENDURANCE SPORTSWIRE/ - Sabah’s Youth and Sports Minister YB Datuk Ellron Angin, sent the GFNY riders on their way with 80 police officers, 30 police motos and 20 medical assistance vehicles securing the race for the riders to BE A PRO FOR A DAY. Under clear skies with perfect temperatures,...

Cycling

Events

Press Releases

December 13, 2023

Challenge Family Announces Second Canadian Race with SAIL Challenge Esprit Montréal

/ENDURANCE SPORTSWIRE/ – Challenge Family has partnered with one of Canada’s oldest and most respected events to announce SAIL Challenge Esprit Montréal on 6-8 September 2024. The event will mark the 40th anniversary of the original Esprit de Montréal Triathlon which each year attracts over 3,000 athletes to the Olympic...

Events

Press Releases

Triathlon

December 13, 2023

Mathis Margirier and Magda Nieuwoudt Finish Season with Challenge Family World Bonus Victories

/ENDURANCE SPORTSWIRE/ – Four wins for Magda Nieuwoudt and three wins for Mathis Margirier: both athletes experienced a great season in 2023 and were stronger than ever at Challenge Family races. On top of their wins came some impressive second place finishes as well, making Nieuwoudt and Margirier the winners...

Events

Press Releases

Triathlon

December 12, 2023

Super League Triathlon amplifies U.S. Expansion as it partners with USA Triathlon for the Long Beach Legacy Triathlon

CALIFORNIA, USA/ENDURANCE SPORTSWIRE/ - Super League Triathlon announced today that they will be continuing their rapid US expansion by assuming the operation of the 2024 Long Beach Legacy Triathlon in partnership with USA Triathlon. This marks another addition to Super League’s growing US portfolio after the acquisition of events in...

Business

Events

Press Releases

Triathlon

December 12, 2023

Over 1,200 Kids to Complete Finish Like a Champion Project at Orlando Magic 5K, 1 Mile and Kids’ Run

ORLANDO, Fla. /ENDURANCE SPORTSWIRE/ – The Orlando Magic 5K, 1 Mile and Kids’ Run is providing an opportunity for kids taking part in Finish Like a Champion to mark a special accomplishment at the run on February 4, the day after the U.S. Marathon Team Trials. Finish Like a Champion is...

Events

Press Releases

Running

December 12, 2023

XTERRA European Championship 2024: High Stakes and Festivities in Prachatice

/ENDURANCE SPORTSWIRE/ - The fight for European Championship glory returns to the tried and tested trails of the Czech Republic. Key Points: Prachatice, Czech named as official destination of 2024 XTERRA European Championship. A €30,000 Elite prize purse and regional championship crowns up for grabs in one of the most...

Cycling

Events

Press Releases

Running

Triathlon

December 12, 2023

The Wizard Run Has a Magical Return to Philly

PHILADELPHIA, Pa. /ENDURANCE SPORTSWIRE/ – Runners and walkers sporting their wizard and magical-themed gear flew through the streets of Philadelphia on Dec. 9 for the return of the in-person Wizard Run. Participants at this year’s Wizard Run started in South Philadelphia’s Navy Yard and journeyed through the 5K and one-mile routes....

Events

Press Releases

December 11, 2023

SUAREZ Gran Fondo National Series and Zwift Announce Schedule for 8-Event E-Fondo Series

(Gettysburg, PA ) /ENDURANCE SPORTSWIRE/ - The SUAREZ Gran Fondo National Series today announced the event schedule for the 4th Annual E-Fondo Series, an 8-event series of competitive cycling events hosted on Zwift’s industry leading virtual cycling platform. The 8-event e-sports cycling competition features timed segments like the Series’ real-world...

Business

Cycling

Events

Press Releases