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

May 22, 2024

Limited Time to Participate Remains for Paris 2024 Sport Connected Challenge

Paris, France/ENDURANCE SPORTSWIRE/ – Now through May 31, participants from around the globe are invited to embark on an exhilarating journey in the Paris 2024 sport connected challenge. Participants have the chance to virtually cycle and run through the streets of Paris or row in the pristine waters of the Vaires-sur-Marne...

Events

Press Releases

May 22, 2024

Runway Ready? Experience Pittsburgh International Airport Like Never Before at the FlyBy 5K and 2-Mile Fun Run/Walk Presented by CNX Resources

PITTSBURGH, PA (May 22, 2024)/ENDURANCE SPORTSWIRE/ – Registration is now open for the eighth annual FlyBy 5K and 2-Mile Fun Run/Walk presented by CNX Resources. Scheduled for Sept. 21, this unique event gives participants exclusive access to run through the airfield and taxiways of Pittsburgh International Airport, a true behind-the-scenes...

Events

Press Releases

Running

May 22, 2024

Members of Team USA & Boston Marathon Podium Finishers Set to Compete at 2024 Boston 10K presented by Brigham and Women’s Hospital

BOSTON /ENDURANCE SPORTSWIRE/ – The Boston Athletic Association (B.A.A.) has announced professional fields for the 2024 Boston 10K presented by Brigham and Women’s Hospital, to be run on Sunday, June 23. American Olympic Marathoners Emily Sisson and Clayton Young will race the new and enhanced Boston 10K course which features...

Events

Press Releases

Running

May 22, 2024

XTERRA Lake Garda Preview: Elite Athletes Tackle Italy’s Iconic Terrain

TOSCOLANO-MADERNO, ITALY /ENDURANCE SPORTSWIRE/ – On May 25, 2024, XTERRA Lake Garda marks the eighth stop of the XTERRA EMEA Tour with the first of four Italian events. Set against the vast backdrop of Italy's largest lake, this Full Distance off-road triathlon challenges elite athletes with its rigorous course amidst...

Cycling

Events

Press Releases

Running

Triathlon

May 22, 2024

2024 XTERRA Colombia: An Elite High Altitude Adventure

PAIPA, BOYACÁ, COLOMBIA /ENDURANCE SPORTSWIRE/ – May 26, 2024 marks a major milestone on the XTERRA World Tour as XTERRA Colombia launches its inaugural event. This Full Distance off-road triathlon, set in the high altitudes of Paipa, Boyacá, introduces athletes to the highest elevation start of the season at 8,000...

Cycling

Events

Press Releases

Running

Triathlon

May 22, 2024

Run Tucson Announces Prize Money for June 1st TMC Meet Me DowntownTucson’s popular three-race series begins with the June 1 TMC Meet Me Downtown 5k Night Run and Walk

/ENDURANCE SPORTSWIRE/ - Seeking the region's fastest runners, Run Tucson has partnered with title sponsor Tucson Medical Center to provide over $2,000 in potential prize money to be awarded to teams and individuals. With expectations of 2,000 participants, the TMC Meet Me Downtown 5k Night Run and Festival of Miles...

Events

Press Releases

Running

May 22, 2024

Weekend of Fair Racing Ahead at Challenge St Pölten

/ENDURANCE SPORTSWIRE/ – In the men’s pro field, two former winners will race. Thomas Hug (GER) will return with the goal to defend his 2023 title with one win under his belt already this season. But he will face stiff competition from 2022 winner, Nicolas Mann (GER). Also lining up...

Events

Press Releases

Triathlon

May 21, 2024

New York City: Tibor Del Grosso (Alpecin-Deceuninck) wins the GP, Caddeo and Beccaria the GFNY

NEW YORK CITY, May 21, 2024 /ENDURANCE SPORTSWIRE/ – Tibor del Grosso (Netherlands) of Alpecin-Deceuninck took the win at the inaugural Gran Premio New York City. The peloton of the first ever UCI pro race in New York was chased by thousands of riders of the 12th Michelob Ultra GFNY...

Cycling

Events

Press Releases

May 21, 2024

Iconic Athletic Brewing IRONMAN Lake Placid Triathlon Extended Through 2027

- The Village of Lake Placid, the Town of North Elba and the Regional Office of Sustainable Tourism (ROOST) agree to renew contract with IRONMAN to continue hosting the event for an additional three-years - Approximately 2,600 registered athletes are expected to toe the line at the 2024 Athletic Brewing...

Events

Press Releases

Triathlon

May 21, 2024

World Best Times and High PTO Points at The Championship 2024

/ENDURANCE SPORTSWIRE/ – Frederic Funk (GER) has posted the world’s fastest middle distance triathlon bike split over 90km at The Championship 2024 in Šamorín, Slovakia with a time of 1:48:48. This was enough to put him in second place on the podium behind Kyle Smith (NZL) who himself posted the...

Events

Press Releases

Triathlon